Query Metrics
1
Database Queries
1
Different statements
2.21 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.21 ms |
SELECT t0.is_important AS is_important_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.slug AS slug_6, t0.date AS date_7, t0.createdAt AS createdAt_8, t0.lastUpdate AS lastUpdate_9, t0.isEnabled AS isEnabled_10, t0.document_id AS document_id_11, t12.id AS id_13, t12.target AS target_14, t12.pages AS pages_15, t12.downloads AS downloads_16, t12.reading AS reading_17, t12.name AS name_18, t12.dir AS dir_19, t12.source AS source_20, t12.size AS size_21, t12.is_enabled AS is_enabled_22, t12.is_deleted AS is_deleted_23, t12.last_update AS last_update_24, t12.created_at AS created_at_25, t12.formatSize AS formatSize_26, t12.mimetype AS mimetype_27, t0.category_id AS category_id_28, t29.id AS id_30, t29.label AS label_31, t29.description AS description_32, t29.slug AS slug_33, t0.banner_id AS banner_id_34, t35.target AS target_36, t35.thumbnailDir AS thumbnailDir_37, t35.hasThumbnail AS hasThumbnail_38, t35.id AS id_39, t35.pages AS pages_40, t35.downloads AS downloads_41, t35.reading AS reading_42, t35.name AS name_43, t35.dir AS dir_44, t35.source AS source_45, t35.size AS size_46, t35.is_enabled AS is_enabled_47, t35.is_deleted AS is_deleted_48, t35.last_update AS last_update_49, t35.created_at AS created_at_50, t35.formatSize AS formatSize_51, t35.mimetype AS mimetype_52, t0.sector_id AS sector_id_53, t0.user_id AS user_id_54, t55.id AS id_56, t55.fName AS fName_57, t55.lName AS lName_58, t55.phone AS phone_59, t55.createdAt AS createdAt_60, t55.lastLogin AS lastLogin_61, t55.password AS password_62, t55.token AS token_63, t55.sex AS sex_64, t55.isEnabled AS isEnabled_65, t55.email AS email_66, t55.profile_id AS profile_id_67, t0.updatedBy AS updatedBy_68 FROM resources t0 LEFT JOIN file t12 ON t0.document_id = t12.id LEFT JOIN resources_categories t29 ON t0.category_id = t29.id LEFT JOIN picture t35 ON t0.banner_id = t35.id LEFT JOIN users t55 ON t0.user_id = t55.id ORDER BY t0.date DESC, t0.id DESC
Parameters:
[] |
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\OSEntity | No errors. |
| App\Entity\Resources | No errors. |
| App\Entity\OSFile | No errors. |
| App\Entity\File | No errors. |
| App\Entity\ResourcesCategories | No errors. |
| App\Entity\Picture | No errors. |
| App\Entity\Sectors | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\Profiles | No errors. |
| App\Entity\Tags | No errors. |