Query Metrics
11
Database Queries
3
Different statements
169.26 ms
Query time
0
Invalid entities
25
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 13.18 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 | 45.20 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.show_in_menu = ? AND t0.website_id = ?
Parameters:
[ 1 19 ]
|
||||||||||||||||||||||||
| 3 | 13.10 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.id = ?
Parameters:
[
565
]
|
||||||||||||||||||||||||
| 4 | 12.12 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.id = ?
Parameters:
[
566
]
|
||||||||||||||||||||||||
| 5 | 12.43 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.id = ?
Parameters:
[
567
]
|
||||||||||||||||||||||||
| 6 | 12.74 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.id = ?
Parameters:
[
568
]
|
||||||||||||||||||||||||
| 7 | 12.48 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.id = ?
Parameters:
[
569
]
|
||||||||||||||||||||||||
| 8 | 12.23 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.id = ?
Parameters:
[
570
]
|
||||||||||||||||||||||||
| 9 | 12.06 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.id = ?
Parameters:
[
571
]
|
||||||||||||||||||||||||
| 10 | 11.79 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.id = ?
Parameters:
[
572
]
|
||||||||||||||||||||||||
| 11 | 11.93 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.id = ?
Parameters:
[
573
]
|
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 |
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. |