Issue Date
|
Substance Number
|
Substance Name
|
Status
|
End Date
|
Certificate Number
|
Type
|
Certificant Name
|
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 (72.83%) | 88.35ms |
1 x Application (25.87%) | 31.39ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
select * from `company_module_category` where `slug` = 'cep-cos' limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from information_schema.tables where table_schema = 'chemxpert_chmxdb' and table_name = 'cep_api' and table_type = 'BASE TABLE'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'chemxpert_chmxdb'
AND TABLE_NAME = 'cep_api'
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` = 'cep-cos' 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" => "cep-cos" "param3" => "cep-cos" "value" => "Merck Sharp And Dohme Ia Corporation" ]
0 of 0array:3 [▼ "param2" => "cep-cos" "param3" => "cep-cos" "value" => "Merck Sharp And Dohme Ia Corporation" ]
0 of 0array:17 [▼ "x-https" => array:1 [▶ 0 => "1" ] "cookie" => array:1 [▶ 0 => "_lfa=LF1.1.cb039a71d1fc8d27.1746094582185; nQ_cookieId=b8d940c1-cafa-31c7-a30a-c89378ec85cd; nQ_userVisitId=61cbd6f2-237f-5d67-cd29-cf173d60c98c; XSRF-TOKEN=eyJpdiI6ImQrY0lNSWlKTGE2OVVSaEFxdkJPNkE9PSIsInZhbHVlIjoiYy9jUlZCMG5pN3loZlpIM0NZRnJDSGk0QXl4MGRvL2JlQk9ZcnpRRDZON3luUnp5YkZ0eUdxZ29Scmhmc0lVempOUmNQNllWZkplNTIwTTFWSWd4TVZkZnZKNGJUdUNqTkE3MHpveEpFdGVOWERnK2g4c29CeExScnNMZ1ZPeEgiLCJtYWMiOiIzMjFjMzNhM2U1OTVjNDU3MjMyNzIzMzFlZmExODc0Y2RjNDg1ODQ1MGJlMjUwNjQyYjFkNWM0OTJjMmZjMmE4IiwidGFnIjoiIn0%3D; chemxpert_session=eyJpdiI6IitubDBSK0QzY3ZJZWo2dldYU0o0SEE9PSIsInZhbHVlIjoiZ1FtY3ZCSk9BY2RFUk5IcHordGRranVOS1kwUXh2OXg4Z1FLN1lva0NJVE9SSGZxbi9qL0JzemI0cVNueXJjNmtvUEFRK3ZuWG9Ua2dqamo4aWFhc2YzRU03YnFHYStySEdkMTRmeHExUVpESXp6alVoS2xVcGtBSFY5cDNDMjEiLCJtYWMiOiJlMzU1MDU0NmVmNGU5MzZiYmU4ZmIxN2FjNjQzODc0NzcyMjBiOTM4M2MwZDc0NWE1Y2I1Y2M4MzRiMmI1MGVhIiwidGFnIjoiIn0%3D ◀_lfa=LF1.1.cb039a71d1fc8d27.1746094582185; nQ_cookieId=b8d940c1-cafa-31c7-a30a-c89378ec85cd; nQ_userVisitId=61cbd6f2-237f-5d67-cd29-cf173d60c98c; XSRF-TOKEN=eyJ ▶" ] "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:59 [▼ "USER" => "chemxpert" "HOME" => "/home/chemxpert" "SCRIPT_NAME" => "/index.php" "REQUEST_URI" => "/api-search-company?param2=cep-cos¶m3=cep-cos&value=Merck+Sharp+And+Dohme+Ia+Corporation" "QUERY_STRING" => "param2=cep-cos¶m3=cep-cos&value=Merck+Sharp+And+Dohme+Ia+Corporation" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.1" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_QUERY_STRING" => "param2=cep-cos¶m3=cep-cos&value=Merck+Sharp+And+Dohme+Ia+Corporation" "REDIRECT_URL" => "/api-search-company" "REMOTE_PORT" => "17103" "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.142.240.117" "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_COOKIE" => "_lfa=LF1.1.cb039a71d1fc8d27.1746094582185; nQ_cookieId=b8d940c1-cafa-31c7-a30a-c89378ec85cd; nQ_userVisitId=61cbd6f2-237f-5d67-cd29-cf173d60c98c; XSRF-TOKEN=eyJpdiI6ImQrY0lNSWlKTGE2OVVSaEFxdkJPNkE9PSIsInZhbHVlIjoiYy9jUlZCMG5pN3loZlpIM0NZRnJDSGk0QXl4MGRvL2JlQk9ZcnpRRDZON3luUnp5YkZ0eUdxZ29Scmhmc0lVempOUmNQNllWZkplNTIwTTFWSWd4TVZkZnZKNGJUdUNqTkE3MHpveEpFdGVOWERnK2g4c29CeExScnNMZ1ZPeEgiLCJtYWMiOiIzMjFjMzNhM2U1OTVjNDU3MjMyNzIzMzFlZmExODc0Y2RjNDg1ODQ1MGJlMjUwNjQyYjFkNWM0OTJjMmZjMmE4IiwidGFnIjoiIn0%3D; chemxpert_session=eyJpdiI6IitubDBSK0QzY3ZJZWo2dldYU0o0SEE9PSIsInZhbHVlIjoiZ1FtY3ZCSk9BY2RFUk5IcHordGRranVOS1kwUXh2OXg4Z1FLN1lva0NJVE9SSGZxbi9qL0JzemI0cVNueXJjNmtvUEFRK3ZuWG9Ua2dqamo4aWFhc2YzRU03YnFHYStySEdkMTRmeHExUVpESXp6alVoS2xVcGtBSFY5cDNDMjEiLCJtYWMiOiJlMzU1MDU0NmVmNGU5MzZiYmU4ZmIxN2FjNjQzODc0NzcyMjBiOTM4M2MwZDc0NWE1Y2I1Y2M4MzRiMmI1MGVhIiwidGFnIjoiIn0%3D ◀_lfa=LF1.1.cb039a71d1fc8d27.1746094582185; nQ_cookieId=b8d940c1-cafa-31c7-a30a-c89378ec85cd; nQ_userVisitId=61cbd6f2-237f-5d67-cd29-cf173d60c98c; XSRF-TOKEN=eyJ ▶" "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/api-search-company" "SCRIPT_URL" => "/api-search-company" "UNIQUE_ID" => "aBNJ_nOvHA8Vs23HiCnCXQAAABY" "REDIRECT_STATUS" => "200" "REDIRECT_SSL_TLS_SNI" => "chemxpert.com" "REDIRECT_HTTPS" => "on" "REDIRECT_SCRIPT_URI" => "https://chemxpert.com/api-search-company" "REDIRECT_SCRIPT_URL" => "/api-search-company" "REDIRECT_UNIQUE_ID" => "aBNJ_nOvHA8Vs23HiCnCXQAAABY" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746094590.0652 "REQUEST_TIME" => 1746094590 "argv" => array:6 [▶ 0 => "param2=cep-cos¶m3=cep-cos&value=Merck" 1 => "Sharp" 2 => "And" 3 => "Dohme" 4 => "Ia" 5 => "Corporation" ] "argc" => 6 ]
0 of 0array:5 [▼ "_lfa" => null "nQ_cookieId" => null "nQ_userVisitId" => null "XSRF-TOKEN" => "s9WxrtJY2rhLcaXV1AmWCzvjUgPFxZbTRYOElI9V" "chemxpert_session" => "KRRVzuQcQbhwI9uXWEemrNhYqsPYgsCb3ju7OTsb" ]
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:16:30 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImxUUERuV21ScGJneERZYnhpQXhQOFE9PSIsInZhbHVlIjoiaWhVcmFXMzhDT1RhNHloNFArMEVyRmRrVWFsdHJBU2FYdWJVMnFMU0lqSmhsWkpxREwwYXdQK28xRnNGSWxJWThwVS9MYzRPdzNlMUNaRmYyL01LYUtsYStrOU9mSDR2N3d5SkROYVJ4ZjIydEhka3JuVDFhTWZGMVVHZnkvY20iLCJtYWMiOiI1YzIzMjc3NDBkMGMxM2MxZjE0Yjc5NmMxMWEwYmE2NDdiZjQxOGEyMjE0YjM1NzQ0ODBlZjU4NWU5NDEwZWQ4IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 10:46:30 GMT; Max-Age=1800; path=/; secure; samesite=none ◀XSRF-TOKEN=eyJpdiI6ImxUUERuV21ScGJneERZYnhpQXhQOFE9PSIsInZhbHVlIjoiaWhVcmFXMzhDT1RhNHloNFArMEVyRmRrVWFsdHJBU2FYdWJVMnFMU0lqSmhsWkpxREwwYXdQK28xRnNGSWxJWThwVS9MY ▶" 1 => "chemxpert_session=eyJpdiI6Ijc4cE5va3JaQmJ0TDlJU000ZXZvT1E9PSIsInZhbHVlIjoiQjlja3JzMHJEbms4R3N5YmlOaEtOSkZZdVdtSVZVNkhCSER0Lzh4WHB3c3p0NDdGK1pFcVNHU1FuU2xvVjJyVXdsVWNEZlB5Zjdtd0ZjTVA4L2xDbHlQL00xTDF6bkwrUjFaSStycjBkd2RxMHNVaHoralBDTXZWQkx1Vi9kaU4iLCJtYWMiOiJmNzBmZGNkMjZkYTdhNWMzODU2Y2RjZjIwNTUwZDNjN2U1YmU4OThkZDFmNTAwYWEwODNhN2RlM2QzMmZkMzIxIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 10:46:30 GMT; Max-Age=1800; path=/; secure; httponly; samesite=none ◀chemxpert_session=eyJpdiI6Ijc4cE5va3JaQmJ0TDlJU000ZXZvT1E9PSIsInZhbHVlIjoiQjlja3JzMHJEbms4R3N5YmlOaEtOSkZZdVdtSVZVNkhCSER0Lzh4WHB3c3p0NDdGK1pFcVNHU1FuU2xvVjJyVX ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImxUUERuV21ScGJneERZYnhpQXhQOFE9PSIsInZhbHVlIjoiaWhVcmFXMzhDT1RhNHloNFArMEVyRmRrVWFsdHJBU2FYdWJVMnFMU0lqSmhsWkpxREwwYXdQK28xRnNGSWxJWThwVS9MYzRPdzNlMUNaRmYyL01LYUtsYStrOU9mSDR2N3d5SkROYVJ4ZjIydEhka3JuVDFhTWZGMVVHZnkvY20iLCJtYWMiOiI1YzIzMjc3NDBkMGMxM2MxZjE0Yjc5NmMxMWEwYmE2NDdiZjQxOGEyMjE0YjM1NzQ0ODBlZjU4NWU5NDEwZWQ4IiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 10:46:30 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImxUUERuV21ScGJneERZYnhpQXhQOFE9PSIsInZhbHVlIjoiaWhVcmFXMzhDT1RhNHloNFArMEVyRmRrVWFsdHJBU2FYdWJVMnFMU0lqSmhsWkpxREwwYXdQK28xRnNGSWxJWThwVS9MY ▶" 1 => "chemxpert_session=eyJpdiI6Ijc4cE5va3JaQmJ0TDlJU000ZXZvT1E9PSIsInZhbHVlIjoiQjlja3JzMHJEbms4R3N5YmlOaEtOSkZZdVdtSVZVNkhCSER0Lzh4WHB3c3p0NDdGK1pFcVNHU1FuU2xvVjJyVXdsVWNEZlB5Zjdtd0ZjTVA4L2xDbHlQL00xTDF6bkwrUjFaSStycjBkd2RxMHNVaHoralBDTXZWQkx1Vi9kaU4iLCJtYWMiOiJmNzBmZGNkMjZkYTdhNWMzODU2Y2RjZjIwNTUwZDNjN2U1YmU4OThkZDFmNTAwYWEwODNhN2RlM2QzMmZkMzIxIiwidGFnIjoiIn0%3D; expires=Thu, 01-May-2025 10:46:30 GMT; path=/; secure; httponly ◀chemxpert_session=eyJpdiI6Ijc4cE5va3JaQmJ0TDlJU000ZXZvT1E9PSIsInZhbHVlIjoiQjlja3JzMHJEbms4R3N5YmlOaEtOSkZZdVdtSVZVNkhCSER0Lzh4WHB3c3p0NDdGK1pFcVNHU1FuU2xvVjJyVX ▶" ] ]
0 of 0array:5 [▼ "_token" => "s9WxrtJY2rhLcaXV1AmWCzvjUgPFxZbTRYOElI9V" "last_activity" => Illuminate\Support\Carbon @1746094590 {#2438 ▶ #endOfTime: false #startOfTime: false #constructedObjectId: "00000000000009860000000000000000" #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:16:30.170888 UTC (+00:00) } "_previous" => array:1 [▶ "url" => "https://chemxpert.com/api-search-company?param2=cep-cos¶m3=cep-cos&value=Merck%20Sharp%20And%20Dohme%20Ia%20Corporation" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]