Query Metrics
6
Database Queries
6
Different statements
63.17 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 44.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content AS content_4, t0.isEnabled AS isEnabled_5, t0.createdAt AS createdAt_6, t0.lastUpdate AS lastUpdate_7, t0.btn_text AS btn_text_8, t0.btn_link AS btn_link_9, t0.color AS color_10, t0.tasks AS tasks_11, t0.resume AS resume_12, t0.missions AS missions_13, t0.benefits AS benefits_14, t0.slug AS slug_15, t0.time AS time_16, t0.cost AS cost_17, t0.department AS department_18, t0.banner_id AS banner_id_19, t0.icon_id AS icon_id_20, t0.category_id AS category_id_21, t22.id AS id_23, t22.label AS label_24, t22.description AS description_25, t22.slug AS slug_26, t22.isEnabled AS isEnabled_27 FROM services t0 LEFT JOIN services_categories t22 ON t0.category_id = t22.id WHERE t0.id = ?
Parameters:
[
"1"
]
|
| 2 | 2.25 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.content AS content_3, s0_.isEnabled AS isEnabled_4, s0_.createdAt AS createdAt_5, s0_.lastUpdate AS lastUpdate_6, s0_.btn_text AS btn_text_7, s0_.btn_link AS btn_link_8, s0_.color AS color_9, s0_.tasks AS tasks_10, s0_.resume AS resume_11, s0_.missions AS missions_12, s0_.benefits AS benefits_13, s0_.slug AS slug_14, s0_.time AS time_15, s0_.cost AS cost_16, s0_.department AS department_17, s0_.banner_id AS banner_id_18, s0_.icon_id AS icon_id_19, s0_.category_id AS category_id_20 FROM services s0_ LEFT JOIN services_categories s1_ ON s0_.category_id = s1_.id WHERE s0_.id <> 1 AND s1_.id = 1 AND s0_.isEnabled = 1
Parameters:
[] |
| 3 | 5.68 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.isEnabled AS isEnabled_5, t0.banner_id AS banner_id_6 FROM articles_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
1
]
|
| 4 | 3.71 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
1
]
|
| 5 | 3.01 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM resources_categories t0
Parameters:
[] |
| 6 | 4.23 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM videos_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
1
]
|
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\Services | No errors. |
| App\Entity\OSFile | No errors. |
| App\Entity\Picture | No errors. |
| App\Entity\ServicesCategories | No errors. |
| App\Entity\ArticlesCategories | No errors. |
| App\Entity\OSEntity | No errors. |
| App\Entity\Articles | No errors. |
| App\Entity\OpportunitiesCategories | No errors. |
| App\Entity\ResourcesCategories | No errors. |
| App\Entity\VideosCategories | No errors. |
| App\Entity\ArticlesTypes | No errors. |
| App\Entity\Albums | No errors. |
| App\Entity\Biblios | No errors. |
| App\Entity\File | No errors. |
| App\Entity\Tags | No errors. |
| App\Entity\Sectors | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\Resources | No errors. |
| App\Entity\Subscribers | No errors. |
| App\Entity\Profiles | No errors. |