SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-it.floraqueen.net'Connection name: default
Speed: 0.342 ms
Query analysis:
· Query: SIMPLE (Impossible WHERE noticed after reading const tables)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 7File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-it.floraqueen.net%' LIMIT 1Connection name: default
Speed: 0.320 ms
Query analysis:
· Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 22File: 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 52File: DOCROOT/index.php, line 238 |
SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('en_US')Connection name: default
Speed: 7.384 ms
Query analysis:
· Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2957 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 48File: APPPATH/config/staging/my.php, line 48File: 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 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains`Connection name: default
Speed: 0.374 ms
Query analysis:
· Query: SIMPLE on domains · Type: ALL · Rows: 26
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 77File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-it.floraqueen.net'Connection name: default
Speed: 0.328 ms · DUPLICATE
Query analysis:
· Query: SIMPLE (Impossible WHERE noticed after reading const tables)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 102File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-it.floraqueen.net%' LIMIT 1Connection name: default
Speed: 0.318 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 117File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 5 AND `permalink` = 'consegna-fiori-in-italia/roma' LIMIT 1Connection name: default
Speed: 0.496 ms
Query analysis:
· Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: permalink_domain_language · Type: ref · Rows: 1 (Using where; Using index)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 274File: DOCROOT/index.php, line 238 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5Connection name: default
Speed: 0.344 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 383File: DOCROOT/index.php, line 238 |
SELECT * FROM `domain_redirects` WHERE `id_domain` = 5 AND `path` = '/consegna-fiori-in-italia/roma' LIMIT 1Connection name: default
Speed: 0.426 ms
Query analysis:
· Query: SIMPLE (Impossible WHERE noticed after reading const tables)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1186File: APPPATH/classes/controller/base.php, line 44File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 5 AND event_start_date IS NOT null AND event_start_date >= '2022-05-26' ORDER BY event_start_date ASCConnection name: slave
Speed: 0.329 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 124File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 5 LIMIT 1Connection name: slave
Speed: 0.355 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 179File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.code, country_i18n.name, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE countries.delivery = 1 AND catalogs.id_domain = 5 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' AND country_i18n.language = 'it_IT' ORDER BY country_i18n.name ASCConnection name: slave
Speed: 0.376 ms
Query analysis:
· Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 23658 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on countries · Possible keys: PRIMARY,code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on country_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1149File: APPPATH/classes/controller/base.php, line 209File: APPPATH/classes/controller/catalog.php, line 51File: 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: 0.328 ms
Query analysis:
· Query: SIMPLE on reviews · Type: ALL · Rows: 75787
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 300File: APPPATH/classes/controller/base.php, line 212File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 5 AND deleted_time = 0 AND active = 1 AND permalink = 'consegna-fiori-in-italia/roma' AND (version IS null OR version = '') LIMIT 1Connection name: slave
Speed: 0.555 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 index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 264File: APPPATH/classes/controller/catalog.php, line 51File: 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 = 5 AND code = 'default') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.370 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)
· 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 163File: APPPATH/classes/controller/catalog.php, line 57File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_combar WHERE id_domain = 5 AND (date_init IS null OR date_init <= '2022-05-26 23:00:00') AND (date_end IS null OR date_end >= '2022-05-26 23:00:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave
Speed: 0.366 ms
Query analysis:
· Query: SIMPLE on domain_combar · Possible keys: IDX_B514A64819EABE6 · Key Used: IDX_B514A64819EABE6 · Type: ref · Rows: 10 (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 58File: 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 = 1234) LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.572 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 163File: APPPATH/classes/controller/catalog.php, line 87File: 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 = 5 LIMIT 1Connection name: slave
Speed: 0.367 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 38File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT filter_catalog.* FROM filter_catalog WHERE id_catalog = 1234Connection name: slave
Speed: 0.342 ms
Query analysis:
· Query: SIMPLE on filter_catalog · Possible keys: IDX_ACBC4522C5B19B37 · Key Used: IDX_ACBC4522C5B19B37 · Type: ref · Rows: 1 (Using index)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 167File: APPPATH/classes/filters.php, line 25File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT filters.id, filters.slug, filters.type, filter_i18n.name, filter_i18n.description FROM filters INNER JOIN filter_i18n ON (filter_i18n.id_filter = filters.id) WHERE filter_i18n.language = 'it_IT' AND filters.slug IN ('flower-type', 'colour') ORDER BY filters.slug DESCConnection name: slave
Speed: 0.327 ms
Query analysis:
· Query: SIMPLE on filters · Possible keys: PRIMARY,UNIQ_7877678D989D9B62 · Key Used: UNIQ_7877678D989D9B62 · Type: range · Rows: 2 (Using index condition)
· Query: SIMPLE on filter_i18n · Possible keys: fk_filters,language · Key Used: fk_filters · Type: ref · Rows: 3 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 62File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT filter_properties.id, filter_properties.slug, filter_property_i18n.name FROM filter_properties INNER JOIN filter_property_i18n ON (filter_property_i18n.id_property = filter_properties.id) WHERE filter_properties.id_filter = '2' AND filter_property_i18n.language = 'it_IT'Connection name: slave
Speed: 0.330 ms
Query analysis:
· Query: SIMPLE on filter_properties · Possible keys: PRIMARY,id_filter_idx,id_active_order · Key Used: id_filter_idx · Type: ref · Rows: 13
· Query: SIMPLE on filter_property_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 79File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT filter_properties.id, filter_properties.slug, filter_property_i18n.name FROM filter_properties INNER JOIN filter_property_i18n ON (filter_property_i18n.id_property = filter_properties.id) WHERE filter_properties.id_filter = '1' AND filter_property_i18n.language = 'it_IT'Connection name: slave
Speed: 0.326 ms
Query analysis:
· Query: SIMPLE on filter_properties · Possible keys: PRIMARY,id_filter_idx,id_active_order · Key Used: id_filter_idx · Type: ref · Rows: 8
· Query: SIMPLE on filter_property_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 79File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.422 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 131 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.383 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 52 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.366 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 20 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.399 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 48 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.380 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 20 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.424 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 33 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.391 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.386 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 8 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.342 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.368 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.374 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.363 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.371 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 15 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.414 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 1.678 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 115 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' 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: 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 1.623 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 84 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 1.127 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.358 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.364 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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 'IT' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.351 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 5 (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 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 444File: APPPATH/classes/trait/catalog.php, line 71File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalog_statics WHERE id_catalog = 1234 AND type IN ('content') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave
Speed: 0.513 ms
Query analysis:
· Query: SIMPLE on catalog_statics · Possible keys: id_catalog,catalog_active,catalog_position,catalog_version_type · Key Used: catalog_active · 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 533File: APPPATH/classes/trait/catalog.php, line 74File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalog_statics WHERE id_catalog = 1234 AND type IN ('hero-banner') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave
Speed: 0.338 ms
Query analysis:
· Query: SIMPLE on catalog_statics · Possible keys: id_catalog,catalog_active,catalog_position,catalog_version_type · Key Used: catalog_active · 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 533File: APPPATH/classes/trait/catalog.php, line 77File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 1234 ORDER BY position ASCConnection name: slave
Speed: 0.427 ms
Query analysis:
· Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_position · Type: ref · Rows: 1 (Using where)
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 363File: APPPATH/classes/trait/catalog.php, line 87File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_domain, type_value FROM domain_configs WHERE domain_configs.id_domain = 5Connection name: slave
Speed: 0.327 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/trait/catalog.php, line 1211File: APPPATH/classes/trait/catalog.php, line 98File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: 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 = 5 AND code = 'all-our-flowers') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.344 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)
· 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 163File: APPPATH/classes/trait/catalog.php, line 101File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.name, product_languages.permalink FROM user_orders INNER JOIN products ON (products.sku = user_orders.product_sku) INNER JOIN product_languages ON (products.id = product_languages.id_product) WHERE user_orders.status = 'delivered' AND user_orders.language = 'it_IT' AND user_orders.delivery_date >= '2021-05-26' AND product_languages.language = 'it_IT' GROUP BY user_orders.product_sku ORDER BY COUNT(*) DESC LIMIT 5Connection name: slave
Speed: 1.413 s
Query analysis:
· Query: SIMPLE on user_orders · Type: ALL · Rows: 2100964 (Using where; Using temporary; Using filesort)
· Query: SIMPLE on products · Possible keys: PRIMARY,usku,sku,id_sku_active · Key Used: usku · Type: eq_ref · Rows: 1 (Using where; Using index)
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: eq_ref · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 662File: APPPATH/classes/trait/catalog.php, line 103File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.*, countries.code, country_i18n.name AS located_name FROM countries INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE (countries.code = 'IT' AND country_i18n.language = 'it_IT') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.382 ms
Query analysis:
· Query: SIMPLE on countries · Possible keys: PRIMARY,code,code_es,code_en · Key Used: code · Type: const · Rows: 1
· Query: SIMPLE on country_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 10 (Using where)
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 624File: APPPATH/classes/trait/catalog.php, line 104File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT global_geo_cities.geo_lng, global_geo_cities.geo_lat FROM global_geo_city_languages INNER JOIN global_geo_cities ON (global_geo_city_languages.id_city = global_geo_cities.id) WHERE global_geo_cities.countrycode = 'IT' AND global_geo_city_languages.language = 'it_IT' AND global_geo_city_languages.name = 'Roma' LIMIT 1Connection name: slave
Speed: 0.356 ms
Query analysis:
· Query: SIMPLE on global_geo_cities · Possible keys: PRIMARY,countrycode · Key Used: countrycode · Type: ref · Rows: 2099 (Using index condition)
· Query: SIMPLE on global_geo_city_languages · Possible keys: city_id,unique,id_city · Key Used: city_id · Type: eq_ref · Rows: 1 (Using index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/catalog.php, line 657File: APPPATH/classes/trait/catalog.php, line 104File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.id, catalogs.code, catalogs.geo_city, catalogs.permalink, catalogs.meta_robots_noindex FROM catalogs WHERE catalogs.code LIKE 'flowers-%' AND catalogs.geo_type = 'ty' AND catalogs.geo_country = 'IT' AND catalogs.permalink IS NOT null AND catalogs.id_domain = 5 AND catalogs.meta_robots_noindex = 0 ORDER BY catalogs.codeConnection name: slave
Speed: 30.470 ms
Query analysis:
· Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27400 (Using where; Using filesort)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/catalog.php, line 853File: APPPATH/classes/trait/catalog.php, line 104File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.id, catalogs.code, catalogs.geo_country, catalogs.permalink, catalogs.meta_robots_noindex FROM catalogs WHERE catalogs.code LIKE 'flowers-%' AND catalogs.geo_type = 'cn' AND catalogs.permalink IS NOT null AND catalogs.id_domain = 5 AND catalogs.meta_robots_noindex = 0 ORDER BY catalogs.codeConnection name: slave
Speed: 0.412 ms
Query analysis:
· Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27400 (Using where; Using filesort)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/catalog.php, line 883File: APPPATH/classes/trait/catalog.php, line 104File: APPPATH/classes/controller/catalog.php, line 123File: 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 = 22 ORDER BY position ASCConnection name: slave
Speed: 0.339 ms
Query analysis:
· Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 54 (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 888File: APPPATH/classes/trait/catalog.php, line 104File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave
Speed: 0.328 ms
Query analysis:
· Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/catalog.php, line 888File: APPPATH/classes/trait/catalog.php, line 104File: APPPATH/classes/controller/catalog.php, line 123File: 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_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = 'it_IT') LEFT JOIN coupons ON (coupons.code = products_badges.coupon) LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = product_languages.language) WHERE product_languages.language IN ('it_IT') AND products.deleted_datetime IS null AND (products.date_on IS null OR products.date_on < '2022-05-26') AND (products.date_off IS null OR products.date_off > '2022-05-26') AND products.id IN (43, 193, 27, 2669, 30, 2660, 1967, 2782, 361, 4269, 4633, 2079, 231, 36, 4268, 29, 25, 2347, 31, 1518, 47, 45, 4632, 4271, 33, 316, 4634, 4267, 2157, 4266, 35, 314) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 43, 193, 27, 2669, 30, 2660, 1967, 2782, 361, 4269, 4633, 2079, 231, 36, 4268, 29, 25, 2347, 31, 1518, 47, 45, 4632, 4271, 33, 316, 4634, 4267, 2157, 4266, 35, 314) ASC LIMIT 512Connection name: slave
Speed: 3.989 ms
Query analysis:
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 32 (Using index condition; Using temporary; Using filesort)
· Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where)
· Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 3 (Using where)
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index)
· Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/trait/catalog.php, line 888File: APPPATH/classes/trait/catalog.php, line 104File: APPPATH/classes/controller/catalog.php, line 123File: 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_badge_i18n.name AS badge_name, products_badge_i18n.url 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 ur |
