SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-it.floraqueen.net'Connection name: default Speed: 0.154 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) 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-stage-it.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.132 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 25 (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: 6.185 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2617 (Using index condition) 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/staging/my.php, line 44File: 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: 0.197 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 25 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 76File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-it.floraqueen.net'Connection name: default Speed: 0.136 ms · DUPLICATE Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 101File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-it.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.126 ms · DUPLICATE Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 25 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 116File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 5 AND `permalink` = 'my/login' LIMIT 1Connection name: default Speed: 0.410 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 where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 277File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `domain_pages` WHERE `id_domain` = 5 AND `permalink` = 'my/login' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.131 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · Key Used: domain_version_pemalink · 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/bootstrap.php, line 313File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 5 AND `permalink` IS NOT null AND (`geo_type` IS null OR `geo_type` IN ('cn')) ORDER BY LENGTH(permalink) DESCConnection name: default Speed: 0.170 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: event_domain · Type: ref · Rows: 29528 (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 328File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink`, `product_permalink` FROM `product_languages` WHERE `permalink` IS NOT null AND `language` IN ('it_IT')Connection name: default Speed: 1.790 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,language,permalink_language · Key Used: permalink_language · Type: ref · Rows: 4872 (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 328File: DOCROOT/index.php, line 238 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5Connection name: default Speed: 0.176 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 386File: 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` = 5 AND `event_start_date` IS NOT null AND `event_start_date` >= '2021-02-28' ORDER BY `event_start_date` ASCConnection name: default Speed: 0.186 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` = 5 LIMIT 1Connection name: default Speed: 0.138 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_it`, `catalogs`.`permalink` FROM `countries` LEFT JOIN `catalogs` ON (`catalogs`.`geo_country` = `countries`.`code`) WHERE `countries`.`delivery` = 1 AND `catalogs`.`id_domain` = 5 AND `catalogs`.`template` = 'browsing-directory-flowers' AND `catalogs`.`geo_type` = 'cn' ORDER BY `countries`.`name_it` ASCConnection name: default Speed: 0.190 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 25110 (Using index condition; 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: 0.153 ms Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 71177 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` = 5 AND `deleted_time` = 0 AND `active` = 1 AND `permalink` = 'my/login' AND (`version` IS null OR `version` = '') LIMIT 1Connection name: default Speed: 0.336 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · Key Used: domain_version_pemalink · 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 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` = 5 AND `menu_type`.`name` = 'root' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.519 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: 2 · 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 * FROM `catalogs` WHERE `id` = '121'Connection name: default Speed: 0.236 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 * FROM `catalogs` WHERE `id` = '339'Connection name: default Speed: 0.227 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` = 5 AND `menus`.`id` = '188' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.372 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; Using where) · 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` = 5 AND `menus`.`id` = '189' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.407 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; Using where) · 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` = '339'Connection name: default Speed: 0.156 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` = '367'Connection name: default Speed: 0.216 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` = '335'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` = '349'Connection name: default Speed: 0.192 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` = 5 AND `menus`.`id` = '190' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.361 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; Using where) · 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` = '471'Connection name: default Speed: 0.228 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` = '499825'Connection name: default Speed: 0.203 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` = '454'Connection name: default Speed: 0.191 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` = '448'Connection name: default Speed: 0.196 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` = '500001'Connection name: default Speed: 0.201 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 * FROM `catalogs` WHERE `id` = '515278'Connection name: default Speed: 0.208 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` = 5 AND `menus`.`id` = '14' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.385 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; Using where) · 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` = '4706'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/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` = '4589'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/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` = 5 AND `menus`.`id` = '248' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.369 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; Using where) · 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` = 5 AND `menus`.`id` = '249' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.378 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; Using where) · 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` = 5 AND `menus`.`id` = '250' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.387 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; Using where) · 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` = '3108'Connection name: default Speed: 0.232 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` = '1337'Connection name: default Speed: 0.224 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` = '3433'Connection name: default Speed: 0.193 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` = '1335'Connection name: default Speed: 0.210 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` = '1334'Connection name: default Speed: 0.201 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` = '3435'Connection name: default Speed: 0.214 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` = 5 AND `id` = 219396 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 · 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` = 219396Connection name: default Speed: 0.292 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 `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` = 5 AND `menus`.`id` = '15' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.332 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; Using where) · 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 `domain_pages` WHERE `id_domain` = 5 AND `id` = 889441 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.211 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 889441Connection name: default Speed: 0.441 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/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` = 5 AND `id` = 1128903 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.207 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 1128903Connection name: default Speed: 0.136 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/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` = 5 AND `id` = 219935 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.201 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 219935Connection name: default Speed: 0.522 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/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` = 121 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.145 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 10 (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.142 ms Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (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_it` AS `badge_name`, `products_badges`.`url_image_it` 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 ('it_IT') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2021-02-28') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2021-02-28') AND `products`.`id` IN (2178, 115, 43, 27, 29, 514, 373, 47, 1618, 45) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 2178, 115, 43, 27, 29, 514, 373, 47, 1618, 45) ASC LIMIT 512Connection name: default Speed: 1.498 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: permalink_product · Type: ref · Rows: 1 (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 (Using where) 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 (2178, 115, 43, 27, 29, 514, 373, 47, 1618, 45) AND `active` = 1 AND `variation_a` = 'IT' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.170 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: 10 (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` = 5 LIMIT 1Connection name: default Speed: 0.144 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 ('it_IT')Connection name: default Speed: 6.292 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2617 (Using index condition) 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` = 5 LIMIT 1Connection name: default Speed: 0.162 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` = 5 LIMIT 1Connection name: default Speed: 0.151 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` = 5 LIMIT 1Connection name: default Speed: 0.143 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` = 5 LIMIT 1Connection name: default Speed: 0.141 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` = 5 LIMIT 1Connection name: default Speed: 0.152 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` = 5 LIMIT 1Connection name: default Speed: 0.136 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` = 5 LIMIT 1Connection name: default Speed: 0.139 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` = 5 LIMIT 1Connection name: default Speed: 0.144 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` = 5 LIMIT 1Connection name: default Speed: 0.128 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` = 'it_IT' AND `reviews`.`sku` IN ('FQ2744', 'FQ0009', 'FQ2328', 'FQ119', 'FQ117', 'FQ6001', 'FQ2745', 'FQ8008', 'FQ30010', 'FQ2313') 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: 14.033 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 140 (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 ('FQ2744', 'FQ0009', 'FQ2328', 'FQ119', 'FQ117', 'FQ6001', 'FQ2745', 'FQ8008', 'FQ30010', 'FQ2313') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'it_IT' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.183 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 140 (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` = 339 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.159 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 10 (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.135 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (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_it` AS `badge_name`, `products_badges`.`url_image_it` 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 ('it_IT') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2021-02-28') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2021-02-28') AND `products`.`id` IN (193, 2347, 30, 3171, 43, 29, 27, 3169, 25, 35) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 193, 2347, 30, 3171, 43, 29, 27, 3169, 25, 35) ASC LIMIT 512Connection name: default Speed: 1.523 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: permalink_product · Type: ref · Rows: 1 (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 (Using where) 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 (193, 2347, 30, 3171, 43, 29, 27, 3169, 25, 35) AND `active` = 1 AND `variation_a` = 'IT' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.155 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: 10 (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` = 5 LIMIT 1Connection name: default Speed: 0.139 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` = 5 LIMIT 1Connection name: default Speed: 0.133 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` = 5 LIMIT 1Connection name: default Speed: 0.152 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` = 5 LIMIT 1Connection name: default Speed: 0.135 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` = 5 LIMIT 1Connection name: default Speed: 0.137 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` = 5 LIMIT 1Connection name: default Speed: 0.131 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` = 5 LIMIT 1Connection name: default Speed: 0.129 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` = 5 LIMIT 1Connection name: default Speed: 0.130 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` = 5 LIMIT 1Connection name: default Speed: 0.156 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` = 5 LIMIT 1Connection name: default Speed: 0.143 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` = 'it_IT' AND `reviews`.`sku` IN ('FQ112', 'FQ4023', 'FQ108', 'FQ2328', 'FQ117', 'FQ119', 'FQ2331', 'FQ8006') 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: 24.291 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 2612 (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 ('FQ112', 'FQ4023', 'FQ108', 'FQ2328', 'FQ117', 'FQ119', 'FQ2331', 'FQ8006') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'it_IT' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.177 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 2612 (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` = 500001 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.162 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 18 (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.132 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (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_it` AS `badge_name`, `products_badges`.`url_image_it` 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 ('it_IT') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2021-02-28') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2021-02-28') AND `products`.`id` IN (1481, 514, 2357, 281, 41, 42, 174, 658, 800, 187) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 1481, 514, 2357, 281, 41, 42, 174, 658, 800, 187) ASC LIMIT 512Connection name: default Speed: 1.534 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: permalink_product · Type: ref · Rows: 1 (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 (Using where) 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 (1481, 514, 2357, 281, 41, 42, 174, 658, 800, 187) AND `active` = 1 AND `variation_a` = 'IT' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.174 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: 10 (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` = 5 LIMIT 1Connection name: default Speed: 0.152 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` = 5 LIMIT 1Connection name: default Speed: 0.133 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` = 5 LIMIT 1Connection name: default Speed: 0.262 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` = 5 LIMIT 1Connection name: default Speed: 0.151 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` = 5 LIMIT 1Connection name: default Speed: 0.135 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` = 5 LIMIT 1Connection name: default Speed: 0.141 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` = 5 LIMIT 1Connection name: default Speed: 0.145 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` = 5 LIMIT 1Connection name: default Speed: 0.144 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` = 5 LIMIT 1Connection name: default Speed: 0.145 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` = 5 LIMIT 1Connection name: default Speed: 0.131 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` = 'it_IT' AND `reviews`.`sku` IN ('PL10016', 'FQ6001', 'PL1220', 'FQ160', 'FQ6005', 'FQ6006', 'FQ11007', 'FQ7244', 'FQ966', 'FQ11114') 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.637 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 140 (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 ('PL10016', 'FQ6001', 'PL1220', 'FQ160', 'FQ6005', 'FQ6006', 'FQ11007', 'FQ7244', 'FQ966', 'FQ11114') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'it_IT' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.163 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 140 (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` = 515278 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.170 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 16 (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.137 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (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_it` AS `badge_name`, `products_badges`.`url_image_it` 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 ('it_IT') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2021-02-28') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2021-02-28') AND `products`.`id` IN (2663, 2662, 2776, 2667, 2661, 2666, 2780, 2772, 2773, 2779) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 2663, 2662, 2776, 2667, 2661, 2666, 2780, 2772, 2773, 2779) ASC LIMIT 512Connection name: default Speed: 1.404 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: permalink_product · Type: ref · Rows: 1 (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 (Using where) 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 (2663, 2662, 2776, 2667, 2661, 2666, 2780, 2772, 2773, 2779) AND `active` = 1 AND `variation_a` = 'IT' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.162 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: 10 (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` = 5 LIMIT 1Connection name: default Speed: 0.154 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` = 5 LIMIT 1Connection name: default Speed: 0.135 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` = 5 LIMIT 1Connection name: default Speed: 0.142 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` = 5 LIMIT 1Connection name: default Speed: 0.142 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` = 5 LIMIT 1Connection name: default Speed: 0.137 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` = 5 LIMIT 1Connection name: default Speed: 0.134 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` = 5 LIMIT 1Connection name: default Speed: 0.140 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` = 5 LIMIT 1Connection name: default Speed: 0.139 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` = 5 LIMIT 1Connection name: default Speed: 0.136 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` = 5 LIMIT 1Connection name: default Speed: 0.139 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` = 'it_IT' AND `reviews`.`sku` IN ('FQ1012VIP', 'FQ1011VIP', 'FQ1021VIP', 'FQ1016VIP', 'FQ1010VIP', 'FQ1015VIP', 'FQ1025VIP', 'FQ1017VIP', 'FQ1018VIP', 'FQ1024VIP') 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: 0.661 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 140 (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 ('FQ1012VIP', 'FQ1011VIP', 'FQ1021VIP', 'FQ1016VIP', 'FQ1010VIP', 'FQ1015VIP', 'FQ1025VIP', 'FQ1017VIP', 'FQ1018VIP', 'FQ1024VIP') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'it_IT' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.140 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 140 (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` = 5Connection name: default Speed: 0.258 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 · Type: ref · Rows: 1 (Using where) 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 `menus`.`id` FROM `menus` INNER JOIN `menu_type` ON (`menu_type`.`id` = `menus`.`id_type`) WHERE `menu_type`.`name` = 'footer' AND `menus`.`id_domain` = 5Connection name: default Speed: 0.258 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` = 5 AND `menus`.`id` = '27' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.388 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; Using where) · 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` = 5 AND `menus`.`id` = '28' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.369 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; Using where) · 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` = 5 AND `id` = 219110 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.150 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 219110Connection name: default Speed: 0.388 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` = 5 AND `id` = 220181 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.221 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 220181Connection name: default Speed: 1.395 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` = 5 AND `id` = 1129972 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.145 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 1129972Connection name: default Speed: 0.189 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` = 5 AND `id` = 219323 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.198 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 219323Connection name: default Speed: 0.538 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` = 5 AND `menus`.`id` = '29' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.397 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; Using where) · 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` = 5 AND `id` = 219621 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 · 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` = 219621Connection name: default Speed: 0.376 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` = 5 AND `id` = 914185 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.220 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 914185Connection name: default Speed: 0.231 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` = 5 AND `menus`.`id` = '40' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.385 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; Using where) · 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` = 5 AND `id` = 219698 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.173 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 219698Connection 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: 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` = 5 AND `id` = 889441 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.139 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 · 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` = 889441Connection name: default Speed: 0.595 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 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` = 5 AND `id` = 219935 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.157 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 · 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` = 219935Connection name: default Speed: 0.412 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 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` = 5 AND `menus`.`id` = '41' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.374 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; Using where) · 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` = 5 AND `id` = 219180 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.223 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 219180Connection name: default Speed: 0.377 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` = 5 AND `id` = 219470 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.155 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 219470Connection name: default Speed: 0.449 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` = 5 AND `id` = 2512 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.139 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 2512Connection name: default Speed: 0.144 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` = 5 AND `id` = 1153718 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.199 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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` = 1153718Connection name: default Speed: 0.133 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` = 5Connection name: default Speed: 0.257 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` = 5 AND `menus`.`id` = '16' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.418 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: 9 (Using index condition; Using where) · 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` = '121'Connection name: default Speed: 0.162 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 * FROM `catalogs` WHERE `id` = '339'Connection name: default Speed: 0.147 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` = 5 AND `menus`.`id` = '188' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.159 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; Using where) · 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` = 5 AND `menus`.`id` = '189' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.154 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: 5 (Using index condition; Using where) · 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` = '339'Connection name: default Speed: 0.197 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` = '367'Connection name: default Speed: 0.147 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` = '335'Connection name: default Speed: 0.148 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` = '349'Connection name: default Speed: 0.142 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` = 5 AND `menus`.`id` = '190' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.170 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; Using where) · 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` = '471'Connection name: default Speed: 0.169 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` = '499825'Connection name: default Speed: 0.146 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` = '454'Connection name: default Speed: 0.138 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` = '448'Connection name: default Speed: 0.145 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` = '500001'Connection name: default Speed: 0.137 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 * FROM `catalogs` WHERE `id` = '515278'Connection name: default Speed: 0.146 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` = 5 AND `menus`.`id` = '14' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.150 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; Using where) · 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` = '4706'Connection name: default Speed: 0.134 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` = '4589'Connection name: default Speed: 0.145 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` = 5 AND `menus`.`id` = '248' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.171 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; Using where) · 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` = 5 AND `menus`.`id` = '249' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.163 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; Using where) · 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` = 5 AND `menus`.`id` = '250' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.148 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; Using where) · 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` = '3108'Connection name: default Speed: 0.168 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` = '1337'Connection name: default Speed: 0.144 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` = '3433'Connection name: default Speed: 0.139 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` = '1335'Connection name: default Speed: 0.136 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` = '1334'Connection name: default Speed: 0.143 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` = '3435'Connection name: default Speed: 0.154 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` = 5 AND `id` = 219396 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.142 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 · 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` = 219396Connection name: default Speed: 0.305 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 `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` = 5 AND `menus`.`id` = '15' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.162 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; Using where) · 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 `domain_pages` WHERE `id_domain` = 5 AND `id` = 889441 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.137 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 · 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` = 889441Connection name: default Speed: 0.433 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 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` = 5 AND `id` = 1128903 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.154 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 · 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` = 1128903Connection name: default Speed: 0.145 ms · DUPLICATE 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 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` = 5 AND `id` = 219935 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.141 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 · 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` = 219935Connection name: default Speed: 0.401 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 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` = 5Connection name: default Speed: 0.256 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` = 5 AND `menus`.`id` = '212' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.476 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; Using where) · 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` = 5 AND `menus`.`id` = '219' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.417 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; Using where) · 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` = 5 AND `id` = 219323 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.155 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 · 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` = 219323Connection name: default Speed: 0.504 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` = 5 AND `menus`.`id` = '220' 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: 7 (Using index condition; Using where) · 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` = '500199'Connection name: default Speed: 0.245 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` = 5 LIMIT 1Connection name: default Speed: 0.178 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 500File: 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` = 5 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.406 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version · 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 780File: 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 |