1 x Application (67.72%) | 402.68ms |
1 x Booting (32.12%) | 190.96ms |
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-10 02:30:54' OR
ec_products.end_date < '2025-01-10 02:30:54'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-01-10 02:30:54' AND
ec_products.end_date >= '2025-01-10 02:30:54'
) 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-10 02:30:54'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-01-10 02:30:54' 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-10 02:30:54' OR
ec_products.end_date < '2025-01-10 02:30:54'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-01-10 02:30:54' AND
ec_products.end_date >= '2025-01-10 02:30:54'
) 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-10 02:30:54'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2025-01-10 02:30:54' 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 10000 offset 10000
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:3 [▼ "num" => "1" "page" => "2" "sort-by" => "default_sorting" ]
0 of 0array:3 [▼ "num" => "1" "page" => "2" "sort-by" => "default_sorting" ]
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 => "18.118.141.153" ] "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=1&page=2&sort-by=default_sorting" "QUERY_STRING" => "num=1&page=2&sort-by=default_sorting" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/1.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_QUERY_STRING" => "num=1&page=2&sort-by=default_sorting" "REDIRECT_URL" => "/public/products" "REMOTE_PORT" => "54698" "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" => "18.118.141.153" "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" => "18.118.141.153" "HTTP_HOST" => "signatureweave.checksample.co.uk" "PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY" => "0" "PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY" => "0" "UNIQUE_ID" => "Z4CGXcZ3bnsFW6N3NcKwoAAAAAc" "REDIRECT_STATUS" => "200" "REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY" => "0" "REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY" => "0" "REDIRECT_UNIQUE_ID" => "Z4CGXcZ3bnsFW6N3NcKwoAAAAAc" "REDIRECT_REDIRECT_STATUS" => "200" "REDIRECT_REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY" => "0" "REDIRECT_REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY" => "0" "REDIRECT_REDIRECT_UNIQUE_ID" => "Z4CGXcZ3bnsFW6N3NcKwoAAAAAc" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1736476254.0947 "REQUEST_TIME" => 1736476254 ]
[]
0 of 0array:10 [▼ "cache-control" => array:1 [▶ 0 => "private, must-revalidate" ] "date" => array:1 [▶ 0 => "Fri, 10 Jan 2025 02:30:54 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=eyJpdiI6ImVqMTh4SFlQY0FqYVlCbjlQVW1JMXc9PSIsInZhbHVlIjoibXJ5WWwwRStCek5MZUh6ZVdOOFpJQTV5N2dGRWhUYThYQ1RXZ0xmeHFCcTlSZ3NQaHJNUHpKVGdzU0ZLcXBMZXlhRE11Y2ViV3FIL0pheDJkOVd5bGJyZFlFclhPdEpIa0VweVkvZkVmd0I5d050M0ZYNXdhOVk4bkgxRjZWSi8iLCJtYWMiOiI2YmU4MjVhOGFhMGE2MmZlYmIwZjRlMWMxMjcwYjRmMDNlMjJlYTgwYTM5NTJiMmRmOWM4ZTkwNzNhMTc5MTdlIiwidGFnIjoiIn0%3D; expires=Fri, 10-Jan-2025 04:30:54 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImVqMTh4SFlQY0FqYVlCbjlQVW1JMXc9PSIsInZhbHVlIjoibXJ5WWwwRStCek5MZUh6ZVdOOFpJQTV5N2dGRWhUYThYQ1RXZ0xmeHFCcTlSZ3NQaHJNUHpKVGdzU0ZLcXBMZXlhRE11Y ▶" 1 => "botble_session=eyJpdiI6ImltM0psamRJWnZua0xyeEtYSkNMTmc9PSIsInZhbHVlIjoialh2Q0JVSGtxWDV5RWxaQXB0Tm8yaHZ3YVhYWGhSaDJsTDd2WVhVUW9rYS9TeG54VWZHOUhTdzFaa2s4ZG1jMi9DVjJLaTY5aTgvd2d5UVBEVDBnNjE0OTQ2Z2lteGdmZlVZR1hwaVhkeUk4ZUZENmZyTlZ4UXY0MXNvSE03aEkiLCJtYWMiOiJlZTMyN2ZlNGQxMjRiMjE1MTVmNGNmYjVjM2U0ZDMwMTAyYzlhNjQ0ZGMzYzI3ODY3M2QwOTg1NzIwYTRhMmM3IiwidGFnIjoiIn0%3D; expires=Fri, 10-Jan-2025 04:30:54 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀botble_session=eyJpdiI6ImltM0psamRJWnZua0xyeEtYSkNMTmc9PSIsInZhbHVlIjoialh2Q0JVSGtxWDV5RWxaQXB0Tm8yaHZ3YVhYWGhSaDJsTDd2WVhVUW9rYS9TeG54VWZHOUhTdzFaa2s4ZG1jMi9DV ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImVqMTh4SFlQY0FqYVlCbjlQVW1JMXc9PSIsInZhbHVlIjoibXJ5WWwwRStCek5MZUh6ZVdOOFpJQTV5N2dGRWhUYThYQ1RXZ0xmeHFCcTlSZ3NQaHJNUHpKVGdzU0ZLcXBMZXlhRE11Y2ViV3FIL0pheDJkOVd5bGJyZFlFclhPdEpIa0VweVkvZkVmd0I5d050M0ZYNXdhOVk4bkgxRjZWSi8iLCJtYWMiOiI2YmU4MjVhOGFhMGE2MmZlYmIwZjRlMWMxMjcwYjRmMDNlMjJlYTgwYTM5NTJiMmRmOWM4ZTkwNzNhMTc5MTdlIiwidGFnIjoiIn0%3D; expires=Fri, 10-Jan-2025 04:30:54 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImVqMTh4SFlQY0FqYVlCbjlQVW1JMXc9PSIsInZhbHVlIjoibXJ5WWwwRStCek5MZUh6ZVdOOFpJQTV5N2dGRWhUYThYQ1RXZ0xmeHFCcTlSZ3NQaHJNUHpKVGdzU0ZLcXBMZXlhRE11Y ▶" 1 => "botble_session=eyJpdiI6ImltM0psamRJWnZua0xyeEtYSkNMTmc9PSIsInZhbHVlIjoialh2Q0JVSGtxWDV5RWxaQXB0Tm8yaHZ3YVhYWGhSaDJsTDd2WVhVUW9rYS9TeG54VWZHOUhTdzFaa2s4ZG1jMi9DVjJLaTY5aTgvd2d5UVBEVDBnNjE0OTQ2Z2lteGdmZlVZR1hwaVhkeUk4ZUZENmZyTlZ4UXY0MXNvSE03aEkiLCJtYWMiOiJlZTMyN2ZlNGQxMjRiMjE1MTVmNGNmYjVjM2U0ZDMwMTAyYzlhNjQ0ZGMzYzI3ODY3M2QwOTg1NzIwYTRhMmM3IiwidGFnIjoiIn0%3D; expires=Fri, 10-Jan-2025 04:30:54 GMT; path=/; httponly ◀botble_session=eyJpdiI6ImltM0psamRJWnZua0xyeEtYSkNMTmc9PSIsInZhbHVlIjoialh2Q0JVSGtxWDV5RWxaQXB0Tm8yaHZ3YVhYWGhSaDJsTDd2WVhVUW9rYS9TeG54VWZHOUhTdzFaa2s4ZG1jMi9DV ▶" ] ]
0 of 0array:5 [▼ "_token" => "pCI3cjVGwrVDAq1ihtp7QEgI3HeTWUYaXnGoth3C" "language" => "en" "_previous" => array:1 [▶ "url" => "http://signatureweave.checksample.co.uk/products?num=1&page=2&sort-by=default_sorting" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]