1 x Application (50.18%) | 730.85ms |
1 x Booting (49.37%) | 719.07ms |
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
Params | |
---|---|
0 |
|
1 |
|
select * from `ec_currencies` order by `order` asc
Metadata | |
---|---|
Backtrace |
|
select count(*) as aggregate from `ec_products` inner join
(
SELECT DISTINCT
`ec_products`.id,
CASE
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price <> 0
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price = 0
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
(
ec_products.start_date > '2025-01-09 12:35:43' OR
ec_products.end_date < '2025-01-09 12:35:43'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-01-09 12:35:43' AND
ec_products.end_date >= '2025-01-09 12:35:43'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2025-01-09 12:35:43'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-01-09 12:35:43' AND
ec_products.end_date IS NULL
) THEN ec_products.sale_price
ELSE ec_products.price
END AS final_price
FROM `ec_products`
) AS products_with_final_price
on `products_with_final_price`.`id` = `ec_products`.`id` where `ec_products`.`status` = 'published' and `ec_products`.`is_variation` = 0
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select distinct `ec_products`.*, `products_with_final_price`.`final_price` from `ec_products` inner join
(
SELECT DISTINCT
`ec_products`.id,
CASE
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price <> 0
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 0 AND
ec_products.sale_price = 0
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
(
ec_products.start_date > '2025-01-09 12:35:43' OR
ec_products.end_date < '2025-01-09 12:35:43'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-01-09 12:35:43' AND
ec_products.end_date >= '2025-01-09 12:35:43'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2025-01-09 12:35:43'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-01-09 12:35:43' AND
ec_products.end_date IS NULL
) THEN ec_products.sale_price
ELSE ec_products.price
END AS final_price
FROM `ec_products`
) AS products_with_final_price
on `products_with_final_price`.`id` = `ec_products`.`id` where `ec_products`.`status` = 'published' and `ec_products`.`is_variation` = 0 order by `ec_products`.`name` asc limit 100 offset 300
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_categories` order by `order` asc, `created_at` desc
Metadata | |
---|---|
Backtrace |
|
select *, (select count(*) from `ec_products` where `ec_brands`.`id` = `ec_products`.`brand_id` and `is_variation` = 0 and `status` = 'published') as `products_count` from `ec_brands` where `status` = 'published' order by `order` asc, `created_at` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select *, (select count(*) from `ec_products` inner join `ec_product_tag_product` on `ec_products`.`id` = `ec_product_tag_product`.`product_id` where `ec_product_tags`.`id` = `ec_product_tag_product`.`tag_id` and `is_variation` = 0) as `products_count` from `ec_product_tags` where `status` = 'published' order by `products_count` desc limit 20
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_attribute_sets` where `status` = 'published' and `is_searchable` = 1 order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_attributes` where `ec_product_attributes`.`attribute_set_id` in (1, 2, 3) order by `order` asc
Metadata | |
---|---|
Backtrace |
|
select * from `ec_product_attributes_translations` where `ec_product_attributes_translations`.`ec_product_attributes_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19)
Metadata | |
---|---|
Backtrace |
|
select * from `slugs` where `slugs`.`reference_id` in (31, 32, 33, 34, 35, 50) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_categories` where `ec_product_categories`.`parent_id` in (31, 32, 33, 34, 35, 50)
Metadata | |
---|---|
Backtrace |
|
select * from `slugs` where `slugs`.`reference_id` in (38, 39, 40, 41, 42, 43, 44, 45, 51, 52, 53, 54, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `reference_id`, `reference_type`, `meta_key`, `meta_value` from `meta_boxes` where `meta_boxes`.`reference_id` in (31, 32, 33, 34, 35, 50) and `meta_boxes`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_categories_translations` where `ec_product_categories_translations`.`ec_product_categories_id` in (38, 39, 40, 41, 42, 43, 44, 45, 51, 52, 53, 54, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66)
Metadata | |
---|---|
Backtrace |
|
select * from `menus` inner join `language_meta` on `language_meta`.`reference_id` = `menus`.`id` where `status` = 'published' and `language_meta`.`reference_type` = 'Botble\Menu\Models\Menu' and `language_meta`.`lang_meta_code` = 'en_US'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menu_nodes` where `menu_nodes`.`menu_id` in (1, 2, 3)
Metadata | |
---|---|
Backtrace |
|
select * from `menu_locations` where `menu_locations`.`menu_id` in (1, 2, 3)
Metadata | |
---|---|
Backtrace |
|
select * from `ec_product_categories` where `parent_id` = 0 limit 8
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 31 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 32 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 33 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 34 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 35 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 50 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menu_nodes` where `menu_nodes`.`parent_id` = 118 and `menu_nodes`.`parent_id` is not null order by `position` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ec_product_categories` where `parent_id` = 0 limit 8
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 31 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 32 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 33 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 34 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 35 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `reference_id` = 50 limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `key` = 'products'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `widgets` where `theme` = 'wowy'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select *, (select count(*) from `ec_products` inner join `ec_product_category_product` on `ec_products`.`id` = `ec_product_category_product`.`product_id` where `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` and `is_variation` = 0) as `products_count` from `ec_product_categories` where `ec_product_categories`.`is_featured` = 1 and `ec_product_categories`.`status` = 'published' order by `ec_product_categories`.`created_at` desc, `ec_product_categories`.`order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `slugs` where `slugs`.`reference_id` in (31, 32, 33, 34) and `slugs`.`reference_type` = 'Botble\Ecommerce\Models\ProductCategory'
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
200
0 of 0array:2 [▼ "num" => "100" "page" => "4" ]
0 of 0array:2 [▼ "num" => "100" "page" => "4" ]
0 of 0array:10 [▼ "accept-encoding" => array:1 [▶ 0 => "gzip, deflate" ] "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" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "close" ] "x-accel-internal" => array:1 [▶ 0 => "/internal-nginx-static-location" ] "x-real-ip" => array:1 [▶ 0 => "3.144.242.84" ] "host" => array:1 [▶ 0 => "signatureweave.checksample.co.uk" ] ]
0 of 0array:49 [▼ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "PP_CUSTOM_PHP_INI" => "/var/www/vhosts/system/signatureweave.checksample.co.uk/etc/php.ini" "PP_CUSTOM_PHP_CGI_INDEX" => "plesk-php74-fastcgi" "SCRIPT_NAME" => "/public/index.php" "REQUEST_URI" => "/products?num=100&page=4" "QUERY_STRING" => "num=100&page=4" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_QUERY_STRING" => "num=100&page=4" "REDIRECT_URL" => "/public/products" "REMOTE_PORT" => "54276" "SCRIPT_FILENAME" => "/var/www/vhosts/checksample.co.uk/signatureweave.checksample.co.uk/httpdocs/public/index.php" "SERVER_ADMIN" => "[no address given]" "CONTEXT_DOCUMENT_ROOT" => "/var/www/vhosts/checksample.co.uk/signatureweave.checksample.co.uk/httpdocs" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "http" "DOCUMENT_ROOT" => "/var/www/vhosts/checksample.co.uk/signatureweave.checksample.co.uk/httpdocs" "REMOTE_ADDR" => "3.144.242.84" "SERVER_PORT" => "80" "SERVER_ADDR" => "172.31.1.80" "SERVER_NAME" => "signatureweave.checksample.co.uk" "SERVER_SOFTWARE" => "Apache" "SERVER_SIGNATURE" => "<address>Apache Server at signatureweave.checksample.co.uk Port 80</address>\n" "HTTP_ACCEPT_ENCODING" => "gzip, deflate" "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_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "close" "HTTP_X_ACCEL_INTERNAL" => "/internal-nginx-static-location" "HTTP_X_REAL_IP" => "3.144.242.84" "HTTP_HOST" => "signatureweave.checksample.co.uk" "PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY" => "0" "PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY" => "0" "UNIQUE_ID" => "Z3-CnVBsYxhijlDU-f1d5wAAAAw" "REDIRECT_STATUS" => "200" "REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY" => "0" "REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY" => "0" "REDIRECT_UNIQUE_ID" => "Z3-CnVBsYxhijlDU-f1d5wAAAAw" "REDIRECT_REDIRECT_STATUS" => "200" "REDIRECT_REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY" => "0" "REDIRECT_REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY" => "0" "REDIRECT_REDIRECT_UNIQUE_ID" => "Z3-CnVBsYxhijlDU-f1d5wAAAAw" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1736426142.6797 "REQUEST_TIME" => 1736426142 ]
[]
0 of 0array:10 [▼ "cache-control" => array:1 [▶ 0 => "private, must-revalidate" ] "date" => array:1 [▶ 0 => "Thu, 09 Jan 2025 12:35:44 GMT" ] "cms-version" => array:1 [▶ 0 => "5.23.6" ] "authorization-at" => array:1 [▶ 0 => "2023-08-01 11:31:30" ] "activated-license" => array:1 [▶ 0 => "No" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => -1 ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjVJOHlZNVFlWlB2bDY5cy95OElYR1E9PSIsInZhbHVlIjoiOWh0Mm9aZXg4ZURxbWgxQzJZRSs4L2xPRVd4U3VIY3J6Q0F5RDFRaHBROHJIcW80UTZlWWlUazFDdmJGeGtBQ0Z6UlhRRlVlMWhYcmNqb3NMSk5ycGZwaWNDUG5Rd2ErMzVLYkczQmJ5TnhtdmpRMDNKWCs1N3BteWh6ZDRqR2giLCJtYWMiOiI1MWIzYzI5MjA4YmM1NmYwYjdlN2ZmYzA1MmI5ODk4MjFlOWYyMmE4YTNiOGEwZjc0YzM3YjM4MDQ4ZGU5ODY2IiwidGFnIjoiIn0%3D; expires=Thu, 09-Jan-2025 14:35:44 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjVJOHlZNVFlWlB2bDY5cy95OElYR1E9PSIsInZhbHVlIjoiOWh0Mm9aZXg4ZURxbWgxQzJZRSs4L2xPRVd4U3VIY3J6Q0F5RDFRaHBROHJIcW80UTZlWWlUazFDdmJGeGtBQ0Z6UlhRR ▶" 1 => "botble_session=eyJpdiI6Im96UU1wS1g1RndPaENaZEhVSmJiaFE9PSIsInZhbHVlIjoiTWxjWXl1UW04Z1F6NjdxTk9hL2N6K2FvNkdUMjJIeFpNUmNmKzlMeFBpeTVsNGUzUjBOOURvR3BieGNEd3gyUlRnQ201ZVV0L3ZmMldpV0wzSUREOVRxeW5IeDNIRElxMlI1ZFd3OWtFME8wTnRJcm9Cb3VHWURsZ3Vwcis3MngiLCJtYWMiOiJlMTA1NWE5OTNlODkzNTg3Y2M5YzNkY2QwYmM0MTZiZjUzNGNjNGRhN2FmMTNjN2Q3ZTg0N2E3ZGU5MmFhNGMyIiwidGFnIjoiIn0%3D; expires=Thu, 09-Jan-2025 14:35:44 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀botble_session=eyJpdiI6Im96UU1wS1g1RndPaENaZEhVSmJiaFE9PSIsInZhbHVlIjoiTWxjWXl1UW04Z1F6NjdxTk9hL2N6K2FvNkdUMjJIeFpNUmNmKzlMeFBpeTVsNGUzUjBOOURvR3BieGNEd3gyUlRnQ ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjVJOHlZNVFlWlB2bDY5cy95OElYR1E9PSIsInZhbHVlIjoiOWh0Mm9aZXg4ZURxbWgxQzJZRSs4L2xPRVd4U3VIY3J6Q0F5RDFRaHBROHJIcW80UTZlWWlUazFDdmJGeGtBQ0Z6UlhRRlVlMWhYcmNqb3NMSk5ycGZwaWNDUG5Rd2ErMzVLYkczQmJ5TnhtdmpRMDNKWCs1N3BteWh6ZDRqR2giLCJtYWMiOiI1MWIzYzI5MjA4YmM1NmYwYjdlN2ZmYzA1MmI5ODk4MjFlOWYyMmE4YTNiOGEwZjc0YzM3YjM4MDQ4ZGU5ODY2IiwidGFnIjoiIn0%3D; expires=Thu, 09-Jan-2025 14:35:44 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjVJOHlZNVFlWlB2bDY5cy95OElYR1E9PSIsInZhbHVlIjoiOWh0Mm9aZXg4ZURxbWgxQzJZRSs4L2xPRVd4U3VIY3J6Q0F5RDFRaHBROHJIcW80UTZlWWlUazFDdmJGeGtBQ0Z6UlhRR ▶" 1 => "botble_session=eyJpdiI6Im96UU1wS1g1RndPaENaZEhVSmJiaFE9PSIsInZhbHVlIjoiTWxjWXl1UW04Z1F6NjdxTk9hL2N6K2FvNkdUMjJIeFpNUmNmKzlMeFBpeTVsNGUzUjBOOURvR3BieGNEd3gyUlRnQ201ZVV0L3ZmMldpV0wzSUREOVRxeW5IeDNIRElxMlI1ZFd3OWtFME8wTnRJcm9Cb3VHWURsZ3Vwcis3MngiLCJtYWMiOiJlMTA1NWE5OTNlODkzNTg3Y2M5YzNkY2QwYmM0MTZiZjUzNGNjNGRhN2FmMTNjN2Q3ZTg0N2E3ZGU5MmFhNGMyIiwidGFnIjoiIn0%3D; expires=Thu, 09-Jan-2025 14:35:44 GMT; path=/; httponly ◀botble_session=eyJpdiI6Im96UU1wS1g1RndPaENaZEhVSmJiaFE9PSIsInZhbHVlIjoiTWxjWXl1UW04Z1F6NjdxTk9hL2N6K2FvNkdUMjJIeFpNUmNmKzlMeFBpeTVsNGUzUjBOOURvR3BieGNEd3gyUlRnQ ▶" ] ]
0 of 0array:5 [▼ "_token" => "DEPkA85GuvqNeLdtC5rkHaIe8XElbzpZ7t2ZN09X" "language" => "en" "_previous" => array:1 [▶ "url" => "http://signatureweave.checksample.co.uk/products?num=100&page=4" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]