GET https://jonathan-websource.websrc.fr/definitions/smo

Query Metrics

19 Database Queries
12 Different statements
42.28 ms Query time
7 Invalid entities
371 Managed entities

Queries

Group similar statements

# Time Info
1 3.81 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:
[
  "smo"
]
2 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 WHERE t0.definition_id = ?
Parameters:
[
  110
]
3 8.21 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:
[
  368
  1
  "2025-10-26 02:22:24"
]
4 3.81 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 3.70 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 02:22:24"
]
6 0.53 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.39 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 0.43 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 0.39 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.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
]
11 4.64 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 1.61 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.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.id = ?
Parameters:
[
  7
]
14 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.id = ?
Parameters:
[
  1
]
15 2.79 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:
[
  4878
]
16 2.00 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:
[
  4848
]
17 1.88 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:
[
  4767
]
18 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 blog_categories t0 WHERE t0.id = ?
Parameters:
[
  6
]
19 2.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:
[
  4175
]

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 14
App\Entity\Categories 13
App\Entity\Tags 12
App\Entity\ThemesCategories 9
App\Entity\BlogCategories 6
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.