Symfony Profiler

Query Metrics

23 Database Queries

23 Different statements

64.16 ms Query time

0 Invalid entities

Queries


SELECT 
                    p.id_product as id_product,
                    p.id_category_default as category_default,
                    p.reference as reference,
                    l.link_rewrite as link_rewrite,
                    l.name as name,
                    l.description_short as description_short,
                    l.description as description,
                    l.meta_description as meta_description,
                    i1.id_image as id_image1,
                    il1.legend as legend1,
                    GROUP_CONCAT(DISTINCT ia.id_image ORDER BY ia.id_image) as id_imagea,
                    GROUP_CONCAT(DISTINCT ila.legend ORDER BY ila.id_image) as legenda,
                    GROUP_CONCAT(DISTINCT s.name) as suppliers,
                    GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers,
                    GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap,
                    GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id,
                    GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec,
                    GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id
                    FROM pre2398_product p
                LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
                LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product
                LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1
                LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image AND ila.id_lang = '2'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2'
                LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product
                LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier
                LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4
                LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2'
                LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5
                LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2'
                WHERE l.id_lang = '2' AND l.link_rewrite = 'wire-rope-load-cells-5500-5505' GROUP BY p.id_product ORDER BY p.id_product
SELECT * FROM pre2398_product_lang p WHERE p.id_product = 3323 AND p.id_lang = '1'
SELECT 
                    p.id_product as id_product,
                    p.id_category_default as category_default,
                    p.reference as reference,
                    l.link_rewrite as link_rewrite,
                    l.name as name,
                    l.description_short as description,
                    i1.id_image as id_image1,
                    i2.id_image as id_image2,
                    il1.legend as legend1,
                    il2.legend as legend2,
                    a.file_name as file_name,
                    GROUP_CONCAT(DISTINCT s.name) as suppliers,
                    GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers,
                    GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap,
                    GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec
                    FROM pre2398_product p
                INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '15'
                LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
                LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2
                LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = '2'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2'
                LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product
                LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name like '%en%'
                LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product
                LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier
                LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4
                LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2'
                LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5
                LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2'
                WHERE l.id_lang = '2' AND a.category = 'Datasheets' AND p.id_category_default = '18' GROUP BY p.id_product ORDER BY p.id_product
SELECT fp.id_feature, fp.id_product , fl.name, p.reference, p.id_product, fvl.value
			FROM `pre2398_feature_product` fp
			INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value
			INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature
			INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product
			INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature
			WHERE fl.id_lang = 2 AND fvl.id_lang = 2 AND p.id_product = 3323 ORDER BY f.position
SELECT fp.id_feature, fp.id_product, fl.name, p.reference, p.id_product, fvl.value
			FROM `pre2398_feature_product` fp
			INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value
			INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature
			INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product
			INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature
			WHERE fl.id_lang = 2 AND fvl.id_lang = 2 AND p.reference LIKE '5500-5505\_%' ORDER BY f.position
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Reference temperature (°C)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Compensated temperature range (°C)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Service temperature range (°C)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Storage temperature range (°C)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Temperature coefficient of the sensitivity  (% F.S.*/10°C)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Temperature coefficient of zero signal  (% F.S.*/10°C)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Nominal sensitivity (mV/V)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Input  resistance (ohm(s))"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Output resistance (ohm(s))"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Insulation resistance (50 V) (Mohm(s))"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Reference excitation voltage (VDC)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Permissible nominal range of excitation voltage  (VDC)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Safe load limit (% F.S.*)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Breaking load (% F.S.*)"
SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1
				FROM `pre2398_cms` c
				INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms
				INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category
				INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category
				INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent
				INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category
				WHERE cl.id_lang = 2
				AND cl.meta_title = "Permissible dynamic loading (% F.S.*)"
SELECT * FROM pre2398_product_attachment pa
                INNER JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment
                WHERE pa.id_product = '3323'
SELECT * FROM pre2398_pet_tab_content_shop ptcs
                LEFT JOIN pre2398_pet_tab_content ptc ON ptc.id_tab_content = ptcs.id_tab_content
                LEFT JOIN pre2398_pet_tab_content_lang ptcl ON ptcl.id_tab_content = ptcs.id_tab_content AND ptcl.id_lang = '2'
                LEFT JOIN pre2398_pet_tab_lang ptl ON ptl.id_tab = ptc.id_tab AND ptl.id_lang = '2'
                WHERE ptcs.id_product = '3323'
