GET http://sensy.adevo-host.net/fr/applications/mesure-de-force-et-de-couple/capteur-de-force-pour-l-industrie-automobile

Response
200 OK
IP
3.15.11.205
Profiled on
Token
a6ff26

Query Metrics

21 Database Queries
21 Different statements
54.09 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
18.70 ms
(34.58%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '17' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
16.56 ms
(30.62%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product IN (17,19,40,42,81) GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
8.69 ms
(16.06%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '19' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.52 ms
(2.81%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '40' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.19 ms
(2.19%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '42' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.04 ms
(1.93%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '81' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.00 ms
(1.85%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product IN (46,2910,2021,2492,2903) GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.86 ms
(1.59%) 		1 
SELECT * FROM pre2398_product p
                LEFT JOIN pre2398_product_lang l ON p.id_product = l.id_product
                LEFT JOIN pre2398_image i ON p.id_product = i.id_product
                WHERE l.id_lang = '1' AND p.id_category_default = '26'
                GROUP BY p.reference ORDER BY p.reference
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.63 ms
(1.16%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '46' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.60 ms
(1.12%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '2903' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.54 ms
(1.00%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '2910' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.54 ms
(1.00%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '2492' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.44 ms
(0.81%) 		1 
SELECT * FROM pre2398_cms_lang c WHERE c.link_rewrite = 'capteur-de-force-pour-l-industrie-automobile' AND c.id_lang = '1'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.38 ms
(0.71%) 		1 
SELECT * FROM pre2398_cms_category_lang cl
                WHERE cl.id_lang = '1' AND cl.link_rewrite = ''
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.32 ms
(0.59%) 		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_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 = '1'
                LEFT JOIN pre2398_image_lang il1 ON il1.id_image = i1.id_image AND il1.id_lang = '1'
                LEFT JOIN pre2398_image_lang il2 ON il2.id_image = i2.id_image AND il2.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'
                LEFT JOIN pre2398_category_lang cl ON cl.id_category = p.id_category_default AND cl.id_lang = '1'
                WHERE l.id_lang = '1' AND a.category = 'Datasheets' AND p.id_product = '2021' GROUP BY p.id_product ORDER BY p.id_product
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.19 ms
(0.36%) 		1 
SELECT L.link_rewrite AS link_rewrite_lang FROM `pre2398_cms_category_lang` AS C
                    INNER JOIN `pre2398_cms_category_lang` AS L ON L.id_cms_category = C.id_cms_category AND L.id_lang <> C.id_lang
                    WHERE C.link_rewrite = 'mesure-de-force-et-de-couple'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.19 ms
(0.35%) 		1 
SELECT * FROM pre2398_cms_lang c WHERE c.id_cms = 227 AND c.id_lang = '2'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.18 ms
(0.33%) 		1 
SELECT * FROM pre2398_cms_category_lang cl
                WHERE cl.id_lang = '1' AND cl.link_rewrite = 'mesure-de-force-et-de-couple'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(0.32%) 		1 
SELECT * FROM pre2398_cms_category_lang cl
                WHERE cl.id_lang = '1' AND cl.link_rewrite = 'fr'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(0.32%) 		1 
SELECT * FROM pre2398_cms_category_lang cl
                WHERE cl.id_lang = '1' AND cl.link_rewrite = 'capteur-de-force-pour-l-industrie-automobile'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.16 ms
(0.30%) 		1 
SELECT * FROM pre2398_cms_category_lang cl
                WHERE cl.id_lang = '1' AND cl.link_rewrite = 'applications'
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.