Query Metrics
206
Database Queries
6
Different statements
83.17 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
62.36 ms (0.00%) |
158 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.dimensions AS dimensions_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM image t0 WHERE t0.id = ?
Parameters:
[
352
]
|
12.44 ms (0.00%) |
30 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.preview_font_size AS preview_font_size_3, t0.link AS link_4, t0.sub_title AS sub_title_5, t0.description AS description_6, t0.is_enabled AS is_enabled_7, t0.is_enabled2 AS is_enabled2_8, t0.quotation AS quotation_9, t0.position AS position_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.image_id AS image_id_13 FROM media_author t0 WHERE t0.id = ?
Parameters:
[
3
]
|
5.37 ms (0.00%) |
13 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.sequence AS sequence_3, t4.id AS id_5, t4.name AS name_6, t4.is_enabled AS is_enabled_7, t4.is_locked AS is_locked_8, t4.locked_text AS locked_text_9, t4.is_promoted_top AS is_promoted_top_10, t4.is_lock_comments AS is_lock_comments_11, t4.is_form_before AS is_form_before_12, t4.is_form_after AS is_form_after_13, t4.is_redirect AS is_redirect_14, t4.redirect_sec AS redirect_sec_15, t4.locked_to AS locked_to_16, t4.type AS type_17, t4.uuid AS uuid_18, t4.publication_date AS publication_date_19, t4.time_to_spend AS time_to_spend_20, t4.created_at AS created_at_21, t4.updated_at AS updated_at_22, t4.position AS position_23, t4.author_id AS author_id_24, t4.video_source_id AS video_source_id_25, t4.e_detailing_source_id AS e_detailing_source_id_26, t4.presentation_source_id AS presentation_source_id_27, t4.image_id AS image_id_28, t4.pdf_source_id AS pdf_source_id_29, t4.podcast_source_id AS podcast_source_id_30, t4.media_group_id AS media_group_id_31, t32.id AS id_33, t32.title AS title_34, t32.uuid AS uuid_35, t32.is_enabled AS is_enabled_36, t32.is_locked AS is_locked_37, t32.locked_to AS locked_to_38, t32.locked_text AS locked_text_39, t32.start_date AS start_date_40, t32.end_date AS end_date_41, t32.show_correct_answer_type AS show_correct_answer_type_42, t32.type AS type_43, t32.cost AS cost_44, t32.correct_cnt AS correct_cnt_45, t32.sub_title AS sub_title_46, t32.description AS description_47, t32.created_at AS created_at_48, t32.updated_at AS updated_at_49, t32.position AS position_50, t32.image_id AS image_id_51, t32.media_group_id AS media_group_id_52, t0.module_id AS module_id_53 FROM media_group t0 LEFT JOIN media t4 ON t4.media_group_id = t0.id LEFT JOIN survey t32 ON t32.media_group_id = t0.id WHERE t0.module_id = ?
Parameters:
[
13
]
|
1.86 ms (0.00%) |
3 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.short_name AS short_name_2, m0_.is_enabled AS is_enabled_3, m0_.is_locked AS is_locked_4, m0_.position AS position_5, m0_.uuid AS uuid_6, m0_.description AS description_7, m0_.created_at AS created_at_8, m0_.updated_at AS updated_at_9, m0_.icon_id AS icon_id_10 FROM module m0_ INNER JOIN media_group m1_ ON m0_.id = m1_.module_id INNER JOIN media m2_ ON m1_.id = m2_.media_group_id WHERE m0_.is_enabled = 1 AND m2_.is_enabled = 1 AND m2_.is_locked = 0 GROUP BY m0_.id ORDER BY m0_.position ASC
Parameters:
[] |
0.59 ms (0.00%) |
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_enabled AS is_enabled_2, m0_.is_locked AS is_locked_3, m0_.locked_text AS locked_text_4, m0_.is_promoted_top AS is_promoted_top_5, m0_.is_lock_comments AS is_lock_comments_6, m0_.is_form_before AS is_form_before_7, m0_.is_form_after AS is_form_after_8, m0_.is_redirect AS is_redirect_9, m0_.redirect_sec AS redirect_sec_10, m0_.locked_to AS locked_to_11, m0_.type AS type_12, m0_.uuid AS uuid_13, m0_.publication_date AS publication_date_14, m0_.time_to_spend AS time_to_spend_15, m0_.created_at AS created_at_16, m0_.updated_at AS updated_at_17, m0_.position AS position_18, m0_.author_id AS author_id_19, m0_.video_source_id AS video_source_id_20, m0_.e_detailing_source_id AS e_detailing_source_id_21, m0_.presentation_source_id AS presentation_source_id_22, m0_.image_id AS image_id_23, m0_.pdf_source_id AS pdf_source_id_24, m0_.podcast_source_id AS podcast_source_id_25, m0_.media_group_id AS media_group_id_26 FROM media m0_ WHERE m0_.is_enabled = ? AND m0_.is_locked = ? AND m0_.media_group_id IS NOT NULL AND m0_.id NOT IN (?) ORDER BY m0_.id DESC LIMIT 3
Parameters:
[ 1 0 [ 215 ] ] |
0.55 ms (0.00%) |
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.is_enabled AS is_enabled_2, m0_.is_locked AS is_locked_3, m0_.locked_text AS locked_text_4, m0_.is_promoted_top AS is_promoted_top_5, m0_.is_lock_comments AS is_lock_comments_6, m0_.is_form_before AS is_form_before_7, m0_.is_form_after AS is_form_after_8, m0_.is_redirect AS is_redirect_9, m0_.redirect_sec AS redirect_sec_10, m0_.locked_to AS locked_to_11, m0_.type AS type_12, m0_.uuid AS uuid_13, m0_.publication_date AS publication_date_14, m0_.time_to_spend AS time_to_spend_15, m0_.created_at AS created_at_16, m0_.updated_at AS updated_at_17, m0_.position AS position_18, m0_.author_id AS author_id_19, m0_.video_source_id AS video_source_id_20, m0_.e_detailing_source_id AS e_detailing_source_id_21, m0_.presentation_source_id AS presentation_source_id_22, m0_.image_id AS image_id_23, m0_.pdf_source_id AS pdf_source_id_24, m0_.podcast_source_id AS podcast_source_id_25, m0_.media_group_id AS media_group_id_26 FROM media m0_ WHERE m0_.is_enabled = ? AND m0_.is_locked = ? ORDER BY m0_.id DESC LIMIT 1
Parameters:
[ 1 0 ] |
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\Media |
|
App\Entity\Module | No errors. |
App\Entity\MediaTimeSpentAction | No errors. |
App\Entity\FavoriteUsersMedia | No errors. |
App\Entity\MediaGroup |
|
App\Entity\Image | No errors. |
App\Entity\MediaAuthor | No errors. |
App\Entity\VideoMediaSource | No errors. |
App\Entity\EDetailingMediaSource | No errors. |
App\Entity\PresentationMediaSource | No errors. |
App\Entity\PdfMediaSource | No errors. |
App\Entity\PodcastMediaSource | No errors. |
App\Entity\Event | No errors. |
App\Entity\MediaViewEvent | No errors. |
App\Entity\MediaLikeEvent | No errors. |
App\Entity\UserGroup | No errors. |
App\Entity\MediaTag | No errors. |
App\Entity\Survey | No errors. |