Query Metrics
4
Database Queries
4
Different statements
1910.63 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1893.08 ms (99.08%) |
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 ORDER BY s.name) as suppliers, GROUP_CONCAT(DISTINCT s.id_supplier ORDER BY s.id_supplier) as id_suppliers, GROUP_CONCAT(DISTINCT pattrl4.id_attribute ORDER BY pattrl4.id_attribute) AS id_attr_cap, GROUP_CONCAT(DISTINCT pattrl4.name ORDER BY pattrl4.name) AS attr_cap, GROUP_CONCAT(DISTINCT pattrl5.id_attribute ORDER BY pattrl5.id_attribute) AS id_attr_prec, GROUP_CONCAT(DISTINCT pattrl5.name ORDER BY pattrl5.name) AS attr_prec, GROUP_CONCAT(DISTINCT fp.id_feature_value ORDER BY fp.id_feature_value) AS id_feat FROM pre2398_product p INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = :category LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product AND l.id_lang = :id_lang 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 il1 ON il1.id_image = i1.id_image AND il1.id_lang = :id_lang LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.id_lang = :id_lang 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 :file_name 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 = :id_lang 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 = :id_lang LEFT JOIN pre2398_feature_product fp ON fp.id_product = p.id_product WHERE a.category = 'Datasheets' GROUP BY p.id_product ORDER BY p.id_product
Parameters:
[ "category" => 17 "id_lang" => 2 "file_name" => "%en%" ] |
15.73 ms (0.82%) |
1 |
SELECT DISTINCT al.name as name, lpa.id_attribute as id_attribute, lpa.id_attribute_group as id_attribute_group, COUNT(p.id_product) as product_count FROM pre2398_product p INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '17' AND p.active = 1 INNER JOIN pre2398_layered_product_attribute lpa ON lpa.id_product = p.id_product INNER JOIN pre2398_attribute_lang al ON al.id_attribute = lpa.id_attribute AND al.id_lang = '2' INNER JOIN pre2398_attribute a ON a.id_attribute = lpa.id_attribute WHERE al.id_lang = '2' GROUP BY lpa.id_attribute ORDER BY a.position
Parameters:
[] |
1.62 ms (0.09%) |
1 |
SELECT DISTINCT fvl.value AS value, fp.id_feature_value AS id_feature, COUNT(p.id_product) AS product_count FROM pre2398_product p INNER JOIN pre2398_category_product cp ON cp.id_product = p.id_product AND cp.id_category = '17' INNER JOIN pre2398_feature_product fp ON fp.id_product = p.id_product INNER JOIN pre2398_feature_value_lang fvl ON fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = '2' INNER JOIN pre2398_feature f ON f.id_feature = fp.id_feature AND f.position = 0 WHERE fvl.id_lang = '2' GROUP BY fp.id_feature_value ORDER BY fvl.value
Parameters:
[] |
0.20 ms (0.01%) |
1 |
SELECT * FROM pre2398_category_lang l INNER JOIN pre2398_category c ON l.id_category = c.id_category WHERE l.link_rewrite = 'tensiometers' AND l.id_lang = '2'
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.