MySQL Debugger Results
Count SQL query Time to execute
1 SELECT id, word, lang_1 as text FROM shop_language_words 0,001
2 SELECT local_url FROM shop_seo WHERE seo_url = ? 0,0013
3 INSERT INTO shop_logs (add_date, ip, url, user_agent) VALUES ('2024-11-21 10:34:14', '18.118.37.85', '/ventilator-za-prah-cormak-fm-300n-400v-1500w', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)') 0,0002
4 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
5 SELECT * FROM `shop_languages` WHERE id = ? 0,0001
6 SELECT `id` as `value`, `t` as `title` FROM `fm_brands` ORDER by `value` ASC 0,0017
7 SELECT `id` as `value`, `name` as `title` FROM `shop_properties` ORDER by `value` ASC 0,0003
8 SELECT * FROM `shop_products` WHERE id = ? 0,0005
9 SELECT * FROM `shop_categories` WHERE id = ? 0,0002
10 SELECT id, name, active_products, active, shown_name, seo_url, icon, parent_id FROM shop_categories WHERE active_products > 0 AND parent_id = ? ORDER BY name ASC 0,0005
11 SELECT id, name, active_products, active, shown_name, seo_url, parent_id FROM shop_categories WHERE active_products > 0 AND parent_id = 181 ORDER BY name ASC 0,0002
12 SELECT id, name, active_products, active, shown_name, seo_url, parent_id FROM shop_categories WHERE active_products > 0 AND parent_id = 592 ORDER BY name ASC 0,0001
13 SELECT id, name, active_products, active, shown_name, seo_url, parent_id FROM shop_categories WHERE active_products > 0 AND parent_id = 590 ORDER BY name ASC 0,0001
14 SELECT id, name, active_products, active, shown_name, seo_url, parent_id FROM shop_categories WHERE active_products > 0 AND parent_id = 591 ORDER BY name ASC 0,0001
15 SELECT * FROM `shop_categories` WHERE id = ? 0,0001
16 SELECT * FROM `fm_brands` WHERE id = ? 0,0001
17 SELECT t.id,t.add_date,t.add_by,p.name as product_id,t.name,t.email,t.comment,t.evaluations FROM `shop_product_reviews` AS t LEFT JOIN shop_products as p ON t.product_id = p.id WHERE 1 AND t.`product_id` = '32819' AND t.`del` = '0' ORDER BY id DESC LIMIT 0, 300 0,0002
18 SELECT COUNT(id) FROM shop_product_reviews WHERE product_id = ? AND del = 0 0,0002
19 SELECT p.id, p.name, p.metric, v.value FROM shop_product_properties AS v INNER JOIN shop_properties AS p ON p.id = v.property_id WHERE v.product_id = ? AND p.show_in_products = ? ORDER BY p.sort_order ASC 0,0003
20 SELECT p.*, b.t AS brand_name, IF((pp.instorage + pp.other_instorage) > 5,5,(pp.instorage + pp.other_instorage)) last_qty FROM shop_products AS p LEFT JOIN fm_pr AS pp ON pp.id = p.id LEFT JOIN fm_brands AS b ON b.id = p.brand_id WHERE p.active = '1' AND p.category_id = '592' AND p.id != '32819' ORDER BY p.id DESC LIMIT 10 0,1016
21 SELECT p.*, b.t as brand_name, IF((pp.instorage + pp.other_instorage) > 5,5,(pp.instorage + pp.other_instorage)) last_qty FROM shop_product_related AS pr LEFT JOIN shop_products AS p ON pr.related_id = p.id LEFT JOIN fm_pr AS pp ON pp.id = p.id LEFT JOIN fm_brands AS b ON b.id = p.brand_id WHERE p.active = 1 AND pr.product_id = '32819' ORDER BY p.id DESC LIMIT 10 0,0009
22 SELECT * FROM `shop_categories` WHERE id = ? 0,0007
23 SELECT * FROM `shop_categories` WHERE id = ? 0,005
24 UPDATE shop_products SET views='699', last_visited='2024-11-21 10:34:14', daily_views='1' WHERE id = '32819' 0,0005
25 SELECT * FROM `shop_categories` WHERE id = ? 0,0009
26 SELECT * FROM `shop_categories` WHERE id = ? 0,0002
27 SELECT id, instorage, other_instorage FROM fm_pr WHERE id = '32819' 0,0002
28 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away 0,0002
- - All Queries Time 0,1176 


#0 /home/mashini/public_html/app/system/Database.class.php(503): Registry::get('lang')
#1 /home/mashini/public_html/app/system/Database.class.php(156): Database->onDbError('SELECT id, inst...', 'SQLSTATE[HY000]...')
#2 /home/mashini/public_html/app/modules/Store/front/Products.controller.php(179): Database->fetchRow('SELECT id, inst...')
#3 /home/mashini/public_html/app/system/Controller.class.php(209): ProductsController->viewAction()
#4 /home/mashini/public_html/index.php(118): Controller->Start()
#5 {main}

'lang' is not set in the Registry