ConfigurationLogsProfilingEventsMailTimelineDumpRouterRequestUserAsset BundlesDatabase
Prev Next
All Latest
67da84027851c: GET https://lepnoedelo.ru/catalog/pivobeers?from=2 at 2025-03-19 08:44:50 am by 43.157.202.235

Database

Database Queries

Total 53 items.
TimeDurationTypeDuplicatedQuery
   
08:44:50.4950.3 msSELECT1
SELECT * FROM `catalogue_categories` WHERE `slug`='pivobeers'

[+] Explain
08:44:50.4950.6 msSHOW1
SHOW FULL COLUMNS FROM `catalogue_categories`
08:44:50.4960.3 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'catalogue_categories' AND `kcu`.`TABLE_NAME` = 'catalogue_categories'

[+] Explain
08:44:50.4970.9 msSELECT1
SELECT COUNT(*) FROM `catalogue_items` LEFT JOIN `catalogue_items_to_categories` ON `catalogue_items`.`id` = `catalogue_items_to_categories`.`item_id` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE (`catalogue_items`.`is_active`=1) AND (`slug`='pivobeers')

[+] Explain
08:44:50.4981.8 msSELECT1
SELECT `catalogue_items`.* FROM `catalogue_items` LEFT JOIN `catalogue_items_to_categories` ON `catalogue_items`.`id` = `catalogue_items_to_categories`.`item_id` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE (`catalogue_items`.`is_active`=1) AND (`slug`='pivobeers') ORDER BY `catalogue_items`.`id` LIMIT 60 OFFSET 120

[+] Explain
08:44:50.5000.5 msSHOW1
SHOW FULL COLUMNS FROM `catalogue_items`
08:44:50.5010.3 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'catalogue_items' AND `kcu`.`TABLE_NAME` = 'catalogue_items'

[+] Explain
08:44:50.5020.5 msSELECT1
SELECT `catalogue_items_to_categories`.* FROM `catalogue_items_to_categories` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE `catalogue_items_to_categories`.`item_id` IN (498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537)

[+] Explain
08:44:50.5030.5 msSHOW1
SHOW FULL COLUMNS FROM `catalogue_items_to_categories`
08:44:50.5030.3 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'catalogue_items_to_categories' AND `kcu`.`TABLE_NAME` = 'catalogue_items_to_categories'

[+] Explain
08:44:50.5040.2 msSELECT1
SELECT * FROM `catalogue_categories` WHERE `id`=9

[+] Explain
08:44:50.5060.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=498))

[+] Explain
08:44:50.5070.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=499))

[+] Explain
08:44:50.5070.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=500))

[+] Explain
08:44:50.5080.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=501))

[+] Explain
08:44:50.5080.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=502))

[+] Explain
08:44:50.5090.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=503))

[+] Explain
08:44:50.5100.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=504))

[+] Explain
08:44:50.5100.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=505))

[+] Explain
08:44:50.5110.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=506))

[+] Explain
08:44:50.5110.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=507))

[+] Explain
08:44:50.5120.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=508))

[+] Explain
08:44:50.5130.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=509))

[+] Explain
08:44:50.5130.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=510))

[+] Explain
08:44:50.5140.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=511))

[+] Explain
08:44:50.5150.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=512))

[+] Explain
08:44:50.5150.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=513))

[+] Explain
08:44:50.5160.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=514))

[+] Explain
08:44:50.5170.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=515))

[+] Explain
08:44:50.5170.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=516))

[+] Explain
08:44:50.5180.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=517))

[+] Explain
08:44:50.5180.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=518))

[+] Explain
08:44:50.5190.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=519))

[+] Explain
08:44:50.5200.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=520))

[+] Explain
08:44:50.5200.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=521))

[+] Explain
08:44:50.5210.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=522))

[+] Explain
08:44:50.5220.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=523))

[+] Explain
08:44:50.5220.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=524))

[+] Explain
08:44:50.5230.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=525))

[+] Explain
08:44:50.5240.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=526))

[+] Explain
08:44:50.5240.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=527))

[+] Explain
08:44:50.5250.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=528))

[+] Explain
08:44:50.5250.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=529))

[+] Explain
08:44:50.5260.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=530))

[+] Explain
08:44:50.5270.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=531))

[+] Explain
08:44:50.5270.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=532))

[+] Explain
08:44:50.5280.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=533))

[+] Explain
08:44:50.5280.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=534))

[+] Explain
08:44:50.5290.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=535))

[+] Explain
08:44:50.5300.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=536))

[+] Explain
08:44:50.5300.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=537))

[+] Explain
08:44:50.5310.2 msSELECT1
SELECT * FROM `catalogue_categories`

[+] Explain
08:44:50.5320.3 msSELECT1
SELECT COUNT(*) FROM `carts` WHERE `session_id`=''

