Query Metrics
13
Database Queries
10
Different statements
176.94 ms
Query time
0
Invalid entities
26
Managed entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25.34 ms (14.32%) |
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:
[ "ee594334c07c6dcef056" 1 1 0 ] |
||||||||||||||||||||||||||||||
23.43 ms (13.24%) |
2 |
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 ] |
||||||||||||||||||||||||||||||
23.28 ms (13.16%) |
2 |
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_%" ] |
||||||||||||||||||||||||||||||
23.09 ms (13.05%) |
2 |
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"
]
|
||||||||||||||||||||||||||||||
22.51 ms (12.72%) |
1 |
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
]
|
||||||||||||||||||||||||||||||
12.28 ms (6.94%) |
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 = ? AND t0.website_id = ? LIMIT 1
Parameters:
[ "photocoagulation" 19 ]
|
||||||||||||||||||||||||||||||
12.03 ms (6.80%) |
1 |
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
]
|
||||||||||||||||||||||||||||||
11.95 ms (6.75%) |
1 |
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.id = ?
Parameters:
[
570
]
|
||||||||||||||||||||||||||||||
11.75 ms (6.64%) |
1 |
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
]
|
||||||||||||||||||||||||||||||
11.28 ms (6.38%) |
1 |
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 = ? AND t0.website_id = ? LIMIT 1
Parameters:
[ "[DEVIS_SLIDER]" 19 ] |
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 |
SmurfsSoftware\SeohubEntitiesBundle\Entity\Component | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
SmurfsSoftware\SeohubEntitiesBundle\Entity\Website | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\WebsiteConfiguration | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\WebsiteCategory | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\User | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\File | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\Page | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\Prospect | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\Blog | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\Service | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\Component | No errors. |