| MySQL Debugger Results | ||
| Count | SQL query | Time to execute |
| 1 | SELECT l.* FROM shop_landings AS l LEFT JOIN shop_landing_views AS lv ON lv.landing_id = l.id WHERE '2026-10-05 16:25:56' BETWEEN l.start AND l.end AND l.active = 1 AND lv.ip = '216.73.217.112' | 0,0002 |
| 2 | SET NAMES utf8mb4 | 0 |
| 3 | SET sql_mode = '' | 0 |
| 4 | SELECT id, word, lang_1 as text FROM shop_language_words | 0,0007 |
| 5 | SELECT * FROM shop_redirects WHERE old_url = ? | 0,0001 |
| 6 | SELECT local_url FROM shop_seo WHERE seo_url = ? | 0,0007 |
| 7 | SELECT local_url FROM shop_seo WHERE seo_url = ? | 0,0002 |
| 8 | SELECT id FROM shop_brands WHERE seo_url = ? LIMIT 1 | 0,0002 |
| 9 | SELECT 1 FROM shop_products AS p JOIN shop_product_categories AS pc ON pc.product_id = p.id AND pc.category_id = ? WHERE p.brand_id = ? AND p.active = 1 AND p.archive = 0 LIMIT 1; | 0,0003 |
| 10 | SELECT id FROM shop_brands WHERE seo_url = ? LIMIT 1 | 0,0002 |
| 11 | SELECT 1 FROM shop_products AS p JOIN shop_product_categories AS pc ON pc.product_id = p.id AND pc.category_id = ? WHERE p.brand_id = ? AND p.active = 1 AND p.archive = 0 LIMIT 1; | 0,0003 |
| 12 | SELECT id FROM shop_brands WHERE seo_url = ? LIMIT 1 | 0,0001 |
| 13 | SELECT 1 FROM shop_products AS p JOIN shop_product_categories AS pc ON pc.product_id = p.id AND pc.category_id = ? WHERE p.brand_id = ? AND p.active = 1 AND p.archive = 0 LIMIT 1; | 0,0002 |
| 14 | SELECT p.id AS property_id, v.id AS value_id FROM shop_properties_new AS p JOIN shop_properties_new_values AS v ON v.property_id = p.id JOIN shop_category_properties AS cp ON cp.property_id = p.id AND cp.category_id = ? AND cp.show_as_filter = 1 WHERE p.seo_url = ? AND v.seo_url = ? LIMIT 1 | 0,0012 |
| 15 | SELECT t.id,t.language,t.code,t.flag,t.active FROM `shop_languages` AS t WHERE 1 AND t.`active` = '1' ORDER BY id DESC LIMIT 0, 300 | 0,0001 |
| 16 | SELECT * FROM `shop_languages` WHERE id = ? | 0,0001 |
| 17 | SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC | 0,0002 |
| 18 | SELECT t.id,t.name,t.seo_url,t.description,t.meta_title,t.meta_description,t.shown_name,t.parent_id,p.name as properties,t.icon,t.share_image,t.index_image FROM `shop_categories` AS t LEFT JOIN shop_properties as p ON t.properties = p.id WHERE 1 AND t.`top` = '1' ORDER BY id ASC LIMIT 0, 3 | 0,0014 |
| 19 | SELECT `id` as `value`, `name` as `title` FROM `shop_brands` ORDER by `value` ASC | 0,0007 |
| 20 | SELECT `id` as `value`, `name` as `title` FROM `shop_brands` ORDER by `value` ASC | 0,0015 |
| 21 | SELECT * FROM `shop_categories` WHERE id = ? | 0,0003 |
| 22 | SELECT id, name, active_products, shown_name, seo_url, icon, parent_id FROM shop_categories WHERE active_products > 0 ORDER BY name ASC | 0,0031 |
| 23 | SELECT p.id, COALESCE(NULLIF(p.store_name, ''), p.name) AS name, p.type, p.unit AS metric, p.seo_url, p.`group`, 1 AS show_in_category, MIN(cp.position) AS sort_order FROM shop_category_properties AS cp JOIN shop_properties_new AS p ON p.id = cp.property_id WHERE cp.category_id = ? AND cp.show_as_filter = 1 GROUP BY p.id ORDER BY sort_order ASC, p.id ASC | 0,0016 |
| 24 | SELECT ppn.property_id, ppn.value_id, v.value, v.seo_url, v.position, COUNT(DISTINCT p.id) AS cnt FROM shop_product_categories AS pc JOIN shop_products AS p ON p.id = pc.product_id AND p.active = 1 AND p.archive = 0 JOIN shop_product_properties_new AS ppn ON ppn.product_id = p.id AND ppn.property_id IN (121,158,483,557,125,128) JOIN shop_properties_new_values AS v ON v.id = ppn.value_id JOIN shop_product_properties_new AS f0 ON f0.product_id = p.id AND f0.property_id = 123 AND f0.value_id IN (1141) WHERE pc.category_id = ? AND p.brand_id IN (64,511,810) GROUP BY ppn.property_id, ppn.value_id HAVING cnt >= 1 ORDER BY ppn.property_id ASC, v.position ASC, v.value ASC | 0,0012 |
| 25 | SELECT ppn.property_id, ppn.value_id, v.value, v.seo_url, v.position, COUNT(DISTINCT p.id) AS cnt FROM shop_product_categories AS pc JOIN shop_products AS p ON p.id = pc.product_id AND p.active = 1 AND p.archive = 0 JOIN shop_product_properties_new AS ppn ON ppn.product_id = p.id AND ppn.property_id IN (123) JOIN shop_properties_new_values AS v ON v.id = ppn.value_id WHERE pc.category_id = ? AND p.brand_id IN (64,511,810) GROUP BY ppn.property_id, ppn.value_id HAVING cnt >= 1 ORDER BY ppn.property_id ASC, v.position ASC, v.value ASC | 0,0016 |
| 26 | SELECT id, seo_url FROM shop_brands WHERE id IN (64,511,810) | 0,0001 |
| 27 | SELECT v.id, v.property_id, v.seo_url, p.seo_url AS prop_seo FROM shop_properties_new_values AS v JOIN shop_properties_new AS p ON p.id = v.property_id WHERE v.id IN (1141) | 0,0017 |
| 28 | SELECT id, COALESCE(NULLIF(store_name, ''), name) AS name, unit AS metric, seo_url FROM shop_properties_new WHERE id = ? | 0,0001 |
| 29 | SQLSTATE[70100]: < |
0,0001 |
| - - | All Queries Time | 0,0182 |
#0 /home/new/public_html/app/system/Database.class.php(639): Registry::get()
#1 /home/new/public_html/app/system/Database.class.php(292): Database->onDbError()
#2 /home/new/public_html/app/modules/Store/models/Searchnew.model.php(1333): Database->fetchRow()
#3 /home/new/public_html/app/modules/Store/models/Searchnew.model.php(1321): Searchnew->addPriceProperty()
#4 /home/new/public_html/app/modules/Store/models/Searchnew.model.php(1114): Searchnew->generateCategoryProperties()
#5 /home/new/public_html/app/modules/Store/models/Searchnew.model.php(180): Searchnew->generateProperties()
#6 /home/new/public_html/app/modules/Store/models/Searchnew.model.php(107): Searchnew->getAllProducts()
#7 /home/new/public_html/app/modules/Store/front/Categories.controller.php(34): Searchnew->load()
#8 /home/new/public_html/app/system/Controller.class.php(291): CategoriesController->indexAction()
#9 /home/new/public_html/index.php(157): Controller->Start()
#10 {main}'lang' is not set in the Registry