ConfigurationLogsProfilingEventsMailTimelineDumpRouterRequestUserAsset BundlesDatabase
Prev Next
All Latest
67daf9b904587: GET https://en.lepnoedelo.ru/catalog at 2025-03-19 05:07:05 pm by 66.249.66.192

Database

Database Queries

Total 72 items.
TimeDurationTypeDuplicatedQuery
   
17:07:05.0201.7 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

[+] Explain
17:07:05.0220.7 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 ORDER BY `catalogue_items`.`id` LIMIT 60

[+] Explain
17:07:05.0230.8 msSHOW1
SHOW FULL COLUMNS FROM `catalogue_items`
17:07:05.0240.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
17:07:05.0260.6 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 (3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 36, 37, 38, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65)

[+] Explain
17:07:05.0270.5 msSHOW1
SHOW FULL COLUMNS FROM `catalogue_items_to_categories`
17:07:05.0280.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
17:07:05.0290.2 msSELECT1
SELECT * FROM `catalogue_categories` WHERE `id` IN (1, 3)

[+] Explain
17:07:05.0290.5 msSHOW1
SHOW FULL COLUMNS FROM `catalogue_categories`
17:07:05.0300.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
17:07:05.0320.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=3))

[+] Explain
17:07:05.0330.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=4))

[+] Explain
17:07:05.0330.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=5))

[+] Explain
17:07:05.0340.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=6))

[+] Explain
17:07:05.0350.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=7))

[+] Explain
17:07:05.0350.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=8))

[+] Explain
17:07:05.0360.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=9))

[+] Explain
17:07:05.0360.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=10))

[+] Explain
17:07:05.0370.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=12))

[+] Explain
17:07:05.0380.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=13))

[+] Explain
17:07:05.0380.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=14))

[+] Explain
17:07:05.0390.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=15))

[+] Explain
17:07:05.0390.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=16))

[+] Explain
17:07:05.0400.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=17))

[+] Explain
17:07:05.0410.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=18))

[+] Explain
17:07:05.0410.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=19))

[+] Explain
17:07:05.0420.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=20))

[+] Explain
17:07:05.0430.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=21))

[+] Explain
17:07:05.0430.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=22))

[+] Explain
17:07:05.0440.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=23))

[+] Explain
17:07:05.0440.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=24))

[+] Explain
17:07:05.0450.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=25))

[+] Explain
17:07:05.0460.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=26))

[+] Explain
17:07:05.0460.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=27))

[+] Explain
17:07:05.0470.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=28))

[+] Explain
17:07:05.0470.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=29))

[+] Explain
17:07:05.0480.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=30))

[+] Explain
17:07:05.0490.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=31))

[+] Explain
17:07:05.0490.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=32))

[+] Explain
17:07:05.0500.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=33))

[+] Explain
17:07:05.0500.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=34))

[+] Explain
17:07:05.0510.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=36))

[+] Explain
17:07:05.0520.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=37))

[+] Explain
17:07:05.0520.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=38))

[+] Explain
17:07:05.0530.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=39))

[+] Explain
17:07:05.0530.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=40))

[+] Explain
17:07:05.0540.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=41))

[+] Explain
17:07:05.0550.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=42))

[+] Explain
17:07:05.0550.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=44))

[+] Explain
17:07:05.0560.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=45))

[+] Explain
17:07:05.0560.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=46))

[+] Explain
17:07:05.0570.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=47))

[+] Explain
17:07:05.0580.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=48))

[+] Explain
17:07:05.0580.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=49))

[+] Explain
17:07:05.0590.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=50))

[+] Explain
17:07:05.0600.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=51))

[+] Explain
17:07:05.0600.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=52))

[+] Explain
17:07:05.0610.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=53))

[+] Explain
17:07:05.0620.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=54))

[+] Explain
17:07:05.0620.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=55))

[+] Explain
17:07:05.0630.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=56))

[+] Explain
17:07:05.0630.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=57))

[+] Explain
17:07:05.0640.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=58))

[+] Explain
17:07:05.0650.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=59))

[+] Explain
17:07:05.0650.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=60))

[+] Explain
17:07:05.0660.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=61))

[+] Explain
17:07:05.0660.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=62))

[+] Explain
17:07:05.0670.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=63))

[+] Explain
17:07:05.0680.1 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=64))

[+] Explain
17:07:05.0680.2 msSELECT1
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=65))

[+] Explain
17:07:05.0690.3 msSELECT1
SELECT * FROM `catalogue_categories`

[+] Explain
17:07:05.0700.2 msSELECT1
SELECT COUNT(*) FROM `carts` WHERE `session_id`=''

