Query Metrics

11 Database Queries
10 Different statements
1827.77 ms Query time
7 Invalid entities
32 Managed entities

Grouped Statements

Show all queries

Time Count Info
1640.80 ms
(89.77%)
2
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.caracteristiques AS caracteristiques_4, t0.price AS price_5, t0.url AS url_6, t0.compatibility AS compatibility_7, t0.miniature AS miniature_8, t0.openai AS openai_9, t0.file AS file_10, t0.removed AS removed_11, t0.id AS id_12, t0.active AS active_13, t0.date_created AS date_created_14, t0.date_updated AS date_updated_15, t0.manufacturer_id AS manufacturer_id_16, t0.main_category_id AS main_category_id_17, t0.user_id AS user_id_18 FROM modules t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "websource-indexnow-module-dindexation-sur-les-moteurs-de-recheche"
  1
]
113.80 ms
(6.23%)
1
SELECT t0.type AS type_1, t0.value AS value_2, t0.position AS position_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.module_id AS module_id_8 FROM medias t0 WHERE t0.module_id = ? ORDER BY t0.position ASC
Parameters:
[
  4185
]
22.00 ms
(1.20%)
1
SELECT t0.name AS name_1, t0.commentaire AS commentaire_2, t0.note AS note_3, t0.firstname AS firstname_4, t0.company AS company_5, t0.image AS image_6, t0.lastname AS lastname_7, t0.email AS email_8, t0.id AS id_9, t0.active AS active_10, t0.date_created AS date_created_11, t0.date_updated AS date_updated_12, t0.module_id AS module_id_13, t0.theme_id AS theme_id_14 FROM reviews t0 WHERE t0.module_id = ?
Parameters:
[
  4185
]
15.38 ms
(0.84%)
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 WHERE t0.id = ?
Parameters:
[
  98
]
11.20 ms
(0.61%)
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
]
7.02 ms
(0.38%)
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.id = ?
Parameters:
[
  118
]
6.55 ms
(0.36%)
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:
[
  "prestashop_module"
]
5.59 ms
(0.31%)
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
]
4.22 ms
(0.23%)
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
]
1.20 ms
(0.07%)
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
]

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\Categories 13
App\Entity\ThemesCategories 9
App\Entity\Medias 4
App\Entity\WebhostingsOffers 3
App\Entity\Modules 1
App\Entity\Manufacturer 1
App\Entity\User 1

Entities Mapping

Class Mapping 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\Manufacturer No errors.
App\Entity\Categories 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\Medias No errors.
App\Entity\Caracteristics No errors.
App\Entity\Reviews
  • The field App\Entity\Reviews#theme is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Themes#reviews does not contain the required 'mappedBy="theme"' attribute.
  • If association App\Entity\Reviews#theme is many-to-one, then the inversed side App\Entity\Themes#reviews has to be one-to-many.
App\Entity\CartDetails No errors.
App\Entity\Downloads 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\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.