GET https://www.kejo-art.com/

Query Metrics

9 Database Queries
9 Different statements
8.65 ms Query time
0 Invalid entities
88 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.64 ms
(18.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5 FROM content t0
Parameters:
[]
1.33 ms
(15.39%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.google_id AS google_id_5 FROM referencement t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
1.24 ms
(14.35%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.ordre AS ordre_2 FROM real_category r0_ WHERE (SELECT COUNT(*) FROM realisation r1_ WHERE r1_.real_category_id = r0_.id) > 0
Parameters:
[]
0.94 ms
(10.81%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.ordre AS ordre_2 FROM category c0_ WHERE (SELECT COUNT(*) FROM product p1_ WHERE p1_.category_id = c0_.id) > 0
Parameters:
[]
0.84 ms
(9.75%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM misc t0
Parameters:
[]
0.77 ms
(8.87%)
1
SELECT t0.id AS id_1, t0.date_cart AS date_cart_2, t0.date_update AS date_update_3, t0.ordered AS ordered_4, t0.status AS status_5, t0.user_id AS user_id_6 FROM cart t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[]
0.76 ms
(8.81%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.reference AS reference_3, t0.image AS image_4, t0.stock AS stock_5, t0.active AS active_6, t7.id AS id_8, t7.description AS description_9, t7.prix AS prix_10, t7.image2 AS image2_11, t7.image3 AS image3_12, t7.video AS video_13, t7.product_id AS product_id_14, t0.category_id AS category_id_15 FROM product t0 LEFT JOIN product_details t7 ON t7.product_id = t0.id WHERE t0.active = ?
Parameters:
[
  1
]
0.73 ms
(8.40%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4 FROM slides t0
Parameters:
[]
0.40 ms
(4.65%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.video AS video_5, t0.real_category_id AS real_category_id_6 FROM realisation t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Realisation 45
App\Entity\Product 13
App\Entity\ProductDetails 13
App\Entity\RealCategory 4
App\Entity\Content 3
App\Entity\Slides 3
App\Entity\Category 3
App\Entity\Misc 3
App\Entity\Referencement 1

Entities Mapping

Class Mapping errors
App\Entity\Content No errors.
App\Entity\RealCategory No errors.
App\Entity\Realisation No errors.
App\Entity\Slides No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\ProductDetails No errors.
App\Entity\Misc No errors.
App\Entity\Referencement No errors.
App\Entity\Cart No errors.
App\Entity\User No errors.