|
Application Number
|
Approval Date
|
Product Name
|
Brand Name
|
Dosage Forms
|
Strength
|
Unit
|
Applicant Type
|
Applicant Holder
|
Applicant Country
|
RLD
|
RS
|
Type
|
Product Number
|
TE Code
|
Approval Year
|
Patent Number
|
Patent Expire
|
Drug Substance Flag
|
Drug Product Flag
|
Patent Use Code
|
Delist Flag
|
Submission Date
|
Exclusivity Code
|
Exclusivity Date
|
Company Name
|
Company Category
|
Company Certification
|
Company Contact Person
|
Company Designation
|
Company Email Id
|
Company Contact Number
|
Company Contact Details
|
Company Region
|
Company Continent
|
Company Country
|
|---|
| 1 x Booting (70.07%) | 89.47ms |
| 1 x Application (28.69%) | 36.64ms |
| 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` = 'usanda' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `subscription_module_list` where `slug` = 'north_america' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id` from `master_product_basicinfo` where `product_name` = 'Basf Pakistan Pvt Ltd' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `comp_id` from `master_companies` where `company_name` = 'Basf Pakistan Pvt Ltd' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `api` where `slug` = 'north_america' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `subscription_module_list` where `regulatory_info id` = 2 limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `company_module_category` where `slug` = 'usanda' limit 1| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from information_schema.tables where table_schema = 'chemxpert_chmxdb' and table_name = 'us_anda_registered' and table_type = 'BASE TABLE'| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'chemxpert_chmxdb'
AND TABLE_NAME = 'us_anda_registered'
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` = 'usanda' 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" => "north_america" "param3" => "usanda" "value" => "Basf Pakistan Pvt Ltd" ]
0 of 0array:3 [▼ "param2" => "north_america" "param3" => "usanda" "value" => "Basf Pakistan Pvt Ltd" ]
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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "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=north_america¶m3=usanda&value=Basf+Pakistan+Pvt+Ltd" "QUERY_STRING" => "param2=north_america¶m3=usanda&value=Basf+Pakistan+Pvt+Ltd" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_QUERY_STRING" => "param2=north_america¶m3=usanda&value=Basf+Pakistan+Pvt+Ltd" "REDIRECT_URL" => "/company-details" "REMOTE_PORT" => "62562" "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.136.222" "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" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "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" => "Z_zeBD-pUjHQuLvKT8pSxAAAAAQ" "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" => "Z_zeBD-pUjHQuLvKT8pSxAAAAAQ" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744625156.8593 "REQUEST_TIME" => 1744625156 "argv" => array:4 [▶ 0 => "param2=north_america¶m3=usanda&value=Basf" 1 => "Pakistan" 2 => "Pvt" 3 => "Ltd" ] "argc" => 4 ]
[]
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 => "Mon, 14 Apr 2025 10:05:56 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjY3K0d5THhSQzBtam45TVpHMld6WkE9PSIsInZhbHVlIjoiNGlZaWYzMFlTUkNiMjB1TTRWeEFUWjNNQzhQU0ZveUZVV3R0ZEZVNGU0U3NnSGRvZDNTcTVTTExQbUZtR01ncy9IOWp2dDRINkJyaGptc3FTMDM4WUVJcXZJbjkzcmVIYi94V0NvTGV1cmd2UzZ6ejMwYlVKc2NmVE12L3lkOWIiLCJtYWMiOiI3NjljNDE3OTljZmNlNzA4MmExYTEyZGViNzIzY2JiZmY2YTUwMjVhZDkyMDZmZWZiNjlhOWViMTY0Mjc0ZTg2IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 10:35:56 GMT; Max-Age=1800; path=/; secure; samesite=none ◀XSRF-TOKEN=eyJpdiI6IjY3K0d5THhSQzBtam45TVpHMld6WkE9PSIsInZhbHVlIjoiNGlZaWYzMFlTUkNiMjB1TTRWeEFUWjNNQzhQU0ZveUZVV3R0ZEZVNGU0U3NnSGRvZDNTcTVTTExQbUZtR01ncy9IOWp2d ▶" 1 => "chemxpert_session=eyJpdiI6IldoMDBZZ2hmMVJpOXFUWDVxUW13OHc9PSIsInZhbHVlIjoiTE14T3NCemN4bGFsZzhRMlZST0MzUWZRekpVVFJXMW9MdS9OVTZBVVlQVFRuNW5KN3JTNDhKbnN3MnpRNzhLMHhQWjk1L2IyTk93S3grUURMNmdDQndOV1ZHKzA4eXNSV2tzUXdNRUpvNFJaK2VUZERxY3NhU05DTlQ1L2xDaEgiLCJtYWMiOiI1ZTI5MzdiZWVhNDY3ZjY0Yzg3Y2ExNGY5MjQ5ZDJjOTRhNWUzZmM0NTg2YjdjZWM2YTkzMDhjNGJmZGNjNTc5IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 10:35:56 GMT; Max-Age=1800; path=/; secure; httponly; samesite=none ◀chemxpert_session=eyJpdiI6IldoMDBZZ2hmMVJpOXFUWDVxUW13OHc9PSIsInZhbHVlIjoiTE14T3NCemN4bGFsZzhRMlZST0MzUWZRekpVVFJXMW9MdS9OVTZBVVlQVFRuNW5KN3JTNDhKbnN3MnpRNzhLMH ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjY3K0d5THhSQzBtam45TVpHMld6WkE9PSIsInZhbHVlIjoiNGlZaWYzMFlTUkNiMjB1TTRWeEFUWjNNQzhQU0ZveUZVV3R0ZEZVNGU0U3NnSGRvZDNTcTVTTExQbUZtR01ncy9IOWp2dDRINkJyaGptc3FTMDM4WUVJcXZJbjkzcmVIYi94V0NvTGV1cmd2UzZ6ejMwYlVKc2NmVE12L3lkOWIiLCJtYWMiOiI3NjljNDE3OTljZmNlNzA4MmExYTEyZGViNzIzY2JiZmY2YTUwMjVhZDkyMDZmZWZiNjlhOWViMTY0Mjc0ZTg2IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 10:35:56 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjY3K0d5THhSQzBtam45TVpHMld6WkE9PSIsInZhbHVlIjoiNGlZaWYzMFlTUkNiMjB1TTRWeEFUWjNNQzhQU0ZveUZVV3R0ZEZVNGU0U3NnSGRvZDNTcTVTTExQbUZtR01ncy9IOWp2d ▶" 1 => "chemxpert_session=eyJpdiI6IldoMDBZZ2hmMVJpOXFUWDVxUW13OHc9PSIsInZhbHVlIjoiTE14T3NCemN4bGFsZzhRMlZST0MzUWZRekpVVFJXMW9MdS9OVTZBVVlQVFRuNW5KN3JTNDhKbnN3MnpRNzhLMHhQWjk1L2IyTk93S3grUURMNmdDQndOV1ZHKzA4eXNSV2tzUXdNRUpvNFJaK2VUZERxY3NhU05DTlQ1L2xDaEgiLCJtYWMiOiI1ZTI5MzdiZWVhNDY3ZjY0Yzg3Y2ExNGY5MjQ5ZDJjOTRhNWUzZmM0NTg2YjdjZWM2YTkzMDhjNGJmZGNjNTc5IiwidGFnIjoiIn0%3D; expires=Mon, 14-Apr-2025 10:35:56 GMT; path=/; secure; httponly ◀chemxpert_session=eyJpdiI6IldoMDBZZ2hmMVJpOXFUWDVxUW13OHc9PSIsInZhbHVlIjoiTE14T3NCemN4bGFsZzhRMlZST0MzUWZRekpVVFJXMW9MdS9OVTZBVVlQVFRuNW5KN3JTNDhKbnN3MnpRNzhLMH ▶" ] ]
0 of 0array:5 [▼ "_token" => "zluGt9QBQYeU7xIcTQE66rQjNN3lgwFlOwJXbuQo" "last_activity" => Illuminate\Support\Carbon @1744625156 {#2434 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "00000000000009820000000000000000" #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-04-14 10:05:56.966643 UTC (+00:00) } "_previous" => array:1 [▶ "url" => "https://chemxpert.com/company-details?param2=north_america¶m3=usanda&value=Basf%20Pakistan%20Pvt%20Ltd" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]