Query Metrics

36 Database Queries
12 Different statements
39.83 ms Query time
8 Invalid entities
75 Managed entities

Queries

Group similar statements

# Time Info
1 15.78 ms
SELECT t0.title AS title_1, t0.content AS content_2, t0.url AS url_3, t0.slug AS slug_4, t0.date_publication AS date_publication_5, t0.image AS image_6, t0.id AS id_7, t0.date_created AS date_created_8, t0.date_updated AS date_updated_9, t0.active AS active_10, t0.user_id AS user_id_11, t0.category_id AS category_id_12 FROM blog_posts t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "quest-ce-quune-sitemap-et-comment-la-soumettre-a-google"
  1
]
2 1.59 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:
[
  4998
]
3 4.21 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
Parameters:
[]
4 3.31 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-25 17:56:07"
]
5 0.55 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:
[
  "blog_list_category"
]
6 0.85 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
]
7 1.18 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
]
8 0.34 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
]
9 0.37 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
]
10 0.47 ms
SELECT t0.username AS username_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.last_login AS last_login_7, t0.password_request_at AS password_request_at_8, t0.token AS token_9, t0.last_activity AS last_activity_10, t0.newsletter AS newsletter_11, t0.avatar AS avatar_12, t0.poste AS poste_13, t0.bio AS bio_14, t0.url AS url_15, t0.linkedin AS linkedin_16, t0.twitter AS twitter_17, t0.works_for AS works_for_18, t0.stripe_account AS stripe_account_19, t0.id AS id_20, t0.date_created AS date_created_21, t0.date_updated AS date_updated_22, t0.active AS active_23, t0.customer_id AS customer_id_24 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 2.33 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  2
]
12 1.10 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  20
]
13 0.33 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  23
]
14 0.31 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  26
]
15 0.30 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  10
]
16 0.32 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  7
]
17 0.30 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  101
]
18 0.28 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  108
]
19 0.30 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  240
]
20 0.31 ms
SELECT t0.title AS title_1, t0.description AS description_2, t0.slug AS slug_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 FROM definitions t0 WHERE t0.id = ?
Parameters:
[
  48
]
21 0.34 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.parent_id = ?
Parameters:
[
  1
]
22 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.parent_id = ?
Parameters:
[
  2
]
23 0.32 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.parent_id = ?
Parameters:
[
  3
]
24 0.35 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.parent_id = ?
Parameters:
[
  4
]
25 0.35 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.parent_id = ?
Parameters:
[
  7
]
26 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.parent_id = ?
Parameters:
[
  13
]
27 0.32 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.parent_id = ?
Parameters:
[
  5
]
28 0.34 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.parent_id = ?
Parameters:
[
  6
]
29 0.31 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.parent_id = ?
Parameters:
[
  8
]
30 0.31 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.parent_id = ?
Parameters:
[
  9
]
31 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.parent_id = ?
Parameters:
[
  10
]
32 0.34 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.parent_id = ?
Parameters:
[
  11
]
33 0.32 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.parent_id = ?
Parameters:
[
  12
]
34 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.parent_id = ?
Parameters:
[
  14
]
35 0.36 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.parent_id = ?
Parameters:
[
  15
]
36 0.31 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.parent_id = ?
Parameters:
[
  16
]

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\BlogCategories 16
App\Entity\Categories 13
App\Entity\BlogPosts 11
App\Entity\Tags 11
App\Entity\Definitions 10
App\Entity\ThemesCategories 9
App\Entity\WebhostingsOffers 3
App\Entity\User 1
App\Entity\Customers 1

Entities Mapping

Class Mapping errors
App\Entity\BlogPosts
  • The association App\Entity\BlogPosts#user refers to the inverse side field App\Entity\User#blogPosts which does not exist.
App\Entity\BlogCategories No errors.
App\Entity\User
  • The association App\Entity\User#webhostings refers to the owning side field App\Entity\Webhostings#users which does not exist.
  • The association App\Entity\User#domains refers to the owning side field App\Entity\WebhostingsDomains#users which does not exist.
  • The field App\Entity\User#carts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart#user does not contain the required 'inversedBy="carts"' attribute.
App\Entity\Tags No errors.
App\Entity\Definitions No errors.
App\Entity\Categories No errors.
App\Entity\ThemesCategories
  • The association App\Entity\ThemesCategories#blogPosts refers to the owning side field App\Entity\Themes#category which does not exist.
App\Entity\WebhostingsOffers No errors.
App\Entity\Faq No errors.
App\Entity\Modules
  • The field App\Entity\Modules#cartDetails is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CartDetails#module does not contain the required 'inversedBy="cartDetails"' attribute.
App\Entity\Themes
  • The association App\Entity\Themes#reviews refers to the inverse side field App\Entity\Reviews#themes which does not exist.
App\Entity\Cart No errors.
App\Entity\Customers
  • The mappings App\Entity\Customers#customersContacts and App\Entity\CustomersContacts#customer are inconsistent with each other.
App\Entity\Guest No errors.
App\Entity\Webhostings
  • The mappings App\Entity\Webhostings#user and App\Entity\User#webhostings are inconsistent with each other.
App\Entity\WebhostingsDomains
  • The mappings App\Entity\WebhostingsDomains#user and App\Entity\User#domains are inconsistent with each other.
App\Entity\Downloads No errors.
App\Entity\Formation No errors.