MySQL Debugger Results
Count	SQL query	Time to execute
1	SELECT ai_ip FROM `3w_allow_ips`	0,0002
2	SELECT * FROM custom_redirects WHERE old_url = ?	0,0002
3	SELECT * FROM 3w_config	0,0002
4	SELECT config_value FROM 3w_config WHERE config_title = 'default_lang'	0,0001
5	SELECT * FROM 3w_route WHERE UPPER(route_seo_url)='PLASTMASOVA-KUTIQ-ZA-INSTRUMENTI-556-H-257-H-287-MM-STANLEY' LIMIT 1	0,0019
6	SELECT * FROM 3w_lang ORDER BY lang_id DESC	0,0002
7	SELECT * FROM 3w_cms_blocks WHERE block_title = 'contact_us' AND block_langId = '16'	0,0003
8	SELECT * FROM 3w_meta WHERE meta_langId = '16'	0,0002
9	SELECT config_value FROM 3w_config WHERE config_title = 'site_logo'	0,0001
10	SELECT * FROM 3w_cms_blocks WHERE block_title = 'copyright' AND block_langId = '16'	0,0006
11	SELECT * FROM 3w_cms_blocks WHERE block_title = 'footer_block'	0,0004
12	SELECT b.* FROM 3w_banner b LEFT JOIN 3w_banner_position bp ON b.b_positionId = bp.bp_id WHERE b.b_isactive = '1' AND b.b_positionId = '24' AND bp.bp_isactive = '1' AND b.b_datePublish < NOW() ORDER BY (RAND() * (100-b_priority)) LIMIT 1	0,0008
13	SELECT * FROM promo WHERE id = 1	0,0001
14	SELECT rule_power FROM 3w_access_rules WHERE rule_section=:section AND rule_package=:package AND rule_controller=:controller AND rule_action=:action LIMIT 1	0,0001
15	SELECT p.*, IF( COUNT(ppr.price_id) > 0, IF( SUM(ppr.price_notinstock) = COUNT(ppr.price_id), 1, 0 ), p.product_notinstock ) AS product_notinstock, p.product_name translated_name, p.product_min_age as min_age, p.product_max_age as max_age, COALESCE(MIN(ppr.product_price_sell),p.product_price_sell) product_price_sell, COALESCE(MIN(NULLIF(ppr.product_price_promo,0)),p.product_price_promo) product_price_promo, COALESCE(MAX(ppr.product_exquisite),p.product_exquisite) product_exquisite, COALESCE(MAX(ppr.product_price_promo_start_date),p.product_price_promo_start_date) product_price_promo_start_date, COALESCE(MAX(ppr.product_price_promo_expire_date),p.product_price_promo_expire_date) product_price_promo_expire_date, IF(p.product_provider_id=208,1,COALESCE(MAX(ppr.product_onsale),p.product_onsale)) product_onsale, COALESCE(MAX(ppr.product_onsale),p.product_onsale) product_onsale_real, COALESCE(MAX(ppr.product_sale_count),p.product_sale_count) product_sale_count, GROUP_CONCAT(pcr.category_id) categoryIds, GROUP_CONCAT(pc.category_parent_id) categoryParentIds FROM 3w_products p INNER JOIN 3w_products_cat_rel pcr ON pcr.product_id = p.product_id INNER JOIN 3w_product_categories pc ON (pc.category_id = pcr.category_id AND pc.is_dummy = '0') LEFT JOIN 3w_products_price ppr ON ppr.product_id = p.product_id AND ppr.product_price_sell > 0 WHERE ( p.product_id = "124" ) AND ( p.deleted = '0' ) AND ( p.hidden = '0' ) GROUP BY p.product_id LIMIT 0, 1	0,0009
16	SELECT COUNT(DISTINCT pcr.product_id) FROM 3w_products_cat_rel pcr WHERE pcr.category_id = '781'	0,0003
17	SELECT id, image_filename FROM 3w_products_gallery WHERE product_id = '124' ORDER BY id = '148' DESC, show_order ASC	0,0002
18	SELECT pi.id, pi.item_seo_name, pi.item_name, pp.property_id, pp.property_seo_name, pp.property_name, count(DISTINCT p.product_id) products FROM 3w_property_items pi LEFT JOIN 3w_properties pp ON pp.property_id = pi.property_id INNER JOIN 3w_property_product_items ppi ON ppi.item_id = pi.id INNER JOIN 3w_products p ON p.product_id = ppi.product_id LEFT JOIN 3w_products_price ppr ON ppr.product_id = p.product_id AND ppr.product_price_sell > 0 WHERE ( p.product_id = "124" ) AND ( p.deleted = '0' ) AND ( p.hidden = '0' ) GROUP BY pi.id ORDER BY pp.property_order ASC, pi.item_order ASC, pi.item_name ASC	0,0004
19	SELECT * FROM 3w_product_reviews WHERE product_id='124' AND review_status<2 ORDER BY id DESC	0,0001
20	SELECT ct.* FROM 3w_product_tags AS ct, 3w_products_tag_rel AS tl WHERE ct.id=tl.tag_id AND tl.product_id=124 ORDER BY name ASC	0,0002
21	SELECT AVG(cm_rating) AS rating_sum FROM 3w_product_comments WHERE product_id = '124' AND cm_isactive = '1'	0,0016
22	SELECT COUNT(cm_id) FROM 3w_product_comments WHERE product_id = '124' AND cm_isactive = '1'	0,0001
23	SELECT pc.*, u.user_username, u.user_avatar FROM 3w_product_comments pc LEFT JOIN 3w_users u ON (u.user_id = pc.user_id) WHERE product_id='124' AND cm_isactive = 1 ORDER BY cm_date ASC LIMIT 5	0,0032
24	SELECT COUNT(cm_id) FROM 3w_product_comments WHERE product_id='124' AND cm_isactive = 1 ORDER BY cm_date ASC	0,0001
25	UPDATE 3w_products SET product_views = product_views + 1 WHERE product_id = '124'	0,2502
26	INSERT INTO 3w_products_recet_viewed (product_id, viewed_time) VALUES ('124', '2025-10-17 12:59:19')	0,0003
27	SQLSTATE[HY000]: General error: 144 Table './megahome/3w_products_recet_viewed' is marked as crashed and last (automatic?) repair failed	0,0003
- -	All Queries Time	0,2633