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-01-23 20:42:48' BETWEEN l.start AND l.end AND l.active = 1 AND lv.ip = '216.73.216.152'**	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,0004
5	*SELECT FROM shop_redirects WHERE old_url = ?**	0,0094
6	SELECT local_url FROM shop_seo WHERE seo_url = ?	0,0001
7	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
8	*SELECT FROM `shop_languages` WHERE id = ?**	0
9	SELECT b.id, b.name, b.active_products, b.seo_url, b.priority FROM shop_brands AS b WHERE b.active_products > 0 ORDER BY b.name ASC	0,0003
10	SELECT b.id, b.name, b.active_products, b.seo_url, b.priority FROM shop_brands AS b WHERE b.active_products = 0 ORDER BY b.name ASC	0,0003
11	SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC	0,0001
12	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,0051
13	SELECT `id` as `value`, `name` as `title` FROM `shop_brands` ORDER by `value` ASC	0,0004
14	INSERT INTO _http_referer_bots (ref_id, user_id, url, ip, ua, created_at) VALUES ('0', '', 'https://patilanci.bg/search?q=%f0%9f%91%89+acc6.top+%f0%9f%91%88%f0%9f%8f%bb+%d9%85%d9%85%d8%a8%d8%b1%d8%b4%d9%be+american+express+%d8%a7%da%a9%d8%a7%d8%a4%d9%86%d9%b9+%d8%ae%d8%b1%db%8c%d8%af%db%8c%da%ba', '216.73.216.152', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2026-01-23 20:42:48')	0,0039
15	SELECT `id` as `value`, `name` as `title` FROM `shop_brands` ORDER by `value` ASC	0,0006
16	SELECT id, searched_for, show_results_for FROM shop_search_engine WHERE searched_for = ?	0,0003
17	SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='	0,0003
- -	All Queries Time	0,022

#0 /home/new/public_html/app/system/Database.class.php(503): Registry::get()
#1 /home/new/public_html/app/system/Database.class.php(156): Database->onDbError()
#2 /home/new/public_html/app/modules/Store/models/Search.model.php(210): Database->fetchRow()
#3 /home/new/public_html/app/modules/Store/models/Search.model.php(65): Search->getAllProducts()
#4 /home/new/public_html/app/modules/Store/front/Categories.controller.php(17): Search->load()
#5 /home/new/public_html/app/system/Controller.class.php(253): CategoriesController->indexAction()
#6 /home/new/public_html/index.php(157): Controller->Start()
#7 {main}

'lang' is not set in the Registry