SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default
Speed: 0.189 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.175 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: 7.764 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.219 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.143 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.241 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-internacional-flores/envio-flores-al-reino-unido/cardiff' LIMIT 1Connection name: default
Speed: 0.345 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.149 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-internacional-flores/envio-flores-al-reino-unido/cardiff' LIMIT 1Connection name: default
Speed: 0.275 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: 7.880 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.217 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.148 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.564 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-11' ORDER BY event_start_date ASCConnection name: slave
Speed: 0.162 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.152 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.206 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.158 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-internacional-flores/envio-flores-al-reino-unido/cardiff' AND (version IS null OR version = '') LIMIT 1Connection name: slave
Speed: 0.331 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.316 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-11 17:00:00') AND (date_end IS null OR date_end >= '2022-08-11 17:00:00') AND ip_countries IS null ORDER BY id DESC LIMIT 1Connection name: slave
Speed: 0.174 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 = 1520) LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.324 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 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.151 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/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 = 1520Connection name: slave
Speed: 0.208 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.147 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.164 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.152 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: 2.237 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: 1.305 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.690 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.116 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.722 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: 1.005 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: 1.012 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.938 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.662 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.397 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.416 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.395 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.468 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.931 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: 1.595 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: 1.786 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.501 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.943 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.989 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.511 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.556 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 = 1520 AND type IN ('content') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave
Speed: 0.372 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 = 1520 AND type IN ('hero-banner') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave
Speed: 0.310 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 = 1520 ORDER BY position ASCConnection name: slave
Speed: 0.249 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.157 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.177 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-11' AND product_languages.language = 'es_ES' GROUP BY user_orders.product_sku ORDER BY COUNT(*) DESC LIMIT 5Connection name: slave
Speed: 1.675 s
Query analysis:
· Query: SIMPLE on user_orders · Type: ALL · Rows: 2162277 (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 = 'GB' AND country_i18n.language = 'es_ES') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.215 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 = 'GB' AND global_geo_city_languages.language = 'es_ES' AND global_geo_city_languages.name = 'Cardiff' LIMIT 1Connection name: slave
Speed: 0.150 ms
Query analysis:
· Query: SIMPLE on global_geo_cities · Possible keys: PRIMARY,countrycode · Key Used: countrycode · Type: ref · Rows: 1234 (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 = 'GB' AND catalogs.permalink IS NOT null AND catalogs.id_domain = 2 AND catalogs.meta_robots_noindex = 0 ORDER BY catalogs.codeConnection name: slave
Speed: 37.789 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.246 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.190 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.151 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-11') AND (products.date_off IS null OR products.date_off > '2022-08-11') 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: 3.196 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-11') AND (products.date_off IS null OR products.date_off > '2022-08-11') 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: 2.864 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-11') AND (products.date_off IS null OR products.date_off > '2022-08-11') 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.647 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 = 'GB' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave
Speed: 0.202 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 = 'GB' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave
Speed: 0.193 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 = 'GB' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave
Speed: 0.177 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: 12 (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.263 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.143 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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.143 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.134 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.232 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.142 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.131 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.139 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.142 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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.132 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.145 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.142 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 = 'ER83T28I7' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave
Speed: 0.252 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.143 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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.156 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.142 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 = 'ER83T28I7'Connection name: slave
Speed: 0.225 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.138 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 = 'ER83T28I7'Connection name: slave
Speed: 0.645 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.150 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.148 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.136 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.136 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.137 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.138 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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.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 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.133 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.134 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.141 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.150 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.133 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.137 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 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 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.137 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.144 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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.142 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.162 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.155 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.152 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.181 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.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 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.183 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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.282 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.168 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.161 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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.168 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.158 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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.141 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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.139 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.152 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.135 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.128 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.132 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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, 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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.152 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.133 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.134 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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.136 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.128 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.136 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.148 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 = 'L2MJFX7QC' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave
Speed: 0.261 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.148 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.139 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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.158 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 = 'L2MJFX7QC'Connection name: slave
Speed: 0.247 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.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 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.145 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 = 'L2MJFX7QC'Connection name: slave
Speed: 0.242 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 coupons WHERE code = 'JADPR4OJY' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave
Speed: 0.284 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.145 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 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.153 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/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 que |
