SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default Speed: 0.403 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.394 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.906 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.431 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.367 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.363 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` = 'rosas-blancas' LIMIT 1Connection name: default Speed: 0.560 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.363 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` = '/rosas-blancas' LIMIT 1Connection name: default Speed: 0.446 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.847 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.423 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.375 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.430 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-20' ORDER BY event_start_date ASCConnection name: slave Speed: 0.374 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.376 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.398 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.378 ms Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75790 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 = 'rosas-blancas' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.547 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.385 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-20 05:00:00') AND (date_end IS null OR date_end >= '2022-08-20 05:00:00') AND ip_countries IS null ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.380 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 = 499829) LIMIT 1 OFFSET 0Connection name: slave Speed: 0.540 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.365 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 = 499829Connection name: slave Speed: 0.448 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.371 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.361 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.364 ms Query analysis: · Query: SIMPLE on filter_properties · Possible keys: PRIMARY,id_filter_idx,id_active_order · Key Used: id_filter_idx · Type: ref · Rows: 8 · Query: SIMPLE on filter_property_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 79File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '4' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.454 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 141 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '5' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.430 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.402 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: 0.514 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.411 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 23 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '22' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.409 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 38 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '23' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.421 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.394 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.383 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.381 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.373 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.367 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.370 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.390 ms Query analysis: · Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: ref · Rows: 55 (Using index; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: ref · Rows: 1 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/filters.php, line 107File: APPPATH/classes/trait/catalog.php, line 471File: APPPATH/classes/trait/catalog.php, line 107File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM product_filter_property INNER JOIN products ON (products.id = product_filter_property.id_product) INNER JOIN product_prices ON (product_prices.id_product = products.id) WHERE product_filter_property.id_property = '2' AND products.active = 1 AND product_prices.active = 1 AND product_prices.variation_a = 'ES' GROUP BY product_prices.id_productConnection name: slave Speed: 0.415 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: 0.437 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: 0.437 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.407 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.399 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.379 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.403 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 = 499829 AND type IN ('content') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave Speed: 0.594 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 = 499829 AND type IN ('hero-banner') AND (active = 1) ORDER BY position ASC, version DESCConnection name: slave Speed: 0.536 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 = 499829 ORDER BY position ASCConnection name: slave Speed: 0.503 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 5 (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 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 * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave Speed: 0.359 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 400File: 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 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-20') AND (products.date_off IS null OR products.date_off > '2022-08-20') AND products.id IN (34, 27, 694, 636, 45) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 34, 27, 694, 636, 45) ASC LIMIT 512Connection name: slave Speed: 1.848 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 5 (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 400File: 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_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (34, 27, 694, 636, 45) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 0.832 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: 8 (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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.377 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.373 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.363 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.359 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.372 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 400File: 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 * FROM coupons WHERE code = '2022WEBDISCOUNT04' AND (currency_code IS null OR currency_code LIKE 'EUR') LIMIT 1Connection name: slave Speed: 0.361 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.382 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.366 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.364 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 400File: 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 * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.360 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.379 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.361 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 400File: 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 * FROM coupons WHERE code = '2022WEBDISCOUNT04'Connection name: slave Speed: 0.352 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.362 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.371 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.366 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.355 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.390 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.384 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 400File: 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 * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave Speed: 0.377 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 400File: 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 catalogs.* FROM catalogs WHERE (id_domain = '2' AND code = 'all-our-flowers') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.393 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,event_name,event_domain,domain_template · Key Used: domain_code_language · Type: ref · Rows: 17 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/catalog.php, line 500File: APPPATH/classes/trait/catalog.php, line 169File: 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.515 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/trait/catalog.php, line 552File: APPPATH/classes/trait/catalog.php, line 173File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku IN ('FQ2315', 'FQ119', 'FQ2313') AND reviews.rating >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (reviews.published IS null OR reviews.published = 1) ORDER BY reviews.created_datetime DESCConnection name: slave Speed: 9.759 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 799 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 64File: APPPATH/classes/review.php, line 131File: APPPATH/classes/trait/catalog.php, line 560File: APPPATH/classes/trait/catalog.php, line 173File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ2315', 'FQ119', 'FQ2313') AND reviews.rating >= 4 AND reviews.language = 'es_ES' AND (reviews.published IS null OR reviews.published = 1) GROUP BY reviews.skuConnection name: slave Speed: 3.324 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 799 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 238File: APPPATH/classes/review.php, line 132File: APPPATH/classes/trait/catalog.php, line 560File: APPPATH/classes/trait/catalog.php, line 173File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'es_ES') WHERE product_images.id_product = 34 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.914 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using where; Using filesort) · 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/products.php, line 333File: APPPATH/classes/trait/catalog.php, line 182File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'es_ES') WHERE product_images.id_product = 27 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.371 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using where; Using filesort) · 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/products.php, line 333File: APPPATH/classes/trait/catalog.php, line 182File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'es_ES') WHERE product_images.id_product = 45 ORDER BY product_images.default DESC LIMIT 2Connection name: slave Speed: 0.375 ms Query analysis: · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 3 (Using where; Using filesort) · 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/products.php, line 333File: APPPATH/classes/trait/catalog.php, line 182File: 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, permalink, language, id_domain, code FROM catalogs WHERE code = 'type-roses-white-roses' AND template = 'default' AND meta_robots_noindex = 0Connection name: slave Speed: 0.368 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: domain_code_language,meta_robots_noindex · Key Used: domain_code_language · Type: ref · Rows: 14 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/catalog.php, line 1137File: APPPATH/classes/trait/catalog.php, line 186File: 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.* FROM catalogs WHERE (id = '6') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.482 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/catalog.php, line 1081File: APPPATH/classes/trait/catalog.php, line 1058File: APPPATH/classes/trait/catalog.php, line 187File: 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.* FROM catalogs WHERE (id = '15') LIMIT 1 OFFSET 0Connection name: slave Speed: 0.377 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/trait/catalog.php, line 1081File: APPPATH/classes/trait/catalog.php, line 1100File: APPPATH/classes/trait/catalog.php, line 1058File: APPPATH/classes/trait/catalog.php, line 187File: 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 reviews WHERE reviews.id_domain = 2 AND (reviews.rating >= 4 OR reviews.published = 1) AND LENGTH(review) - LENGTH(REPLACE(review, ' ', '')) + 1 >= 7 ORDER BY reviews.created_datetime DESC LIMIT 9Connection name: slave Speed: 0.380 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: index6 · Key Used: search · Type: index · Rows: 27 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 276File: APPPATH/classes/trait/catalog.php, line 195File: APPPATH/classes/controller/catalog.php, line 123File: COREPATH/classes/request.php, line 454File: 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.347 ms · DUPLICATE Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75790 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 301File: APPPATH/classes/trait/catalog.php, line 202File: 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.570 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/trait/catalog.php, line 213File: 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 FROM countries INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE (countries.code IS null AND country_i18n.language = 'es_ES') ORDER BY country_i18n.name ASC LIMIT 1 OFFSET 0Connection name: slave Speed: 0.380 ms Query analysis: · Query: SIMPLE (Impossible WHERE) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: COREPATH/classes/model/crud.php, line 127File: APPPATH/classes/countries.php, line 309File: APPPATH/classes/trait/catalog.php, line 274File: 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, id_domain, code, name, anchor_text, head_title, geo_country, permalink FROM catalogs WHERE id_domain = 2 AND code IN ('all-our-flowers')Connection name: slave Speed: 0.358 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,domain_code_language,event_name,event_domain,domain_template · Key Used: domain_code_language · Type: ref · Rows: 17 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/view.php, line 138File: APPPATH/classes/trait/catalog.php, line 279File: 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.code, country_i18n.name FROM countries INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE delivery = 1 AND country_i18n.language = 'es_ES' ORDER BY country_i18n.name ASCConnection name: slave Speed: 0.374 ms Query analysis: · Query: SIMPLE on countries · Possible keys: PRIMARY,delivery · Key Used: delivery · Type: ref · Rows: 95 (Using temporary; Using filesort) · 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/view.php, line 155File: APPPATH/classes/trait/catalog.php, line 279File: 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.401 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/trait/catalog.php, line 357File: APPPATH/classes/controller/catalog.php, line 67File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menu_type.name = 'root' ORDER BY menu_item.positionConnection name: slave Speed: 0.392 ms Query analysis: · Query: SIMPLE on menu_type · Possible keys: PRIMARY,menu_type_name_IDX · Key Used: menu_type_name_IDX · Type: const · Rows: 1 (Using index; Using temporary; Using filesort) · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: menus_FK_2,menus_FK_1 · Type: index_merge · Rows: 1 (Using intersect(menus_FK_2,menus_FK_1); Using where; Using index) · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '435'Connection name: slave Speed: 0.349 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '4'Connection name: slave Speed: 0.363 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '236' ORDER BY menu_item.positionConnection name: slave Speed: 0.372 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 2 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '237' ORDER BY menu_item.positionConnection name: slave Speed: 0.367 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 9 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '4'Connection name: slave Speed: 0.362 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '363'Connection name: slave Speed: 0.351 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '331'Connection name: slave Speed: 0.363 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608396'Connection name: slave Speed: 0.369 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '238' ORDER BY menu_item.positionConnection name: slave Speed: 0.387 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '6'Connection name: slave Speed: 0.373 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '450'Connection name: slave Speed: 0.350 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '445'Connection name: slave Speed: 0.362 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608459'Connection name: slave Speed: 0.347 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608310'Connection name: slave Speed: 0.366 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '515275'Connection name: slave Speed: 0.346 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '500002'Connection name: slave Speed: 0.359 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '3' ORDER BY menu_item.positionConnection name: slave Speed: 0.375 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 7 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608303'Connection name: slave Speed: 0.356 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '4420'Connection name: slave Speed: 0.356 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608352'Connection name: slave Speed: 0.355 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608171'Connection name: slave Speed: 0.352 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '608090'Connection name: slave Speed: 0.360 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '4759'Connection name: slave Speed: 0.360 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '239' ORDER BY menu_item.positionConnection name: slave Speed: 0.582 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 3 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '240' ORDER BY menu_item.positionConnection name: slave Speed: 0.377 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT menu_item.*, menu_itemtype.name AS item_type, menu_type.name AS menu_type, menu_visibility.name AS item_visibility FROM menu_item INNER JOIN menus ON (menus.id = menu_item.id_menu) INNER JOIN menu_type ON (menu_type.id = menus.id_type) INNER JOIN menu_itemtype ON (menu_itemtype.id = menu_item.id_type) INNER JOIN menu_visibility ON (menu_visibility.id = menu_item.id_visibility) WHERE menus.id_domain = 2 AND menus.id = '241' ORDER BY menu_item.positionConnection name: slave Speed: 0.404 ms Query analysis: · Query: SIMPLE on menus · Possible keys: PRIMARY,menus_FK_1,menus_FK_2 · Key Used: PRIMARY · Type: const · Rows: 1 (Using filesort) · Query: SIMPLE on menu_type · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on menu_item · Possible keys: menu_item_id_menu_IDX,menu_item_FK_2,menu_item_FK_3 · Key Used: menu_item_id_menu_IDX · Type: ref · Rows: 6 (Using index condition; Using where) · Query: SIMPLE on menu_itemtype · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on menu_visibility · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 96File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1344'Connection name: slave Speed: 0.351 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1343'Connection name: slave Speed: 0.355 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1341'Connection name: slave Speed: 0.356 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1516'Connection name: slave Speed: 0.368 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '1792'Connection name: slave Speed: 0.357 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id, id_parent, code, name, permalink, anchor_text, geo_country FROM catalogs WHERE id = '3963'Connection name: slave Speed: 0.357 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: PRIMARY,catalog_domain · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/menu.php, line 194File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND id = 214375 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.367 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/menu.php, line 197File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/menu.php, line 184File: APPPATH/classes/menu.php, line 102File: APPPATH/classes/controller/base.php, line 390File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id_product FROM catalog_products WHERE id_catalog = 435 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.359 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 28 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/trait/menu.php, line 13File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.347 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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-20') AND (products.date_off IS null OR products.date_off > '2022-08-20') AND products.id IN (231, 316, 2660, 5325, 5324, 5323, 5038, 4269, 5327, 2782) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 231, 316, 2660, 5325, 5324, 5323, 5038, 4269, 5327, 2782) ASC LIMIT 512Connection name: slave Speed: 2.095 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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 (231, 316, 2660, 5325, 5324, 5323, 5038, 4269, 5327, 2782) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 0.383 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: range · Rows: 10 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.372 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.373 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.354 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.364 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.372 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.369 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.357 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.362 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.356 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.369 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.362 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.373 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.357 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.372 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.366 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.371 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.380 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.362 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.356 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM coupons WHERE code = 'ER83T28I7'Connection name: slave Speed: 0.363 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.380 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.371 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM coupons WHERE code = 'ER83T28I7'Connection name: slave Speed: 0.359 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.363 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.352 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.365 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.453 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.360 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.361 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.366 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.366 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.374 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM coupons WHERE code = 'L2MJFX7QC'Connection name: slave Speed: 0.367 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.366 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.374 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM coupons WHERE code = 'L2MJFX7QC'Connection name: slave Speed: 0.352 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.367 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.372 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.379 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.374 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.374 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.366 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.364 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.384 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.359 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.379 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.365 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.364 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM coupons WHERE code = 'JADPR4OJY'Connection name: slave Speed: 0.365 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.364 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.362 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT * FROM coupons WHERE code = 'JADPR4OJY'Connection name: slave Speed: 0.364 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.366 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.366 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.367 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.355 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.362 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku IN ('FQ120', 'FQ2001', 'FQ4049', 'FQ02218', 'FQ02217', 'FQ02216', 'FQ41013C', 'FQ41014', 'FQ02220', 'FQ4058') AND reviews.rating >= 4 AND LENGTH(reviews.review) - LENGTH(REPLACE(reviews.review,' ', '')) >= 1 AND (reviews.published IS null OR reviews.published = 1) ORDER BY reviews.created_datetime DESCConnection name: slave Speed: 3.941 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 150 (Using index condition; Using where; Using filesort) · Query: SIMPLE on user_orders · Possible keys: order_2,my_history · Key Used: order_2 · Type: ref · Rows: 1 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 64File: APPPATH/classes/review.php, line 131File: APPPATH/classes/trait/menu.php, line 47File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ120', 'FQ2001', 'FQ4049', 'FQ02218', 'FQ02217', 'FQ02216', 'FQ41013C', 'FQ41014', 'FQ02220', 'FQ4058') AND reviews.rating >= 4 AND reviews.language = 'es_ES' AND (reviews.published IS null OR reviews.published = 1) GROUP BY reviews.skuConnection name: slave Speed: 0.370 ms Query analysis: · Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 150 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 238File: APPPATH/classes/review.php, line 132File: APPPATH/classes/trait/menu.php, line 47File: APPPATH/classes/trait/menu.php, line 15File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: DOCROOT/index.php, line 219File: DOCROOT/index.php, line 235 |
SELECT id_product FROM catalog_products WHERE id_catalog = 4 ORDER BY position ASC LIMIT 10Connection name: slave Speed: 0.386 ms Query analysis: · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37 · Key Used: catalog_collection · Type: ref · Rows: 31 (Using where; Using index; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 99File: APPPATH/classes/trait/menu.php, line 13File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.384 ms · DUPLICATE Query analysis: · Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 32 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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-20') AND (products.date_off IS null OR products.date_off > '2022-08-20') AND products.id IN (4635, 30, 4268, 43, 27, 5325, 4633, 4271, 2347, 31) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 4635, 30, 4268, 43, 27, 5325, 4633, 4271, 2347, 31) ASC LIMIT 512Connection name: slave Speed: 0.545 ms Query analysis: · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 10 (Using index condition; Using temporary; Using filesort) · Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where) · Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 · Query: SIMPLE on 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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 (4635, 30, 4268, 43, 27, 5325, 4633, 4271, 2347, 31) AND active = 1 AND variation_a = 'ES' AND variation_b = 'small' ORDER BY variation_b DESCConnection name: slave Speed: 0.408 ms Query analysis: · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_variation_all · Type: range · Rows: 10 (Using index condition; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 261File: APPPATH/classes/catalogs.php, line 410File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.393 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.391 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.377 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.367 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.354 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.365 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.370 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.376 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.366 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.369 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.370 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.354 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.369 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.360 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.368 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.370 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.374 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.370 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.365 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 259File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.374 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/menu.php, line 14File: APPPATH/classes/controller/base.php, line 394File: APPPATH/classes/controller/catalog.php, line 69File: COREPATH/classes/request.php, line 456File: 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.370 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 66Fi |