Query Metrics
1
Database Queries
1
Different statements
2.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.92 ms (100.00%) |
1 |
SELECT t0.opening_date AS opening_date_1, t0.closing_date AS closing_date_2, t0.structure AS structure_3, t0.place AS place_4, t0.submission_link AS submission_link_5, t0.submission_btn_title AS submission_btn_title_6, t0.id AS id_7, t0.title AS title_8, t0.description AS description_9, t0.content AS content_10, t0.slug AS slug_11, t0.date AS date_12, t0.createdAt AS createdAt_13, t0.lastUpdate AS lastUpdate_14, t0.isEnabled AS isEnabled_15, t0.biblio_id AS biblio_id_16, t17.id AS id_18, t17.title AS title_19, t17.isEnabled AS isEnabled_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, t0.type_id AS type_id_28, t0.banner_id AS banner_id_29, t30.target AS target_31, t30.thumbnailDir AS thumbnailDir_32, t30.hasThumbnail AS hasThumbnail_33, t30.id AS id_34, t30.pages AS pages_35, t30.downloads AS downloads_36, t30.reading AS reading_37, t30.name AS name_38, t30.dir AS dir_39, t30.source AS source_40, t30.size AS size_41, t30.is_enabled AS is_enabled_42, t30.is_deleted AS is_deleted_43, t30.last_update AS last_update_44, t30.created_at AS created_at_45, t30.formatSize AS formatSize_46, t30.mimetype AS mimetype_47, t0.sector_id AS sector_id_48, t0.user_id AS user_id_49, t50.id AS id_51, t50.fName AS fName_52, t50.lName AS lName_53, t50.phone AS phone_54, t50.createdAt AS createdAt_55, t50.lastLogin AS lastLogin_56, t50.password AS password_57, t50.token AS token_58, t50.sex AS sex_59, t50.isEnabled AS isEnabled_60, t50.email AS email_61, t50.profile_id AS profile_id_62, t0.updatedBy AS updatedBy_63 FROM opportunities t0 LEFT JOIN biblios t17 ON t0.biblio_id = t17.id LEFT JOIN opportunities_categories t22 ON t0.category_id = t22.id LEFT JOIN picture t30 ON t0.banner_id = t30.id LEFT JOIN users t50 ON t0.user_id = t50.id ORDER BY 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\Opportunities | No errors. |
| App\Entity\Biblios | No errors. |
| App\Entity\OpportunitiesCategories | No errors. |
| App\Entity\OpportunitiesTypes | No errors. |
| App\Entity\OSFile | 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. |
| App\Entity\File | No errors. |