|
Application Type
|
Application No
|
Trade Name
|
Active Ingredient
|
Protecting Patent Number
|
Drug Applicant
|
Period Of Extension Granted
|
Comments
|
Patent Expiry Date
|
|---|
| 1 x Booting (70.82%) | 103.44ms |
| 1 x Application (27.72%) | 40.49ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
select `meta_title`, `meta_keyword`, `meta_description` from `company_module_category` where `slug` = 'spc' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `subscription_module_list` where `slug` = 'patent-filed' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id` from `master_product_basicinfo` where `product_name` = 'Merck Generics Group' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `comp_id` from `master_companies` where `company_name` = 'Merck Generics Group' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `company_module_category` where `slug` = 'spc' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from information_schema.tables where table_schema = 'chemxpert_chmxdb' and table_name = 'tbl_spc' and table_type = 'BASE TABLE'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'chemxpert_chmxdb'
AND TABLE_NAME = 'tbl_spc'
ORDER BY ORDINAL_POSITION| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `indus_id` as `data_id`, `name` as `value`, `order_number` from `industry_type` where `indus_id` not in ('18') order by `order_number` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `indus_id` as `data_id`, `name` as `value`, `order_number` from `industry_type` where `indus_id` not in ('18') order by `order_number` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `title`, `last_updated_file_date` from `company_module_category` where `slug` = 'spc' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `indus_id` as `data_id`, `name` as `value`, `order_number` from `industry_type` where `indus_id` not in ('18') order by `order_number` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `indus_id` as `data_id`, `name` as `value`, `order_number` from `industry_type` where `indus_id` not in ('18') order by `order_number` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `indus_id` as `data_id`, `name` as `value`, `order_number` from `industry_type` where `indus_id` not in ('18') order by `order_number` asc| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
0 of 0array:3 [▼ "param2" => "patent-filed" "param3" => "spc" "value" => "Merck Generics Group" ]
0 of 0array:3 [▼ "param2" => "patent-filed" "param3" => "spc" "value" => "Merck Generics Group" ]
0 of 0array:16 [▼ "x-https" => array:1 [▶ 0 => "1" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "chemxpert.com" ] ]
0 of 0array:58 [▼ "USER" => "chemxpert" "HOME" => "/home/chemxpert" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/company-details?param2=patent-filed¶m3=spc&value=Merck+Generics+Group" "QUERY_STRING" => "param2=patent-filed¶m3=spc&value=Merck+Generics+Group" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_QUERY_STRING" => "param2=patent-filed¶m3=spc&value=Merck+Generics+Group" "REDIRECT_URL" => "/company-details" "REMOTE_PORT" => "22020" "SCRIPT_FILENAME" => "/home/chemxpert/public_html/index.php" "SERVER_ADMIN" => "webmaster@chemxpert.com" "CONTEXT_DOCUMENT_ROOT" => "/home/chemxpert/public_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/chemxpert/public_html" "REMOTE_ADDR" => "3.14.79.153" "SERVER_PORT" => "443" "SERVER_ADDR" => "10.0.0.22" "SERVER_NAME" => "chemxpert.com" "SERVER_SOFTWARE" => "Apache" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶" "HTTP_X_HTTPS" => "1" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "HTTP_HOST" => "chemxpert.com" "proxy-nokeepalive" => "1" "SSL_TLS_SNI" => "chemxpert.com" "HTTPS" => "on" "SCRIPT_URI" => "https://chemxpert.com/company-details" "SCRIPT_URL" => "/company-details" "UNIQUE_ID" => "aBNGkac-QvsdXlBQMkBWVgAAAAk" "REDIRECT_STATUS" => "200" "REDIRECT_SSL_TLS_SNI" => "chemxpert.com" "REDIRECT_HTTPS" => "on" "REDIRECT_SCRIPT_URI" => "https://chemxpert.com/company-details" "REDIRECT_SCRIPT_URL" => "/company-details" "REDIRECT_UNIQUE_ID" => "aBNGkac-QvsdXlBQMkBWVgAAAAk" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746093713.2716 "REQUEST_TIME" => 1746093713 "argv" => array:3 [▶ 0 => "param2=patent-filed¶m3=spc&value=Merck" 1 => "Generics" 2 => "Group" ] "argc" => 3 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 01 May 2025 10:01:53 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InFmMEIxMEUzcUNHTnFSZEJsZnRVRnc9PSIsInZhbHVlIjoiU3hOMzErUVpkcEc1RkF6MUViZmJxMTE1aWJpVm9HNkRYM0VWQUQ0T3BVYUI3QXVzcGVoR3M4c0h1NzlyT2daK1JBRzdmSE1zQVZIeEVYM291Ui9YTjRqMVpZSXNSSjVTZE9rdUkzbXAzcURQeCtYam51T2k5SzdTcEFTaHFqMXkiLCJtYWMiOiJmN2YzNmE0Yzk0MThlMzM3MjQ2NjExMmM3MmI4NTg5ZGU0NzMzNGY1YmQxNDU5MTNlODE0OTlkYmRjYmZhZTA1IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 10:31:53 GMT; Max-Age=1800; path=/; secure; samesite=none ◀XSRF-TOKEN=eyJpdiI6InFmMEIxMEUzcUNHTnFSZEJsZnRVRnc9PSIsInZhbHVlIjoiU3hOMzErUVpkcEc1RkF6MUViZmJxMTE1aWJpVm9HNkRYM0VWQUQ0T3BVYUI3QXVzcGVoR3M4c0h1NzlyT2daK1JBRzdmS ▶" 1 => "chemxpert_session=eyJpdiI6IjZhZEpqQUZ2R0g3MW5VU1BidVVnOVE9PSIsInZhbHVlIjoiOGpHdXBoQUZ5TXA2ZDJvbE5hOWZJcG1oMmdhZEZwNEE0TTFLeHllY2pYejE5MEpjUzhlWGorOHRkZ2dCcnBqS3p5MkFMOW5wNi9ac1d2UUZJLzAxZDhiQm54Ymh4eks0blMxSG1TbjBzbU1jOWVpK2dVN0YvdEJSUnltbzhtcUoiLCJtYWMiOiI1NzQ4MmI5NGQyMDU4NjA5Mjc5YWZlOGEyN2M0NTk1NTBhNTJjZGY2N2NjMmFlMDQ4YmJiNjVjZmYwZDU3ZjNmIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 10:31:53 GMT; Max-Age=1800; path=/; secure; httponly; samesite=none ◀chemxpert_session=eyJpdiI6IjZhZEpqQUZ2R0g3MW5VU1BidVVnOVE9PSIsInZhbHVlIjoiOGpHdXBoQUZ5TXA2ZDJvbE5hOWZJcG1oMmdhZEZwNEE0TTFLeHllY2pYejE5MEpjUzhlWGorOHRkZ2dCcnBqS3 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InFmMEIxMEUzcUNHTnFSZEJsZnRVRnc9PSIsInZhbHVlIjoiU3hOMzErUVpkcEc1RkF6MUViZmJxMTE1aWJpVm9HNkRYM0VWQUQ0T3BVYUI3QXVzcGVoR3M4c0h1NzlyT2daK1JBRzdmSE1zQVZIeEVYM291Ui9YTjRqMVpZSXNSSjVTZE9rdUkzbXAzcURQeCtYam51T2k5SzdTcEFTaHFqMXkiLCJtYWMiOiJmN2YzNmE0Yzk0MThlMzM3MjQ2NjExMmM3MmI4NTg5ZGU0NzMzNGY1YmQxNDU5MTNlODE0OTlkYmRjYmZhZTA1IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 10:31:53 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InFmMEIxMEUzcUNHTnFSZEJsZnRVRnc9PSIsInZhbHVlIjoiU3hOMzErUVpkcEc1RkF6MUViZmJxMTE1aWJpVm9HNkRYM0VWQUQ0T3BVYUI3QXVzcGVoR3M4c0h1NzlyT2daK1JBRzdmS ▶" 1 => "chemxpert_session=eyJpdiI6IjZhZEpqQUZ2R0g3MW5VU1BidVVnOVE9PSIsInZhbHVlIjoiOGpHdXBoQUZ5TXA2ZDJvbE5hOWZJcG1oMmdhZEZwNEE0TTFLeHllY2pYejE5MEpjUzhlWGorOHRkZ2dCcnBqS3p5MkFMOW5wNi9ac1d2UUZJLzAxZDhiQm54Ymh4eks0blMxSG1TbjBzbU1jOWVpK2dVN0YvdEJSUnltbzhtcUoiLCJtYWMiOiI1NzQ4MmI5NGQyMDU4NjA5Mjc5YWZlOGEyN2M0NTk1NTBhNTJjZGY2N2NjMmFlMDQ4YmJiNjVjZmYwZDU3ZjNmIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 10:31:53 GMT; path=/; secure; httponly ◀chemxpert_session=eyJpdiI6IjZhZEpqQUZ2R0g3MW5VU1BidVVnOVE9PSIsInZhbHVlIjoiOGpHdXBoQUZ5TXA2ZDJvbE5hOWZJcG1oMmdhZEZwNEE0TTFLeHllY2pYejE5MEpjUzhlWGorOHRkZ2dCcnBqS3 ▶" ] ]
0 of 0array:5 [▼ "_token" => "p5tx5dgk2DzZGQYmFy0xgGuhRJUJseNWyi9cRMMv" "last_activity" => Illuminate\Support\Carbon @1746093713 {#2437 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "00000000000009850000000000000000" #localMonthsOverflow: null #localYearsOverflow: null #localStrictModeEnabled: null #localHumanDiffOptions: null #localToStringFormat: null #localSerializer: null #localMacros: null #localGenericMacros: null #localFormatFunction: null #localTranslator: null #dumpProperties: array:3 [▶ 0 => "date" 1 => "timezone_type" 2 => "timezone" ] #dumpLocale: null #dumpDateProperties: null date: 2025-05-01 10:01:53.397331 UTC (+00:00) } "_previous" => array:1 [▶ "url" => "https://chemxpert.com/company-details?param2=patent-filed¶m3=spc&value=Merck%20Generics%20Group" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]