Query Metrics
5
Database Queries
4
Different statements
27.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
14.41 ms (52.51%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.title AS title_2, p0_.commission AS commission_3, p0_.pax AS pax_4, p0_.bedrooms AS bedrooms_5, p0_.office_id AS office_id_6, p0_.client_id AS client_id_7, p0_.contact_id AS contact_id_8, p0_.reference_name AS reference_name_9, p0_.reference_id AS reference_id_10, p0_.agent_id AS agent_id_11, p0_.approximate_billing AS approximate_billing_12, p0_.team_id AS team_id_13, p0_.agent_two_id AS agent_two_id_14, p0_.agent_commercial_id AS agent_commercial_id_15, p0_.date_proposed_at AS date_proposed_at_16, p0_.date_event_star_at AS date_event_star_at_17, p0_.date_event_end_at AS date_event_end_at_18, p0_.days_email_reminder AS days_email_reminder_19, p0_.language AS language_20, p0_.include_logo AS include_logo_21, p0_.version_ppt AS version_ppt_22, p0_.version_excel AS version_excel_23, p0_.version_flahs AS version_flahs_24, p0_.version_word AS version_word_25, p0_.briefing AS briefing_26, p0_.date_presentation_at AS date_presentation_at_27, p0_.status AS status_28, p0_.sent AS sent_29, p0_.select_type AS select_type_30, p0_.created_at AS created_at_31, p0_.created_id AS created_id_32, p0_.updated_at AS updated_at_33, p0_.updated_id AS updated_id_34, p0_.access_key AS access_key_35, p0_.viewed_at AS viewed_at_36, p0_.observation AS observation_37, p0_.send_admin AS send_admin_38, p0_.mcp AS mcp_39, p0_.image AS image_40, p0_.category AS category_41, p0_.idMusic AS idMusic_42 FROM proposals p0_ WHERE p0_.team_id = ? AND p0_.status IN (?, ?) AND p0_.date_event_star_at > ?
Parameters:
[ 1 "Confirmed" "Invoiced" "2025-05-06 12:23:09" ] |
|
9.51 ms (34.64%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.title AS title_4, t0.address AS address_5, t0.address_number AS address_number_6, t0.zip_code AS zip_code_7, t0.population AS population_8, t0.province AS province_9, t0.region AS region_10, t0.country AS country_11, t0.telephone AS telephone_12, t0.fax AS fax_13, t0.email AS email_14, t0.gds AS gds_15, t0.type_document AS type_document_16, t0.id_document AS id_document_17, t0.observation AS observation_18, t0.id_office AS id_office_19, t0.created_at AS created_at_20, t0.created_id AS created_id_21, t0.updated_at AS updated_at_22, t0.updated_id AS updated_id_23, t0.status AS status_24, t0.picture AS picture_25, t0.group_id AS group_id_26, t0.competency AS competency_27, t0.action AS action_28, t0.return_investment AS return_investment_29, t0.is_client_in_out AS is_client_in_out_30, t0.is_client_green_patio AS is_client_green_patio_31, t0.is_client_av_express AS is_client_av_express_32, t0.is_client_develup AS is_client_develup_33, t0.typology AS typology_34 FROM clients t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 577 1696 549 2295 2639 529 2627 951 3495 157 2706 3495 3495 549 4971 4507 4285 951 2526 2869 1238 1945 951 2639 4857 3356 4616 951 4704 513 1696 2627 385 2627 108 108 108 108 4205 4428 4285 4285 108 385 4285 4285 4915 4285 587 587 4806 4807 4285 951 1324 1324 951 4817 4808 4810 4824 4285 4285 4285 4285 4285 490 4285 4285 4285 4842 4285 4285 4285 4285 967 4848 1612 4858 1238 4428 613 4285 4285 4865 2639 4866 1696 1696 4865 4868 4181 4285 4873 917 513 951 4824 2627 4842 2991 4872 4879 1945 4879 4872 4842 3375 4285 5030 4285 3258 3258 1324 262 1324 2639 4285 4285 4285 4285 3117 951 4912 4916 2769 5156 3159 2769 4285 3258 2679 3495 2526 3258 4285 4285 4285 5399 4428 513 951 4457 2627 4926 4428 1324 1324 1612 4065 1238 4285 3159 1324 385 4285 3495 1696 3397 3397 3397 3397 4942 4943 4944 4945 4946 4947 4948 4285 1324 951 625 421 4956 4285 4677 2820 1020 5070 4824 321 3703 3569 1324 4457 1324 577 91 1990 4355 5399 1324 2627 480 385 352 5007 2627 1085 490 2879 1324 5027 5031 5034 527 5222 4221 625 4065 2627 4285 2627 2217 490 2627 4285 3623 4872 490 490 951 5083 490 490 4886 321 385 951 791 490 951 2639 5166 3703 462 5130 5031 3495 2639 3495 2949 625 5114 625 2727 1324 1324 2640 5170 4573 3258 577 587 951 2879 5154 3159 5158 1085 4677 5181 4285 4285 4285 5114 2811 5265 385 4221 1324 5184 1203 3703 4941 5116 5115 5190 5130 951 4507 490 4285 5114 3258 4285 4221 4285 3495 951 5210 4221 4285 2639 3703 1187 4285 4221 4285 718 4285 4285 2991 5353 262 4428 4285 4285 2879 999 3482 2498 2627 3258 3258 3258 3258 4285 4285 4285 4285 4956 2627 3258 4221 5222 3495 4285 2627 4285 4285 4285 91 4428 4704 4221 480 1238 1324 5265 4355 951 4704 951 385 4221 4285 1324 5281 4181 5362 2790 4285 5353 4507 4573 4065 4879 3937 2727 1085 5301 2627 490 3258 108 4285 951 4285 490 4285 4285 4285 4221 3258 385 2627 5034 3258 3159 4280 4817 3159 5327 5328 5329 5431 3356 2627 4428 529 1254 385 2706 5458 2639 1203 4285 4285 4285 951 5160 5360 5361 5160 4428 1945 1085 262 2639 2991 2811 4285 108 108 108 108 549 5379 5379 447 3231 5385 951 3258 1324 4285 2879 3881 157 587 157 2921 2790 4285 4285 262 1085 3377 5566 5166 490 2727 3258 4285 1612 549 5353 4587 2706 1085 4465 385 2679 1324 2706 1324 490 4704 4704 5181 385 3495 4285 4285 4285 4285 4285 4285 4285 4285 4285 5441 5443 1324 2627 4221 1324 3482 4704 951 3495 2822 1324 2869 2627 1696 5766 5797 421 2627 5362 587 5353 4285 4285 4285 4285 4704 5866 262 951 5496 2820 2869 4285 4285 405 3187 4915 4285 4285 4285 951 4915 3159 4221 3495 3384 4285 4285 1612 4428 5666 4221 4285 3159 4285 352 4285 6 1324 2627 5265 108 108 108 5353 4915 4285 4285 4285 2991 2627 4285 625 3187 4432 951 4285 4285 108 2627 4221 3159 2627 4285 4285 3356 4221 2627 385 951 5689 3703 3221 4704 4285 321 4285 4181 4872 1324 4285 4285 4285 4285 4285 4704 5726 5399 5399 1324 5399 5728 967 4704 4285 4285 5160 5865 4285 2627 3495 4285 951 4285 4285 4285 4285 4285 5855 1663 4285 1663 549 1663 1663 4285 157 1663 3703 4285 4285 1663 385 1324 4285 4285 4285 4285 4285 4285 4285 4285 4285 5860 1663 5861 385 2627 4285 4285 4285 ] |
|
2.08 ms (7.57%) |
1 |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 28 22 29 22 29 29 22 126 28 22 126 28 28 29 104 126 22 125 29 128 121 28 27 29 104 22 126 134 125 27 22 128 104 126 125 125 125 125 104 123 27 125 125 134 123 126 121 128 27 27 27 27 104 125 22 22 29 126 29 29 104 125 126 126 126 125 27 128 128 128 104 123 126 104 121 22 104 128 126 22 123 29 121 121 104 29 104 22 22 126 27 126 123 128 123 123 125 104 123 104 121 126 126 134 126 126 126 104 27 29 123 128 128 22 20 22 104 126 128 104 125 121 27 126 123 20 134 104 20 125 128 28 28 29 128 134 121 29 29 126 123 126 28 123 125 22 22 22 123 134 22 125 104 22 128 121 28 121 29 29 29 29 29 29 29 29 29 29 29 125 20 128 121 121 128 126 121 28 22 29 104 27 128 123 125 28 22 28 22 104 134 29 22 126 22 97 128 27 123 125 128 128 22 27 29 126 134 126 22 121 134 126 126 123 104 128 123 126 126 125 27 125 121 22 121 128 134 27 123 125 128 104 104 121 22 128 97 104 29 28 104 28 123 121 121 121 28 128 29 126 128 126 125 126 28 125 125 125 29 29 121 134 22 126 126 126 121 121 22 22 128 22 97 29 128 125 123 123 29 104 121 126 123 128 123 134 126 22 126 28 128 126 125 126 104 128 123 126 125 134 22 126 126 104 29 20 121 97 97 128 125 22 22 128 134 134 134 134 126 126 97 123 128 123 134 104 104 28 126 123 126 126 126 22 123 125 123 22 97 22 128 104 134 134 104 97 125 123 22 29 126 104 28 126 104 126 126 134 125 28 28 121 104 125 121 128 104 126 121 125 104 125 125 125 22 125 134 126 126 125 97 125 121 97 28 28 28 126 28 123 29 29 125 97 97 125 104 134 125 125 125 123 104 22 29 104 126 28 121 28 97 125 126 126 125 125 125 125 104 123 123 104 123 22 123 97 128 126 125 123 22 28 22 28 28 125 125 125 121 29 104 22 104 28 22 29 29 29 97 22 28 22 123 123 28 22 128 22 22 128 121 121 97 28 125 125 125 125 125 125 125 125 125 28 121 22 121 125 22 22 121 126 28 128 128 128 22 22 29 22 125 22 128 28 104 97 97 97 126 104 29 123 125 104 28 22 97 97 28 126 121 125 121 97 22 121 22 97 28 126 125 125 104 121 123 125 126 22 125 128 121 123 22 123 128 125 125 22 154 121 154 154 154 121 126 97 121 123 22 22 126 154 125 22 154 29 123 29 154 97 22 22 154 97 28 154 28 121 125 121 125 126 126 22 154 125 154 154 154 128 28 29 29 29 29 29 104 128 125 125 104 29 125 154 28 125 128 154 97 97 97 154 97 126 126 123 104 125 128 125 22 126 128 125 125 154 97 29 154 97 97 97 125 125 125 125 125 22 154 121 97 22 97 97 97 ] |
|
1.45 ms (5.28%) |
2 |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.movil_password AS movil_password_6, t0.pass_gmail AS pass_gmail_7, t0.firm_gmail AS firm_gmail_8, t0.name AS name_9, t0.last_name AS last_name_10, t0.telephone AS telephone_11, t0.mobile AS mobile_12, t0.id_office AS id_office_13, t0.status AS status_14, t0.id_company AS id_company_15, t0.id_user_rol AS id_user_rol_16, t0.id_team AS id_team_17, t0.team_leader AS team_leader_18, t0.role AS role_19, t0.access_key AS access_key_20, t0.language AS language_21, t0.color AS color_22, t0.vacations AS vacations_23, t0.half_days AS half_days_24, t0.sidebar AS sidebar_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.description AS description_28, t0.job_title AS job_title_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"umut.kamaci@inout.events"
]
|
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\User | No errors. |
| App\MDS\EventsBundle\Entity\Proposal | No errors. |
| App\Entity\Client | No errors. |