Query Metrics
10
Database Queries
5
Different statements
74.85 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
51.91 ms (0.00%) |
3 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.compulsory AS compulsory_3, t0.grade AS grade_4, t0.beeee AS beeee_5, t0.location AS location_6, t0.closing_date AS closing_date_7, t0.project_number AS project_number_8, t0.awarded AS awarded_9, t0.contract_description AS contract_description_10, t0.tender_notice AS tender_notice_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.is_published AS is_published_14, t0.modified AS modified_15, t0.created AS created_16, t0.brief_date AS brief_date_17, t0.closing_time AS closing_time_18, t0.category_id AS category_id_19, t0.region_id AS region_id_20 FROM tenders t0 WHERE t0.id = ?
Parameters:
[
"20"
]
|
6.75 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.category AS category_2, t0.thumbnail AS thumbnail_3, t0.modified AS modified_4, t0.created AS created_5 FROM categories t0 WHERE t0.id = ?
Parameters:
[
11
]
|
6.12 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.region AS region_2, t0.thumbnail AS thumbnail_3, t0.address AS address_4, t0.map AS map_5, t0.modified AS modified_6, t0.created AS created_7 FROM regions t0 WHERE t0.id = ?
Parameters:
[
5
]
|
5.82 ms (0.00%) |
1 |
SELECT t0_.tender_id AS tender_id_0, t0_.alt_tender AS alt_tender_1, t0_.tender_submission_id AS tender_submission_id_2, t0_.amount AS amount_3, t0_.notes AS notes_4, t1_.company_name AS company_name_5, t2_.project_number AS project_number_6, t2_.id AS id_7 FROM tender_recipient t0_ INNER JOIN tenders t2_ ON (t0_.tender_id = t2_.id) INNER JOIN tender_submissions t1_ ON (t0_.tender_submission_id = t1_.id) WHERE t0_.tender_id = ?
Parameters:
[
[
"20"
]
]
|
4.25 ms (0.00%) |
2 |
SELECT t0.id AS id_1, t0.document AS document_2, t0.modified AS modified_3, t0.created AS created_4, t0.tender_id AS tender_id_5 FROM documents t0 WHERE t0.tender_id = ?
Parameters:
[
"20"
]
|
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\Tenders | No errors. |
App\Entity\Categories | No errors. |
App\Entity\Regions | No errors. |
App\Entity\Documents | No errors. |
App\Entity\TenderRecipient | No errors. |
App\Entity\TenderSubmissions | No errors. |