Query Metrics
22
Database Queries
10
Different statements
14.41 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.26 ms (29.59%) |
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_.agent_id IS NULL AND p0_.status <> ? ORDER BY p0_.id DESC
Parameters:
[
"Cancel"
]
|
1.84 ms (12.74%) |
3 |
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 FROM clients t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
4034
]
|
1.74 ms (12.07%) |
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:
[
"elena.paret@inout.events"
]
|
1.49 ms (10.32%) |
3 |
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 = ? LIMIT 1
Parameters:
[
19
]
|
1.42 ms (9.82%) |
3 |
SELECT t0.id AS id_1, t0.idProp AS idProp_2, t0.agOne AS agOne_3, t0.agTwo AS agTwo_4, t0.agThree AS agThree_5, t0.agFour AS agFour_6, t0.agOnePerc AS agOnePerc_7, t0.agTwoPerc AS agTwoPerc_8, t0.agThreePerc AS agThreePerc_9, t0.agFourPerc AS agFourPerc_10, t0.agOneWork AS agOneWork_11, t0.agTwoWork AS agTwoWork_12, t0.agThreeWork AS agThreeWork_13, t0.agFourWork AS agFourWork_14 FROM proposal_agents t0 WHERE t0.idProp = ? LIMIT 1
Parameters:
[
5431
]
|
1.35 ms (9.34%) |
3 |
SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.position AS position_3, t0.department AS department_4, t0.type_client AS type_client_5, t0.name AS name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.password AS password_9, t0.token AS token_10, t0.phone AS phone_11, t0.mobile AS mobile_12, t0.birthday AS birthday_13, t0.assigned_agent AS assigned_agent_14, t0.situation AS situation_15, t0.status AS status_16, t0.created_id AS created_id_17, t0.created_at AS created_at_18, t0.updated_id AS updated_id_19, t0.updated_at AS updated_at_20, t0.picture AS picture_21, t0.newsletter AS newsletter_22 FROM clients_contact t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
5050
]
|
0.95 ms (6.56%) |
3 |
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 IS NULL LIMIT 1
Parameters:
[] |
0.68 ms (4.69%) |
2 |
SELECT t0.id AS id_1, t0.team AS team_2 FROM settings_team t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
0.42 ms (2.91%) |
1 |
SELECT u0_.id AS id_0, u0_.picture AS picture_1, u0_.username AS username_2, u0_.email AS email_3, u0_.password AS password_4, u0_.movil_password AS movil_password_5, u0_.pass_gmail AS pass_gmail_6, u0_.firm_gmail AS firm_gmail_7, u0_.name AS name_8, u0_.last_name AS last_name_9, u0_.telephone AS telephone_10, u0_.mobile AS mobile_11, u0_.id_office AS id_office_12, u0_.status AS status_13, u0_.id_company AS id_company_14, u0_.id_user_rol AS id_user_rol_15, u0_.id_team AS id_team_16, u0_.team_leader AS team_leader_17, u0_.role AS role_18, u0_.access_key AS access_key_19, u0_.language AS language_20, u0_.color AS color_21, u0_.vacations AS vacations_22, u0_.half_days AS half_days_23, u0_.sidebar AS sidebar_24, u0_.created_at AS created_at_25, u0_.updated_at AS updated_at_26, u0_.description AS description_27, u0_.job_title AS job_title_28 FROM users u0_ WHERE u0_.status = ? AND u0_.id_team IN (1, 2, 4, 5, 16) ORDER BY u0_.name ASC
Parameters:
[
1
]
|
0.28 ms (1.95%) |
1 |
SELECT t0.id AS id_1, t0.team AS team_2 FROM settings_team t0 WHERE t0.id IS NULL LIMIT 1
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\User | No errors. |
App\MDS\EventsBundle\Entity\Proposal | No errors. |
App\Entity\Client | No errors. |
App\Entity\ClientContact | No errors. |
App\Entity\SettingsTeam | No errors. |
App\MDS\EventsBundle\Entity\ProposalAgents | No errors. |