GET https://test-front.smurfs-software.tech/Cardiologie/Coronarographie.html

Query Metrics

57 Database Queries
10 Different statements
54.35 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
23.24 ms
(42.77%)
23
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.label AS label_3, t0.duree_de_service AS duree_de_service_4, t0.description AS description_5, t0.unit_price AS unit_price_6, t0.photo AS photo_7, t0.use_in_devis_form AS use_in_devis_form_8, t0.is_enabled AS is_enabled_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.category_id AS category_id_14, t15.id AS id_16, t15.tag AS tag_17, t15.show_in_menu AS show_in_menu_18, t15.display_order AS display_order_19, t15.menu_title AS menu_title_20, t15.slug AS slug_21, t15.has_cover_image AS has_cover_image_22, t15.cover_image AS cover_image_23, t15.tab_title AS tab_title_24, t15.page_title AS page_title_25, t15.first_content AS first_content_26, t15.second_content AS second_content_27, t15.third_content AS third_content_28, t15.right_content AS right_content_29, t15.meta_title AS meta_title_30, t15.meta_description AS meta_description_31, t15.extra_import AS extra_import_32, t15.is_enabled AS is_enabled_33, t15.is_deleted AS is_deleted_34, t15.created_at AS created_at_35, t15.updated_at AS updated_at_36, t15.deleted_at AS deleted_at_37, t15.website_id AS website_id_38, t15.website_category_id AS website_category_id_39, t15.service_id AS service_id_40 FROM shared__service t0 LEFT JOIN shared__page t15 ON t15.service_id = t0.id WHERE t0.category_id = ?
Parameters:
[
  9
]
14.25 ms
(26.22%)
18
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.description AS description_3, t0.label AS label_4, t0.picture AS picture_5, t0.use_in_devis_form AS use_in_devis_form_6, t0.is_enabled AS is_enabled_7, t0.is_deleted AS is_deleted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.website_id AS website_id_12, t0.parent_id AS parent_id_13, t14.id AS id_15, t14.tag AS tag_16, t14.show_in_menu AS show_in_menu_17, t14.display_order AS display_order_18, t14.menu_title AS menu_title_19, t14.slug AS slug_20, t14.has_cover_image AS has_cover_image_21, t14.cover_image AS cover_image_22, t14.tab_title AS tab_title_23, t14.page_title AS page_title_24, t14.first_content AS first_content_25, t14.second_content AS second_content_26, t14.third_content AS third_content_27, t14.right_content AS right_content_28, t14.meta_title AS meta_title_29, t14.meta_description AS meta_description_30, t14.extra_import AS extra_import_31, t14.is_enabled AS is_enabled_32, t14.is_deleted AS is_deleted_33, t14.created_at AS created_at_34, t14.updated_at AS updated_at_35, t14.deleted_at AS deleted_at_36, t14.website_id AS website_id_37, t14.website_category_id AS website_category_id_38, t14.service_id AS service_id_39 FROM shared__website_category t0 LEFT JOIN shared__page t14 ON t14.website_category_id = t0.id WHERE t0.id = ?
Parameters:
[
  24
]
4.09 ms
(7.53%)
3
SELECT s0_.id AS id_0, s0_.tag AS tag_1, s0_.description AS description_2, s0_.value AS value_3, s0_.default_load AS default_load_4, s0_.is_enabled AS is_enabled_5, s0_.is_deleted AS is_deleted_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.deleted_at AS deleted_at_9, s0_.website_id AS website_id_10 FROM shared__website_configuration s0_ LEFT JOIN shared__website s1_ ON s0_.website_id = s1_.id WHERE s1_.token = ? AND s0_.default_load = ?
Parameters:
[
  "cca8af6a2d332cc16c25"
  2
]
3.03 ms
(5.58%)
3
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.description AS description_3, t0.label AS label_4, t0.picture AS picture_5, t0.use_in_devis_form AS use_in_devis_form_6, t0.is_enabled AS is_enabled_7, t0.is_deleted AS is_deleted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.website_id AS website_id_12, t0.parent_id AS parent_id_13, t14.id AS id_15, t14.tag AS tag_16, t14.show_in_menu AS show_in_menu_17, t14.display_order AS display_order_18, t14.menu_title AS menu_title_19, t14.slug AS slug_20, t14.has_cover_image AS has_cover_image_21, t14.cover_image AS cover_image_22, t14.tab_title AS tab_title_23, t14.page_title AS page_title_24, t14.first_content AS first_content_25, t14.second_content AS second_content_26, t14.third_content AS third_content_27, t14.right_content AS right_content_28, t14.meta_title AS meta_title_29, t14.meta_description AS meta_description_30, t14.extra_import AS extra_import_31, t14.is_enabled AS is_enabled_32, t14.is_deleted AS is_deleted_33, t14.created_at AS created_at_34, t14.updated_at AS updated_at_35, t14.deleted_at AS deleted_at_36, t14.website_id AS website_id_37, t14.website_category_id AS website_category_id_38, t14.service_id AS service_id_39 FROM shared__website_category t0 LEFT JOIN shared__page t14 ON t14.website_category_id = t0.id WHERE t0.parent_id = ?
Parameters:
[
  9
]
3.00 ms
(5.53%)
5
SELECT t0.id AS id_1, t0.description AS description_2, t0.value AS value_3, t0.code AS code_4, t0.is_enabled AS is_enabled_5, t0.is_deleted AS is_deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.website_id AS website_id_10 FROM shared__component t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "[DEVIS_BUTTON]"
]
1.82 ms
(3.35%)
1
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.show_in_menu AS show_in_menu_3, t0.display_order AS display_order_4, t0.menu_title AS menu_title_5, t0.slug AS slug_6, t0.has_cover_image AS has_cover_image_7, t0.cover_image AS cover_image_8, t0.tab_title AS tab_title_9, t0.page_title AS page_title_10, t0.first_content AS first_content_11, t0.second_content AS second_content_12, t0.third_content AS third_content_13, t0.right_content AS right_content_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.extra_import AS extra_import_17, t0.is_enabled AS is_enabled_18, t0.is_deleted AS is_deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.deleted_at AS deleted_at_22, t0.website_id AS website_id_23, t0.website_category_id AS website_category_id_24, t0.service_id AS service_id_25 FROM shared__page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "Coronarographie"
]
1.63 ms
(3.01%)
1
SELECT s0_.id AS id_0, s0_.tag AS tag_1, s0_.show_in_menu AS show_in_menu_2, s0_.display_order AS display_order_3, s0_.menu_title AS menu_title_4, s0_.slug AS slug_5, s0_.has_cover_image AS has_cover_image_6, s0_.cover_image AS cover_image_7, s0_.tab_title AS tab_title_8, s0_.page_title AS page_title_9, s0_.first_content AS first_content_10, s0_.second_content AS second_content_11, s0_.third_content AS third_content_12, s0_.right_content AS right_content_13, s0_.meta_title AS meta_title_14, s0_.meta_description AS meta_description_15, s0_.extra_import AS extra_import_16, s0_.is_enabled AS is_enabled_17, s0_.is_deleted AS is_deleted_18, s0_.created_at AS created_at_19, s0_.updated_at AS updated_at_20, s0_.deleted_at AS deleted_at_21, s0_.website_id AS website_id_22, s0_.website_category_id AS website_category_id_23, s0_.service_id AS service_id_24 FROM shared__page s0_ LEFT JOIN shared__website s1_ ON s0_.website_id = s1_.id WHERE s1_.token = ? AND s0_.show_in_menu = ? AND s0_.is_enabled = ? AND s0_.is_deleted = ? AND s0_.service_id IS NULL ORDER BY s0_.display_order ASC
Parameters:
[
  "cca8af6a2d332cc16c25"
  1
  1
  0
]
1.26 ms
(2.31%)
1
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.label AS label_3, t0.duree_de_service AS duree_de_service_4, t0.description AS description_5, t0.unit_price AS unit_price_6, t0.photo AS photo_7, t0.use_in_devis_form AS use_in_devis_form_8, t0.is_enabled AS is_enabled_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.category_id AS category_id_14, t15.id AS id_16, t15.tag AS tag_17, t15.show_in_menu AS show_in_menu_18, t15.display_order AS display_order_19, t15.menu_title AS menu_title_20, t15.slug AS slug_21, t15.has_cover_image AS has_cover_image_22, t15.cover_image AS cover_image_23, t15.tab_title AS tab_title_24, t15.page_title AS page_title_25, t15.first_content AS first_content_26, t15.second_content AS second_content_27, t15.third_content AS third_content_28, t15.right_content AS right_content_29, t15.meta_title AS meta_title_30, t15.meta_description AS meta_description_31, t15.extra_import AS extra_import_32, t15.is_enabled AS is_enabled_33, t15.is_deleted AS is_deleted_34, t15.created_at AS created_at_35, t15.updated_at AS updated_at_36, t15.deleted_at AS deleted_at_37, t15.website_id AS website_id_38, t15.website_category_id AS website_category_id_39, t15.service_id AS service_id_40 FROM shared__service t0 LEFT JOIN shared__page t15 ON t15.service_id = t0.id WHERE t0.id = ?
Parameters:
[
  71
]
1.02 ms
(1.88%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.token AS token_4, t0.url AS url_5, t0.logo AS logo_6, t0.phone AS phone_7, t0.dev_mod AS dev_mod_8, t0.address AS address_9, t0.is_enabled AS is_enabled_10, t0.is_deleted AS is_deleted_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14 FROM shared__website t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "cca8af6a2d332cc16c25"
]
0.99 ms
(1.82%)
1
SELECT s0_.id AS id_0, s0_.tag AS tag_1, s0_.description AS description_2, s0_.value AS value_3, s0_.default_load AS default_load_4, s0_.is_enabled AS is_enabled_5, s0_.is_deleted AS is_deleted_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.deleted_at AS deleted_at_9, s0_.website_id AS website_id_10 FROM shared__website_configuration s0_ LEFT JOIN shared__website s1_ ON s0_.website_id = s1_.id WHERE s1_.token = ? AND s0_.tag LIKE ? ORDER BY s0_.tag ASC
Parameters:
[
  "cca8af6a2d332cc16c25"
  "%social_media_%"
]

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.

