Query Metrics
21
Database Queries
9
Different statements
194.64 ms
Query time
8
Invalid entities
128
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.02 ms |
SELECT r0_.name AS name_0, r0_.commentaire AS commentaire_1, r0_.note AS note_2, r0_.firstname AS firstname_3, r0_.company AS company_4, r0_.image AS image_5, r0_.lastname AS lastname_6, r0_.email AS email_7, r0_.id AS id_8, r0_.active AS active_9, r0_.date_created AS date_created_10, r0_.date_updated AS date_updated_11, r0_.module_id AS module_id_12, r0_.theme_id AS theme_id_13 FROM reviews r0_ WHERE r0_.name IS NULL AND r0_.active = ? ORDER BY RAND() ASC
Parameters:
[
1
]
|
| 2 | 6.88 ms |
SELECT b0_.title AS title_0, b0_.content AS content_1, b0_.url AS url_2, b0_.slug AS slug_3, b0_.date_publication AS date_publication_4, b0_.image AS image_5, b0_.id AS id_6, b0_.date_created AS date_created_7, b0_.date_updated AS date_updated_8, b0_.active AS active_9, b0_.user_id AS user_id_10, b0_.category_id AS category_id_11 FROM blog_posts b0_ INNER JOIN blog_categories b1_ ON (b0_.category_id = b1_.id) WHERE b0_.active = ? AND b0_.date_publication <= ? ORDER BY b0_.date_publication DESC LIMIT 10
Parameters:
[ 1 "2025-10-24 17:12:26" ] |
| 3 | 12.44 ms |
SELECT t0.question AS question_1, t0.answer AS answer_2, t0.routename AS routename_3, t0.id AS id_4, t0.date_created AS date_created_5, t0.date_updated AS date_updated_6 FROM faq t0 WHERE t0.routename = ?
Parameters:
[
"homepage"
]
|
| 4 | 13.73 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description_short AS description_short_3, t0.id AS id_4, t0.active AS active_5, t0.date_created AS date_created_6, t0.date_updated AS date_updated_7, t0.parent_id AS parent_id_8 FROM categories t0 WHERE t0.active = ? AND t0.parent_id = ?
Parameters:
[ 1 118 ] |
| 5 | 20.13 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.color AS color_3, t0.id AS id_4, t0.date_created AS date_created_5, t0.date_updated AS date_updated_6, t0.active AS active_7, t0.parent_id AS parent_id_8 FROM themes_categories t0 WHERE t0.active = ? AND t0.parent_id = ?
Parameters:
[ 1 2 ] |
| 6 | 65.20 ms |
SELECT t0.install AS install_1, t0.config AS config_2, t0.express AS express_3, t0.status AS status_4, t0.id AS id_5, t0.date_created AS date_created_6, t0.date_updated AS date_updated_7, t0.customer_id AS customer_id_8, t0.user_id AS user_id_9, t0.guest_id AS guest_id_10 FROM cart t0 WHERE t0.guest_id = ? LIMIT 1
Parameters:
[
null
]
|
| 7 | 44.56 ms |
SELECT t0.name AS name_1, t0.io AS io_2, t0.ram AS ram_3, t0.storage AS storage_4, t0.price AS price_5, t0.strike_price AS strike_price_6, t0.market_price AS market_price_7, t0.headline AS headline_8, t0.stars AS stars_9, t0.id AS id_10, t0.active AS active_11 FROM webhostings_offers t0 WHERE t0.active = ? ORDER BY t0.id ASC
Parameters:
[
1
]
|
| 8 | 3.24 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.color AS color_3, t0.id AS id_4, t0.date_created AS date_created_5, t0.date_updated AS date_updated_6, t0.active AS active_7, t0.parent_id AS parent_id_8 FROM blog_categories t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 9 | 0.52 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5372
]
|
| 10 | 0.48 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5371
]
|
| 11 | 0.48 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5370
]
|
| 12 | 4.08 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.color AS color_3, t0.id AS id_4, t0.date_created AS date_created_5, t0.date_updated AS date_updated_6, t0.active AS active_7, t0.parent_id AS parent_id_8 FROM blog_categories t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 13 | 0.54 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5369
]
|
| 14 | 0.33 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.color AS color_3, t0.id AS id_4, t0.date_created AS date_created_5, t0.date_updated AS date_updated_6, t0.active AS active_7, t0.parent_id AS parent_id_8 FROM blog_categories t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 15 | 0.49 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5368
]
|
| 16 | 3.76 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5367
]
|
| 17 | 0.58 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5366
]
|
| 18 | 4.85 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5365
]
|
| 19 | 1.90 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5364
]
|
| 20 | 0.38 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.color AS color_3, t0.id AS id_4, t0.date_created AS date_created_5, t0.date_updated AS date_updated_6, t0.active AS active_7, t0.parent_id AS parent_id_8 FROM blog_categories t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 21 | 7.06 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.date_created AS date_created_4, t0.date_updated AS date_updated_5, t0.active AS active_6, t0.definition_id AS definition_id_7 FROM tags t0 INNER JOIN blog_posts_tags ON t0.id = blog_posts_tags.tags_id WHERE blog_posts_tags.blog_posts_id = ?
Parameters:
[
5363
]
|
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\Reviews | 56 |
| App\Entity\Tags | 14 |
| App\Entity\Categories | 13 |
| App\Entity\Definitions | 12 |
| App\Entity\BlogPosts | 10 |
| App\Entity\ThemesCategories | 9 |
| App\Entity\BlogCategories | 5 |
| App\Entity\Faq | 5 |
| App\Entity\WebhostingsOffers | 3 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Reviews |
|
| App\Entity\Modules |
|
| App\Entity\Themes |
|
| App\Entity\BlogPosts |
|
| App\Entity\BlogCategories | No errors. |
| App\Entity\User |
|
| App\Entity\Tags | No errors. |
| App\Entity\Categories | No errors. |
| App\Entity\ThemesCategories |
|
| App\Entity\WebhostingsOffers | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Customers |
|
| App\Entity\Guest | No errors. |
| App\Entity\Webhostings |
|
| App\Entity\Definitions | No errors. |