Query Metrics
21
Database Queries
18
Different statements
114.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
66.52 ms (57.90%) |
1 |
SELECT t0.id AS id_1, t0.proposal_id AS proposal_id_2, t0.briefing AS briefing_3, t0.userId AS userId_4, t0.userName AS userName_5, t0.addedAt AS addedAt_6 FROM proposal_briefing_list t0 WHERE t0.proposal_id = ?
Parameters:
[
"7043"
]
|
|
32.12 ms (27.96%) |
1 |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.name AS name_2, c0_.title AS title_3, c0_.address AS address_4, c0_.address_number AS address_number_5, c0_.zip_code AS zip_code_6, c0_.population AS population_7, c0_.province AS province_8, c0_.region AS region_9, c0_.country AS country_10, c0_.telephone AS telephone_11, c0_.fax AS fax_12, c0_.email AS email_13, c0_.gds AS gds_14, c0_.type_document AS type_document_15, c0_.id_document AS id_document_16, c0_.observation AS observation_17, c0_.id_office AS id_office_18, c0_.created_at AS created_at_19, c0_.created_id AS created_id_20, c0_.updated_at AS updated_at_21, c0_.updated_id AS updated_id_22, c0_.status AS status_23, c0_.picture AS picture_24, c0_.group_id AS group_id_25, c0_.competency AS competency_26, c0_.action AS action_27, c0_.return_investment AS return_investment_28, c0_.is_client_in_out AS is_client_in_out_29, c0_.is_client_green_patio AS is_client_green_patio_30, c0_.is_client_av_express AS is_client_av_express_31, c0_.is_client_develup AS is_client_develup_32, c0_.typology AS typology_33 FROM clients c0_
Parameters:
[] |
|
9.39 ms (8.17%) |
1 |
SELECT t0.id AS id_1, t0.date_at AS date_at_2, t0.text AS text_3, t0.agent_id AS agent_id_4, t0.proposal_id AS proposal_id_5, t0.viewed AS viewed_6, t0.created_id AS created_id_7, t0.created_at AS created_at_8, t0.updated_id AS updated_id_9, t0.updated_at AS updated_at_10 FROM proposal_tracings t0 WHERE t0.proposal_id = ?
Parameters:
[
"7043"
]
|
|
1.39 ms (1.21%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.commission AS commission_4, t0.pax AS pax_5, t0.bedrooms AS bedrooms_6, t0.office_id AS office_id_7, t0.client_id AS client_id_8, t0.contact_id AS contact_id_9, t0.reference_name AS reference_name_10, t0.reference_id AS reference_id_11, t0.agent_id AS agent_id_12, t0.approximate_billing AS approximate_billing_13, t0.team_id AS team_id_14, t0.agent_two_id AS agent_two_id_15, t0.agent_commercial_id AS agent_commercial_id_16, t0.date_proposed_at AS date_proposed_at_17, t0.date_event_star_at AS date_event_star_at_18, t0.date_event_end_at AS date_event_end_at_19, t0.days_email_reminder AS days_email_reminder_20, t0.language AS language_21, t0.include_logo AS include_logo_22, t0.version_ppt AS version_ppt_23, t0.version_excel AS version_excel_24, t0.version_flahs AS version_flahs_25, t0.version_word AS version_word_26, t0.briefing AS briefing_27, t0.date_presentation_at AS date_presentation_at_28, t0.status AS status_29, t0.sent AS sent_30, t0.select_type AS select_type_31, t0.created_at AS created_at_32, t0.created_id AS created_id_33, t0.updated_at AS updated_at_34, t0.updated_id AS updated_id_35, t0.access_key AS access_key_36, t0.viewed_at AS viewed_at_37, t0.observation AS observation_38, t0.send_admin AS send_admin_39, t0.mcp AS mcp_40, t0.image AS image_41, t0.category AS category_42, t0.idMusic AS idMusic_43 FROM proposals t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"7043"
]
|
|
1.22 ms (1.06%) |
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:
[
"cailiang.zhou@inout.events"
]
|
|
0.46 ms (0.40%) |
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.id = ? LIMIT 1
Parameters:
[
128
]
|
|
0.44 ms (0.38%) |
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 = ? LIMIT 1
Parameters:
[
262
]
|
|
0.41 ms (0.36%) |
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.41 ms (0.35%) |
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_
Parameters:
[] |
|
0.34 ms (0.30%) |
1 |
SELECT t0.id AS id_1, t0.office AS office_2 FROM settings_office t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"1"
]
|
|
0.33 ms (0.28%) |
1 |
SELECT s0_.id AS id_0, s0_.office AS office_1 FROM settings_office s0_
Parameters:
[] |
|
0.33 ms (0.28%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.file AS file_3, t0.created_id AS created_id_4, t0.created_at AS created_at_5, t0.updated_id AS updated_id_6, t0.updated_at AS updated_at_7 FROM presentation_music t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
|
0.31 ms (0.27%) |
1 |
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:
[
"7043"
]
|
|
0.29 ms (0.25%) |
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:
[ "" ] |
|
0.27 ms (0.23%) |
1 |
SELECT t0.id AS id_1, t0.group_Base AS group_Base_2, t0.base AS base_3, t0.name AS name_4 FROM suppliers_settings_type t0
Parameters:
[] |
|
0.25 ms (0.21%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.file AS file_2, p0_.created_id AS created_id_3, p0_.created_at AS created_at_4, p0_.updated_id AS updated_id_5, p0_.updated_at AS updated_at_6 FROM presentation_music p0_
Parameters:
[] |
|
0.23 ms (0.20%) |
1 |
SELECT t0.id AS id_1, t0.team AS team_2 FROM settings_team t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
0.20 ms (0.17%) |
1 |
SELECT s0_.id AS id_0, s0_.team AS team_1 FROM settings_team s0_
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\SettingsOffice | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\SettingsTeam | No errors. |
| App\Entity\PresentationMusic | No errors. |
| App\Entity\SupplierSettingsType | No errors. |
| App\MDS\EventsBundle\Entity\ProposalBriefingList | No errors. |
| App\MDS\EventsBundle\Entity\ProposalTracing | No errors. |
| App\MDS\EventsBundle\Entity\ProposalAgents | No errors. |