SELECT * FROM `domains` WHERE `domain` = 'product-19.flowers-qa-en.floraqueen.net'Connection name: default Speed: 0.431 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 7File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 50File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-qa-en.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.386 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 27 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 21File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 50File: DOCROOT/index.php, line 238 |
SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('en_US')Connection name: default Speed: 8.264 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2901 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 124File: APPPATH/base.php, line 14File: APPPATH/config/development/my.php, line 43File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 50File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains`Connection name: default Speed: 2.903 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 27 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 74File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `domain` = 'product-19.flowers-qa-en.floraqueen.net'Connection name: default Speed: 0.592 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 99File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%product-19.flowers-qa-en.floraqueen.net%' OR `alias` LIKE '%flowers-qa-en.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.289 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 27 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 114File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `type` = 'flowers' AND `language` = 'fr_FR' LIMIT 1Connection name: default Speed: 0.234 ms Query analysis: · Query: SIMPLE on domains · Possible keys: type_language · Key Used: type_language · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 207File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 3 AND `permalink` = 'my/login' LIMIT 1Connection name: default Speed: 0.434 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: permalink_domain_language · Type: ref · Rows: 1 (Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 275File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `domain_pages` WHERE `id_domain` = 3 AND `permalink` = 'my/login' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.400 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 311File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 3 AND `permalink` IS NOT null AND (`geo_type` IS null OR `geo_type` IN ('cn')) ORDER BY LENGTH(permalink) DESCConnection name: default Speed: 46.379 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27162 (Using index condition; Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/routing.php, line 25File: APPPATH/bootstrap.php, line 326File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink`, `product_permalink` FROM `product_languages` WHERE `permalink` IS NOT null AND `language` IN ('fr_FR')Connection name: default Speed: 3.775 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,language,permalink_language · Key Used: permalink_language · Type: ref · Rows: 5558 (Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/routing.php, line 38File: APPPATH/bootstrap.php, line 326File: DOCROOT/index.php, line 238 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3Connection name: default Speed: 5.602 ms Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 384File: DOCROOT/index.php, line 238 |
SELECT `id`, `id_domain`, `code`, `name`, `description`, `anchor_text`, `head_title`, `permalink`, `event_start_date`, `event_end_date`, `event_location` FROM `catalogs` WHERE `id_domain` = 3 AND `event_start_date` IS NOT null AND `event_start_date` >= '2022-05-26' ORDER BY `event_start_date` ASCConnection name: default Speed: 0.578 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: event_domain · Type: range · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 128File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 9File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.313 ms Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/controller/base.php, line 206File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 9File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `countries`.`code`, `countries`.`name_fr`, `catalogs`.`permalink` FROM `countries` LEFT JOIN `catalogs` ON (`catalogs`.`geo_country` = `countries`.`code`) WHERE `countries`.`delivery` = 1 AND `catalogs`.`id_domain` = 3 AND `catalogs`.`template` = 'browsing-directory-flowers' AND `catalogs`.`geo_type` = 'cn' ORDER BY `countries`.`name_fr` ASCConnection name: default Speed: 28.849 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 22794 (Using where; Using temporary; Using filesort) · Query: SIMPLE on countries · Possible keys: code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 254File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 9File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT COUNT(id) AS `total`, SUM(rating) AS `rating` FROM `reviews`Connection name: default Speed: 39.764 ms Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 50899 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 287File: APPPATH/classes/controller/base.php, line 271File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 9File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `deleted_time` = 0 AND `active` = 1 AND `permalink` = 'my/login' AND (`version` IS null OR `version` = '') LIMIT 1Connection name: default Speed: 0.588 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 323File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 9File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menu_type`.`name` = 'root' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.936 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index; Using temporary; Using filesort) · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '468' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.432 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '83'Connection name: default Speed: 0.302 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '4765'Connection name: default Speed: 4.383 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '337'Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '242' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.511 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '243' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.492 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '365'Connection name: default Speed: 0.249 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '337'Connection name: default Speed: 0.301 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '333'Connection name: default Speed: 0.266 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '347'Connection name: default Speed: 0.226 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '244' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.445 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '469'Connection name: default Speed: 0.240 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '500170'Connection name: default Speed: 0.231 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '452'Connection name: default Speed: 0.218 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '447'Connection name: default Speed: 0.260 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '500003'Connection name: default Speed: 0.221 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '19' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.409 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '4622'Connection name: default Speed: 0.271 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '608091'Connection name: default Speed: 0.247 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '4457'Connection name: default Speed: 0.248 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '245' ORDER BY `menu_item`.`position`Connection name: default Speed: 4.128 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '246' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.537 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '247' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.395 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '3972'Connection name: default Speed: 0.278 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '1347'Connection name: default Speed: 0.246 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '1348'Connection name: default Speed: 0.242 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '3977'Connection name: default Speed: 0.438 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '3981'Connection name: default Speed: 0.225 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '4149'Connection name: default Speed: 0.265 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 217049 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.251 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 217049Connection name: default Speed: 0.335 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 4 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product` FROM `catalog_products` WHERE `id_catalog` = 337 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.356 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 33 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/experiment/product12/controller.php, line 29File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `currencies` WHERE `code` = 'EUR' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.296 ms Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 33 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 285File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `products`.`id`, `product_languages`.`id_product`, `products`.`active`, `products`.`sku`, `products`.`main_sku`, `products`.`fin_sku`, `products`.`code`, `products`.`group_name`, `products`.`feed_group_name`, `products`.`id_typology`, `products`.`meta_robots_noindex`, `products`.`filter_gender`, `products`.`filter_category`, `products`.`filter_color`, `products`.`created_datetime`, `products`.`feeds_enabled`, `products`.`price` AS `default_price`, `products_typologies`.`code` AS `typology_code`, `product_languages`.`id_badge`, `product_languages`.`language`, `product_languages`.`name`, `product_languages`.`permalink`, `product_languages`.`product_permalink`, `product_languages`.`description`, `product_languages`.`content`, `product_languages`.`content_html`, `product_languages`.`head_title`, `product_languages`.`meta_description`, `product_languages`.`feed_title`, `product_languages`.`feed_description`, `product_languages`.`mkt_name`, `products_badges`.`type` AS `badge_type`, `products_badges`.`position` AS `badge_position`, `products_badges`.`name_fr` AS `badge_name`, `products_badges`.`url_image_fr` AS `badge_url_image`, `products_badges`.`coupon` AS `coupon`, `product_images`.`url_image` AS `url_image`, `product_images`.`url_image_lg` AS `url_image_lg`, `product_images`.`url_image_md` AS `url_image_md`, `product_images`.`url_image_sm` AS `url_image_sm`, `product_images`.`url_image_xs` AS `url_image_xs`, `product_images`.`background_color` AS `image_bg_color`, `product_images_i18n`.`text` AS `image_alt` FROM `product_languages` INNER JOIN `products` ON (`products`.`id` = `product_languages`.`id_product`) LEFT JOIN `products_typologies` ON (`products`.`id_typology` = `products_typologies`.`id`) LEFT JOIN `product_images` ON (`products`.`id` = `product_images`.`id_product` AND `product_images`.`default` = 1 AND `product_images`.`related_sku` IS NULL) LEFT JOIN `products_badges` ON (`products_badges`.`id` = `product_languages`.`id_badge`) LEFT JOIN `coupons` ON (`coupons`.`code` = `products_badges`.`coupon`) LEFT JOIN `product_images_i18n` ON (`product_images_i18n`.`id_product_image` = `product_images`.`id` AND `product_images_i18n`.`language` = `product_languages`.`language`) WHERE `product_languages`.`language` IN ('fr_FR') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2022-05-26') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2022-05-26') AND `products`.`id` IN (43, 193, 231, 2669, 314, 27, 3171, 2662, 2660, 3051) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 43, 193, 231, 2669, 314, 27, 3171, 2662, 2660, 3051) ASC LIMIT 512Connection name: default Speed: 6.746 ms Query analysis: · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: range · Rows: 10 (Using where; Using temporary; Using filesort) · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language,id_name_language · Key Used: unique · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: id_product · Type: ref · Rows: 2 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 294File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product`, `variation`, `variation_a`, `variation_b`, `variation_c`, `retail_price`, `site_price` FROM `product_prices` WHERE `id_product` IN (43, 193, 231, 2669, 314, 27, 3171, 2662, 2660, 3051) AND `active` = 1 AND `variation_a` = 'FR' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 1.190 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: range · Rows: 17 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 260File: APPPATH/classes/catalogs.php, line 404File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.268 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('fr_FR')Connection name: default Speed: 8.132 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2903 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 124File: APPPATH/base.php, line 14File: APPPATH/classes/coupons.php, line 335File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.490 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'EKW56XXL7' AND (`currency_code` IS null OR `currency_code` LIKE 'EUR') LIMIT 1Connection name: default Speed: 0.279 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 166File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.232 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'EKW56XXL7'Connection name: default Speed: 0.247 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'EKW56XXL7'Connection name: default Speed: 0.201 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 4.252 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.281 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'BLACKFRIDAYFQ20' AND (`currency_code` IS null OR `currency_code` LIKE 'EUR') LIMIT 1Connection name: default Speed: 0.259 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 166File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.233 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'BLACKFRIDAYFQ20'Connection name: default Speed: 0.214 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'BLACKFRIDAYFQ20'Connection name: default Speed: 0.216 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.234 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.256 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.229 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'EKW56XXL7' AND (`currency_code` IS null OR `currency_code` LIKE 'EUR') LIMIT 1Connection name: default Speed: 2.854 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 166File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.354 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `coupons` WHERE `code` = 'EKW56XXL7'Connection name: default Speed: 0.285 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `reviews`.`review`, `reviews`.`rating`, `reviews`.`sku`, ROUND(reviews.rating / 5 * 100) AS `per`, `reviews`.`user_name` AS `name`, `user_orders`.`delivery_city` AS `city`, `reviews`.`created_datetime` AS `created` FROM `reviews` LEFT JOIN `user_orders` ON (`user_orders`.`order` = `reviews`.`order`) WHERE `reviews`.`language` = 'fr_FR' AND `reviews`.`sku` IN ('FQ2328', 'FQ112', 'FQ120', 'FQ4051', 'FQ20008', 'FQ119', 'FQ4086', 'FQ1011VIP', 'FQ4049', 'FQ1029VIP') AND `reviews`.`rating` >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) ORDER BY `reviews`.`created_datetime` DESCConnection name: default Speed: 7.124 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 490 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 58File: APPPATH/classes/review.php, line 122File: APPPATH/classes/experiment/product12/controller.php, line 57File: APPPATH/classes/experiment/product12/controller.php, line 32File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS `avg`, `reviews`.`sku` FROM `reviews` WHERE `reviews`.`sku` IN ('FQ2328', 'FQ112', 'FQ120', 'FQ4051', 'FQ20008', 'FQ119', 'FQ4086', 'FQ1011VIP', 'FQ4049', 'FQ1029VIP') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'fr_FR' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 6.548 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku,search · Key Used: language · Type: range · Rows: 490 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 225File: APPPATH/classes/review.php, line 123File: APPPATH/classes/experiment/product12/controller.php, line 57File: APPPATH/classes/experiment/product12/controller.php, line 32File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product` FROM `catalog_products` WHERE `id_catalog` = 500003 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 6.785 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 27 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/experiment/product12/controller.php, line 29File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `currencies` WHERE `code` = 'EUR' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.389 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 33 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 285File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `products`.`id`, `product_languages`.`id_product`, `products`.`active`, `products`.`sku`, `products`.`main_sku`, `products`.`fin_sku`, `products`.`code`, `products`.`group_name`, `products`.`feed_group_name`, `products`.`id_typology`, `products`.`meta_robots_noindex`, `products`.`filter_gender`, `products`.`filter_category`, `products`.`filter_color`, `products`.`created_datetime`, `products`.`feeds_enabled`, `products`.`price` AS `default_price`, `products_typologies`.`code` AS `typology_code`, `product_languages`.`id_badge`, `product_languages`.`language`, `product_languages`.`name`, `product_languages`.`permalink`, `product_languages`.`product_permalink`, `product_languages`.`description`, `product_languages`.`content`, `product_languages`.`content_html`, `product_languages`.`head_title`, `product_languages`.`meta_description`, `product_languages`.`feed_title`, `product_languages`.`feed_description`, `product_languages`.`mkt_name`, `products_badges`.`type` AS `badge_type`, `products_badges`.`position` AS `badge_position`, `products_badges`.`name_fr` AS `badge_name`, `products_badges`.`url_image_fr` AS `badge_url_image`, `products_badges`.`coupon` AS `coupon`, `product_images`.`url_image` AS `url_image`, `product_images`.`url_image_lg` AS `url_image_lg`, `product_images`.`url_image_md` AS `url_image_md`, `product_images`.`url_image_sm` AS `url_image_sm`, `product_images`.`url_image_xs` AS `url_image_xs`, `product_images`.`background_color` AS `image_bg_color`, `product_images_i18n`.`text` AS `image_alt` FROM `product_languages` INNER JOIN `products` ON (`products`.`id` = `product_languages`.`id_product`) LEFT JOIN `products_typologies` ON (`products`.`id_typology` = `products_typologies`.`id`) LEFT JOIN `product_images` ON (`products`.`id` = `product_images`.`id_product` AND `product_images`.`default` = 1 AND `product_images`.`related_sku` IS NULL) LEFT JOIN `products_badges` ON (`products_badges`.`id` = `product_languages`.`id_badge`) LEFT JOIN `coupons` ON (`coupons`.`code` = `products_badges`.`coupon`) LEFT JOIN `product_images_i18n` ON (`product_images_i18n`.`id_product_image` = `product_images`.`id` AND `product_images_i18n`.`language` = `product_languages`.`language`) WHERE `product_languages`.`language` IN ('fr_FR') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2022-05-26') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2022-05-26') AND `products`.`id` IN (514, 281, 595, 41, 2102, 2356, 1479, 592, 174, 800) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 514, 281, 595, 41, 2102, 2356, 1479, 592, 174, 800) ASC LIMIT 512Connection name: default Speed: 2.144 ms Query analysis: · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: range · Rows: 10 (Using where; Using temporary; Using filesort) · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language,id_name_language · Key Used: unique · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: id_product · Type: ref · Rows: 2 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 294File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product`, `variation`, `variation_a`, `variation_b`, `variation_c`, `retail_price`, `site_price` FROM `product_prices` WHERE `id_product` IN (514, 281, 595, 41, 2102, 2356, 1479, 592, 174, 800) AND `active` = 1 AND `variation_a` = 'FR' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 1.068 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: range · Rows: 19 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 260File: APPPATH/classes/catalogs.php, line 404File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.232 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.246 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.261 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.230 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.236 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.231 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.227 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.218 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.240 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.219 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `reviews`.`review`, `reviews`.`rating`, `reviews`.`sku`, ROUND(reviews.rating / 5 * 100) AS `per`, `reviews`.`user_name` AS `name`, `user_orders`.`delivery_city` AS `city`, `reviews`.`created_datetime` AS `created` FROM `reviews` LEFT JOIN `user_orders` ON (`user_orders`.`order` = `reviews`.`order`) WHERE `reviews`.`language` = 'fr_FR' AND `reviews`.`sku` IN ('FQ6001', 'FQ160', 'FQ7007', 'FQ6005', 'PL7198', 'PL1219', 'PL10004', 'FQ7004', 'FQ11007', 'FQ966') AND `reviews`.`rating` >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) ORDER BY `reviews`.`created_datetime` DESCConnection name: default Speed: 4.699 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 120 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 58File: APPPATH/classes/review.php, line 122File: APPPATH/classes/experiment/product12/controller.php, line 57File: APPPATH/classes/experiment/product12/controller.php, line 32File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS `avg`, `reviews`.`sku` FROM `reviews` WHERE `reviews`.`sku` IN ('FQ6001', 'FQ160', 'FQ7007', 'FQ6005', 'PL7198', 'PL1219', 'PL10004', 'FQ7004', 'FQ11007', 'FQ966') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'fr_FR' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 1.061 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku,search · Key Used: language · Type: range · Rows: 120 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 225File: APPPATH/classes/review.php, line 123File: APPPATH/classes/experiment/product12/controller.php, line 57File: APPPATH/classes/experiment/product12/controller.php, line 32File: APPPATH/classes/controller/base.php, line 406File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menus`.`id` FROM `menus` INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) WHERE `menu_type`.`name` = 'prefooter' AND `menus`.`id_domain` = 3Connection name: default Speed: 5.850 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index) · Query: SIMPLE on menus · Possible keys: menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '289' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.571 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '290' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.425 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '291' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.466 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '292' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.423 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '293' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.391 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '337'Connection name: default Speed: 0.263 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '365'Connection name: default Speed: 0.314 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '333'Connection name: default Speed: 0.231 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '347'Connection name: default Speed: 0.219 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '294' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.411 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '469'Connection name: default Speed: 0.233 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '452'Connection name: default Speed: 0.260 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '447'Connection name: default Speed: 0.221 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '500170'Connection name: default Speed: 0.282 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '464'Connection name: default Speed: 0.226 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menus`.`id` FROM `menus` INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) WHERE `menu_type`.`name` = 'footer' AND `menus`.`id_domain` = 3Connection name: default Speed: 0.378 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index) · Query: SIMPLE on menus · Possible keys: menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '65' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.415 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '68' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.383 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 216693 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.240 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 216693Connection name: default Speed: 5.147 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 2 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 217834 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.375 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 217834Connection name: default Speed: 0.298 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 1129968 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.245 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 1129968Connection name: default Speed: 0.250 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 0 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.211 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 216976 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.280 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 216976Connection name: default Speed: 0.756 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '69' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.490 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 217274 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.254 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 217274Connection name: default Speed: 0.554 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 913917 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.238 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 913917Connection name: default Speed: 0.258 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 2 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '70' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.498 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 217351 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.225 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 217351Connection name: default Speed: 0.383 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 889091 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.264 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 889091Connection name: default Speed: 0.515 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 217588 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.233 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 217588Connection name: default Speed: 0.662 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '71' ORDER BY `menu_item`.`position`Connection name: default Speed: 4.447 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 216763 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.283 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 216763Connection name: default Speed: 0.527 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 217123 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.247 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 217123Connection name: default Speed: 0.566 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 5848 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.243 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 5848Connection name: default Speed: 0.237 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 1153719 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.266 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 1153719Connection name: default Speed: 0.213 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menus`.`id` FROM `menus` INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) WHERE `menu_type`.`name` = 'hamburger' AND `menus`.`id_domain` = 3Connection name: default Speed: 0.397 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index) · Query: SIMPLE on menus · Possible keys: menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '21' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.599 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 10 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '124'Connection name: default Speed: 0.304 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '337'Connection name: default Speed: 0.239 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '242' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.415 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '243' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.445 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '365'Connection name: default Speed: 0.308 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '337'Connection name: default Speed: 0.241 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '333'Connection name: default Speed: 0.303 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '347'Connection name: default Speed: 0.224 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '244' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.415 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '469'Connection name: default Speed: 0.256 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '500170'Connection name: default Speed: 0.232 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '452'Connection name: default Speed: 0.223 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '447'Connection name: default Speed: 0.285 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '500003'Connection name: default Speed: 0.257 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '19' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.481 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '4622'Connection name: default Speed: 0.244 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '608091'Connection name: default Speed: 0.253 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '4457'Connection name: default Speed: 0.258 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '245' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.446 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '246' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.415 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '247' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.427 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '3972'Connection name: default Speed: 0.317 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '1347'Connection name: default Speed: 0.245 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '1348'Connection name: default Speed: 0.225 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '3977'Connection name: default Speed: 0.241 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '3981'Connection name: default Speed: 0.223 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '4149'Connection name: default Speed: 0.272 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 217049 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.272 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 217049Connection name: default Speed: 0.364 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 4 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menus`.`id` FROM `menus` INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) WHERE `menu_type`.`name` = 'user' AND `menus`.`id_domain` = 3Connection name: default Speed: 0.474 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index) · Query: SIMPLE on menus · Possible keys: menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 419File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '211' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.428 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '217' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.453 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 8 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 3 AND `id` = 216976 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.244 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_page_content` WHERE `id_page` = 216976Connection name: default Speed: 0.737 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `menu_item`.*, `menu_itemtype`.`name` AS `item_type`, `menu_type`.`name` AS `menu_type`, `menu_visibility`.`name` AS `item_visibility` FROM `menu_item` INNER JOIN `menus` ON (`menus`.`id` = `menu_item`.`id_menu`) INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) INNER JOIN `menu_itemtype` ON (`menu_itemtype`.`id` = `menu_item`.`id_type`) INNER JOIN `menu_visibility` ON (`menu_visibility`.`id` = `menu_item`.`id_visibility`) WHERE `menus`.`id_domain` = 3 AND `menus`.`id` = '218' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.530 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 7 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `catalogs` WHERE `id` = '500198'Connection name: default Speed: 0.272 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 3 LIMIT 1Connection name: default Speed: 0.382 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/views/abtest/go.php, line 3File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/template.php, line 155File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/classes/controller/base.php, line 495File: APPPATH/classes/controller/base.php, line 424File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id`, `id_domain`, `code`, `title`, `name`, `permalink` FROM `domain_pages` WHERE `id_domain` = 3 AND `deleted_time` = 0 AND `active` = 1 AND `code` IN ('legal-privacy') AND (`version` IS null OR `version` = '') GROUP BY `code`Connection name: default Speed: 0.662 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_version_code · Type: ref_or_null · Rows: 2 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 775File: APPPATH/classes/controller/base.php, line 425File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |