Query Metrics
9
Database Queries
9
Different statements
12.85 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 6.94 ms |
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 WHERE t0.id = ?
Parameters:
[
"6"
]
|
2 | 0.67 ms |
SELECT o0_.opening_date AS opening_date_0, o0_.closing_date AS closing_date_1, o0_.structure AS structure_2, o0_.place AS place_3, o0_.submission_link AS submission_link_4, o0_.submission_btn_title AS submission_btn_title_5, o0_.id AS id_6, o0_.title AS title_7, o0_.description AS description_8, o0_.content AS content_9, o0_.slug AS slug_10, o0_.date AS date_11, o0_.createdAt AS createdAt_12, o0_.lastUpdate AS lastUpdate_13, o0_.isEnabled AS isEnabled_14, o0_.biblio_id AS biblio_id_15, o0_.category_id AS category_id_16, o0_.type_id AS type_id_17, o0_.banner_id AS banner_id_18, o0_.sector_id AS sector_id_19, o0_.user_id AS user_id_20, o0_.updatedBy AS updatedBy_21 FROM opportunities o0_ WHERE o0_.isEnabled = 1
Parameters:
[] |
3 | 0.49 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.isEnabled AS isEnabled_3 FROM biblios t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 3 4 5 7 8 ] |
4 | 0.54 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.id IN (?)
Parameters:
[
1
]
|
5 | 0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.isEnabled AS isEnabled_5, t0.banner_id AS banner_id_6 FROM articles_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
1
]
|
6 | 0.38 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM opportunities_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
1
]
|
7 | 0.57 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM resources_categories t0
Parameters:
[] |
8 | 0.50 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.isEnabled AS isEnabled_5 FROM videos_categories t0 WHERE t0.isEnabled = ?
Parameters:
[
1
]
|
9 | 2.12 ms |
SELECT t0.id AS id_1, t0.target AS target_2, t0.pages AS pages_3, t0.downloads AS downloads_4, t0.reading AS reading_5, t0.name AS name_6, t0.dir AS dir_7, t0.source AS source_8, t0.size AS size_9, t0.is_enabled AS is_enabled_10, t0.is_deleted AS is_deleted_11, t0.last_update AS last_update_12, t0.created_at AS created_at_13, t0.formatSize AS formatSize_14, t0.mimetype AS mimetype_15 FROM file t0 INNER JOIN biblios_file ON t0.id = biblios_file.file_id WHERE biblios_file.biblios_id = ?
Parameters:
[
6
]
|
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. |
App\Entity\ArticlesCategories | No errors. |
App\Entity\Articles | No errors. |
App\Entity\ResourcesCategories | No errors. |
App\Entity\VideosCategories | No errors. |
App\Entity\ArticlesTypes | No errors. |
App\Entity\Albums | No errors. |
App\Entity\Resources | No errors. |
App\Entity\Subscribers | No errors. |