Query Metrics
293
Database Queries
11
Different statements
985.29 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
480.97 ms (48.81%) |
139 |
SELECT t0.id AS id_1, t0.number AS number_2, t0.department AS department_3, t0.video_id AS video_id_4, t0.author_id AS author_id_5, t0.organization_id AS organization_id_6 FROM video_author_organization t0 WHERE t0.video_id = ?
Parameters:
[
27
]
|
|
228.53 ms (23.19%) |
65 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.lastname AS lastname_4, t0.position AS position_5, t0.department AS department_6 FROM author t0 WHERE t0.id = ?
Parameters:
[
53
]
|
|
88.01 ms (8.93%) |
27 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.province_id AS province_id_3 FROM organization t0 WHERE t0.id = ?
Parameters:
[
13310
]
|
|
79.67 ms (8.09%) |
27 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.number AS number_3, t0.video_image AS video_image_4, t0.page_section_id AS page_section_id_5 FROM video_group t0 WHERE t0.id = ?
Parameters:
[
13
]
|
|
61.49 ms (6.24%) |
20 |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.text AS text_5, t0.number AS number_6, t0.type AS type_7, t0.has_background AS has_background_8, t0.menu_label AS menu_label_9, t0.edition_id AS edition_id_10 FROM page_section t0 WHERE t0.id = ?
Parameters:
[
15
]
|
|
20.52 ms (2.08%) |
8 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.name AS name_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.cover_image AS cover_image_8 FROM project t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
8.98 ms (0.91%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.clover_analytics_code AS clover_analytics_code_6, t0.contact_email AS contact_email_7, t0.admin_email AS admin_email_8, t0.number AS number_9, t0.privacy_policy AS privacy_policy_10, t0.legal_notice AS legal_notice_11, t0.cookies_policy AS cookies_policy_12, t0.url AS url_13, t0.domain AS domain_14, t0.author AS author_15, t0.google_analytics_codes AS google_analytics_codes_16, t0.favicon AS favicon_17 FROM settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
7.70 ms (0.78%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM year t0 WHERE t0.id = ?
Parameters:
[
5
]
|
|
3.33 ms (0.34%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.show_on_home AS show_on_home_4, t0.is_new AS is_new_5, t0.number AS number_6, t0.favicon AS favicon_7, t0.logo AS logo_8, t0.video_image AS video_image_9, t0.schedule AS schedule_10, t0.cover_image AS cover_image_11, t0.streaming_iframe AS streaming_iframe_12, t0.streaming_date AS streaming_date_13, t0.streaming_time AS streaming_time_14, t0.is_timer_shown AS is_timer_shown_15, t0.is_questions_button_shown AS is_questions_button_shown_16, t0.clover_project_number AS clover_project_number_17, t0.external_link AS external_link_18, t0.welcome_image AS welcome_image_19, t0.welcome_video_code AS welcome_video_code_20, t0.show_welcome_video AS show_welcome_video_21, t0.show_welcome_image AS show_welcome_image_22, t0.flip_iframe AS flip_iframe_23, t0.flip_doc AS flip_doc_24, t0.keywords AS keywords_25, t0.clover_analytics_code AS clover_analytics_code_26, t0.google_analytics_codes AS google_analytics_codes_27, t0.year_id AS year_id_28, t0.project_id AS project_id_29 FROM edition t0
Parameters:
[] |
|
3.10 ms (0.31%) |
1 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.document AS document_3, t0.number AS number_4, t0.title AS title_5, t0.vimeo_code AS vimeo_code_6, t0.description AS description_7, t0.is_marked AS is_marked_8, t0.video_group_id AS video_group_id_9 FROM video t0 ORDER BY t0.id ASC
Parameters:
[] |
|
3.00 ms (0.30%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM province t0 WHERE t0.id = ?
Parameters:
[
52
]
|
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\Settings | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Edition |
|
| App\Entity\Project |
|
| App\Entity\Video | No errors. |
| App\Entity\Year | No errors. |
| App\Entity\PageSection | No errors. |
| App\Entity\EditionBrand | No errors. |
| App\Entity\VideoGroup | No errors. |
| App\Entity\VideoAuthorOrganization | No errors. |
| App\Entity\Author | No errors. |
| App\Entity\Organization | No errors. |
| App\Entity\Province | No errors. |