SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-en.floraqueen.net'Connection name: default Speed: 0.165 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-en.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.135 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.361 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2691 (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.235 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-en.floraqueen.net'Connection name: default Speed: 0.146 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-en.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.123 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 * FROM `domains` WHERE `type` = 'flowers' AND `language` = 'pl_PL' LIMIT 1Connection name: default Speed: 0.127 ms Query analysis: · Query: SIMPLE on domains · Possible keys: type_language · Key Used: type_language · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 209File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 6 AND `permalink` = 'my/login' LIMIT 1Connection name: default Speed: 0.354 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` = 6 AND `permalink` = 'my/login' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.127 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` = 6 AND `permalink` IS NOT null AND (`geo_type` IS null OR `geo_type` IN ('cn')) ORDER BY LENGTH(permalink) DESCConnection name: default Speed: 27.876 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: 28170 (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 ('pl_PL')Connection name: default Speed: 1.574 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,language,permalink_language · Key Used: permalink_language · Type: ref · Rows: 4362 (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` = 6Connection name: default Speed: 0.186 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 * FROM `domain_redirects` WHERE `id_domain` = 6 AND `path` = '/my/login' LIMIT 1Connection name: default Speed: 0.204 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/classes/controller/base.php, line 1153File: APPPATH/classes/controller/base.php, line 43File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
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` = 6 AND `event_start_date` IS NOT null AND `event_start_date` >= '2021-04-20' ORDER BY `event_start_date` ASCConnection name: default Speed: 0.147 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 121File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: 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` = 6 LIMIT 1Connection name: default Speed: 0.143 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 176File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `countries`.`code`, `countries`.`name_pl`, `catalogs`.`permalink` FROM `countries` LEFT JOIN `catalogs` ON (`catalogs`.`geo_country` = `countries`.`code`) WHERE `countries`.`delivery` = 1 AND `catalogs`.`id_domain` = 6 AND `catalogs`.`template` = 'browsing-directory-flowers' AND `catalogs`.`geo_type` = 'cn' ORDER BY `countries`.`name_pl` ASCConnection name: default Speed: 0.204 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 24144 (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 229File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: 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: 73282 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 249File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM `domain_pages` WHERE `id_domain` = 6 AND `deleted_time` = 0 AND `active` = 1 AND `permalink` = 'my/login' AND (`version` IS null OR `version` = '') LIMIT 1Connection name: default Speed: 0.381 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 301File: APPPATH/modules/my/classes/controller/base.php, line 15File: APPPATH/modules/my/classes/controller/login.php, line 16File: 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` = 6 AND `menu_type`.`name` = 'root' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.170 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_1,menus_FK_2 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_1,menus_FK_2); 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 382File: APPPATH/modules/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` = '431'Connection name: default Speed: 0.148 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 382File: APPPATH/modules/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` = '336'Connection name: default Speed: 0.235 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 382File: APPPATH/modules/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` = 6 AND `menus`.`id` = '257' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.142 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 382File: APPPATH/modules/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` = 6 AND `menus`.`id` = '258' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.131 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 382File: APPPATH/modules/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` = '336'Connection name: default Speed: 0.216 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 382File: APPPATH/modules/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` = '364'Connection name: default Speed: 0.154 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 382File: APPPATH/modules/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` = '332'Connection name: default Speed: 0.146 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 382File: APPPATH/modules/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` = '346'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 382File: APPPATH/modules/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` = 6 AND `menus`.`id` = '259' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.155 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 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 382File: APPPATH/modules/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` = '468'Connection name: default Speed: 0.205 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 382File: APPPATH/modules/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` = '451'Connection name: default Speed: 0.219 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 382File: APPPATH/modules/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` = '446'Connection name: default Speed: 0.209 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 382File: APPPATH/modules/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` = '463'Connection name: default Speed: 0.141 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 382File: APPPATH/modules/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` = '515279'Connection name: default Speed: 0.142 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 382File: APPPATH/modules/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` = 6 AND `menus`.`id` = '54' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.187 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 382File: APPPATH/modules/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` = '4663'Connection name: default Speed: 0.135 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 382File: APPPATH/modules/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` = '4678'Connection name: default Speed: 0.139 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 382File: APPPATH/modules/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` = 6 AND `menus`.`id` = '260' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.154 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 382File: APPPATH/modules/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` = 6 AND `menus`.`id` = '261' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.152 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 382File: APPPATH/modules/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` = 6 AND `menus`.`id` = '262' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.146 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 382File: APPPATH/modules/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` = '1331'Connection name: default Speed: 0.213 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 382File: APPPATH/modules/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` = '3193'Connection name: default Speed: 0.139 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 382File: APPPATH/modules/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` = '3185'Connection name: default Speed: 0.351 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 382File: APPPATH/modules/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` = '3192'Connection name: default Speed: 0.220 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 382File: APPPATH/modules/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` = '1338'Connection name: default Speed: 0.152 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 382File: APPPATH/modules/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` = '1336'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 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 382File: APPPATH/modules/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` = 6 AND `id` = 215627 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.159 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 382File: APPPATH/modules/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` = 215627Connection name: default Speed: 0.304 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 382File: APPPATH/modules/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` = 6 AND `menus`.`id` = '53' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.161 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 382File: APPPATH/modules/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` = 6 AND `id` = 889177 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.133 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 382File: APPPATH/modules/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` = 889177Connection name: default Speed: 0.429 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 382File: APPPATH/modules/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` = 6 AND `id` = 216313 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.142 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 382File: APPPATH/modules/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` = 216313Connection name: default Speed: 0.392 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 382File: APPPATH/modules/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` = 431 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.135 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 30File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 'PLN' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.140 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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_pl` AS `badge_name`, `products_badges`.`url_image_pl` 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_collection` = 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 ('pl_PL') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2021-04-20') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2021-04-20') AND `products`.`id` IN (43, 193, 2347, 2669, 27, 2353, 115, 30, 47, 29) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 43, 193, 2347, 2669, 27, 2353, 115, 30, 47, 29) ASC LIMIT 512Connection name: default Speed: 2.917 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product`, `variation`, `variation_a`, `variation_b`, `variation_c`, `retail_price`, `site_price` FROM `product_prices` WHERE `id_product` IN (43, 193, 2347, 2669, 27, 2353, 115, 30, 47, 29) AND `active` = 1 AND `variation_a` = 'PL' 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.138 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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 ('pl_PL')Connection name: default Speed: 5.795 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2398 (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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.189 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.155 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.127 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.261 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.124 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 'pl_PL' AND `reviews`.`sku` IN ('FQ2328', 'FQ112', 'FQ4023', 'FQ4051', 'FQ119', 'FQ4029', 'FQ0009', 'FQ108', 'FQ8008', 'FQ117') 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.214 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 58File: APPPATH/classes/experiment/product12/controller.php, line 33File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS `avg`, `reviews`.`sku` FROM `reviews` WHERE `reviews`.`sku` IN ('FQ2328', 'FQ112', 'FQ4023', 'FQ4051', 'FQ119', 'FQ4029', 'FQ0009', 'FQ108', 'FQ8008', 'FQ117') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'pl_PL' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.143 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 58File: APPPATH/classes/experiment/product12/controller.php, line 33File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 336 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.150 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 30File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 'PLN' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.120 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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_pl` AS `badge_name`, `products_badges`.`url_image_pl` 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_collection` = 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 ('pl_PL') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2021-04-20') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2021-04-20') AND `products`.`id` IN (337, 43, 231, 35, 30, 36, 193, 47, 27, 2347) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 337, 43, 231, 35, 30, 36, 193, 47, 27, 2347) ASC LIMIT 512Connection name: default Speed: 1.463 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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 (337, 43, 231, 35, 30, 36, 193, 47, 27, 2347) AND `active` = 1 AND `variation_a` = 'PL' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.172 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.138 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.153 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.147 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.127 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 'pl_PL' AND `reviews`.`sku` IN ('FQ2306', 'FQ2328', 'FQ120', 'FQ8006', 'FQ108', 'FQ3013', 'FQ112', 'FQ8008', 'FQ119', 'FQ4023') 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: 3.752 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 58File: APPPATH/classes/experiment/product12/controller.php, line 33File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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 ('FQ2306', 'FQ2328', 'FQ120', 'FQ8006', 'FQ108', 'FQ3013', 'FQ112', 'FQ8008', 'FQ119', 'FQ4023') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'pl_PL' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.152 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 58File: APPPATH/classes/experiment/product12/controller.php, line 33File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 463 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.158 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 17 (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 30File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 'PLN' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.123 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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_pl` AS `badge_name`, `products_badges`.`url_image_pl` 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_collection` = 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 ('pl_PL') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2021-04-20') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2021-04-20') AND `products`.`id` IN (514, 2357, 281, 41, 42, 280, 174, 658, 800, 187) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 514, 2357, 281, 41, 42, 280, 174, 658, 800, 187) ASC LIMIT 512Connection name: default Speed: 1.383 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT `id_product`, `variation`, `variation_a`, `variation_b`, `variation_c`, `retail_price`, `site_price` FROM `product_prices` WHERE `id_product` IN (514, 2357, 281, 41, 42, 280, 174, 658, 800, 187) AND `active` = 1 AND `variation_a` = 'PL' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.169 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.127 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 'pl_PL' AND `reviews`.`sku` IN ('FQ6001', 'PL1220', 'FQ160', 'FQ6005', 'FQ6006', 'FQ159', 'FQ11007', 'FQ7244', 'FQ966') AND `reviews`.`rating` >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) ORDER BY `reviews`.`created_datetime` DESCConnection name: default Speed: 0.996 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 40 (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 58File: APPPATH/classes/experiment/product12/controller.php, line 33File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS `avg`, `reviews`.`sku` FROM `reviews` WHERE `reviews`.`sku` IN ('FQ6001', 'PL1220', 'FQ160', 'FQ6005', 'FQ6006', 'FQ159', 'FQ11007', 'FQ7244', 'FQ966') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'pl_PL' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.138 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 40 (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 58File: APPPATH/classes/experiment/product12/controller.php, line 33File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 515279 ORDER BY `position` ASC LIMIT 10Connection name: default Speed: 0.134 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 30File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 'PLN' ORDER BY `created_date` DESC LIMIT 1Connection name: default Speed: 0.122 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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_pl` AS `badge_name`, `products_badges`.`url_image_pl` 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_collection` = 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 ('pl_PL') AND `products`.`deleted_datetime` IS null AND (`products`.`date_on` IS null OR `products`.`date_on` < '2021-04-20') AND (`products`.`date_off` IS null OR `products`.`date_off` > '2021-04-20') AND `products`.`id` IN (2662, 2778, 2776, 2779, 2666, 2661, 2772, 2665, 2664, 2774) GROUP BY `product_languages`.`id_product`, `product_languages`.`language` ORDER BY field(`products`.`id`, 2662, 2778, 2776, 2779, 2666, 2661, 2772, 2665, 2664, 2774) ASC LIMIT 512Connection name: default Speed: 1.420 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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 (2662, 2778, 2776, 2779, 2666, 2661, 2772, 2665, 2664, 2774) AND `active` = 1 AND `variation_a` = 'PL' AND `variation_b` = 'small' ORDER BY `variation_b` DESCConnection name: default Speed: 0.153 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.126 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.132 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.323 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6 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 31File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 'pl_PL' AND `reviews`.`sku` IN ('FQ1011VIP', 'FQ1023VIP', 'FQ1021VIP', 'FQ1024VIP', 'FQ1015VIP', 'FQ1010VIP', 'FQ1017VIP', 'FQ1014VIP', 'FQ1013VIP', 'FQ1019VIP') 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.498 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 58File: APPPATH/classes/experiment/product12/controller.php, line 33File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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 ('FQ1011VIP', 'FQ1023VIP', 'FQ1021VIP', 'FQ1024VIP', 'FQ1015VIP', 'FQ1010VIP', 'FQ1017VIP', 'FQ1014VIP', 'FQ1013VIP', 'FQ1019VIP') AND `reviews`.`rating` >= 4 AND `reviews`.`language` = 'pl_PL' AND (`reviews`.`published` IS null OR `reviews`.`published` = 1) GROUP BY `reviews`.`sku`Connection name: default Speed: 0.153 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 58File: APPPATH/classes/experiment/product12/controller.php, line 33File: APPPATH/classes/controller/base.php, line 384File: APPPATH/modules/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` = 6Connection name: default Speed: 0.128 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 388File: APPPATH/modules/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` = 6Connection name: default Speed: 0.120 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 391File: APPPATH/modules/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` = 6 AND `menus`.`id` = '57' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.253 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 391File: APPPATH/modules/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` = 6 AND `menus`.`id` = '58' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.138 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 391File: APPPATH/modules/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` = 6 AND `id` = 215345 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.136 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 391File: APPPATH/modules/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` = 215345Connection name: default Speed: 0.462 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 391File: APPPATH/modules/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` = 6 AND `id` = 216556 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.140 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 391File: APPPATH/modules/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` = 216556Connection name: default Speed: 0.285 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 391File: APPPATH/modules/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` = 6 AND `menus`.`id` = '59' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.174 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 391File: APPPATH/modules/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` = 6 AND `id` = 215849 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.165 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 391File: APPPATH/modules/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` = 215849Connection name: default Speed: 0.375 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 391File: APPPATH/modules/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` = 6 AND `id` = 913829 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.156 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 391File: APPPATH/modules/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` = 913829Connection name: default Speed: 0.129 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 391File: APPPATH/modules/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` = 6 AND `menus`.`id` = '60' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.160 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 391File: APPPATH/modules/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` = 6 AND `id` = 215925 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.125 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 391File: APPPATH/modules/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` = 215925Connection name: default Speed: 0.315 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 391File: APPPATH/modules/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` = 6 AND `id` = 889177 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 391File: APPPATH/modules/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` = 889177Connection name: default Speed: 0.420 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 391File: APPPATH/modules/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` = 6 AND `id` = 216313 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 391File: APPPATH/modules/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` = 216313Connection name: default Speed: 0.362 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 391File: APPPATH/modules/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` = 6 AND `menus`.`id` = '61' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.155 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 391File: APPPATH/modules/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` = 6 AND `id` = 215414 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.133 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 391File: APPPATH/modules/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` = 215414Connection name: default Speed: 0.592 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 391File: APPPATH/modules/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` = 6 AND `id` = 215700 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.154 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 391File: APPPATH/modules/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` = 215700Connection name: default Speed: 0.446 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 391File: APPPATH/modules/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` = 6 AND `id` = 2393 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 391File: APPPATH/modules/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` = 2393Connection name: default Speed: 0.126 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 391File: APPPATH/modules/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` = 6 AND `id` = 1153721 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.160 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 391File: APPPATH/modules/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` = 1153721Connection name: default Speed: 0.134 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 391File: APPPATH/modules/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` = 6Connection name: default Speed: 0.125 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 394File: APPPATH/modules/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` = 6 AND `menus`.`id` = '56' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.439 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 394File: APPPATH/modules/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` = '431'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 31File: APPPATH/classes/controller/base.php, line 394File: APPPATH/modules/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` = '336'Connection name: default Speed: 0.247 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 394File: APPPATH/modules/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` = 6 AND `menus`.`id` = '257' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.214 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 394File: APPPATH/modules/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` = 6 AND `menus`.`id` = '258' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.144 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 394File: APPPATH/modules/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` = '336'Connection name: default Speed: 0.235 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 394File: APPPATH/modules/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` = '364'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 394File: APPPATH/modules/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` = '332'Connection name: default Speed: 0.132 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 394File: APPPATH/modules/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` = '346'Connection name: default Speed: 0.218 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 394File: APPPATH/modules/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` = 6 AND `menus`.`id` = '259' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.151 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 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 394File: APPPATH/modules/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` = '468'Connection name: default Speed: 0.372 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 394File: APPPATH/modules/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` = '451'Connection name: default Speed: 0.212 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 394File: APPPATH/modules/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` = '446'Connection name: default Speed: 0.223 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 394File: APPPATH/modules/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` = '463'Connection name: default Speed: 0.153 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 394File: APPPATH/modules/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` = '515279'Connection name: default Speed: 0.122 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 394File: APPPATH/modules/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` = 6 AND `menus`.`id` = '260' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.169 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 394File: APPPATH/modules/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` = 6 AND `menus`.`id` = '261' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.138 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 394File: APPPATH/modules/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` = 6 AND `menus`.`id` = '262' 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: 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 394File: APPPATH/modules/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` = '1331'Connection name: default Speed: 0.196 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 394File: APPPATH/modules/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` = '3193'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 394File: APPPATH/modules/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` = '3185'Connection name: default Speed: 0.202 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 394File: APPPATH/modules/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` = '3192'Connection name: default Speed: 0.359 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 394File: APPPATH/modules/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` = '1338'Connection name: default Speed: 0.153 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 394File: APPPATH/modules/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` = '1336'Connection name: default Speed: 0.201 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 394File: APPPATH/modules/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` = 6 AND `id` = 215627 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 394File: APPPATH/modules/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` = 215627Connection name: default Speed: 0.307 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 394File: APPPATH/modules/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` = 6 AND `menus`.`id` = '54' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.164 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 394File: APPPATH/modules/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` = '4663'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 31File: APPPATH/classes/controller/base.php, line 394File: APPPATH/modules/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` = '4678'Connection name: default Speed: 0.151 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 394File: APPPATH/modules/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` = 6 AND `menus`.`id` = '53' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.145 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 394File: APPPATH/modules/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` = 6 AND `id` = 889177 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.129 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 394File: APPPATH/modules/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` = 889177Connection name: default Speed: 0.416 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 394File: APPPATH/modules/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` = 6 AND `id` = 216313 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.147 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 394File: APPPATH/modules/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` = 216313Connection name: default Speed: 0.378 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 394File: APPPATH/modules/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` = 6Connection name: default Speed: 0.140 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 397File: APPPATH/modules/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` = 6 AND `menus`.`id` = '214' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.145 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 397File: APPPATH/modules/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` = 6 AND `menus`.`id` = '223' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.174 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 397File: APPPATH/modules/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` = 6 AND `id` = 215555 AND `deleted_time` = 0 AND `active` = 1 LIMIT 1Connection name: default Speed: 0.142 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 397File: APPPATH/modules/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` = 215555Connection name: default Speed: 0.810 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 397File: APPPATH/modules/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` = 6 AND `menus`.`id` = '224' ORDER BY `menu_item`.`position`Connection name: default Speed: 0.161 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 397File: APPPATH/modules/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` = '500197'Connection name: default Speed: 0.475 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 397File: APPPATH/modules/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` = 6 LIMIT 1Connection name: default Speed: 0.153 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 478File: APPPATH/classes/controller/base.php, line 402File: APPPATH/modules/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` = 6 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.221 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 758File: APPPATH/classes/controller/base.php, line 403File: APPPATH/modules/my/classes/controller/base.php, line 47File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |