Query Metrics
6
Database Queries
6
Different statements
33.59 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 14.50 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.subtitle AS subtitle_3, t0.preview AS preview_4, t0.text AS text_5, t0.published AS published_6, t0.publish_at AS publish_at_7, t0.pinned AS pinned_8, t0.deleted AS deleted_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12, t0.owner_uuid AS owner_uuid_13, t0.owner_active AS owner_active_14, t0.owner_deleted AS owner_deleted_15, t0.interval_from AS interval_from_16, t0.interval_to AS interval_to_17, t0.image_id AS image_id_18, t0.type_id AS type_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21 FROM news t0 WHERE t0.id = ?
Parameters:
[
"194"
]
|
| 2 | 5.75 ms |
SELECT n0_.id AS id_0, n0_.caption AS caption_1, n0_.subtitle AS subtitle_2, n0_.preview AS preview_3, n0_.text AS text_4, n0_.published AS published_5, n0_.publish_at AS publish_at_6, n0_.pinned AS pinned_7, n0_.deleted AS deleted_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.uuid AS uuid_11, n0_.owner_uuid AS owner_uuid_12, n0_.owner_active AS owner_active_13, n0_.owner_deleted AS owner_deleted_14, n0_.interval_from AS interval_from_15, n0_.interval_to AS interval_to_16, n1_.id AS id_17, n1_.caption AS caption_18, n1_.subtitle AS subtitle_19, n1_.preview AS preview_20, n1_.text AS text_21, n1_.locale AS locale_22, f2_.id AS id_23, f2_.public AS public_24, f2_.created_at AS created_at_25, f2_.data_name AS data_name_26, f2_.data_original_name AS data_original_name_27, f2_.data_mime_type AS data_mime_type_28, f2_.data_dimensions AS data_dimensions_29, f2_.data_size AS data_size_30, f2_.owner_uuid AS owner_uuid_31, f2_.owner_active AS owner_active_32, f2_.owner_deleted AS owner_deleted_33, n3_.id AS id_34, n3_.caption AS caption_35, n3_.slug AS slug_36, n3_.type AS type_37, n3_.deleted AS deleted_38, n3_.active AS active_39, n0_.image_id AS image_id_40, n0_.type_id AS type_id_41, n0_.created_by_id AS created_by_id_42, n0_.updated_by_id AS updated_by_id_43, n1_.translatable_id AS translatable_id_44, f2_.created_by_id AS created_by_id_45 FROM news n0_ LEFT JOIN news_translation n1_ ON n0_.id = n1_.translatable_id LEFT JOIN files f2_ ON n0_.image_id = f2_.id LEFT JOIN news_type n3_ ON n0_.type_id = n3_.id WHERE n0_.deleted = 0 AND n0_.published = 1 AND n0_.owner_active = 1 AND n3_.type = ? AND n0_.publish_at <= ? AND n1_.locale = ? AND n0_.id NOT IN (?) ORDER BY n0_.pinned DESC, n0_.publish_at DESC, n0_.id DESC LIMIT 6
Parameters:
[ "news" "2024-11-21 11:53:56" "ru" 194 ] |
| 3 | 6.09 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.subtitle AS subtitle_3, t0.preview AS preview_4, t0.text AS text_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM news_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
194
]
|
| 4 | 4.22 ms |
SELECT u0_.type AS type_0 FROM uuid_owners u0_ WHERE u0_.uuid = ?
Parameters:
[
"01caeded-51df-41fa-949f-ffef642f9fc5"
]
|
| 5 | 2.27 ms |
SELECT o0_.id AS id_0, o0_.caption AS caption_1, o0_.subtitle AS subtitle_2, o0_.mainpage AS mainpage_3, o0_.description AS description_4, o0_.results AS results_5, o0_.deleted AS deleted_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.active AS active_9, o0_.uuid AS uuid_10, o0_.interval_from AS interval_from_11, o0_.interval_to AS interval_to_12, f1_.id AS id_13, f1_.public AS public_14, f1_.created_at AS created_at_15, f1_.data_name AS data_name_16, f1_.data_original_name AS data_original_name_17, f1_.data_mime_type AS data_mime_type_18, f1_.data_dimensions AS data_dimensions_19, f1_.data_size AS data_size_20, f1_.owner_uuid AS owner_uuid_21, f1_.owner_active AS owner_active_22, f1_.owner_deleted AS owner_deleted_23, o0_.level_id AS level_id_24, o0_.logo_id AS logo_id_25, o0_.created_by_id AS created_by_id_26, o0_.updated_by_id AS updated_by_id_27, f1_.created_by_id AS created_by_id_28 FROM olympiad o0_ LEFT JOIN files f1_ ON o0_.logo_id = f1_.id WHERE (o0_.active = 1 AND o0_.deleted = 0) AND o0_.uuid = ?
Parameters:
[
"01caeded-51df-41fa-949f-ffef642f9fc5"
]
|
| 6 | 0.75 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.subtitle AS subtitle_3, t0.description AS description_4, t0.results AS results_5, t0.date_string AS date_string_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM olympiad_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
60
]
|
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\User\User | No errors. |
| App\Entity\Common\Owner | No errors. |
| App\Entity\Common\DateInterval | No errors. |
| App\Entity\Content\News | No errors. |
| App\Entity\Common\UploadedData | No errors. |
| App\Entity\Common\File | No errors. |
| App\Entity\Content\NewsType | No errors. |
| App\Entity\Content\NewsTranslation | No errors. |
| App\Entity\UUID\Owners | No errors. |
| App\Entity\Olympiad\Olympiad | No errors. |
| App\Entity\Olympiad\Level | No errors. |
| App\Entity\Olympiad\Discipline | No errors. |
| App\Entity\Olympiad\Grade | No errors. |
| App\Entity\Olympiad\Stage | No errors. |
| App\Entity\Common\Coord | No errors. |
| App\Entity\Organisation\Organisation | No errors. |
| App\Entity\Organisation\University\OlympPrivilegy | No errors. |
| App\Entity\Scholar\Profile | No errors. |
| App\Entity\Organisation\SuccessHistory | No errors. |
| App\Entity\Olympiad\OlympiadTranslation | No errors. |