Query Metrics
15
Database Queries
10
Different statements
13.61 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.86 ms |
SELECT t0.name AS name_1, t0.value AS value_2, t0.id AS id_3 FROM global_settings t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"Maintenance"
]
|
| 2 | 0.58 ms |
SELECT s0_.name AS name_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.id AS id_3, s0_.deleted_at AS deleted_at_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.brand_id AS brand_id_7 FROM season s0_ INNER JOIN brand b1_ ON s0_.brand_id = b1_.id WHERE b1_.base_information_slug = 'defaut' LIMIT 1
Parameters:
[] |
| 3 | 0.50 ms |
SELECT t0.common_password AS common_password_1, t0.slug AS slug_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.season_id AS season_id_7, t0.author_id AS author_id_8, t0.creator_id AS creator_id_9, t0.update_by_id AS update_by_id_10 FROM seminar t0 WHERE t0.season_id = ?
Parameters:
[
4
]
|
| 4 | 0.62 ms |
SELECT t0.lang AS lang_1, t0.asso_planner_active AS asso_planner_active_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.base_information_content AS base_information_content_7, t0.base_information_name AS base_information_name_8, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_9, t0.base_information_published_end AS base_information_published_end_10, t0.base_information_status AS base_information_status_11, t0.base_information_slug AS base_information_slug_12, t0.base_information_source AS base_information_source_13, t0.address_id AS address_id_14, t0.cms_content_id AS cms_content_id_15, t0.author_id AS author_id_16, t0.creator_id AS creator_id_17, t0.update_by_id AS update_by_id_18 FROM brand t0 WHERE t0.id = ?
Parameters:
[
8
]
|
| 5 | 2.03 ms |
SELECT s0_.relative_url AS relative_url_0, s0_.short_description AS short_description_1, s0_.id AS id_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.base_information_content AS base_information_content_6, s0_.base_information_name AS base_information_name_7, s0_.base_information_scheduled_published_date AS base_information_scheduled_published_date_8, s0_.base_information_published_end AS base_information_published_end_9, s0_.base_information_status AS base_information_status_10, s0_.base_information_slug AS base_information_slug_11, s0_.base_information_source AS base_information_source_12, s0_.parent_page_id AS parent_page_id_13, s0_.cms_content_id AS cms_content_id_14, s0_.author_id AS author_id_15, s0_.creator_id AS creator_id_16, s0_.update_by_id AS update_by_id_17 FROM static_page s0_ WHERE s0_.relative_url = ?
Parameters:
[
"/tutoriel"
]
|
| 6 | 2.12 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.base_information_content AS base_information_content_5, t0.base_information_name AS base_information_name_6, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_7, t0.base_information_published_end AS base_information_published_end_8, t0.base_information_status AS base_information_status_9, t0.base_information_slug AS base_information_slug_10, t0.base_information_source AS base_information_source_11, t0.author_id AS author_id_12, t0.creator_id AS creator_id_13, t0.update_by_id AS update_by_id_14 FROM animation_group t0 INNER JOIN static_page_animation_group ON t0.id = static_page_animation_group.animation_group_id WHERE static_page_animation_group.static_page_id = ?
Parameters:
[
1
]
|
| 7 | 1.84 ms |
SELECT t0.content AS content_1, t0.entity_agreg AS entity_agreg_2, t0.entity_id AS entity_id_3, t0.entity_type AS entity_type_4, t0.entity_sub_type AS entity_sub_type_5, t0.groupe AS groupe_6, t0.parent_content AS parent_content_7, t0.position AS position_8, t0.child AS child_9, t0.childs_number AS childs_number_10, t0.child_order AS child_order_11, t0.id AS id_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.author_id AS author_id_15, t0.creator_id AS creator_id_16, t0.update_by_id AS update_by_id_17 FROM animation_link t0 INNER JOIN animation_group_animation_link ON t0.id = animation_group_animation_link.animation_link_id WHERE animation_group_animation_link.animation_group_id = ?
Parameters:
[
1
]
|
| 8 | 0.52 ms |
SELECT t0.relative_url AS relative_url_1, t0.short_description AS short_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.base_information_content AS base_information_content_7, t0.base_information_name AS base_information_name_8, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_9, t0.base_information_published_end AS base_information_published_end_10, t0.base_information_status AS base_information_status_11, t0.base_information_slug AS base_information_slug_12, t0.base_information_source AS base_information_source_13, t0.parent_page_id AS parent_page_id_14, t0.cms_content_id AS cms_content_id_15, t0.author_id AS author_id_16, t0.creator_id AS creator_id_17, t0.update_by_id AS update_by_id_18 FROM static_page t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 9 | 0.46 ms |
SELECT t0.relative_url AS relative_url_1, t0.short_description AS short_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.base_information_content AS base_information_content_7, t0.base_information_name AS base_information_name_8, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_9, t0.base_information_published_end AS base_information_published_end_10, t0.base_information_status AS base_information_status_11, t0.base_information_slug AS base_information_slug_12, t0.base_information_source AS base_information_source_13, t0.parent_page_id AS parent_page_id_14, t0.cms_content_id AS cms_content_id_15, t0.author_id AS author_id_16, t0.creator_id AS creator_id_17, t0.update_by_id AS update_by_id_18 FROM static_page t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 10 | 0.42 ms |
SELECT t0.relative_url AS relative_url_1, t0.short_description AS short_description_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.base_information_content AS base_information_content_7, t0.base_information_name AS base_information_name_8, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_9, t0.base_information_published_end AS base_information_published_end_10, t0.base_information_status AS base_information_status_11, t0.base_information_slug AS base_information_slug_12, t0.base_information_source AS base_information_source_13, t0.parent_page_id AS parent_page_id_14, t0.cms_content_id AS cms_content_id_15, t0.author_id AS author_id_16, t0.creator_id AS creator_id_17, t0.update_by_id AS update_by_id_18 FROM static_page t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 11 | 0.55 ms |
SELECT s0_.name AS name_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.id AS id_3, s0_.deleted_at AS deleted_at_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.brand_id AS brand_id_7 FROM season s0_ INNER JOIN brand b1_ ON s0_.brand_id = b1_.id WHERE b1_.base_information_slug = 'defaut' LIMIT 1
Parameters:
[] |
| 12 | 1.22 ms |
SELECT t0.content AS content_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.author_id AS author_id_6, t0.creator_id AS creator_id_7, t0.update_by_id AS update_by_id_8 FROM cms_content t0 WHERE t0.id = ?
Parameters:
[
18
]
|
| 13 | 1.11 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_type AS image_type_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.author_id AS author_id_8, t0.creator_id AS creator_id_9, t0.update_by_id AS update_by_id_10 FROM image_entity t0 INNER JOIN static_page_image_entity ON t0.id = static_page_image_entity.image_entity_id WHERE static_page_image_entity.static_page_id = ?
Parameters:
[
3
]
|
| 14 | 0.43 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_type AS image_type_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.author_id AS author_id_8, t0.creator_id AS creator_id_9, t0.update_by_id AS update_by_id_10 FROM image_entity t0 INNER JOIN static_page_image_entity ON t0.id = static_page_image_entity.image_entity_id WHERE static_page_image_entity.static_page_id = ?
Parameters:
[
2
]
|
| 15 | 0.34 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image_name AS image_name_3, t0.image_size AS image_size_4, t0.image_type AS image_type_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7, t0.author_id AS author_id_8, t0.creator_id AS creator_id_9, t0.update_by_id AS update_by_id_10 FROM image_entity t0 INNER JOIN static_page_image_entity ON t0.id = static_page_image_entity.image_entity_id WHERE static_page_image_entity.static_page_id = ?
Parameters:
[
5
]
|
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 |
|---|---|
| App\Entity\Common\GlobalSettings | No errors. |
| App\Entity\Company\Season | No errors. |
| App\Entity\BaseInformation | No errors. |
| App\Entity\Company\Brand |
|
| App\Entity\Company\UserSeason | No errors. |
| App\Entity\User |
|
| App\Entity\Event\WorkshopGroup | No errors. |
| App\Entity\Event\Seminar | No errors. |
| App\Entity\Common\Address | No errors. |
| App\Entity\CMS\CmsContent | No errors. |
| App\Entity\User\ApiBrandUser |
|
| App\Entity\Company\BrandType | No errors. |
| App\Entity\Company\Contact | No errors. |
| App\Entity\Event\EventSuperClass | No errors. |
| App\Entity\Event\Event | No errors. |
| App\Entity\Event\EventGroup | No errors. |
| App\Entity\Event\Characteristic | No errors. |
| App\Entity\Event\EventCharacteristic | No errors. |
| App\Entity\Company\UserBrandRole | No errors. |
| App\Entity\CMS\CmsMainBlock | No errors. |
| App\Entity\Image\Images | No errors. |
| App\Entity\Image\ImageEntity | No errors. |
| App\Entity\StaticPage | No errors. |
| App\Entity\Common\AnimationGroup | No errors. |
| App\Entity\Common\AnimationLink | No errors. |