Query Metrics
16
Database Queries
7
Different statements
81.90 ms
Query time
0
Invalid entities
20
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 21.97 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.title AS title_2, p0_.published_date AS published_date_3, p0_.authority_org_nr AS authority_org_nr_4, p0_.tender_id AS tender_id_5, p0_.form_name AS form_name_6, p0_.deadline AS deadline_7, p0_.status AS status_8, p0_.winner_date AS winner_date_9, p0_.procuring_org_name AS procuring_org_name_10, p0_.description AS description_11, p0_.object_type AS object_type_12, p0_.bvpz_codes AS bvpz_codes_13, p0_.detail_url AS detail_url_14, p0_.estimated_total AS estimated_total_15, p0_.eps_ref_nr AS eps_ref_nr_16, p0_.procurement_no AS procurement_no_17, p0_.procurement_type AS procurement_type_18, p0_.procurement_report AS procurement_report_19, p0_.procurement_number AS procurement_number_20, p0_.procurement_object_name AS procurement_object_name_21, p0_.procurement_design_name AS procurement_design_name_22, p0_.procurement_financed_by_funds AS procurement_financed_by_funds_23, p0_.official_name AS official_name_24, p0_.legal_entity_code AS legal_entity_code_25, p0_.postal_address AS postal_address_26, p0_.town AS town_27, p0_.postal_code AS postal_code_28, p0_.country1 AS country1_29, p0_.url_general AS url_general_30, p0_.url_buyer AS url_buyer_31, p0_.type_of_contract AS type_of_contract_32, p0_.total_contract_value AS total_contract_value_33, p0_.insert_date AS insert_date_34, p0_.republished AS republished_35, p0_.imported_from AS imported_from_36, p0_.modified_date AS modified_date_37, p0_.update_date AS update_date_38, p0_.country AS country_39 FROM procurement p0_ ORDER BY p0_.published_date DESC LIMIT 10
Parameters:
[] |
||||||||||||||||||||||||||||||||||
| 2 | 0.98 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24819
]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.38 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24823
]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.37 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24816
]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.40 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24818
]
|
||||||||||||||||||||||||||||||||||
| 6 | 0.34 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24820
]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.38 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24821
]
|
||||||||||||||||||||||||||||||||||
| 8 | 0.32 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24822
]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.32 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24835
]
|
||||||||||||||||||||||||||||||||||
| 10 | 0.42 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24817
]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.39 ms |
SELECT t0.id AS id_1, t0.procurement_reference AS procurement_reference_2, t0.evaluation_criteria AS evaluation_criteria_3, t0.submission_days AS submission_days_4, t0.submission_hours AS submission_hours_5, t0.clarification_deadline AS clarification_deadline_6, t0.contact_person AS contact_person_7, t0.nuts_codes AS nuts_codes_8, t0.estimated_value AS estimated_value_9, t0.contract_duration AS contract_duration_10, t0.proposal_validity_days AS proposal_validity_days_11, t0.eu_funded AS eu_funded_12, t0.allow_alternatives AS allow_alternatives_13, t0.winner_determination_date AS winner_determination_date_14, t0.language AS language_15, t0.persons_viewing_proposals_count AS persons_viewing_proposals_count_16, t0.parts_split AS parts_split_17, t0.parts_count AS parts_count_18, t0.parts_names AS parts_names_19, t0.documents_upload_allowed AS documents_upload_allowed_20, t0.published_date AS published_date_21, t0.directive AS directive_22, t0.procurement_method AS procurement_method_23, t0.contract_type AS contract_type_24, t0.technical_specification AS technical_specification_25, t0.value_threshold AS value_threshold_26, t0.ai_summary AS ai_summary_27, t0.procurement_id AS procurement_id_28 FROM procurement_info t0 WHERE t0.procurement_id = ?
Parameters:
[
24824
]
|
||||||||||||||||||||||||||||||||||
| 12 | 1.09 ms |
SELECT u0_.id AS id_0, u0_.unique_id AS unique_id_1, u0_.title AS title_2, u0_.description AS description_3, u0_.type AS type_4, u0_.category AS category_5, u0_.tags AS tags_6, u0_.budget AS budget_7, u0_.currency AS currency_8, u0_.priority AS priority_9, u0_.status AS status_10, u0_.location AS location_11, u0_.city AS city_12, u0_.country AS country_13, u0_.is_public AS is_public_14, u0_.allow_remote_work AS allow_remote_work_15, u0_.deadline AS deadline_16, u0_.created_at AS created_at_17, u0_.updated_at AS updated_at_18, u0_.attachments AS attachments_19, u0_.notes AS notes_20, u0_.ai_questions AS ai_questions_21, u0_.ai_answers AS ai_answers_22, u0_.suggested_categories AS suggested_categories_23, u0_.suggested_tags AS suggested_tags_24, u0_.view_count AS view_count_25, u0_.is_ai_processed AS is_ai_processed_26, u0_.company_code AS company_code_27, u0_.hide_company_code AS hide_company_code_28, u0_.valid_until AS valid_until_29, u0_.include_vat AS include_vat_30, u0_.allow_partial_bids AS allow_partial_bids_31, u0_.user_id AS user_id_32, u0_.company_id AS company_id_33 FROM user_request u0_ WHERE u0_.is_public = ? AND u0_.status = ? ORDER BY u0_.created_at DESC LIMIT 10
Parameters:
[ 1 1 ]
|
||||||||||||||||||||||||||||||||||
| 13 | 13.65 ms |
SELECT COUNT(*) FROM company t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 14 | 34.18 ms |
SELECT count(c0_.id) AS sclr_0 FROM company c0_ WHERE c0_.insert_date >= ?
Parameters:
[
"2026-04-20 05:03:53"
]
|
||||||||||||||||||||||||||||||||||
| 15 | 1.68 ms |
SELECT COUNT(*) FROM procurement t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 16 | 5.03 ms |
SELECT count(p0_.id) AS sclr_0 FROM procurement p0_ WHERE p0_.insert_date >= ?
Parameters:
[
"2026-04-20 05:03:53"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Procurement | 10 |
| App\Entity\ProcurementInfo | 10 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Procurement | No errors. |
| App\Entity\ProcurementInfo | No errors. |
| App\Entity\UserRequest | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Company | No errors. |