Query Metrics
4
Database Queries
4
Different statements
24.97 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.external_id AS external_id_3, t0.code AS code_4, t0.post_id AS post_id_5, t0.lang_code AS lang_code_6, t0.is_top_category AS is_top_category_7, t0.is_accessory AS is_accessory_8, t0.slug AS slug_9 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"measurement-equipment"
]
|
| 2 | 3.81 ms |
SELECT c.name as categoryName, c.id as categoryId, sc.name as subcategoryName, sc.id as subcategoryId, (SELECT COUNT(p.id) FROM product p WHERE p.is_archived = 0 AND p.sub_category_id = sc.id) as productCount FROM category c INNER JOIN sub_category sc ON sc.category_id = c.id WHERE c.is_accessory = 1 AND c.lang_code = 'en' UNION SELECT 'Others' as categoryName, 0 as categoryId, sc.name as subcategoryName, sc.id as subcategoryId, (SELECT COUNT(p.id) FROM product p WHERE p.is_archived = 0 AND p.sub_category_id = sc.id) as productCount FROM sub_category sc WHERE sc.is_accessory = 1 AND sc.lang_code = 'en' ORDER BY categoryName, subcategoryName
Parameters:
[] |
| 3 | 18.59 ms |
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 = 'en' AND p.sub_category_id IN (143,144,282,152,153,234,218,155,202,157,159,161,162,163,164,248,167,168,169,171,172,174,175,176,177,342,191) AND p.is_archived = 0 ORDER BY p.id DESC;
Parameters:
[] |
| 4 | 1.42 ms |
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 = 'en' AND sc.id IN (143,143,143,143,164,234,143,143,342,176,172,155,282,152,144,248,176,162,144,234,163,163,163,163,163,163,163,163,163,163,163,163,163,172,167,167,143,176,163,218,167,163,163,143,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,164,164,164,163,163,163,163,163,163,163,163,163,163,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,164,177,143,143,143,143,143,144,202,191,191,191,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,176,175,174,172,172,171,169,169,168,168,167,164,164,164,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,163,161,159,159,157,155,153,153,153,144,144,144,144,143,143,143,143,143,143,143,143,143,143) 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\Category | No errors. |
| App\Entity\SubCategory | No errors. |
| App\Entity\Product | No errors. |