Query Metrics
55
Database Queries
10
Different statements
113.29 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54.47 ms (48.08%) |
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.85 ms (13.11%) |
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 ] |
||||||||||||||||||||||||||||||
14.66 ms (12.94%) |
3 |
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]"
]
|
||||||||||||||||||||||||||||||
14.47 ms (12.77%) |
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.72 ms (4.16%) |
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_%" ] |
||||||||||||||||||||||||||||||
3.24 ms (2.86%) |
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
]
|
||||||||||||||||||||||||||||||
2.30 ms (2.03%) |
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:
[
"Liposuccion-Tunisie"
]
|
||||||||||||||||||||||||||||||
2.20 ms (1.94%) |
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.40 ms (1.24%) |
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:
[
17
]
|
||||||||||||||||||||||||||||||
0.98 ms (0.87%) |
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"
]
|
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 |
|
SmurfsSoftware\SeohubEntitiesBundle\Entity\WebsiteCategory |
|
SmurfsSoftware\SeohubEntitiesBundle\Entity\Service | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\Prospect |
|
SmurfsSoftware\SeohubEntitiesBundle\Entity\WebsiteConfiguration | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\User |
|
SmurfsSoftware\SeohubEntitiesBundle\Entity\File | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\Blog | No errors. |
SmurfsSoftware\SeohubEntitiesBundle\Entity\Component | No errors. |