GET http://emuk-relaunch.dev-creatediv.de/en/stock

Response
200 OK
IP
216.73.216.38
Profiled on
Token
7162fe

Query Metrics

2 Database Queries
2 Different statements
35.92 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 32.40 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.is_archived = 0
            ORDER BY p.id DESC;
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 3.52 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 (358,120,287,143,143,143,143,116,354,351,348,268,346,118,118,164,234,344,143,143,342,340,339,338,262,260,260,332,119,260,135,116,119,119,119,326,326,319,319,319,120,120,119,244,135,135,304,318,135,308,247,306,306,306,306,304,105,294,119,119,183,288,287,176,172,155,282,152,144,268,120,118,118,268,113,257,264,120,262,240,260,104,257,248,247,244,240,176,120,119,258,162,144,234,139,139,139,139,139,232,163,163,163,163,163,163,163,163,163,163,163,163,163,172,167,167,143,176,226,204,120,163,218,150,224,214,212,167,163,163,143,210,135,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,186,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,120,121,206,120,177,143,143,143,143,143,144,202,119,197,195,195,192,191,191,191,187,186,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,150,149,144,144,144,144,143,143,143,143,143,143,143,143,143,143,139,137,132,124,123,121,121,121,120,120,120,118,118,117,113,110,110,106,105)
            ORDER BY categoryName, subcategoryName
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

Class Mapping errors
App\Entity\Product No errors.