Query Metrics
9
Database Queries
8
Different statements
4.66 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.61 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.47 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.41 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.35 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 | 0.50 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/livescore"
]
|
| 6 | 0.60 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:
[
5
]
|
| 7 | 0.41 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:
[] |
| 8 | 0.37 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:
[
1
]
|
| 9 | 0.94 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:
[
225
]
|
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. |