Query Metrics
25
Database Queries
25
Different statements
22.18 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.07 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 = '1' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1' 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 = '1' 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 = '1' WHERE l.id_lang = '1' AND l.link_rewrite = 'capteurs-de-traction-5200-5205' GROUP BY p.id_product ORDER BY p.id_product
Parameters:
[] |
2 | 0.17 ms |
SELECT * FROM pre2398_product_lang p WHERE p.id_product = 95 AND p.id_lang = '2'
Parameters:
[] |
3 | 1.30 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 = '12' 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 = '1' LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1' 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 '%fr%' 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 = '1' 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 = '1' WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_category_default = '18' GROUP BY p.id_product ORDER BY p.id_product
Parameters:
[] |
4 | 0.52 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 = 1 AND fvl.id_lang = 1 AND p.id_product = 95 ORDER BY f.position
Parameters:
[] |
5 | 8.72 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 = 1 AND fvl.id_lang = 1 AND p.reference LIKE '5200-5205\_%' ORDER BY f.position
Parameters:
[] |
6 | 0.57 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 = 1 AND cl.meta_title = "Erreur combinée (non-linéarité + hystérésis) (% P.E.*)"
Parameters:
[] |
7 | 0.51 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 = 1 AND cl.meta_title = "Erreur de répétabilité (% P.E.*)"
Parameters:
[] |
8 | 0.48 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 = 1 AND cl.meta_title = "Fluage sur 30 min. (% P.E.*)"
Parameters:
[] |
9 | 0.47 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 = 1 AND cl.meta_title = "Retour à zéro (% P.E.*)"
Parameters:
[] |
10 | 0.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 = 1 AND cl.meta_title = "Température de référence (°C)"
Parameters:
[] |
11 | 0.65 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 = 1 AND cl.meta_title = "Température compensée (°C)"
Parameters:
[] |
12 | 0.65 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 = 1 AND cl.meta_title = "Température opérationnelle (°C)"
Parameters:
[] |
13 | 0.63 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 = 1 AND cl.meta_title = "Température de stockage (°C)"
Parameters:
[] |
14 | 0.60 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 = 1 AND cl.meta_title = "Dérive thermique de sensibilité (% P.E.*/10°C)"
Parameters:
[] |
15 | 0.57 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 = 1 AND cl.meta_title = "Dérive thermique du zéro (% P.E.*/10°C)"
Parameters:
[] |
16 | 0.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 = 1 AND cl.meta_title = "Plage du zéro initial (mV/V)"
Parameters:
[] |
17 | 0.57 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 = 1 AND cl.meta_title = "Résistance d'entrée (ohm(s))"
Parameters:
[] |
18 | 0.59 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 = 1 AND cl.meta_title = "Résistance de sortie (ohm(s))"
Parameters:
[] |
19 | 0.60 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 = 1 AND cl.meta_title = "Résistance d'isolement (50 V) (Mohm(s))"
Parameters:
[] |
20 | 0.54 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 = 1 AND cl.meta_title = "Tension d'alimentation de référence (VDC)"
Parameters:
[] |
21 | 0.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 = 1 AND cl.meta_title = "Tension d'alimentation nominale permise (VDC)"
Parameters:
[] |
22 | 0.54 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 = 1 AND cl.meta_title = "Charge maximale admissible (% P.E.*)"
Parameters:
[] |
23 | 0.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 = 1 AND cl.meta_title = "Charge de rupture (% P.E.*)"
Parameters:
[] |
24 | 0.17 ms |
SELECT * FROM pre2398_product_attachment pa INNER JOIN pre2398_attachment a ON a.id_attachment = pa.id_attachment WHERE pa.id_product = '95'
Parameters:
[] |
25 | 0.21 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 = '1' LEFT JOIN pre2398_pet_tab_lang ptl ON ptl.id_tab = ptc.id_tab AND ptl.id_lang = '1' WHERE ptcs.id_product = '95'
Parameters:
[] |
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.