Query Metrics
81
Database Queries
13
Different statements
489.35 ms
Query time
8
Invalid entities
1839
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
357.24 ms (73.00%) |
1 |
SELECT t0_.url AS url_0, t0_.name AS name_1, t0_.description AS description_2, t0_.nb_ventes AS nb_ventes_3, t0_.price AS price_4, t0_.link AS link_5, t0_.slug AS slug_6, t0_.cover AS cover_7, t0_.price_strike AS price_strike_8, t0_.file AS file_9, t0_.removed AS removed_10, t0_.id AS id_11, t0_.date_created AS date_created_12, t0_.date_updated AS date_updated_13, t0_.active AS active_14, t0_.author_id AS author_id_15, t0_.reviews_id AS reviews_id_16, t0_.user_id AS user_id_17, t0_.main_category_id AS main_category_id_18 FROM themes t0_ LEFT JOIN themes_themes_categories t2_ ON t0_.id = t2_.themes_id LEFT JOIN themes_categories t1_ ON t1_.id = t2_.themes_categories_id WHERE EXISTS (SELECT 1 FROM themes_themes_categories t3_ WHERE t3_.themes_id = t0_.id AND t3_.themes_categories_id IN (?)) AND t0_.active = ? AND t1_.active = ?
Parameters:
[ 43 1 1 ] |
|
72.17 ms (14.75%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.image AS image_3, t0.description AS description_4, t0.country AS country_5, t0.support_languages AS support_languages_6, t0.id AS id_7, t0.active AS active_8, t0.date_created AS date_created_9, t0.date_updated AS date_updated_10 FROM manufacturer t0
Parameters:
[] |
|
35.22 ms (7.20%) |
1 |
SELECT t0_.name AS name_0, t0_.slug AS slug_1, t0_.link AS link_2, t0_.description AS description_3, t0_.logo AS logo_4, t0_.id AS id_5, t0_.date_created AS date_created_6, t0_.date_updated AS date_updated_7, t0_.active AS active_8 FROM themes_authors t0_ WHERE t0_.active = ? AND t0_.name <> ? ORDER BY t0_.name ASC
Parameters:
[
1
""
]
|
|
17.22 ms (3.52%) |
66 |
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.parent_id = ?
Parameters:
[
119
]
|
|
3.33 ms (0.68%) |
1 |
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-26 00:01:22" ] |
|
1.12 ms (0.23%) |
4 |
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
]
|
|
0.49 ms (0.10%) |
1 |
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 ] |
|
0.48 ms (0.10%) |
1 |
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:
[
"themes"
]
|
|
0.46 ms (0.09%) |
1 |
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.parent_id = ? AND t0.active = ?
Parameters:
[ 43 1 ] |
|
0.44 ms (0.09%) |
1 |
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.slug = ? LIMIT 1
Parameters:
[
"template-kits"
]
|
|
0.41 ms (0.08%) |
1 |
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 ] |
|
0.39 ms (0.08%) |
1 |
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
]
|
|
0.37 ms (0.07%) |
1 |
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
]
|
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\ThemesAuthors | 917 |
| App\Entity\Themes | 728 |
| App\Entity\Manufacturer | 98 |
| App\Entity\Categories | 67 |
| App\Entity\ThemesCategories | 10 |
| App\Entity\BlogPosts | 10 |
| App\Entity\BlogCategories | 5 |
| App\Entity\WebhostingsOffers | 3 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Manufacturer | No errors. |
| App\Entity\Modules |
|
| App\Entity\ThemesAuthors | No errors. |
| App\Entity\Themes |
|
| App\Entity\ThemesCategories |
|
| App\Entity\Reviews |
|
| App\Entity\User |
|
| App\Entity\Categories | No errors. |
| App\Entity\ThemesFeatures | No errors. |
| App\Entity\ThemesCompatibilitiesValues | No errors. |
| App\Entity\ThemesTags | No errors. |
| App\Entity\Downloads | No errors. |
| App\Entity\BlogPosts |
|
| App\Entity\BlogCategories | No errors. |
| App\Entity\Tags | No errors. |
| 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 |
|