[+] Explain
[+] Explain all

Database Callers

Total 6 items.
CallerNo. of CallsTotal DurationQueries
406.3 ms
Time Duration Queries
08:44:50.5060.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=498))

[+] Explain
08:44:50.5070.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=499))

[+] Explain
08:44:50.5070.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=500))

[+] Explain
08:44:50.5080.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=501))

[+] Explain
08:44:50.5080.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=502))

[+] Explain
08:44:50.5090.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=503))

[+] Explain
08:44:50.5100.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=504))

[+] Explain
08:44:50.5100.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=505))

[+] Explain
08:44:50.5110.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=506))

[+] Explain
08:44:50.5110.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=507))

[+] Explain
08:44:50.5120.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=508))

[+] Explain
08:44:50.5130.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=509))

[+] Explain
08:44:50.5130.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=510))

[+] Explain
08:44:50.5140.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=511))

[+] Explain
08:44:50.5150.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=512))

[+] Explain
08:44:50.5150.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=513))

[+] Explain
08:44:50.5160.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=514))

[+] Explain
08:44:50.5170.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=515))

[+] Explain
08:44:50.5170.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=516))

[+] Explain
08:44:50.5180.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=517))

[+] Explain
08:44:50.5180.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=518))

[+] Explain
08:44:50.5190.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=519))

[+] Explain
08:44:50.5200.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=520))

[+] Explain
08:44:50.5200.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=521))

[+] Explain
08:44:50.5210.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=522))

[+] Explain
08:44:50.5220.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=523))

[+] Explain
08:44:50.5220.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=524))

[+] Explain
08:44:50.5230.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=525))

[+] Explain
08:44:50.5240.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=526))

[+] Explain
08:44:50.5240.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=527))

[+] Explain
08:44:50.5250.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=528))

[+] Explain
08:44:50.5250.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=529))

[+] Explain
08:44:50.5260.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=530))

[+] Explain
08:44:50.5270.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=531))

[+] Explain
08:44:50.5270.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=532))

[+] Explain
08:44:50.5280.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=533))

[+] Explain
08:44:50.5280.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=534))

[+] Explain
08:44:50.5290.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=535))

[+] Explain
08:44:50.5300.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=536))

[+] Explain
08:44:50.5300.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=537))

[+] Explain
74.0 ms
Time Duration Queries
08:44:50.4981.8 ms
SELECT `catalogue_items`.* FROM `catalogue_items` LEFT JOIN `catalogue_items_to_categories` ON `catalogue_items`.`id` = `catalogue_items_to_categories`.`item_id` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE (`catalogue_items`.`is_active`=1) AND (`slug`='pivobeers') ORDER BY `catalogue_items`.`id` LIMIT 60 OFFSET 120

[+] Explain
08:44:50.5000.5 ms
SHOW FULL COLUMNS FROM `catalogue_items`
08:44:50.5010.3 ms
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'catalogue_items' AND `kcu`.`TABLE_NAME` = 'catalogue_items'

[+] Explain
08:44:50.5020.5 ms
SELECT `catalogue_items_to_categories`.* FROM `catalogue_items_to_categories` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE `catalogue_items_to_categories`.`item_id` IN (498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537)

[+] Explain
08:44:50.5030.5 ms
SHOW FULL COLUMNS FROM `catalogue_items_to_categories`
08:44:50.5030.3 ms
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'catalogue_items_to_categories' AND `kcu`.`TABLE_NAME` = 'catalogue_items_to_categories'

[+] Explain
08:44:50.5040.2 ms
SELECT * FROM `catalogue_categories` WHERE `id`=9

[+] Explain
31.3 ms
Time Duration Queries
08:44:50.4950.3 ms
SELECT * FROM `catalogue_categories` WHERE `slug`='pivobeers'

[+] Explain
08:44:50.4950.6 ms
SHOW FULL COLUMNS FROM `catalogue_categories`
08:44:50.4960.3 ms
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'catalogue_categories' AND `kcu`.`TABLE_NAME` = 'catalogue_categories'

[+] Explain
10.9 ms
Time Duration Queries
08:44:50.4970.9 ms
SELECT COUNT(*) FROM `catalogue_items` LEFT JOIN `catalogue_items_to_categories` ON `catalogue_items`.`id` = `catalogue_items_to_categories`.`item_id` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE (`catalogue_items`.`is_active`=1) AND (`slug`='pivobeers')

[+] Explain
10.2 ms
Time Duration Queries
08:44:50.5310.2 ms
SELECT * FROM `catalogue_categories`

[+] Explain
10.3 ms
Time Duration Queries
08:44:50.5320.3 ms
SELECT COUNT(*) FROM `carts` WHERE `session_id`=''

[+] Explain
[+] Explain all