GET https://all.white-sign.baks.dev/

Response
200 OK
IP
216.73.216.25
Profiled on
Token
e9a7d6

Query Metrics

2 Database Queries
2 Different statements
466.49 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 8.42 ms 
SELECT poster.id, poster.event AS event, event.title AS poster_title, event.sort AS poster_sort, event.start AS poster_start, event.ended AS poster_end, JSON_AGG(
                    DISTINCT JSONB_BUILD_OBJECT(
                        'texts', poster_text.text,
                        'positions', poster_text.position,
                        'css', poster_text.css
                    )
                ) AS poster_text, CONCAT ('/upload/poster_image' , '/', poster_image.name) AS poster_image_name, poster_image.ext AS poster_image_ext, poster_image.cdn AS poster_image_cdn FROM poster LEFT JOIN poster_profile project_profile ON project_profile.event = poster.event INNER JOIN poster_event event ON 
                    event.id = poster.event AND
                    event.device = ? AND
                    
                    DATE(event.start) <= CURRENT_DATE AND
                    (event.ended IS NULL OR DATE(event.ended) >= CURRENT_DATE)
                  LEFT JOIN poster_text poster_text ON poster_text.event = poster.event LEFT JOIN poster_image poster_image ON poster_image.event = poster.event WHERE (project_profile.value IS NULL OR project_profile.value = ?) GROUP BY poster.id, poster.event, event.title, event.sort, event.start, event.ended, poster_image.name, poster_image.ext, poster_image.cdn ORDER BY event.sort ASC
Parameters: 
[
  "pc"
  "019469c3-700f-76a9-9b34-ccde7b4e6f49"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 458.07 ms 
SELECT review.event AS review_event, review_modify.mod_date as update, review_product.value AS review_product, product_trans.name AS product_name, 
            JSON_AGG 
                (DISTINCT
                    CASE
                        WHEN product_photo.ext IS NOT NULL THEN
                            JSONB_BUILD_OBJECT
                            (
                                'product_img_root', product_photo.root,
                                'product_img', CONCAT ( '/upload/product_photo' , '/', product_photo.name),
                                'product_img_ext', product_photo.ext,
                                'product_img_cdn', product_photo.cdn
                            )
                        ELSE NULL
                END)
            AS product_images, category_info.url AS category_url, product_info.url as product_url, review_status.value AS review_status, review_text.value AS review_text, review_user.value AS review_user, review_rating.value AS review_rating_value, profile_personal.username as profile_username, review_name.value AS review_name, review_average_counter.value AS count FROM product_review review INNER JOIN product_review_event review_event ON review.event = review_event.id INNER JOIN product_review_modify review_modify ON review_modify.event = review_event.id INNER JOIN product_review_product review_product ON review_product.event = review_event.id INNER JOIN product_review_status review_status ON review_status.event = review_event.id AND review_status.value = ? INNER JOIN product_review_text review_text ON review_text.event = review_event.id INNER JOIN product_review_user review_user ON review_user.event = review_event.id LEFT JOIN product_review_rating review_rating ON review_rating.event = review_event.id LEFT JOIN product_review_name review_name ON review_name.event = review_event.id INNER JOIN product product ON product.id = review_product.value INNER JOIN product_review_average review_average ON review_average.product = review_product.value INNER JOIN product_event product_event ON product_event.id = product.event INNER JOIN product_trans product_trans ON product_trans.event = product_event.id LEFT JOIN product_photo product_photo ON product_photo.event = product_event.id AND product_photo.root = TRUE LEFT JOIN product_categories_product product_category ON product_category.event = product_event.id LEFT JOIN product_category category ON category.id = product_category.category LEFT JOIN product_info product_info ON product_info.product = product.id LEFT JOIN product_category_info category_info ON category_info.event = category.event INNER JOIN product_review_average_counter review_average_counter ON review_average_counter.product = review_average.product INNER JOIN users_profile_info profile_info ON profile_info.usr = review_user.value AND profile_info.active = true LEFT JOIN users_profile profile ON profile.id = profile_info.profile LEFT JOIN users_profile_personal profile_personal ON profile_personal.event = profile.event GROUP BY review.event, review_modify.mod_date, review_product.value, product_trans.name, category_info.url, product_info.url, review_status.value, review_text.value, review_user.value, review_rating.value, profile_personal.username, review_name.value, review_average_counter.value, review.id ORDER BY review.id DESC LIMIT 3
Parameters: 
[
  "active"
]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

No loaded entities.