[+] Explain
[+] Explain all

Database Callers

Total 5 items.
CallerNo. of CallsTotal DurationQueries
609.9 ms
Time Duration Queries
17:07:05.0320.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=3))

[+] Explain
17:07:05.0330.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=4))

[+] Explain
17:07:05.0330.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=5))

[+] Explain
17:07:05.0340.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=6))

[+] Explain
17:07:05.0350.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=7))

[+] Explain
17:07:05.0350.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=8))

[+] Explain
17:07:05.0360.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=9))

[+] Explain
17:07:05.0360.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=10))

[+] Explain
17:07:05.0370.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=12))

[+] Explain
17:07:05.0380.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=13))

[+] Explain
17:07:05.0380.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=14))

[+] Explain
17:07:05.0390.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=15))

[+] Explain
17:07:05.0390.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=16))

[+] Explain
17:07:05.0400.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=17))

[+] Explain
17:07:05.0410.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=18))

[+] Explain
17:07:05.0410.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=19))

[+] Explain
17:07:05.0420.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=20))

[+] Explain
17:07:05.0430.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=21))

[+] Explain
17:07:05.0430.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=22))

[+] Explain
17:07:05.0440.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=23))

[+] Explain
17:07:05.0440.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=24))

[+] Explain
17:07:05.0450.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=25))

[+] Explain
17:07:05.0460.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=26))

[+] Explain
17:07:05.0460.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=27))

[+] Explain
17:07:05.0470.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=28))

[+] Explain
17:07:05.0470.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=29))

[+] Explain
17:07:05.0480.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=30))

[+] Explain
17:07:05.0490.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=31))

[+] Explain
17:07:05.0490.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=32))

[+] Explain
17:07:05.0500.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=33))

[+] Explain
17:07:05.0500.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=34))

[+] Explain
17:07:05.0510.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=36))

[+] Explain
17:07:05.0520.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=37))

[+] Explain
17:07:05.0520.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=38))

[+] Explain
17:07:05.0530.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=39))

[+] Explain
17:07:05.0530.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=40))

[+] Explain
17:07:05.0540.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=41))

[+] Explain
17:07:05.0550.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=42))

[+] Explain
17:07:05.0550.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=44))

[+] Explain
17:07:05.0560.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=45))

[+] Explain
17:07:05.0560.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=46))

[+] Explain
17:07:05.0570.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=47))

[+] Explain
17:07:05.0580.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=48))

[+] Explain
17:07:05.0580.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=49))

[+] Explain
17:07:05.0590.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=50))

[+] Explain
17:07:05.0600.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=51))

[+] Explain
17:07:05.0600.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=52))

[+] Explain
17:07:05.0610.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=53))

[+] Explain
17:07:05.0620.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=54))

[+] Explain
17:07:05.0620.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=55))

[+] Explain
17:07:05.0630.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=56))

[+] Explain
17:07:05.0630.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=57))

[+] Explain
17:07:05.0640.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=58))

[+] Explain
17:07:05.0650.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=59))

[+] Explain
17:07:05.0650.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=60))

[+] Explain
17:07:05.0660.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=61))

[+] Explain
17:07:05.0660.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=62))

[+] Explain
17:07:05.0670.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=63))

[+] Explain
17:07:05.0680.1 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=64))

[+] Explain
17:07:05.0680.2 ms
SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=65))

[+] Explain
94.1 ms
Time Duration Queries
17:07:05.0220.7 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 ORDER BY `catalogue_items`.`id` LIMIT 60

[+] Explain
17:07:05.0230.8 ms
SHOW FULL COLUMNS FROM `catalogue_items`
17:07:05.0240.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
17:07:05.0260.6 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 (3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 36, 37, 38, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65)

[+] Explain
17:07:05.0270.5 ms
SHOW FULL COLUMNS FROM `catalogue_items_to_categories`
17:07:05.0280.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
17:07:05.0290.2 ms
SELECT * FROM `catalogue_categories` WHERE `id` IN (1, 3)

[+] Explain
17:07:05.0290.5 ms
SHOW FULL COLUMNS FROM `catalogue_categories`
17:07:05.0300.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
11.7 ms
Time Duration Queries
17:07:05.0201.7 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

[+] Explain
10.3 ms
Time Duration Queries
17:07:05.0690.3 ms
SELECT * FROM `catalogue_categories`

[+] Explain
10.2 ms
Time Duration Queries
17:07:05.0700.2 ms
SELECT COUNT(*) FROM `carts` WHERE `session_id`=''

[+] Explain
[+] Explain all