SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default
Speed: 0.454 ms
Query analysis:
· Query: SIMPLE (Impossible WHERE noticed after reading const tables)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 7File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default
Speed: 0.200 ms
Query analysis:
· Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 22File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT `groupname`, `name`, `language`, `text` FROM `i18n` WHERE `language` IN ('en_US')Connection name: default
Speed: 7.474 ms
Query analysis:
· Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2957 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 48File: APPPATH/config/staging/my.php, line 48File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains`Connection name: default
Speed: 0.306 ms
Query analysis:
· Query: SIMPLE on domains · Type: ALL · Rows: 26
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 77File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-es.floraqueen.net'Connection name: default
Speed: 0.206 ms · DUPLICATE
Query analysis:
· Query: SIMPLE (Impossible WHERE noticed after reading const tables)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 102File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-es.floraqueen.net%' LIMIT 1Connection name: default
Speed: 0.199 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domains · Type: ALL · Rows: 26 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 117File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 2 AND `permalink` = 'enviar-flores/primer-amor' LIMIT 1Connection name: default
Speed: 0.438 ms
Query analysis:
· Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: permalink_domain_language · Type: ref · Rows: 1 (Using where; Using index)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 274File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `domain_pages` WHERE `id_domain` = 2 AND `permalink` = 'enviar-flores/primer-amor' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default
Speed: 0.376 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/bootstrap.php, line 310File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 2 AND `permalink` IS NOT null AND (`geo_type` IS null OR `geo_type` IN ('cn')) ORDER BY LENGTH(permalink) DESCConnection name: default
Speed: 30.223 ms
Query analysis:
· Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27952 (Using where; Using filesort)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/routing.php, line 25File: APPPATH/bootstrap.php, line 325File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink`, `product_permalink` FROM `product_languages` WHERE `permalink` IS NOT null AND `language` IN ('es_ES')Connection name: default
Speed: 2.545 ms
Query analysis:
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,language,permalink_language · Key Used: permalink_language · Type: ref · Rows: 6270 (Using where; Using index)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/routing.php, line 38File: APPPATH/bootstrap.php, line 325File: DOCROOT/index.php, line 238 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 2Connection name: default
Speed: 0.254 ms
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/bootstrap.php, line 383File: DOCROOT/index.php, line 238 |
SELECT * FROM `domain_redirects` WHERE `id_domain` = 2 AND `path` = '/enviar-flores/primer-amor' LIMIT 1Connection name: default
Speed: 0.222 ms
Query analysis:
· Query: SIMPLE (Impossible WHERE noticed after reading const tables)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1186File: APPPATH/classes/controller/base.php, line 44File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 2 AND event_start_date IS NOT null AND event_start_date >= '2022-05-25' ORDER BY event_start_date ASCConnection name: slave
Speed: 0.234 ms
Query analysis:
· Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: event_domain · Type: range · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 124File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.227 ms
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/controller/base.php, line 179File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.code, country_i18n.name, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE countries.delivery = 1 AND catalogs.id_domain = 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: 29.812 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 1149File: APPPATH/classes/controller/base.php, line 209File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT COUNT(id) AS total, SUM(rating) AS rating FROM reviewsConnection name: slave
Speed: 0.249 ms
Query analysis:
· Query: SIMPLE on reviews · Type: ALL · Rows: 75787
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 300File: APPPATH/classes/controller/base.php, line 212File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 2 AND deleted_time = 0 AND active = 1 AND permalink = 'enviar-flores/primer-amor' AND (version IS null OR version = '') LIMIT 1Connection name: slave
Speed: 0.525 ms
Query analysis:
· Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: ref · Rows: 1 (Using index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 264File: APPPATH/classes/controller/product.php, line 45File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_combar WHERE id_domain = 2 AND (date_init IS null OR date_init <= '2022-05-25 20:30:00') AND (date_end IS null OR date_end >= '2022-05-25 20:30:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave
Speed: 0.248 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/product.php, line 60File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM products WHERE sku = '3335' LIMIT 1Connection name: slave
Speed: 0.340 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/trait/product.php, line 58File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_languages.* FROM product_languages WHERE (id = '3335') LIMIT 1 OFFSET 0Connection name: slave
Speed: 0.250 ms
Query analysis:
· Query: SIMPLE on product_languages · Possible keys: PRIMARY,routing · 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/product.php, line 81File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave
Speed: 0.218 ms
Query analysis:
· Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = '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-05-25') AND (products.date_off IS null OR products.date_off > '2022-05-25') AND products.id = 361 GROUP BY product_languages.id_product, product_languages.language LIMIT 1Connection name: slave
Speed: 0.816 ms
Query analysis:
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: const · Rows: 1
· Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on products_badges · Possible keys: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Type: const · Rows: 1
· Query: SIMPLE on coupons · Possible keys: code · Type: const · Rows: 1
· 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)
· 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/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (361) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave
Speed: 0.262 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: ref · Rows: 3 (Using where)
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/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.236 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/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT groupname, name, language, text FROM i18n WHERE language IN ('es_ES')Connection name: slave
Speed: 9.692 ms
Query analysis:
· Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2981 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 48File: APPPATH/classes/coupons.php, line 460File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.291 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.238 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.224 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 23File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM catalogs INNER JOIN catalog_products ON (catalog_products.id_catalog = catalogs.id) WHERE catalogs.id_domain IN (19, 21) AND catalog_products.id_product = 361 LIMIT 1Connection name: slave
Speed: 1.844 ms
Query analysis:
· Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37,IDX_816D8444DD7ADDD · Key Used: IDX_816D8444DD7ADDD · Type: ref · Rows: 155 (Using where)
· Query: SIMPLE on catalogs · Possible keys: PRIMARY,id_domain,event_name,catalog_domain,event_domain,domain_template · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 628File: APPPATH/classes/products.php, line 28File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'es_ES') WHERE product_images.id_product = 361 ORDER BY product_images.default DESC LIMIT 4Connection name: slave
Speed: 0.292 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 336File: APPPATH/classes/products.php, line 47File: APPPATH/classes/trait/product.php, line 97File: APPPATH/classes/controller/product.php, line 86File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_campaigns WHERE type_name = 'shipping' AND id_domain = 2Connection name: slave
Speed: 0.247 ms
Query analysis:
· Query: SIMPLE on domain_campaigns · Possible keys: id_domain · Key Used: id_domain · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/campaign.php, line 438File: APPPATH/classes/controller/product.php, line 103File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_behaviors WHERE id_product = 361 AND type_name = 'special_combo_components' LIMIT 1Connection name: slave
Speed: 0.378 ms
Query analysis:
· Query: SIMPLE on product_behaviors · Possible keys: unique,id_product · Key Used: unique · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 509File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM products WHERE sku = 'BR200001' LIMIT 1Connection name: slave
Speed: 1.047 ms
Query analysis:
· Query: SIMPLE on products · Possible keys: usku,sku · Key Used: usku · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 521File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM products WHERE sku = 'CD30067' LIMIT 1Connection name: slave
Speed: 0.273 ms
Query analysis:
· Query: SIMPLE on products · Possible keys: usku,sku · Key Used: usku · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 521File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave
Speed: 0.232 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = '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-05-25') AND (products.date_off IS null OR products.date_off > '2022-05-25') AND products.id IN (2912, 3193) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 2912, 3193) ASC LIMIT 512Connection name: slave
Speed: 1.514 ms
Query analysis:
· Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: range · Rows: 2 (Using where; Using temporary; Using filesort)
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: eq_ref · Rows: 1 (Using index condition)
· 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/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (2912, 3193) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave
Speed: 0.289 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: 4 (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/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.246 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/coupons.php, line 448File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.251 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.240 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.221 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/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.223 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.217 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/products.php, line 530File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'es_ES') WHERE product_images.id_product = 2912 ORDER BY product_images.default DESC LIMIT 1Connection name: slave
Speed: 0.241 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: 1 (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 336File: APPPATH/classes/products.php, line 532File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_images.*, product_images_i18n.text AS image_alt FROM product_images LEFT JOIN product_images_i18n ON (product_images_i18n.id_product_image = product_images.id AND product_images_i18n.language = 'es_ES') WHERE product_images.id_product = 3193 ORDER BY product_images.default DESC LIMIT 1Connection name: slave
Speed: 0.269 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: 1 (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 336File: APPPATH/classes/products.php, line 532File: APPPATH/classes/controller/product.php, line 107File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_languages.id, product_languages.product_permalink, product_languages.language, domains.domain, domains.id AS id_domain FROM product_languages INNER JOIN domains ON (domains.language = product_languages.language) WHERE product_languages.id_product = 361 AND domains.type = 'flowers'Connection name: slave
Speed: 0.270 ms
Query analysis:
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: id_product · Type: ref · Rows: 10
· Query: SIMPLE on domains · Possible keys: type_language · Key Used: type_language · Type: ref · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/products.php, line 295File: APPPATH/classes/trait/product.php, line 463File: APPPATH/classes/controller/product.php, line 110File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM components INNER JOIN component_languages ON (component_languages.id_component = components.id) INNER JOIN product_component ON (product_component.id_component = components.id) WHERE component_languages.language = 'es_ES' AND product_component.id_product = 361 GROUP BY components.id ORDER BY product_component.position ASCConnection name: slave
Speed: 0.275 ms
Query analysis:
· Query: SIMPLE on product_component · Possible keys: unique,idx_product,idx_component,idx_collection · Key Used: unique · Type: ref · Rows: 1 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on components · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on component_languages · Possible keys: IDX_7E28CF28C9CB1D70 · Key Used: IDX_7E28CF28C9CB1D70 · Type: ref · Rows: 3 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 152File: APPPATH/classes/controller/product.php, line 123File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_filter_property WHERE id_product = 361Connection name: slave
Speed: 0.533 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD · Key Used: IDX_84161CE3DD7ADDD · Type: ref · Rows: 5 (Using index)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 186File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id FROM products INNER JOIN product_filter_property ON (product_filter_property.id_product = products.id) WHERE product_filter_property.id_property IN (2, 4, 6, 7, 32) AND products.id <> 361 AND products.id_typology IN (1) GROUP BY products.id ORDER BY COUNT(products.id) DESC LIMIT 8Connection name: slave
Speed: 1.816 ms
Query analysis:
· Query: SIMPLE on product_filter_property · Possible keys: PRIMARY,IDX_84161CE3DD7ADDD,IDX_84161CE3DB29F04B · Key Used: IDX_84161CE3DB29F04B · Type: range · Rows: 495 (Using where; Using index; Using temporary; Using filesort)
· Query: SIMPLE on products · Possible keys: PRIMARY,id_typology,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 203File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM currencies WHERE code = 'EUR' ORDER BY created_date DESC LIMIT 1Connection name: slave
Speed: 0.234 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on currencies · Possible keys: unique,code · Key Used: unique · Type: ref · Rows: 29 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 287File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT products.id, product_languages.id_product, products.active, products.sku, products.main_sku, products.fin_sku, products.code, products.group_name, products.feed_group_name, products.id_typology, products.meta_robots_noindex, products.filter_gender, products.filter_category, products.filter_color, products.created_datetime, products.feeds_enabled, products.price AS default_price, products_typologies.code AS typology_code, product_languages.id_badge, product_languages.language, product_languages.name, product_languages.permalink, product_languages.product_permalink, product_languages.description, product_languages.content, product_languages.content_html, product_languages.head_title, product_languages.meta_description, product_languages.feed_title, product_languages.feed_description, product_languages.mkt_name, products_badges.type AS badge_type, products_badges.position AS badge_position, products_badge_i18n.name AS badge_name, products_badge_i18n.url AS badge_url_image, products_badges.coupon AS coupon, product_images.url_image AS url_image, product_images.url_image_lg AS url_image_lg, product_images.url_image_md AS url_image_md, product_images.url_image_sm AS url_image_sm, product_images.url_image_xs AS url_image_xs, product_images.background_color AS image_bg_color, product_images_i18n.text AS image_alt FROM product_languages INNER JOIN products ON (products.id = product_languages.id_product) LEFT JOIN products_typologies ON (products.id_typology = products_typologies.id) LEFT JOIN product_images ON (products.id = product_images.id_product AND product_images.default_collection = 1 AND product_images.related_sku IS NULL) LEFT JOIN products_badges ON (products_badges.id = product_languages.id_badge) LEFT JOIN products_badge_i18n ON (products_badge_i18n.id_badge = products_badges.id AND products_badge_i18n.language = '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-05-25') AND (products.date_off IS null OR products.date_off > '2022-05-25') AND products.id IN (25, 307, 2347, 29, 308, 2348, 30, 309) GROUP BY product_languages.id_product, product_languages.language ORDER BY field(`products`.`id`, 25, 307, 2347, 29, 308, 2348, 30, 309) ASC LIMIT 512Connection name: slave
Speed: 1.467 ms
Query analysis:
· Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language · Key Used: unique · Type: range · Rows: 8 (Using index condition; Using temporary; Using filesort)
· Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on products_typologies · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on product_images · Possible keys: permalink_product,id_product,related_product,images_related · Key Used: permalink_product · Type: ref · Rows: 1 (Using where)
· Query: SIMPLE on products_badges · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on products_badge_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 3 (Using where)
· Query: SIMPLE on coupons · Possible keys: code · Key Used: code · Type: eq_ref · Rows: 1 (Using where; Using index)
· Query: SIMPLE on product_images_i18n · Possible keys: image_language,language · Key Used: image_language · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/catalogs.php, line 296File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id_product, variation, variation_a, variation_b, variation_c, retail_price, site_price FROM product_prices WHERE id_product IN (25, 307, 2347, 29, 308, 2348, 30, 309) AND active = 1 AND variation_a = 'ES' ORDER BY variation_b DESCConnection name: slave
Speed: 0.884 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: 28 (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/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.323 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/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.264 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.236 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.252 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.227 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.229 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.219 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.225 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/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.227 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/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.345 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.225 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.220 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.215 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.211 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.214 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.218 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/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.220 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.224 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.213 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.212 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.234 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.242 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/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.232 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/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.215 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/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.211 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.230 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.225 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.224 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.243 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/abtest.php, line 91File: APPPATH/classes/coupons.php, line 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.237 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 465File: APPPATH/classes/coupons.php, line 269File: APPPATH/classes/catalogs.php, line 436File: APPPATH/classes/trait/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.230 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/product.php, line 208File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku IN ('FQ2331', 'FQ4023', 'FQ117', 'FQ108') 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: 19.604 ms
Query analysis:
· Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 1830 (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/product.php, line 212File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg, reviews.sku FROM reviews WHERE reviews.sku IN ('FQ2331', 'FQ4023', 'FQ117', 'FQ108') 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: 6.645 ms
Query analysis:
· Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: range · Rows: 1830 (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/product.php, line 212File: APPPATH/classes/controller/product.php, line 126File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM products WHERE id = 361 LIMIT 1Connection name: slave
Speed: 0.407 ms
Query analysis:
· Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 256File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_prices WHERE product_prices.id_product = 361 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave
Speed: 0.420 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: ref · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 33File: APPPATH/classes/calendar.php, line 135File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT suppliers_delivery_methods.*, suppliers.type AS delivery_type, suppliers.code AS supplier_code FROM suppliers_delivery_methods INNER JOIN suppliers ON (suppliers.id = suppliers_delivery_methods.id_supplier) WHERE suppliers_delivery_methods.country = 'ES' ORDER BY suppliers.order_by ASCConnection name: slave
Speed: 0.255 ms
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Type: ALL · Rows: 7 (Using filesort)
· Query: SIMPLE on suppliers_delivery_methods · Possible keys: id_supplier_2,id_supplier · Key Used: id_supplier_2 · Type: ref · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 62File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.225 ms
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.211 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.222 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.224 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.208 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.213 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.214 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.216 ms
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.211 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.212 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.205 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.207 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.207 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.213 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.212 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave
Speed: 0.214 ms
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave
Speed: 0.212 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave
Speed: 0.206 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 135File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT supplier_delivery_countries.country FROM supplier_delivery_countries INNER JOIN suppliers_delivery_methods ON (suppliers_delivery_methods.id = supplier_delivery_countries.id_method) WHERE suppliers_delivery_methods.code LIKE 'standard%' GROUP BY supplier_delivery_countries.countryConnection name: slave
Speed: 0.270 ms
Query analysis:
· Query: SIMPLE on suppliers_delivery_methods · Possible keys: PRIMARY,code_country · Key Used: code_country · Type: range · Rows: 61 (Using where; Using index; Using temporary; Using filesort)
· Query: SIMPLE on supplier_delivery_countries · Possible keys: id_method · Key Used: id_method · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/countries.php, line 237File: APPPATH/classes/controller/product.php, line 139File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM products WHERE id = 361 LIMIT 1Connection name: slave
Speed: 0.234 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on products · Possible keys: PRIMARY,id_sku_active · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 256File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_prices WHERE product_prices.id_product = 361 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave
Speed: 0.224 ms · DUPLICATE
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: ref · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 33File: APPPATH/classes/calendar.php, line 135File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT suppliers_delivery_methods.*, suppliers.type AS delivery_type, suppliers.code AS supplier_code FROM suppliers_delivery_methods INNER JOIN suppliers ON (suppliers.id = suppliers_delivery_methods.id_supplier) WHERE suppliers_delivery_methods.country = 'ES' ORDER BY suppliers.order_by ASCConnection name: slave
Speed: 0.235 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Type: ALL · Rows: 7 (Using filesort)
· Query: SIMPLE on suppliers_delivery_methods · Possible keys: id_supplier_2,id_supplier · Key Used: id_supplier_2 · Type: ref · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 62File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.210 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.201 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.205 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.218 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.218 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.212 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.206 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.206 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.205 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.218 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.204 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.211 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.203 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.209 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.210 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave
Speed: 0.208 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave
Speed: 0.217 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave
Speed: 0.209 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/calendar.php, line 138File: APPPATH/classes/trait/product.php, line 277File: APPPATH/classes/controller/product.php, line 140File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM messages WHERE messages.id_domain = 2 AND category_slug <> 'funeral'Connection name: slave
Speed: 0.273 ms
Query analysis:
· Query: SIMPLE on messages · Possible keys: idx_domain,index3 · Key Used: idx_domain · Type: ref · Rows: 24 (Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/trait/product.php, line 354File: APPPATH/classes/controller/product.php, line 145File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.220 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/experiment/product13/controller.php, line 18File: APPPATH/classes/controller/product.php, line 147File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT reviews.review, reviews.rating, reviews.sku, ROUND(reviews.rating / 5 * 100) AS per, reviews.user_name AS name, user_orders.delivery_city AS city, reviews.created_datetime AS created FROM reviews LEFT JOIN user_orders ON (user_orders.order = reviews.order) WHERE reviews.language = 'es_ES' AND reviews.sku = 'FQ2330' 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.046 ms
Query analysis:
· Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 211 (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 103File: APPPATH/classes/controller/product.php, line 150File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT AVG(reviews.rating) AS avg FROM reviews WHERE reviews.sku = 'FQ2330' AND reviews.rating >= 4 AND reviews.language = 'es_ES' AND (reviews.published IS null OR reviews.published = 1)Connection name: slave
Speed: 0.228 ms
Query analysis:
· Query: SIMPLE on reviews · Possible keys: language,sku · Key Used: language · Type: ref · Rows: 211 (Using index condition; Using where)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/review.php, line 207File: APPPATH/classes/review.php, line 104File: APPPATH/classes/controller/product.php, line 150File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 2 LIMIT 1Connection name: slave
Speed: 0.250 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on domain_configs · Possible keys: IDX_A0BE612B819EABE6 · Key Used: IDX_A0BE612B819EABE6 · Type: ref · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/domainconfig.php, line 20File: APPPATH/classes/controller/product.php, line 199File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM product_prices WHERE product_prices.id_product = 361 AND product_prices.variation_a = 'ES' AND product_prices.variation_b = 'small' AND product_prices.active = 1Connection name: slave
Speed: 0.219 ms · DUPLICATE
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: ref · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 33File: APPPATH/classes/controller/product.php, line 546File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT suppliers_delivery_methods.*, suppliers.type AS delivery_type, suppliers.code AS supplier_code FROM suppliers_delivery_methods INNER JOIN suppliers ON (suppliers.id = suppliers_delivery_methods.id_supplier) WHERE suppliers_delivery_methods.country = 'ES' ORDER BY suppliers.order_by ASCConnection name: slave
Speed: 0.225 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Type: ALL · Rows: 7 (Using filesort)
· Query: SIMPLE on suppliers_delivery_methods · Possible keys: id_supplier_2,id_supplier · Key Used: id_supplier_2 · Type: ref · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 62File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.208 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.200 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.204 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.221 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.206 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.208 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.204 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.205 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.209 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.201 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.207 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.205 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.209 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.207 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.209 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave
Speed: 0.210 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave
Speed: 0.199 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '1' LIMIT 1Connection name: slave
Speed: 0.213 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM country_deliveryhourhide WHERE country_deliveryhourhide.country IN ('ALL', 'ES') AND country_deliveryhourhide.strdate_date = '2022-05-25'Connection name: slave
Speed: 0.235 ms
Query analysis:
· Query: SIMPLE on country_deliveryhourhide · Possible keys: country_date_type,index3 · Key Used: country_date_type · Type: range · Rows: 2 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 85File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.252 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.216 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.206 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.214 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.211 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.204 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.201 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.225 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.212 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.210 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.210 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.204 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.220 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.214 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.210 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 101File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT suppliers_delivery_methods.*, suppliers.type AS delivery_type, suppliers.code AS supplier_code FROM suppliers_delivery_methods INNER JOIN suppliers ON (suppliers.id = suppliers_delivery_methods.id_supplier) WHERE suppliers_delivery_methods.country = 'ES' ORDER BY suppliers.order_by ASCConnection name: slave
Speed: 0.238 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Type: ALL · Rows: 7 (Using filesort)
· Query: SIMPLE on suppliers_delivery_methods · Possible keys: id_supplier_2,id_supplier · Key Used: id_supplier_2 · Type: ref · Rows: 1 (Using index condition)
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/supplier.php, line 62File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.204 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.209 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.208 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.215 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.206 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.201 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '2' LIMIT 1Connection name: slave
Speed: 0.207 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.204 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.208 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM suppliers WHERE id = '8' LIMIT 1Connection name: slave
Speed: 0.203 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on suppliers · Possible keys: PRIMARY,id_code_country · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/supplier/delivery/methods.php, line 30File: APPPATH/classes/supplier.php, line 68File: APPPATH/classes/controller/product.php, line 554File: APPPATH/classes/controller/product.php, line 222File: COREPATH/classes/request.php, line 454File: DOCROOT/index.ph |
