Query Metrics
4
Database Queries
4
Different statements
3.71 ms
Query time
0
Invalid entities
32
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.87 ms |
SELECT t0.cle AS cle_1, t0.valeur AS valeur_2 FROM home_setting t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 1.25 ms |
SELECT h0_.id AS id_0, h0_.type AS type_1, h0_.titre AS titre_2, h0_.sous_titre AS sous_titre_3, h0_.contenu AS contenu_4, h0_.image_url AS image_url_5, h0_.button_text AS button_text_6, h0_.button_url AS button_url_7, h0_.ordre AS ordre_8, h0_.actif AS actif_9 FROM home_section h0_ WHERE h0_.actif = 1 ORDER BY h0_.ordre ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
| 3 | 0.85 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.price AS price_5, p0_.image_url AS image_url_6, p0_.features AS features_7, p0_.rating AS rating_8, p0_.in_stock AS in_stock_9, p0_.published AS published_10, p0_.stock_quantity AS stock_quantity_11, p0_.stock_by_age AS stock_by_age_12, p0_.created_at AS created_at_13, c1_.id AS id_14, c1_.name AS name_15, c1_.slug AS slug_16, p0_.category_id AS category_id_17 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.published = ? AND c1_.slug = ? ORDER BY p0_.created_at DESC LIMIT 500
Parameters:
[ 1 "robe" ]
|
||||||||||||||||||||||||||||
| 4 | 0.74 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.price AS price_5, p0_.image_url AS image_url_6, p0_.features AS features_7, p0_.rating AS rating_8, p0_.in_stock AS in_stock_9, p0_.published AS published_10, p0_.stock_quantity AS stock_quantity_11, p0_.stock_by_age AS stock_by_age_12, p0_.created_at AS created_at_13, c1_.id AS id_14, c1_.name AS name_15, c1_.slug AS slug_16, p0_.category_id AS category_id_17 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id WHERE p0_.published = ? ORDER BY p0_.created_at DESC LIMIT 500
Parameters:
[
1
]
|
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\HomeSetting | 21 |
| App\Entity\Product | 6 |
| App\Entity\Category | 5 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\HomeSetting | No errors. |
| App\Entity\HomeSection | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Category | No errors. |