SELECT * FROM `domains` WHERE `domain` = 'product-19.flowers-qa-en.floraqueen.net'Connection name: default Speed: 0.496 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 7File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 50File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-qa-en.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.369 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 27 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 21File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 50File: DOCROOT/index.php, line 238 |
SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('en_US')Connection name: default Speed: 8.221 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2901 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 124File: APPPATH/base.php, line 14File: APPPATH/config/development/my.php, line 43File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 50File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains`Connection name: default Speed: 0.458 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 27 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 74File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `domain` = 'product-19.flowers-qa-en.floraqueen.net'Connection name: default Speed: 0.223 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 99File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%product-19.flowers-qa-en.floraqueen.net%' OR `alias` LIKE '%flowers-qa-en.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.288 ms Query analysis: · Query: SIMPLE on domains · Type: ALL · Rows: 27 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 114File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 13 AND `permalink` = 'international-flower-delivery/labor-day' LIMIT 1Connection name: default Speed: 0.643 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: permalink_domain_language · Type: ref · Rows: 1 (Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 275File: DOCROOT/index.php, line 238 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 13Connection name: default Speed: 0.304 ms Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 384File: DOCROOT/index.php, line 238 |
SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 13 AND event_start_date IS NOT null AND event_start_date >= '2022-08-07' ORDER BY event_start_date ASCConnection name: slave Speed: 0.650 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: event_domain · Type: range · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 128File: APPPATH/classes/controller/catalog.php, line 50File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.339 ms Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/controller/base.php, line 206File: APPPATH/classes/controller/catalog.php, line 50File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.code, countries.name_en, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) WHERE countries.delivery = 1 AND catalogs.id_domain = 13 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' ORDER BY countries.name_en ASCConnection name: slave Speed: 35.326 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 21676 (Using where; Using temporary; Using filesort) · Query: SIMPLE on countries · Possible keys: code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 254File: APPPATH/classes/controller/catalog.php, line 50File: 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 reviewsConnection name: slave Speed: 47.588 ms Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 50899 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 287File: APPPATH/classes/controller/base.php, line 271File: APPPATH/classes/controller/catalog.php, line 50File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND deleted_time = 0 AND active = 1 AND permalink = 'international-flower-delivery/labor-day' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.741 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 323File: APPPATH/classes/controller/catalog.php, line 50File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.*, catalog_properties.* FROM catalogs LEFT JOIN catalog_properties ON (catalog_properties.id_catalog = catalogs.id) WHERE (id_domain = 13 AND code = 'default') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.583 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,event_name,event_domain,domain_template · Key Used: domain_code_language · Type: ref · Rows: 18 (Using index condition) · Query: SIMPLE on catalog_properties · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/controller/catalog.php, line 177File: APPPATH/classes/controller/catalog.php, line 56File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_combar WHERE id_domain = 13 AND (date_init IS null OR date_init <= '2022-08-07 21:30:00') AND (date_end IS null OR date_end >= '2022-08-07 21:30:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.397 ms Query analysis: · Query: SIMPLE on domain_combar · Possible keys: IDX_B514A64819EABE6 · Key Used: IDX_B514A64819EABE6 · Type: ref · Rows: 2 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/combar.php, line 95File: APPPATH/classes/controller/catalog.php, line 57File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.*, catalog_properties.* FROM catalogs LEFT JOIN catalog_properties ON (catalog_properties.id_catalog = catalogs.id) WHERE (id = 4324) LIMIT 1 OFFSET 0Connection name: slave Speed: 0.483 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on catalog_properties · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/controller/catalog.php, line 177File: APPPATH/classes/controller/catalog.php, line 85File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_redirects WHERE id_domain = 13 AND path = '/international-flower-delivery/labor-day' LIMIT 1Connection name: slave Speed: 0.284 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1170File: APPPATH/classes/controller/catalog.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.302 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/trait/catalog.php, line 35File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM filters WHERE filters.slug IN ('flower-type', 'colour') ORDER BY filters.slug DESCConnection name: slave Speed: 6.669 ms Query analysis: · Query: SIMPLE on filters · Possible keys: UNIQ_7877678D989D9B62 · Key Used: UNIQ_7877678D989D9B62 · Type: range · Rows: 2 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 36File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM filter_properties WHERE filter_properties.id_filter = '2'Connection name: slave Speed: 0.554 ms Query analysis: · Query: SIMPLE on filter_properties · Possible keys: id_filter_idx,id_active_order · Key Used: id_filter_idx · Type: ref · Rows: 13 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 45File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM filter_properties WHERE filter_properties.id_filter = '1'Connection name: slave Speed: 0.243 ms Query analysis: · Query: SIMPLE on filter_properties · Possible keys: id_filter_idx,id_active_order · Key Used: id_filter_idx · Type: ref · Rows: 8 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 45File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '4' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 3.376 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 129 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '5' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 1.912 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 53 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '10' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.568 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 16 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '12' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 1.193 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 55 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '19' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.781 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 23 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '22' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.830 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 30 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '23' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.963 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 34 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '24' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.802 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 7 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '25' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 6.258 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 12 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '33' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.612 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 2 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '34' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.415 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 1 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '35' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.490 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 3 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '36' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.572 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 10 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '1' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 1.029 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 50 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '2' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 1.963 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 111 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '3' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 1.961 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 91 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '9' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 1.383 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 69 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '11' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.955 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 26 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '13' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.961 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 31 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '27' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 3.359 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 1 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '32' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'DE' GROUP BY product_prices.id_productConnection name: slave Speed: 0.730 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 6 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · 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: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 73File: APPPATH/classes/trait/catalog.php, line 344File: APPPATH/classes/trait/catalog.php, line 60File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalog_statics WHERE id_catalog = 4324 AND type IN ('content') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave Speed: 41.423 ms Query analysis: · Query: SIMPLE on catalog_statics · Possible keys: id_catalog,catalog_active,catalog_position,catalog_version_type · Key Used: id_catalog · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 529File: APPPATH/classes/trait/catalog.php, line 63File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalog_statics WHERE id_catalog = 4324 AND type IN ('hero-banner') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave Speed: 4.920 ms Query analysis: · Query: SIMPLE on catalog_statics · Possible keys: id_catalog,catalog_active,catalog_position,catalog_version_type · Key Used: id_catalog · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 529File: APPPATH/classes/trait/catalog.php, line 66File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product FROM catalog_products WHERE id_catalog = 4324 ORDER BY position ASCConnection name: slave Speed: 0.725 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 15 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 82File: APPPATH/classes/trait/catalog.php, line 267File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'USD' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.561 ms Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 33 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 285File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: 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_en AS badge_name, products_badges.url_image_en AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('en_US') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-08-07') AND (products.date_off IS null OR products.date_off > '2022-08-07') AND products.id IN (30, 44, 231, 43, 47, 32, 28, 1551, 48, 1552, 29, 38, 193, 35, 27) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 30, 44, 231, 43, 47, 32, 28, 1551, 48, 1552, 29, 38, 193, 35, 27) ASC LIMIT 512Connection name: slave Speed: 3.704 ms Query analysis: · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: range · Rows: 15 (Using where; Using temporary; Using filesort) · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language,id_name_language · Key Used: unique · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: id_product · Type: ref · Rows: 2 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 294File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: 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 (30, 44, 231, 43, 47, 32, 28, 1551, 48, 1552, 29, 38, 193, 35, 27) AND active = 1 AND variation_a = 'DE' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 2.829 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: 27 (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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 5.410 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.258 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.264 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.265 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.246 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.246 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'BLACKFRIDAYFQ10' AND (currency_code IS null OR currency_code LIKE 'USD') LIMIT 1Connection name: slave Speed: 0.277 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 166File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.229 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'BLACKFRIDAYFQ10'Connection name: slave Speed: 0.280 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'BLACKFRIDAYFQ10'Connection name: slave Speed: 0.233 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.298 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.473 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.392 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.331 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.296 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.255 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.259 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'BLACKFRIDAYFQ20' AND (currency_code IS null OR currency_code LIKE 'USD') LIMIT 1Connection name: slave Speed: 0.245 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 166File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.290 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/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'BLACKFRIDAYFQ20'Connection name: slave Speed: 0.238 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'BLACKFRIDAYFQ20'Connection name: slave Speed: 0.244 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/trait/catalog.php, line 274File: APPPATH/classes/trait/catalog.php, line 76File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.* FROM catalogs WHERE (id_domain = '13' AND code = 'all-our-flowers') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.428 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,event_name,event_domain,domain_template · Key Used: domain_code_language · Type: ref · Rows: 17 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/catalog.php, line 376File: APPPATH/classes/trait/catalog.php, line 103File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 13 LIMIT 1Connection name: slave Speed: 0.253 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/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/trait/catalog.php, line 430File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: 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 = 'en_US' AND reviews.sku IN ('FQ108', 'FQ2308', 'FQ120', 'FQ2328', 'FQ8008', 'FQ2324', 'FQ2304', 'FQ2501', 'FQ2505', 'FQ117', 'FQ112', 'FQ8006', 'FQ119') 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: slave Speed: 60.481 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 4356 (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/trait/catalog.php, line 434File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ108', 'FQ2308', 'FQ120', 'FQ2328', 'FQ8008', 'FQ2324', 'FQ2304', 'FQ2501', 'FQ2505', 'FQ117', 'FQ112', 'FQ8006', 'FQ119') AND reviews.rating >= 4 AND reviews.language = 'en_US' AND (reviews.published IS null OR reviews.published = 1) GROUP BY reviews.skuConnection name: slave Speed: 22.578 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku,search · Key Used: language · Type: range · Rows: 4356 (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/trait/catalog.php, line 434File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 30 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.671 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 44 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.446 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 5 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 43 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.396 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 47 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.444 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 32 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.364 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 28 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.411 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 29 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.381 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 193 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.392 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 35 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.391 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'en_US') WHERE product_images.id_product = 27 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.360 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using index condition; Using filesort) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 336File: APPPATH/classes/trait/catalog.php, line 116File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, permalink, language, id_domain, code FROM catalogs WHERE code = 'event-labor-day' AND template = 'default' AND meta_robots_noindex = 0Connection name: slave Speed: 0.378 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: domain_code_language,meta_robots_noindex · Key Used: domain_code_language · Type: ref · Rows: 3 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/catalog.php, line 993File: APPPATH/classes/trait/catalog.php, line 120File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.* FROM catalogs WHERE (id = '499905') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.339 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: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/catalog.php, line 947File: APPPATH/classes/trait/catalog.php, line 924File: APPPATH/classes/trait/catalog.php, line 121File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM reviews WHERE reviews.id_domain = 13 AND (reviews.rating >= 4 OR reviews.published = 1) AND LENGTH(review) - LENGTH(REPLACE(review, ' ', '')) + 1 >= 7 ORDER BY reviews.created_datetime DESC LIMIT 9Connection name: slave Speed: 0.862 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: index6 · Key Used: search · Type: index · Rows: 18 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 263File: APPPATH/classes/trait/catalog.php, line 130File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT COUNT(id) AS total, SUM(rating) AS rating FROM reviewsConnection name: slave Speed: 41.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 50899 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 287File: APPPATH/classes/trait/catalog.php, line 137File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.*, code, name_en AS name FROM countries WHERE (code IS null) ORDER BY name_en ASC LIMIT 1 OFFSET 0Connection name: slave Speed: 0.316 ms Query analysis: · Query: SIMPLE (Impossible WHERE) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/countries.php, line 303File: APPPATH/classes/trait/catalog.php, line 176File: APPPATH/classes/controller/catalog.php, line 137File: COREPATH/classes/request.php, line 454File: 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 = 13 AND menu_type.name = 'root' ORDER BY menu_item.positionConnection name: slave Speed: 5.395 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index; Using temporary; Using filesort) · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '467' ORDER BY menu_item.positionConnection name: slave Speed: 0.573 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2436'Connection name: slave Speed: 0.314 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4487'Connection name: slave Speed: 0.265 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2492'Connection name: slave Speed: 0.293 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '77' ORDER BY menu_item.positionConnection name: slave Speed: 0.478 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '78' ORDER BY menu_item.positionConnection name: slave Speed: 0.653 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2492'Connection name: slave Speed: 0.267 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2498'Connection name: slave Speed: 0.254 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2491'Connection name: slave Speed: 0.249 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2495'Connection name: slave Speed: 0.315 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '79' ORDER BY menu_item.positionConnection name: slave Speed: 0.532 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2519'Connection name: slave Speed: 0.338 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '500163'Connection name: slave Speed: 0.300 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2515'Connection name: slave Speed: 0.287 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2514'Connection name: slave Speed: 0.370 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '500005'Connection name: slave Speed: 0.301 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '82' ORDER BY menu_item.positionConnection name: slave Speed: 0.625 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4486'Connection name: slave Speed: 0.321 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608095'Connection name: slave Speed: 0.368 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4590'Connection name: slave Speed: 0.336 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '75' ORDER BY menu_item.positionConnection name: slave Speed: 1.795 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '76' ORDER BY menu_item.positionConnection name: slave Speed: 0.619 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2002'Connection name: slave Speed: 0.301 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2160'Connection name: slave Speed: 0.318 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2085'Connection name: slave Speed: 0.274 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2289'Connection name: slave Speed: 0.248 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2050'Connection name: slave Speed: 0.319 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2103'Connection name: slave Speed: 0.298 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '81' ORDER BY menu_item.positionConnection name: slave Speed: 0.530 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 212738 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.482 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 212738Connection name: slave Speed: 0.387 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 4 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/controller/base.php, line 404File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 2492 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.418 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 36 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/experiment/product12/controller.php, line 29File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'USD' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 7.372 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 33 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 285File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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_en AS badge_name, products_badges.url_image_en AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('en_US') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-08-07') AND (products.date_off IS null OR products.date_off > '2022-08-07') AND products.id IN (43, 2669, 27, 193, 314, 231, 2667, 2347, 2664, 2660) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 43, 2669, 27, 193, 314, 231, 2667, 2347, 2664, 2660) ASC LIMIT 512Connection name: slave Speed: 2.464 ms Query analysis: · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: range · Rows: 10 (Using where; Using temporary; Using filesort) · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language,id_name_language · Key Used: unique · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: id_product · Type: ref · Rows: 2 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 294File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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, 2669, 27, 193, 314, 231, 2667, 2347, 2664, 2660) AND active = 1 AND variation_a = 'DE' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 1.186 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: 18 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 260File: APPPATH/classes/catalogs.php, line 404File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.268 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.263 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'BLACKFRIDAYFQ20' AND (currency_code IS null OR currency_code LIKE 'USD') LIMIT 1Connection name: slave Speed: 0.298 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 166File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.228 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'BLACKFRIDAYFQ20'Connection name: slave Speed: 0.219 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM coupons WHERE code = 'BLACKFRIDAYFQ20'Connection name: slave Speed: 0.276 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 124File: APPPATH/classes/coupons.php, line 133File: APPPATH/classes/coupons.php, line 349File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.250 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.239 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.288 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 4.917 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.395 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.296 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.292 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 'en_US' AND reviews.sku IN ('FQ2328', 'FQ4051', 'FQ119', 'FQ112', 'FQ20008', 'FQ120', 'FQ4023', 'FQ1013VIP', 'FQ4049') 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: slave Speed: 27.169 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 2238 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 58File: APPPATH/classes/review.php, line 122File: APPPATH/classes/experiment/product12/controller.php, line 57File: APPPATH/classes/experiment/product12/controller.php, line 32File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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', 'FQ4051', 'FQ119', 'FQ112', 'FQ20008', 'FQ120', 'FQ4023', 'FQ1013VIP', 'FQ4049') AND reviews.rating >= 4 AND reviews.language = 'en_US' AND (reviews.published IS null OR reviews.published = 1) GROUP BY reviews.skuConnection name: slave Speed: 8.538 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku,search · Key Used: language · Type: range · Rows: 2238 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 225File: APPPATH/classes/review.php, line 123File: APPPATH/classes/experiment/product12/controller.php, line 57File: APPPATH/classes/experiment/product12/controller.php, line 32File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 500005 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.592 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 27 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/experiment/product12/controller.php, line 29File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'USD' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.298 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 33 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 285File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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_en AS badge_name, products_badges.url_image_en AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('en_US') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-08-07') AND (products.date_off IS null OR products.date_off > '2022-08-07') AND products.id IN (514, 281, 595, 41, 2102, 2356, 1479, 592, 174, 800) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 514, 281, 595, 41, 2102, 2356, 1479, 592, 174, 800) ASC LIMIT 512Connection name: slave Speed: 2.439 ms Query analysis: · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: range · Rows: 10 (Using where; Using temporary; Using filesort) · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language,id_name_language · Key Used: unique · Type: eq_ref · Rows: 1 · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: id_product · Type: ref · Rows: 2 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index) · Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 294File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (514, 281, 595, 41, 2102, 2356, 1479, 592, 174, 800) AND active = 1 AND variation_a = 'DE' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 1.265 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: 18 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 260File: APPPATH/classes/catalogs.php, line 404File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.280 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.295 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.235 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.259 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.234 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.243 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.254 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.294 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.233 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 0.233 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 323File: APPPATH/classes/coupons.php, line 176File: APPPATH/classes/catalogs.php, line 430File: APPPATH/classes/experiment/product12/controller.php, line 30File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 'en_US' AND reviews.sku IN ('FQ6001', 'FQ160', 'FQ7007', 'FQ6005', 'PL7198', 'PL1219', 'PL10004', 'FQ7004', 'FQ11007', 'FQ966') AND reviews.rating >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (reviews.published IS null OR reviews.published = 1) ORDER BY reviews.created_datetime DESCConnection name: slave Speed: 4.339 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 334 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 58File: APPPATH/classes/review.php, line 122File: APPPATH/classes/experiment/product12/controller.php, line 57File: APPPATH/classes/experiment/product12/controller.php, line 32File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ6001', 'FQ160', 'FQ7007', 'FQ6005', 'PL7198', 'PL1219', 'PL10004', 'FQ7004', 'FQ11007', 'FQ966') AND reviews.rating >= 4 AND reviews.language = 'en_US' AND (reviews.published IS null OR reviews.published = 1) GROUP BY reviews.skuConnection name: slave Speed: 1.956 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku,search · Key Used: language · Type: range · Rows: 334 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 225File: APPPATH/classes/review.php, line 123File: APPPATH/classes/experiment/product12/controller.php, line 57File: APPPATH/classes/experiment/product12/controller.php, line 32File: APPPATH/classes/controller/base.php, line 406File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13Connection name: slave Speed: 0.653 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index) · Query: SIMPLE on menus · Possible keys: menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 410File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '275' ORDER BY menu_item.positionConnection name: slave Speed: 0.628 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '277' ORDER BY menu_item.positionConnection name: slave Speed: 0.492 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '278' ORDER BY menu_item.positionConnection name: slave Speed: 0.452 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '279' ORDER BY menu_item.positionConnection name: slave Speed: 0.593 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '280' ORDER BY menu_item.positionConnection name: slave Speed: 0.477 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '281' ORDER BY menu_item.positionConnection name: slave Speed: 0.579 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 410File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13Connection name: slave Speed: 0.481 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index) · Query: SIMPLE on menus · Possible keys: menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '35' ORDER BY menu_item.positionConnection name: slave Speed: 0.549 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '36' ORDER BY menu_item.positionConnection name: slave Speed: 0.514 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 212194 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.268 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 212194Connection name: slave Speed: 0.585 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 2 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 1129969 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.257 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 1129969Connection name: slave Speed: 0.254 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 0 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.277 ms Query analysis: · Query: SIMPLE (no matching row in const table) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 212658 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.257 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 212658Connection name: slave Speed: 1.020 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 2 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '37' ORDER BY menu_item.positionConnection name: slave Speed: 3.777 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 212901 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.278 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 212901Connection name: slave Speed: 0.585 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 913742 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.300 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 913742Connection name: slave Speed: 0.259 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 2 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '38' ORDER BY menu_item.positionConnection name: slave Speed: 0.496 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 212984 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.258 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 212984Connection name: slave Speed: 0.360 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 895381 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.289 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 895381Connection name: slave Speed: 0.544 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 213326 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.238 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 213326Connection name: slave Speed: 0.544 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 3 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '39' ORDER BY menu_item.positionConnection name: slave Speed: 0.526 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 862914 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.243 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 862914Connection name: slave Speed: 0.634 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 2 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 212347 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.374 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 212347Connection name: slave Speed: 0.524 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 2 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 2138 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.273 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 2138Connection name: slave Speed: 0.278 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 1153715 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.312 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 1153715Connection name: slave Speed: 0.241 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 413File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13Connection name: slave Speed: 0.475 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index) · Query: SIMPLE on menus · Possible keys: menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '34' ORDER BY menu_item.positionConnection name: slave Speed: 0.629 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 10 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2509'Connection name: slave Speed: 0.278 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2492'Connection name: slave Speed: 0.320 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '77' ORDER BY menu_item.positionConnection name: slave Speed: 0.606 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '78' ORDER BY menu_item.positionConnection name: slave Speed: 0.649 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2492'Connection name: slave Speed: 0.269 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2498'Connection name: slave Speed: 0.267 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2491'Connection name: slave Speed: 0.313 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2495'Connection name: slave Speed: 0.441 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '79' ORDER BY menu_item.positionConnection name: slave Speed: 0.431 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2519'Connection name: slave Speed: 0.279 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '500163'Connection name: slave Speed: 0.231 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2515'Connection name: slave Speed: 0.373 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2514'Connection name: slave 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 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '500005'Connection name: slave Speed: 0.276 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '82' ORDER BY menu_item.positionConnection name: slave Speed: 0.450 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 4 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4486'Connection name: slave Speed: 0.255 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '608095'Connection name: slave Speed: 0.233 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '4590'Connection name: slave Speed: 0.289 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '75' ORDER BY menu_item.positionConnection name: slave Speed: 0.509 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '76' ORDER BY menu_item.positionConnection name: slave Speed: 0.469 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2002'Connection name: slave Speed: 0.263 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2160'Connection name: slave Speed: 0.295 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2085'Connection name: slave Speed: 0.266 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2289'Connection name: slave Speed: 0.243 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2050'Connection name: slave Speed: 0.230 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '2103'Connection name: slave Speed: 0.243 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '81' ORDER BY menu_item.positionConnection name: slave Speed: 0.462 ms · DUPLICATE Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 5 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 212738 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.315 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 212738Connection name: slave Speed: 0.278 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 4 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 416File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13Connection name: slave Speed: 0.415 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index) · Query: SIMPLE on menus · Possible keys: menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 27File: APPPATH/classes/controller/base.php, line 419File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '210' ORDER BY menu_item.positionConnection name: slave Speed: 0.502 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '215' ORDER BY menu_item.positionConnection name: slave Speed: 0.509 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 8 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 13 AND id = 212658 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.306 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 181File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 212658Connection name: slave Speed: 0.895 ms · DUPLICATE 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 419File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND menus.id = '216' ORDER BY menu_item.positionConnection name: slave Speed: 0.545 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 7 (Using index condition) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 80File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs WHERE id = '500196'Connection name: slave Speed: 0.264 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 177File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 168File: APPPATH/classes/menu.php, line 86File: APPPATH/classes/menu.php, line 31File: APPPATH/classes/controller/base.php, line 419File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 LIMIT 1Connection name: slave Speed: 1.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/views/abtest/go.php, line 3File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/template.php, line 155File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/classes/controller/base.php, line 495File: APPPATH/classes/controller/base.php, line 424File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, id_domain, code, name, anchor_text, head_title, geo_country, permalink FROM catalogs WHERE id_domain = 13 AND code IN ('all-our-flowers', 'occasion-birthday', 'occasion-love', 'occasion-birth', 'occasion-funeral', 'all-our-flowers', 'bestsellers')Connection name: slave Speed: 0.776 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,event_name,event_domain,domain_template · Key Used: domain_code_language · Type: range · Rows: 94 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 737File: APPPATH/classes/controller/base.php, line 425File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT code, name_en FROM countries WHERE delivery = 1 ORDER BY name_en ASCConnection name: slave Speed: 0.612 ms Query analysis: · Query: SIMPLE on countries · Possible keys: delivery · Key Used: delivery · Type: ref · Rows: 100 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 748File: APPPATH/classes/controller/base.php, line 425File: APPPATH/classes/controller/catalog.php, line 68File: 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 = 13 AND deleted_time = 0 AND active = 1 AND code IN ('landing-international-flowers-delivery', 'landing-international-flowers-delivery', 'legal-privacy') AND (version IS null OR version = '') GROUP BY codeConnection name: slave Speed: 0.428 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_version_code · Type: range · Rows: 4 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 775File: APPPATH/classes/controller/base.php, line 425File: APPPATH/classes/controller/catalog.php, line 68File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |