SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default
Speed: 0.201 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 54File: DOCROOT/index.php, line 232 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default
Speed: 0.220 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 54File: DOCROOT/index.php, line 232 |
SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('en_US')Connection name: default
Speed: 8.412 ms
Query analysis:
· Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2963 (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 47File: 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 54File: DOCROOT/index.php, line 232 |
SELECT * FROM `domains`Connection name: default
Speed: 0.295 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 232 |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default
Speed: 0.211 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 232 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default
Speed: 0.195 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 232 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 2 AND `permalink` = 'envio-flores-a-espana/granollers' LIMIT 1Connection name: default
Speed: 0.166 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 273File: DOCROOT/index.php, line 232 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 2Connection name: default
Speed: 0.190 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 382File: DOCROOT/index.php, line 232 |
SELECT * FROM `domain_redirects` WHERE `id_domain` = 2 AND `path` = '/envio-flores-a-espana/granollers' LIMIT 1Connection name: default
Speed: 0.435 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 988File: APPPATH/classes/controller/base.php, line 52File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT groupname, name, language, text FROM i18n WHERE language IN ('es_ES')Connection name: slave
Speed: 8.405 ms
Query analysis:
· Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2987 (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 47File: APPPATH/classes/controller/base.php, line 94File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT catalogs.*, catalog_properties.* FROM catalogs LEFT JOIN catalog_properties ON (catalog_properties.id_catalog = catalogs.id) WHERE (id_domain = 2 AND code = 'all-our-flowers') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.286 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/base.php, line 98File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND code = 'company-help' AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave
Speed: 0.208 ms
Query analysis:
· Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_version_code · Type: ref · Rows: 1 (Using index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 54File: APPPATH/classes/controller/base.php, line 103File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_page_content WHERE id_page = 214297Connection name: slave
Speed: 0.281 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 71File: APPPATH/classes/controller/base.php, line 103File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 2 AND event_start_date IS NOT null AND event_start_date >= '2022-08-07' ORDER BY event_start_date ASCConnection name: slave
Speed: 0.179 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 155File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.178 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 223File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 2 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' AND country_i18n.language = 'es_ES' ORDER BY country_i18n.name ASCConnection name: slave
Speed: 0.251 ms
Query analysis:
· Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 23950 (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 950File: APPPATH/classes/controller/base.php, line 253File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT COUNT(id) AS total, SUM(rating) AS rating FROM reviewsConnection name: slave
Speed: 0.204 ms
Query analysis:
· Query: SIMPLE on reviews · Type: ALL · Rows: 75789
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 301File: APPPATH/classes/controller/base.php, line 256File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND deleted_time = 0 AND active = 1 AND permalink = 'envio-flores-a-espana/granollers' AND (version IS null OR version = '') LIMIT 1Connection name: slave
Speed: 0.175 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 308File: APPPATH/classes/controller/catalog.php, line 51File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT catalogs.*, catalog_properties.* FROM catalogs LEFT JOIN catalog_properties ON (catalog_properties.id_catalog = catalogs.id) WHERE (id_domain = 2 AND code = 'default') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.215 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 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_combar WHERE id_domain = 2 AND (date_init IS null OR date_init <= '2022-08-07 23:00:00') AND (date_end IS null OR date_end >= '2022-08-07 23:00:00') AND ip_countries IS null ORDER BY id DESC LIMIT 1Connection name: slave
Speed: 0.197 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 219File: DOCROOT/index.php, line 235 |
SELECT catalogs.*, catalog_properties.* FROM catalogs LEFT JOIN catalog_properties ON (catalog_properties.id_catalog = catalogs.id) WHERE (id = 394035) LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.233 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: 0 (unique row not found)
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 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.179 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 37File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT filter_catalog.* FROM filter_catalog WHERE id_catalog = 394035Connection name: slave
Speed: 0.182 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'es_ES' AND filters.slug IN ('flower-type', 'colour') ORDER BY filters.slug DESCConnection name: slave
Speed: 0.204 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'es_ES'Connection name: slave
Speed: 0.188 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'es_ES'Connection name: slave
Speed: 0.180 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.328 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 141 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.466 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.242 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 1.445 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 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.269 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 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.248 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 38 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.266 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 35 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.218 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 11 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.243 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 9 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.217 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.199 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.187 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.188 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.256 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 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.305 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 116 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 2.701 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 102 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 1.868 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.277 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 37 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.247 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 35 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.223 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 4 (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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' GROUP BY product_prices.id_productConnection name: slave
Speed: 0.212 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 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM catalog_statics WHERE id_catalog = 394035 AND type IN ('content') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave
Speed: 0.187 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 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 110File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM catalog_statics WHERE id_catalog = 394035 AND type IN ('hero-banner') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave
Speed: 0.192 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 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 113File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id_product FROM catalog_products WHERE id_catalog = 394035 ORDER BY position ASCConnection name: slave
Speed: 0.406 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 393File: APPPATH/classes/trait/catalog.php, line 123File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id_domain, type_value FROM domain_configs WHERE domain_configs.id_domain = 2Connection name: slave
Speed: 0.189 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 1221File: APPPATH/classes/trait/catalog.php, line 136File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT catalogs.*, catalog_properties.* FROM catalogs LEFT JOIN catalog_properties ON (catalog_properties.id_catalog = catalogs.id) WHERE (id_domain = 2 AND code = 'all-our-flowers') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.208 ms · DUPLICATE
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 139File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'es_ES' AND user_orders.delivery_date >= '2021-08-07' AND product_languages.language = 'es_ES' GROUP BY user_orders.product_sku ORDER BY COUNT(*) DESC LIMIT 5Connection name: slave
Speed: 1.727 s
Query analysis:
· Query: SIMPLE on user_orders · Type: ALL · Rows: 2159940 (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 659File: APPPATH/classes/trait/catalog.php, line 141File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' AND country_i18n.language = 'es_ES') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.217 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 654File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' AND global_geo_city_languages.language = 'es_ES' AND global_geo_city_languages.name = 'Granollers' LIMIT 1Connection name: slave
Speed: 3.144 ms
Query analysis:
· Query: SIMPLE on global_geo_cities · Possible keys: PRIMARY,countrycode · Key Used: countrycode · Type: ref · Rows: 1019 (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 688File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'ES' AND catalogs.permalink IS NOT null AND catalogs.id_domain = 2 AND catalogs.meta_robots_noindex = 0 ORDER BY catalogs.codeConnection name: slave
Speed: 0.415 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: 28224 (Using where; Using filesort)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/catalog.php, line 887File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 2 AND catalogs.meta_robots_noindex = 0 ORDER BY catalogs.codeConnection name: slave
Speed: 0.268 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: 28224 (Using where; Using filesort)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/catalog.php, line 917File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id_product FROM catalog_products WHERE id_catalog = 15 ORDER BY position ASCConnection name: slave
Speed: 0.221 ms
Query analysis:
· Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 72 (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 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave
Speed: 0.181 ms
Query analysis:
· Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'es_ES') 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 ('es_ES') 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 (27, 43, 5325, 4268, 193, 30, 231, 4271, 2669, 25, 316, 4269, 5323, 5327, 5324, 5331, 4632, 29, 2347, 3169, 3168, 5350, 2100, 34, 361, 2660, 36, 4266, 4635, 45, 4265, 4633) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 27, 43, 5325, 4268, 193, 30, 231, 4271, 2669, 25, 316, 4269, 5323, 5327, 5324, 5331, 4632, 29, 2347, 3169, 3168, 5350, 2100, 34, 361, 2660, 36, 4266, 4635, 45, 4265, 4633) ASC LIMIT 512Connection name: slave
Speed: 4.762 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 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'es_ES') 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 ('es_ES') 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 (5357, 31, 3170, 5352, 3171, 2782, 35, 5330, 4686, 33, 311, 5353, 5351, 5354, 2079, 2353, 4634, 28, 166, 5328, 2157, 314, 32, 318, 4267, 2317, 796, 4270, 4273, 4689, 5326, 2348) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 5357, 31, 3170, 5352, 3171, 2782, 35, 5330, 4686, 33, 311, 5353, 5351, 5354, 2079, 2353, 4634, 28, 166, 5328, 2157, 314, 32, 318, 4267, 2317, 796, 4270, 4273, 4689, 5326, 2348) ASC LIMIT 512Connection name: slave
Speed: 3.213 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 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
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 = 'es_ES') 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 ('es_ES') 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 (4276, 4272, 47, 5329, 4275, 4274, 5041, 5038) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 4276, 4272, 47, 5329, 4275, 4274, 5041, 5038) ASC LIMIT 512Connection name: slave
Speed: 1.987 ms
Query analysis:
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 8 (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 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (27, 43, 5325, 4268, 193, 30, 231, 4271, 2669, 25, 316, 4269, 5323, 5327, 5324, 5331, 4632, 29, 2347, 3169, 3168, 5350, 2100, 34, 361, 2660, 36, 4266, 4635, 45, 4265, 4633) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave
Speed: 0.269 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: 32 (Using index condition; Using filesort)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (5357, 31, 3170, 5352, 3171, 2782, 35, 5330, 4686, 33, 311, 5353, 5351, 5354, 2079, 2353, 4634, 28, 166, 5328, 2157, 314, 32, 318, 4267, 2317, 796, 4270, 4273, 4689, 5326, 2348) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave
Speed: 0.228 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: 32 (Using index condition; Using filesort)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (4276, 4272, 47, 5329, 4275, 4274, 5041, 5038) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave
Speed: 0.195 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: 13 (Using index condition; Using filesort)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave
Speed: 0.534 ms
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.192 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 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.157 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/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.146 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/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave
Speed: 0.300 ms
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.167 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/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.147 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 469File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave
Speed: 0.173 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/coupons.php, line 224File: APPPATH/classes/coupons.php, line 480File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.163 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 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, line 142File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.154 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 464File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/catalog.php, line 922File: APPPATH/classes/trait/catalog.php, lin |
