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-11-16 10:53:02' BETWEEN l.start AND l.end AND l.active = 1 AND lv.ip = '216.73.217.88' 0.0005
2 SET NAMES utf8mb4 0.0001
3 SET sql_mode = '' 0.0001
4 SELECT id, word, lang_1 as text FROM shop_language_words 0.0011
5 SELECT * FROM shop_redirects WHERE old_url = ? 0.0003
6 SELECT local_url FROM shop_seo WHERE seo_url = ? 0.0002
7 SELECT local_url FROM shop_seo WHERE seo_url = ? 0.0008
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.0004
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 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.0002
15 SELECT * FROM `shop_languages` WHERE id = ? 0.0001
16 SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC 0.0002
17 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.0013
18 SELECT `id` as `value`, `name` as `title` FROM `shop_brands` ORDER by `value` ASC 0.001
19 SELECT `id` as `value`, `name` as `title` FROM `shop_brands` ORDER by `value` ASC 0.0009
20 SELECT * FROM `shop_categories` WHERE id = ? 0.0009
21 SELECT id, name, active_products, shown_name, seo_url, icon, parent_id FROM shop_categories WHERE active_products > 0 ORDER BY name ASC 0.0075
22 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.0005
23 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,123,125,128) JOIN shop_properties_new_values AS v ON v.id = ppn.value_id WHERE pc.category_id = ? AND p.brand_id IN (353,126,523) 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
24 SELECT id, seo_url FROM shop_brands WHERE id IN (353,126,523) 0.0001
25 SELECT id, COALESCE(NULLIF(store_name, ''), name) AS name, unit AS metric, seo_url FROM shop_properties_new WHERE id = ? 0.0002
26 SELECT id, COALESCE(NULLIF(store_name, ''), name) AS name, unit AS metric, seo_url, type FROM shop_properties_new WHERE id = ? 0.0001
27 SELECT p.brand_id AS value_id, b.name AS value, b.priority, b.seo_url, COUNT(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_brands AS b ON b.id = p.brand_id WHERE pc.category_id = ? AND p.brand_id > 0 GROUP BY p.brand_id ORDER BY cnt DESC, b.priority DESC, b.name ASC 0.0187
28 SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress 0.0187
- - All Queries Time 0.0561


#0 /home/new/public_html/app/system/Database.class.php(643): Registry::get()
#1 /home/new/public_html/app/system/Database.class.php(269): Database->onDbError()
#2 /home/new/public_html/app/modules/Store/models/Searchnew.model.php(1402): Database->fetchAll()
#3 /home/new/public_html/app/modules/Store/models/Searchnew.model.php(1326): Searchnew->addBrandProperty()
#4 /home/new/public_html/app/modules/Store/models/Searchnew.model.php(1117): 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(295): CategoriesController->indexAction()
#9 /home/new/public_html/index.php(162): Controller->Start()
#10 {main}

'lang' is not set in the Registry