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 '2025-12-29 04:31:49' BETWEEN l.start AND l.end AND l.active = 1 AND lv.ip = '216.73.216.167'**	0,0008
2	SET NAMES utf8mb4	0,0001
3	SET sql_mode = ''	0
4	SELECT id, word, lang_1 as text FROM shop_language_words	0,0003
5	*SELECT FROM shop_redirects WHERE old_url = ?**	0,0109
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,0001
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,003
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,0002
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,0018
13	SELECT `id` as `value`, `name` as `title` FROM `shop_brands` ORDER by `value` ASC	0,0044
14	INSERT INTO _http_referer_bots (ref_id, user_id, url, ip, ua, created_at) VALUES ('0', '', 'https://patilanci.bg/search?q=%e0%a6%8f%e0%a6%95%e0%a6%9f%e0%a6%bf+bigo+%e0%a6%85%e0%a7%8d%e0%a6%af%e0%a6%be%e0%a6%95%e0%a6%be%e0%a6%89%e0%a6%a8%e0%a7%8d%e0%a6%9f+%e0%a6%aa%e0%a6%be%e0%a6%a8+%f0%9f%91%89%f0%9f%8f%bc+acc6.top+%f0%9f%91%88%f0%9f%8f%bc', '216.73.216.167', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2025-12-29 04:31:49')	0,0063
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,0296

#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