Query Metrics
2
Database Queries
2
Different statements
45.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
41.70 ms (92.36%) |
1 |
SELECT p.id as id, REPLACE(REPLACE(TRIM(CONCAT_WS(' ', p.manufacturer, p.manufacture_type)), '''', '\u0027'), '"', '\u0022') as name, p.machine_number as machine_number, (SELECT CONCAT_WS(' / ', c.name, sc.name) FROM sub_category sc INNER JOIN category c ON c.id = sc.category_id WHERE sc.id = p.sub_category_id) as categoryName, (SELECT c.id FROM sub_category sc INNER JOIN category c ON c.id = sc.category_id WHERE sc.id = p.sub_category_id) as categoryId, p.sub_category_id as subCategoryId, IFNULL(p.manufacture_year, 'unknown') as manufacture_year, (SELECT w.location FROM warehouse w WHERE w.id = p.warehouse_id) as warehouse_name, IFNULL(p.country_of_origin, 'unknown') as country_of_origin, p.delivery_time as delivery_time, IF(p.price = 0, 'Price on Request', CONCAT_WS(' ', p.price, p.currency)) as price, (SELECT REPLACE(m.url, "https://emuk.de/", "") FROM media m WHERE m.product_id = p.id AND m.type = "PICTURE" LIMIT 1) as thumbnail_url, (SELECT m.description FROM media m WHERE m.product_id = p.id AND m.type = "PICTURE" LIMIT 1) as thumbnail_description, p.is_archived as is_archived, p.overview_video_link as videoOnFire, p.youtube_codes as youtubeCodes FROM product p INNER JOIN sub_category sc ON sc.id = p.sub_category_id INNER JOIN category c ON c.id = sc.category_id WHERE p.lang_code = 'de' AND p.is_archived = 0 ORDER BY p.id DESC;
Parameters:
[] |
|
3.45 ms (7.64%) |
1 |
SELECT c.name as categoryName, c.id as categoryId, c.slug as categorySlug, sc.name as subcategoryName, sc.id as subcategoryId, (SELECT COUNT(p.id) FROM product p WHERE p.sub_category_id = sc.id AND p.is_archived = 0) as productCount FROM sub_category sc INNER JOIN category c ON c.id = sc.category_id WHERE sc.lang_code = 'de' AND sc.id IN (357,95,355,286,24,24,24,24,94,353,350,347,267,345,91,91,343,233,43,24,24,341,337,336,335,261,254,254,331,92,254,92,92,92,94,325,325,7,315,315,315,95,95,92,317,299,243,7,7,7,307,245,305,305,305,305,299,72,293,92,92,65,286,285,48,46,27,281,55,41,95,267,91,91,267,82,253,263,95,261,239,70,254,253,246,245,243,239,48,95,92,255,55,50,233,22,22,22,22,22,231,42,42,42,42,42,42,42,42,42,42,42,42,42,30,30,27,24,48,225,203,95,222,42,215,11,213,211,42,42,30,24,209,7,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,68,42,42,42,42,42,42,42,42,42,42,43,43,43,42,42,42,42,42,42,42,42,42,42,95,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,43,88,95,205,49,24,24,24,24,24,55,92,201,95,95,95,91,91,88,88,88,87,86,83,83,82,80,75,75,75,73,72,68,57,55,55,55,55,51,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,46,43,43,43,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,40,39,38,38,37,37,35,32,32,32,31,31,30,29,27,27,24,24,24,24,24,24,24,24,24,24,22,21,17,14,11,9,5,5,3) ORDER BY categoryName, subcategoryName
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
| Class | Mapping errors |
|---|---|
| App\Entity\Product | No errors. |