Entities Mapping

Class Mapping errors
SmurfsSoftware\SeohubEntitiesBundle\Entity\Page No errors.
SmurfsSoftware\SeohubEntitiesBundle\Entity\Website
  • The association SmurfsSoftware\SeohubEntitiesBundle\Entity\Website#customers refers to the owning side field SmurfsSoftware\SeohubEntitiesBundle\Entity\User#commercial which does not exist.
SmurfsSoftware\SeohubEntitiesBundle\Entity\WebsiteCategory
  • The association SmurfsSoftware\SeohubEntitiesBundle\Entity\WebsiteCategory#prospects refers to the owning side field SmurfsSoftware\SeohubEntitiesBundle\Entity\Prospect#categoryy which does not exist.
SmurfsSoftware\SeohubEntitiesBundle\Entity\Service No errors.
SmurfsSoftware\SeohubEntitiesBundle\Entity\Prospect
  • The mappings SmurfsSoftware\SeohubEntitiesBundle\Entity\Prospect#prospectSource and SmurfsSoftware\SeohubEntitiesBundle\Entity\ProspectSource#prospects are inconsistent with each other.
  • The mappings SmurfsSoftware\SeohubEntitiesBundle\Entity\Prospect#category and SmurfsSoftware\SeohubEntitiesBundle\Entity\WebsiteCategory#prospects are inconsistent with each other.
SmurfsSoftware\SeohubEntitiesBundle\Entity\WebsiteConfiguration No errors.
SmurfsSoftware\SeohubEntitiesBundle\Entity\User
  • The association SmurfsSoftware\SeohubEntitiesBundle\Entity\User#prospects refers to the owning side field SmurfsSoftware\SeohubEntitiesBundle\Entity\User#commercial which does not exist.
SmurfsSoftware\SeohubEntitiesBundle\Entity\File No errors.
SmurfsSoftware\SeohubEntitiesBundle\Entity\Blog No errors.
SmurfsSoftware\SeohubEntitiesBundle\Entity\Component No errors.