GET https://ophtalmologuetunisie.com/faq.html

Query Metrics

11 Database Queries
8 Different statements
157.14 ms Query time
0 Invalid entities
25 Managed entities

Queries

Group similar statements

# Time Info
1 11.86 ms
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:
[
  "ee594334c07c6dcef056"
]
2 11.97 ms
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 = ? AND t0.website_id = ? LIMIT 1
Parameters:
[
  "faq"
  19
]
3 11.26 ms
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:
[
  "ee594334c07c6dcef056"
]
4 11.48 ms
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:
[
  "ee594334c07c6dcef056"
  2
]
5 11.41 ms
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:
[
  "ee594334c07c6dcef056"
  3
]
6 29.39 ms
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:
[
  "ee594334c07c6dcef056"
  1
  1
  0
]
7 11.54 ms
SELECT t0.id AS id_1, t0.icons AS icons_2, t0.tag AS tag_3, t0.description AS description_4, t0.label AS label_5, t0.picture AS picture_6, t0.use_in_devis_form AS use_in_devis_form_7, t0.is_enabled AS is_enabled_8, t0.is_deleted AS is_deleted_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.website_id AS website_id_13, t0.parent_id AS parent_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__website_category t0 LEFT JOIN shared__page t15 ON t15.website_category_id = t0.id WHERE t0.id = ?
Parameters:
[
  142
]
8 11.43 ms
SELECT t0.id AS id_1, t0.icons AS icons_2, t0.tag AS tag_3, t0.description AS description_4, t0.label AS label_5, t0.picture AS picture_6, t0.use_in_devis_form AS use_in_devis_form_7, t0.is_enabled AS is_enabled_8, t0.is_deleted AS is_deleted_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.website_id AS website_id_13, t0.parent_id AS parent_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__website_category t0 LEFT JOIN shared__page t15 ON t15.website_category_id = t0.id WHERE t0.parent_id = ?
Parameters:
[
  142
]
9 22.68 ms
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.icons AS icons_3, t0.label AS label_4, t0.duree_de_service AS duree_de_service_5, t0.description AS description_6, t0.unit_price AS unit_price_7, t0.photo AS photo_8, t0.use_in_devis_form AS use_in_devis_form_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, t0.category_id AS category_id_15, t16.id AS id_17, t16.tag AS tag_18, t16.show_in_menu AS show_in_menu_19, t16.display_order AS display_order_20, t16.menu_title AS menu_title_21, t16.slug AS slug_22, t16.has_cover_image AS has_cover_image_23, t16.cover_image AS cover_image_24, t16.tab_title AS tab_title_25, t16.page_title AS page_title_26, t16.first_content AS first_content_27, t16.second_content AS second_content_28, t16.third_content AS third_content_29, t16.right_content AS right_content_30, t16.meta_title AS meta_title_31, t16.meta_description AS meta_description_32, t16.extra_import AS extra_import_33, t16.is_enabled AS is_enabled_34, t16.is_deleted AS is_deleted_35, t16.created_at AS created_at_36, t16.updated_at AS updated_at_37, t16.deleted_at AS deleted_at_38, t16.website_id AS website_id_39, t16.website_category_id AS website_category_id_40, t16.service_id AS service_id_41 FROM shared__service t0 LEFT JOIN shared__page t16 ON t16.service_id = t0.id WHERE t0.category_id = ?
Parameters:
[
  142
]
10 12.07 ms
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:
[
  "ee594334c07c6dcef056"
  "%social_media_%"
]
11 12.06 ms
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:
[
  "ee594334c07c6dcef056"
  "%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.

Managed Entities

default entity manager

Class Amount of managed objects
SmurfsSoftware\SeohubEntitiesBundle\Entity\Page 14
SmurfsSoftware\SeohubEntitiesBundle\Entity\Service 9
SmurfsSoftware\SeohubEntitiesBundle\Entity\Website 1
SmurfsSoftware\SeohubEntitiesBundle\Entity\WebsiteCategory 1