GET https://jonathan-websource.websrc.fr/definitions/referencement-payant

Query Metrics

50 Database Queries
12 Different statements
105.97 ms Query time
7 Invalid entities
408 Managed entities

Queries

Group similar statements

# Time Info
1 5.66 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.slug = ? LIMIT 1
Parameters:
[
  "referencement-payant"
]
2 1.55 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 WHERE t0.definition_id = ?
Parameters:
[
  102
]
3 4.34 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 EXISTS (SELECT 1 FROM blog_posts_tags b2_ WHERE b2_.blog_posts_id = b0_.id AND b2_.tags_id IN (?)) AND b0_.active = ? AND b0_.date_publication <= ? ORDER BY b0_.id DESC
Parameters:
[
  337
  1
  "2025-10-26 07:00:40"
]
4 3.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.active = ?
Parameters:
[
  1
]
5 8.05 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-26 07:00:40"
]
6 6.03 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:
[
  "definitions_word"
]
7 0.42 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
]
8 1.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 themes_categories t0 WHERE t0.active = ? AND t0.parent_id = ?
Parameters:
[
  1
  2
]
9 6.60 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
]
10 0.39 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
]
11 3.58 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
]
12 2.93 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 1.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:
[
  7
]
14 2.63 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
]
15 2.60 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:
[
  5128
]
16 2.23 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:
[
  5104
]
17 1.29 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:
[
  5038
]
18 2.46 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:
[
  4988
]
19 1.37 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:
[
  4804
]
20 1.57 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:
[
  4748
]
21 2.33 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:
[
  4683
]
22 1.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:
[
  4669
]
23 1.33 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:
[
  4663
]
24 1.35 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:
[
  4659
]
25 1.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:
[
  4657
]
26 1.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:
[
  4641
]
27 1.43 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:
[
  4617
]
28 1.50 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:
[
  4585
]
29 0.68 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:
[
  4574
]
30 1.17 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:
[
  4555
]
31 1.97 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:
[
  4477
]
32 4.96 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:
[
  4474
]
33 3.34 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:
[
  4468
]
34 0.44 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:
[
  4466
]
35 0.44 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:
[
  4449
]
36 3.80 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:
[
  4448
]
37 0.47 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:
[
  4426
]
38 0.75 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:
[
  4425
]
39 2.46 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:
[
  4418
]
40 0.68 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:
[
  4417
]
41 1.30 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:
[
  4409
]
42 1.35 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:
[
  4400
]
43 1.38 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:
[
  4395
]
44 0.44 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:
[
  4374
]
45 1.19 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:
[
  4370
]
46 1.42 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:
[
  4358
]
47 1.35 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:
[
  4343
]
48 1.41 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:
[
  4335
]
49 1.43 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:
[
  4304
]
50 1.41 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:
[
  4299
]

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\Definitions 313
App\Entity\BlogPosts 46
App\Entity\Tags 18
App\Entity\Categories 13
App\Entity\ThemesCategories 9
App\Entity\BlogCategories 5
App\Entity\WebhostingsOffers 3
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Definitions No errors.
App\Entity\Tags No 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\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.