SELECT 
                    p.id_product as id_product,
                    p.id_category_default as category_default,
                    p.reference as reference,
                    l.link_rewrite as link_rewrite,
                    l.name as name,
                    l.description_short as description_short,
                    l.description as description,
                    l.meta_description as meta_description,
                    i1.id_image as id_image1,
                    i2.id_image as id_image2,
                    il1.legend as legend1,
                    il2.legend as legend2,
                    cl.link_rewrite as prelink,
                    a.file_name as file_name,
                    GROUP_CONCAT(DISTINCT ia.id_image ORDER BY ia.id_image) as id_imagea,
                    GROUP_CONCAT(DISTINCT ila.legend ORDER BY ila.id_image) as legenda,
                    GROUP_CONCAT(DISTINCT s.name) as suppliers,
                    GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers,
                    GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap,
                    GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id,
                    GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec,
                    GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id
                    FROM pre2398_product p
                LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
                LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product
                LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1
                LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2
                LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image AND ila.id_lang = '2'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = '2'
                LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product
                LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name like '%en%'
                LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product
                LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier
                LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4
                LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2'
                LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5
                LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '2'
                WHERE l.id_lang = '2' AND p.id_product = '1795' GROUP BY p.id_product ORDER BY p.id_product

#▲	Time	Info
1	0.74 ms	SELECT p.id_product as id_product, p.id_category_default as category_default, p.reference as reference, l.link_rewrite as link_rewrite, l.name as name, l.description_short as description_short, l.description as description, l.meta_description as meta_description, i1.id_image as id_image1, il1.legend as legend1, GROUP_CONCAT(DISTINCT ia.id_image ORDER BY ia.id_image) as id_imagea, GROUP_CONCAT(DISTINCT ila.legend ORDER BY ila.id_image) as legenda, GROUP_CONCAT(DISTINCT s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap, GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id, GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec, GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id FROM pre2398_product p LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1 LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image AND ila.id_lang = '2' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2' LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4 LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2' LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5 LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2' WHERE l.id_lang = '2' AND l.link_rewrite = 'wire-rope-load-cells-5500-5505' GROUP BY p.id_product ORDER BY p.id_product Parameters: [] View formatted query View runnable query Explain query SELECT p.id_product as id_product, p.id_category_default as category_default, p.reference as reference, l.link_rewrite as link_rewrite, l.name as name, l.description_short as description_short, l.description as description, l.meta_description as meta_description, i1.id_image as id_image1, il1.legend as legend1, GROUP_CONCAT( DISTINCT ia.id_image ORDER BY ia.id_image ) as id_imagea, GROUP_CONCAT( DISTINCT ila.legend ORDER BY ila.id_image ) as legenda, GROUP_CONCAT(DISTINCT s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap, GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id, GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec, GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id FROM pre2398_product p LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1 LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image AND ila.id_lang = '2' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2' LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4 LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2' LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5 LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2' WHERE l.id_lang = '2' AND l.link_rewrite = 'wire-rope-load-cells-5500-5505' GROUP BY p.id_product ORDER BY p.id_product SELECT p.id_product as id_product, p.id_category_default as category_default, p.reference as reference, l.link_rewrite as link_rewrite, l.name as name, l.description_short as description_short, l.description as description, l.meta_description as meta_description, i1.id_image as id_image1, il1.legend as legend1, GROUP_CONCAT(DISTINCT ia.id_image ORDER BY ia.id_image) as id_imagea, GROUP_CONCAT(DISTINCT ila.legend ORDER BY ila.id_image) as legenda, GROUP_CONCAT(DISTINCT s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap, GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id, GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec, GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id FROM pre2398_product p LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1 LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image AND ila.id_lang = '2' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2' LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4 LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2' LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5 LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2' WHERE l.id_lang = '2' AND l.link_rewrite = 'wire-rope-load-cells-5500-5505' GROUP BY p.id_product ORDER BY p.id_product;
2	0.18 ms	SELECT * FROM pre2398_product_lang p WHERE p.id_product = 3323 AND p.id_lang = '1' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM pre2398_product_lang p WHERE p.id_product = 3323 AND p.id_lang = '1' SELECT * FROM pre2398_product_lang p WHERE p.id_product = 3323 AND p.id_lang = '1';
3	3.02 ms	SELECT p.id_product as id_product, p.id_category_default as category_default, p.reference as reference, l.link_rewrite as link_rewrite, l.name as name, l.description_short as description, i1.id_image as id_image1, i2.id_image as id_image2, il1.legend as legend1, il2.legend as legend2, a.file_name as file_name, GROUP_CONCAT(DISTINCT s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap, GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec FROM pre2398_product p INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '15' LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2 LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1 LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = '2' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2' LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name like '%en%' LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4 LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2' LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5 LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2' WHERE l.id_lang = '2' AND a.category = 'Datasheets' AND p.id_category_default = '18' GROUP BY p.id_product ORDER BY p.id_product Parameters: [] View formatted query View runnable query Explain query SELECT p.id_product as id_product, p.id_category_default as category_default, p.reference as reference, l.link_rewrite as link_rewrite, l.name as name, l.description_short as description, i1.id_image as id_image1, i2.id_image as id_image2, il1.legend as legend1, il2.legend as legend2, a.file_name as file_name, GROUP_CONCAT(DISTINCT s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap, GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec FROM pre2398_product p INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '15' LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2 LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1 LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = '2' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2' LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name like '%en%' LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4 LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2' LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5 LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2' WHERE l.id_lang = '2' AND a.category = 'Datasheets' AND p.id_category_default = '18' GROUP BY p.id_product ORDER BY p.id_product SELECT p.id_product as id_product, p.id_category_default as category_default, p.reference as reference, l.link_rewrite as link_rewrite, l.name as name, l.description_short as description, i1.id_image as id_image1, i2.id_image as id_image2, il1.legend as legend1, il2.legend as legend2, a.file_name as file_name, GROUP_CONCAT(DISTINCT s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap, GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec FROM pre2398_product p INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '15' LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2 LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1 LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = '2' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2' LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name like '%en%' LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4 LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2' LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5 LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2' WHERE l.id_lang = '2' AND a.category = 'Datasheets' AND p.id_category_default = '18' GROUP BY p.id_product ORDER BY p.id_product;
4	0.36 ms	SELECT fp.id_feature, fp.id_product , fl.name, p.reference, p.id_product, fvl.value FROM `pre2398_feature_product` fp INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature WHERE fl.id_lang = 2 AND fvl.id_lang = 2 AND p.id_product = 3323 ORDER BY f.position Parameters: [] View formatted query View runnable query Explain query SELECT fp.id_feature, fp.id_product, fl.name, p.reference, p.id_product, fvl.value FROM `pre2398_feature_product` fp INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature WHERE fl.id_lang = 2 AND fvl.id_lang = 2 AND p.id_product = 3323 ORDER BY f.position SELECT fp.id_feature, fp.id_product , fl.name, p.reference, p.id_product, fvl.value FROM `pre2398_feature_product` fp INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature WHERE fl.id_lang = 2 AND fvl.id_lang = 2 AND p.id_product = 3323 ORDER BY f.position;
5	11.55 ms	SELECT fp.id_feature, fp.id_product, fl.name, p.reference, p.id_product, fvl.value FROM `pre2398_feature_product` fp INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature WHERE fl.id_lang = 2 AND fvl.id_lang = 2 AND p.reference LIKE '5500-5505\_%' ORDER BY f.position Parameters: [] View formatted query View runnable query Explain query SELECT fp.id_feature, fp.id_product, fl.name, p.reference, p.id_product, fvl.value FROM `pre2398_feature_product` fp INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature WHERE fl.id_lang = 2 AND fvl.id_lang = 2 AND p.reference LIKE '5500-5505\_%' ORDER BY f.position SELECT fp.id_feature, fp.id_product, fl.name, p.reference, p.id_product, fvl.value FROM `pre2398_feature_product` fp INNER JOIN `pre2398_feature_value_lang` fvl ON fp.id_feature_value = fvl.id_feature_value INNER JOIN `pre2398_feature_lang` fl ON fp.id_feature = fl.id_feature INNER JOIN `pre2398_product` p ON fp.id_product = p.id_product INNER JOIN `pre2398_feature` f ON f.id_feature = fl.id_feature WHERE fl.id_lang = 2 AND fvl.id_lang = 2 AND p.reference LIKE '5500-5505\_%' ORDER BY f.position;
6	3.75 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Reference temperature (°C)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Reference temperature (°C)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Reference temperature (°C)" ;
7	4.21 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Compensated temperature range (°C)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Compensated temperature range (°C)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Compensated temperature range (°C)" ;
8	3.82 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Service temperature range (°C)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Service temperature range (°C)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Service temperature range (°C)" ;
9	2.91 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Storage temperature range (°C)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Storage temperature range (°C)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Storage temperature range (°C)" ;
10	2.94 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Temperature coefficient of the sensitivity (% F.S./10°C)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Temperature coefficient of the sensitivity (% F.S./10°C)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Temperature coefficient of the sensitivity (% F.S.*/10°C)" ;
11	2.76 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Temperature coefficient of zero signal (% F.S./10°C)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Temperature coefficient of zero signal (% F.S./10°C)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Temperature coefficient of zero signal (% F.S.*/10°C)" ;
12	3.76 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Nominal sensitivity (mV/V)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Nominal sensitivity (mV/V)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Nominal sensitivity (mV/V)" ;
13	3.32 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Input resistance (ohm(s))" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Input resistance (ohm(s))" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Input resistance (ohm(s))" ;
14	3.23 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Output resistance (ohm(s))" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Output resistance (ohm(s))" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Output resistance (ohm(s))" ;
15	2.52 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Insulation resistance (50 V) (Mohm(s))" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Insulation resistance (50 V) (Mohm(s))" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Insulation resistance (50 V) (Mohm(s))" ;
16	3.20 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Reference excitation voltage (VDC)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Reference excitation voltage (VDC)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Reference excitation voltage (VDC)" ;
17	2.50 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Permissible nominal range of excitation voltage (VDC)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Permissible nominal range of excitation voltage (VDC)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Permissible nominal range of excitation voltage (VDC)" ;
18	2.43 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Safe load limit (% F.S.)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Safe load limit (% F.S.)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Safe load limit (% F.S.*)" ;
19	3.56 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Breaking load (% F.S.)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Breaking load (% F.S.)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Breaking load (% F.S.*)" ;
20	2.53 ms	SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Permissible dynamic loading (% F.S.)" Parameters: [] View formatted query View runnable query Explain query SELECT cl.link_rewrite, cl.meta_title, cl.meta_description, cl.id_cms, c.active, ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Permissible dynamic loading (% F.S.)" SELECT cl.link_rewrite,cl.meta_title,cl.meta_description,cl.id_cms,c.active,ccl.link_rewrite as link2, ccl2.link_rewrite as link1 FROM `pre2398_cms` c INNER JOIN `pre2398_cms_lang` cl ON cl.id_cms = c.id_cms INNER JOIN `pre2398_cms_category` cc ON cc.id_cms_category = c.id_cms_category INNER JOIN `pre2398_cms_category_lang` ccl ON ccl.id_cms_category = cc.id_cms_category INNER JOIN `pre2398_cms_category` cc2 ON cc2.id_cms_category = cc.id_parent INNER JOIN `pre2398_cms_category_lang` ccl2 ON ccl2.id_cms_category = cc2.id_cms_category WHERE cl.id_lang = 2 AND cl.meta_title = "Permissible dynamic loading (% F.S.*)" ;
21	0.14 ms	SELECT * FROM pre2398_product_attachment pa INNER JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment WHERE pa.id_product = '3323' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM pre2398_product_attachment pa INNER JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment WHERE pa.id_product = '3323' SELECT * FROM pre2398_product_attachment pa INNER JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment WHERE pa.id_product = '3323';
22	0.17 ms	SELECT * FROM pre2398_pet_tab_content_shop ptcs LEFT JOIN pre2398_pet_tab_content ptc ON ptc.id_tab_content = ptcs.id_tab_content LEFT JOIN pre2398_pet_tab_content_lang ptcl ON ptcl.id_tab_content = ptcs.id_tab_content AND ptcl.id_lang = '2' LEFT JOIN pre2398_pet_tab_lang ptl ON ptl.id_tab = ptc.id_tab AND ptl.id_lang = '2' WHERE ptcs.id_product = '3323' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM pre2398_pet_tab_content_shop ptcs LEFT JOIN pre2398_pet_tab_content ptc ON ptc.id_tab_content = ptcs.id_tab_content LEFT JOIN pre2398_pet_tab_content_lang ptcl ON ptcl.id_tab_content = ptcs.id_tab_content AND ptcl.id_lang = '2' LEFT JOIN pre2398_pet_tab_lang ptl ON ptl.id_tab = ptc.id_tab AND ptl.id_lang = '2' WHERE ptcs.id_product = '3323' SELECT * FROM pre2398_pet_tab_content_shop ptcs LEFT JOIN pre2398_pet_tab_content ptc ON ptc.id_tab_content = ptcs.id_tab_content LEFT JOIN pre2398_pet_tab_content_lang ptcl ON ptcl.id_tab_content = ptcs.id_tab_content AND ptcl.id_lang = '2' LEFT JOIN pre2398_pet_tab_lang ptl ON ptl.id_tab = ptc.id_tab AND ptl.id_lang = '2' WHERE ptcs.id_product = '3323';
23	0.54 ms	SELECT p.id_product as id_product, p.id_category_default as category_default, p.reference as reference, l.link_rewrite as link_rewrite, l.name as name, l.description_short as description_short, l.description as description, l.meta_description as meta_description, i1.id_image as id_image1, i2.id_image as id_image2, il1.legend as legend1, il2.legend as legend2, cl.link_rewrite as prelink, a.file_name as file_name, GROUP_CONCAT(DISTINCT ia.id_image ORDER BY ia.id_image) as id_imagea, GROUP_CONCAT(DISTINCT ila.legend ORDER BY ila.id_image) as legenda, GROUP_CONCAT(DISTINCT s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap, GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id, GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec, GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id FROM pre2398_product p LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1 LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2 LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image AND ila.id_lang = '2' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2' LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = '2' LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name like '%en%' LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4 LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2' LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5 LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2' LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '2' WHERE l.id_lang = '2' AND p.id_product = '1795' GROUP BY p.id_product ORDER BY p.id_product Parameters: [] View formatted query View runnable query Explain query SELECT p.id_product as id_product, p.id_category_default as category_default, p.reference as reference, l.link_rewrite as link_rewrite, l.name as name, l.description_short as description_short, l.description as description, l.meta_description as meta_description, i1.id_image as id_image1, i2.id_image as id_image2, il1.legend as legend1, il2.legend as legend2, cl.link_rewrite as prelink, a.file_name as file_name, GROUP_CONCAT( DISTINCT ia.id_image ORDER BY ia.id_image ) as id_imagea, GROUP_CONCAT( DISTINCT ila.legend ORDER BY ila.id_image ) as legenda, GROUP_CONCAT(DISTINCT s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap, GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id, GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec, GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id FROM pre2398_product p LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1 LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2 LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image AND ila.id_lang = '2' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2' LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = '2' LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name like '%en%' LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4 LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2' LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5 LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2' LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '2' WHERE l.id_lang = '2' AND p.id_product = '1795' GROUP BY p.id_product ORDER BY p.id_product SELECT p.id_product as id_product, p.id_category_default as category_default, p.reference as reference, l.link_rewrite as link_rewrite, l.name as name, l.description_short as description_short, l.description as description, l.meta_description as meta_description, i1.id_image as id_image1, i2.id_image as id_image2, il1.legend as legend1, il2.legend as legend2, cl.link_rewrite as prelink, a.file_name as file_name, GROUP_CONCAT(DISTINCT ia.id_image ORDER BY ia.id_image) as id_imagea, GROUP_CONCAT(DISTINCT ila.legend ORDER BY ila.id_image) as legenda, GROUP_CONCAT(DISTINCT s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.name) as attr_cap, GROUP_CONCAT(DISTINCT pattrl4.id_attribute) as attr_cap_id, GROUP_CONCAT(DISTINCT pattrl5.name) as attr_prec, GROUP_CONCAT(DISTINCT pattrl5.id_attribute) as attr_prec_id FROM pre2398_product p LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product LEFT JOIN pre2398_image ia ON p.id_product = ia.id_product LEFT JOIN pre2398_image i1 ON p.id_product = i1.id_product AND i1.position = 1 LEFT JOIN pre2398_image i2 ON p.id_product = i2.id_product AND i2.position = 2 LEFT JOIN pre2398_image_lang ila ON ila.id_image = ia.id_image AND ila.id_lang = '2' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '2' LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = '2' LEFT JOIN pre2398_product_attachment pa ON pa.id_product = p.id_product LEFT JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment AND a.file_name like '%en%' LEFT JOIN pre2398_product_supplier ps ON ps.id_product = p.id_product LEFT JOIN pre2398_supplier s ON s.id_supplier = ps.id_supplier LEFT JOIN pre2398_layered_product_attribute lpa4 ON lpa4.id_product = p.id_product AND lpa4.id_attribute_group = 4 LEFT JOIN pre2398_attribute_lang pattrl4 ON pattrl4.id_attribute = lpa4.id_attribute AND pattrl4.id_lang = '2' LEFT JOIN pre2398_layered_product_attribute lpa5 ON lpa5.id_product = p.id_product AND lpa5.id_attribute_group = 5 LEFT JOIN pre2398_attribute_lang pattrl5 ON pattrl5.id_attribute = lpa5.id_attribute AND pattrl5.id_lang = '2' LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '2' WHERE l.id_lang = '2' AND p.id_product = '1795' GROUP BY p.id_product ORDER BY p.id_product;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.

Symfony Profiler

GET http://sensy.adevo-host.net/en/tensiometers/wire-rope-load-cells-5500-5505

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping