SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-it.floraqueen.net'Connection name: default Speed: 0.265 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/config/currency.php, line 7File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-it.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.259 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: 8.066 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2958 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 47File: APPPATH/config/staging/my.php, line 48File: COREPATH/classes/fuel.php, line 306File: COREPATH/classes/config/php.php, line 87File: COREPATH/classes/config/file.php, line 48File: COREPATH/classes/config.php, line 94File: COREPATH/classes/fuel.php, line 342File: COREPATH/classes/fuel.php, line 191File: APPPATH/bootstrap.php, line 52File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains`Connection name: default Speed: 0.301 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 78File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `domain` = 'flowers-stage-it.floraqueen.net'Connection name: default Speed: 0.248 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 103File: DOCROOT/index.php, line 238 |
SELECT * FROM `domains` WHERE `alias` LIKE '%flowers-stage-it.floraqueen.net%' LIMIT 1Connection name: default Speed: 0.229 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 118File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `catalogs` WHERE `id_domain` = 5 AND `permalink` = 'sitemap' LIMIT 1Connection name: default Speed: 0.455 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 275File: DOCROOT/index.php, line 238 |
SELECT `id`, `permalink` FROM `domain_pages` WHERE `id_domain` = 5 AND `permalink` = 'sitemap' AND `deleted_time` = 0 AND `active` = 1 AND (`version` = '' OR `version` IS null) LIMIT 1Connection name: default Speed: 0.439 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 311File: DOCROOT/index.php, line 238 |
SELECT `type_value` FROM `domain_configs` WHERE `domain_configs`.`id_domain` = 5Connection name: default Speed: 0.278 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 384File: DOCROOT/index.php, line 238 |
SELECT * FROM `domain_redirects` WHERE `id_domain` = 5 AND `path` = '/sitemap' LIMIT 1Connection name: default Speed: 0.261 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 1187File: APPPATH/classes/controller/base.php, line 44File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 5 AND event_start_date IS NOT null AND event_start_date >= '2022-07-01' ORDER BY event_start_date ASCConnection name: slave Speed: 0.254 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/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 5 LIMIT 1Connection name: slave Speed: 0.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/classes/abtest.php, line 44File: APPPATH/classes/abtest.php, line 66File: APPPATH/classes/controller/base.php, line 179File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.code, country_i18n.name, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE countries.delivery = 1 AND catalogs.id_domain = 5 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' AND country_i18n.language = 'it_IT' ORDER BY country_i18n.name ASCConnection name: slave Speed: 0.288 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 23658 (Using index condition; Using where; Using temporary; Using filesort) · Query: SIMPLE on countries · Possible keys: PRIMARY,code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on country_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1150File: APPPATH/classes/controller/base.php, line 209File: APPPATH/classes/controller/page.php, line 14File: 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.253 ms Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75788 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/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 5 AND deleted_time = 0 AND active = 1 AND permalink = 'sitemap' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.493 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/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 2512Connection name: slave Speed: 0.274 ms Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 273File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_combar WHERE id_domain = 5 AND (date_init IS null OR date_init <= '2022-07-02 00:00:00') AND (date_end IS null OR date_end >= '2022-07-02 00:00:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.277 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/page.php, line 20File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT groupname, name, language, text FROM i18n WHERE language IN ('it_IT')Connection name: slave Speed: 8.116 ms Query analysis: · Query: SIMPLE on i18n · Possible keys: language · Key Used: language · Type: ref · Rows: 2962 (Using index condition) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/model/i18n.php, line 149File: APPPATH/base.php, line 47File: APPPATH/classes/widgets.php, line 138File: APPPATH/classes/controller/page.php, line 25File: COREPATH/classes/request.php, line 452File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 5 AND id = 2512 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.321 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/controller/page.php, line 94File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 2512Connection name: slave Speed: 0.285 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/controller/page.php, line 94File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_redirects WHERE id_domain = 5 AND path = '/page/sitemap/2512' LIMIT 1Connection name: slave Speed: 0.357 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 1187File: APPPATH/classes/controller/base.php, line 44File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, id_domain, code, name, description, anchor_text, head_title, permalink, event_start_date, event_end_date, event_location FROM catalogs WHERE id_domain = 5 AND event_start_date IS NOT null AND event_start_date >= '2022-07-01' ORDER BY event_start_date ASCConnection name: slave Speed: 0.261 ms · DUPLICATE 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/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_configs WHERE domain_configs.id_domain = 5 LIMIT 1Connection name: slave Speed: 0.275 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/controller/base.php, line 179File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT countries.code, country_i18n.name, catalogs.permalink FROM countries LEFT JOIN catalogs ON (catalogs.geo_country = countries.code) INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE countries.delivery = 1 AND catalogs.id_domain = 5 AND catalogs.template = 'browsing-directory-flowers' AND catalogs.geo_type = 'cn' AND country_i18n.language = 'it_IT' ORDER BY country_i18n.name ASCConnection name: slave Speed: 0.297 ms · DUPLICATE Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 23658 (Using index condition; Using where; Using temporary; Using filesort) · Query: SIMPLE on countries · Possible keys: PRIMARY,code,code_es,code_en,delivery · Key Used: code · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on country_i18n · Possible keys: fk_country · Key Used: fk_country · Type: ref · Rows: 4 (Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 1150File: APPPATH/classes/controller/base.php, line 209File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: 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.252 ms · DUPLICATE Query analysis: · Query: SIMPLE on reviews · Type: ALL · Rows: 75788 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/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 5 AND deleted_time = 0 AND active = 1 AND permalink = 'sitemap' AND (version IS null OR version = '') LIMIT 1Connection name: slave Speed: 0.244 ms · DUPLICATE 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/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 2512Connection name: slave Speed: 0.261 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/base.php, line 273File: APPPATH/classes/controller/page.php, line 14File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_combar WHERE id_domain = 5 AND (date_init IS null OR date_init <= '2022-07-02 00:00:00') AND (date_end IS null OR date_end >= '2022-07-02 00:00:00') AND (ip_countries IS null OR ip_countries LIKE '%US%') ORDER BY id DESC LIMIT 1Connection name: slave Speed: 0.254 ms · DUPLICATE 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/page.php, line 20File: COREPATH/classes/request.php, line 452File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_pages WHERE id_domain = 5 AND id = 2512 AND deleted_time = 0 AND active = 1 LIMIT 1Connection name: slave Speed: 0.317 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 17File: APPPATH/classes/controller/page.php, line 418File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT * FROM domain_page_content WHERE id_page = 2512Connection name: slave Speed: 0.260 ms · DUPLICATE Query analysis: · Query: SIMPLE on domain_page_content · Possible keys: id_page · Key Used: id_page · Type: ref · Rows: 1 Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 34File: APPPATH/classes/controller/page.php, line 418File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT id, permalink, id_domain, code FROM domain_pages WHERE code = 'sitemap' AND active = 1 AND deleted_time = 0 AND id_domain = 5Connection name: slave Speed: 0.271 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_version_code · Type: ref · Rows: 1 (Using index condition; Using where) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/pages.php, line 84File: APPPATH/classes/controller/page.php, line 428File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT product_languages.name, product_languages.permalink FROM products INNER JOIN product_languages ON (product_languages.id_product = products.id) INNER JOIN product_prices ON (product_prices.id_product = products.id) INNER JOIN catalog_products ON (product_languages.id_product = catalog_products.id_product) INNER JOIN catalogs ON (catalog_products.id_catalog = catalogs.id) WHERE product_languages.language = 'it_IT' AND products.active = 1 AND product_prices.active = 1 AND product_languages.name IS NOT null AND product_languages.permalink IS NOT null AND catalogs.id_domain = 5 GROUP BY products.id ORDER BY product_languages.nameConnection name: slave Speed: 150.848 ms Query analysis: · Query: SIMPLE on products · Possible keys: PRIMARY,id_active,id_sku_active · Key Used: id_active · Type: ref · Rows: 1252 (Using where; Using index; Using temporary; Using filesort) · Query: SIMPLE on product_languages · Possible keys: unique,unique_permalink,id_product,language,permalink_language,id_name_language · Key Used: unique · Type: eq_ref · Rows: 1 (Using index condition; Using where) · Query: SIMPLE on catalog_products · Possible keys: unique,catalog_position,catalog_collection,IDX_816D8444C5B19B37,IDX_816D8444DD7ADDD · Key Used: IDX_816D8444DD7ADDD · Type: ref · Rows: 10 (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) · Query: SIMPLE on product_prices · Possible keys: unique,id_product,product_active,variation_active,variation_retail_price,product_variation_all · Key Used: product_active · Type: ref · Rows: 21 (Using index) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 1029File: APPPATH/classes/controller/page.php, line 431File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND name IS NOT null AND geo_type IS null AND template = 'default' AND meta_robots_noindex = 0 ORDER BY nameConnection name: slave Speed: 0.929 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 64 (Using index condition; Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 975File: APPPATH/classes/controller/page.php, line 440File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT domain_pages.name, domain_pages.permalink FROM domain_pages WHERE id_domain = 5 AND permalink IS NOT null AND name IS NOT null AND active = 1 AND deleted_time = 0 AND code NOT IN ('landing-international-flowers-delivery', 'landing-international-gifts-delivery') AND id <> 2512 ORDER BY nameConnection name: slave Speed: 0.286 ms Query analysis: · Query: SIMPLE on domain_pages · Possible keys: PRIMARY,domain_hash_unique,domain_version_pemalink,domain_version_code,id_domain,domain_version,domain_permalink · Key Used: domain_permalink · Type: range · Rows: 59 (Using index condition; Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 998File: APPPATH/classes/controller/page.php, line 450File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.head_title, catalogs.permalink, countries.code AS country_code, country_i18n.name AS country_name FROM catalogs INNER JOIN countries ON (countries.code = catalogs.geo_country) INNER JOIN country_i18n ON (country_i18n.id_country = countries.id) WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'cn' AND template = 'browsing-directory-flowers' AND meta_robots_noindex = 0 AND country_i18n.language = 'it_IT' ORDER BY country_i18n.name ASCConnection name: slave Speed: 27.993 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template,meta_robots_noindex · Type: index_merge · Rows: 11828 (Using intersect(domain_template,meta_robots_noindex); Using where; Using temporary; Using filesort) · Query: SIMPLE on countries · Possible keys: PRIMARY,code,code_es,code_en · Key Used: code · Type: eq_ref · Rows: 1 (Using index) · 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/page.php, line 932File: APPPATH/classes/controller/page.php, line 459File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'AR' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 35.121 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'AM' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.597 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'AU' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.675 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'AT' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.646 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'AZ' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.288 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'BH' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 36.890 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'BE' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.838 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'BY' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.913 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'BO' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.425 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'BA' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.952 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'BR' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 35.965 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'BG' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 35.539 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'CA' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.093 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'CL' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.649 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'CN' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.626 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'CY' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 33.945 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'CO' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.249 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'KR' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 35.259 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'CR' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.437 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'HR' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.024 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'DK' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.329 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'EC' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.467 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'EG' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: 34.224 ms Query analysis: · Query: SIMPLE on catalogs · Possible keys: id_domain,permalink_domain_language,meta_robots_noindex,event_name,event_domain,domain_template · Key Used: domain_template · Type: ref · Rows: 27462 (Using where; Using filesort) Call trace for this query:File: COREPATH/classes/model/crud.php, line 242File: APPPATH/classes/controller/page.php, line 953File: APPPATH/classes/controller/page.php, line 466File: COREPATH/classes/request.php, line 454File: APPPATH/classes/controller/page.php, line 127File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 225File: DOCROOT/index.php, line 241 |
SELECT catalogs.geo_city AS name, catalogs.permalink FROM catalogs WHERE id_domain = 5 AND permalink IS NOT null AND geo_type = 'ty' AND geo_country = 'SV' AND meta_robots_noindex = 0 ORDER BY geo_cityConnection name: slave Speed: |