Query Metrics
4
Database Queries
4
Different statements
273.98 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
268.55 ms (98.02%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.client AS client_3, t0.clientContact AS clientContact_4, t0.contactUnregistered AS contactUnregistered_5, t0.nameContactUnregistered AS nameContactUnregistered_6, t0.phoneContactUnregistered AS phoneContactUnregistered_7, t0.days AS days_8, t0.createdAt AS createdAt_9, t0.priority AS priority_10, t0.createdBy AS createdBy_11, t0.supplier AS supplier_12, t0.status AS status_13, t0.updatedAt AS updatedAt_14, t0.updatedBy AS updatedBy_15, t0.daysBlock AS daysBlock_16, t0.advancePayment AS advancePayment_17, t0.idProposal AS idProposal_18, t0.cateringName AS cateringName_19, t0.boolCatering AS boolCatering_20, t0.dateStart AS dateStart_21, t0.dateEnd AS dateEnd_22, t0.pax AS pax_23, t0.deposit AS deposit_24, t0.access_key AS access_key_25, t0.description AS description_26, t0.contract AS contract_27, t0.token AS token_28, t0.comAvGp AS comAvGp_29, t0.comHtGp AS comHtGp_30, t31.id AS id_32, t31.title AS title_33, t31.status AS status_34, t31.days_block AS days_block_35, t31.pax AS pax_36, t31.description AS description_37, t31.description_two AS description_two_38, t31.contact_unregistered AS contact_unregistered_39, t31.name_contact_unregistered AS name_contact_unregistered_40, t31.phone_contact_unregistered AS phone_contact_unregistered_41, t31.date_start AS date_start_42, t31.date_end AS date_end_43, t31.created_at AS created_at_44, t31.updated_at AS updated_at_45, t31.client_type AS client_type_46, t31.client_id AS client_id_47, t31.proposal_id AS proposal_id_48, t31.created_id_id AS created_id_id_49, t31.updated_id_id AS updated_id_id_50, t31.client_contact_id AS client_contact_id_51, t31.reservation_id AS reservation_id_52 FROM reservation t0 LEFT JOIN ht_file t31 ON t31.reservation_id = t0.id
Parameters:
[] |
4.06 ms (1.48%) |
1 |
SELECT t0.id AS id_1, t0.agentId AS agentId_2, t0.clientId AS clientId_3, t0.clientName AS clientName_4, t0.loungeName AS loungeName_5, t0.idLounge AS idLounge_6, t0.dateStart AS dateStart_7, t0.dateEnd AS dateEnd_8, t0.servicePrice AS servicePrice_9, t0.idReservation AS idReservation_10, t0.pax AS pax_11, t0.type AS type_12, t0.hourStart AS hourStart_13, t0.minStart AS minStart_14, t0.hourEnd AS hourEnd_15, t0.minEnd AS minEnd_16, t0.createdAt AS createdAt_17, t0.createdId AS createdId_18, t0.updatedAt AS updatedAt_19, t0.updatedId AS updatedId_20 FROM reservation_visit t0
Parameters:
[] |
0.94 ms (0.34%) |
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
Parameters:
[] |
0.43 ms (0.16%) |
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_user_rol IN (?, ?)
Parameters:
[ 49 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.
Entities Mapping
Class | Mapping errors |
---|---|
App\MDS\GreenPatioBundle\Entity\ReservationVisit | No errors. |
App\MDS\GreenPatioBundle\Entity\Reservation | No errors. |
App\Entity\HtFile | No errors. |
App\Entity\Client | No errors. |
App\MDS\EventsBundle\Entity\Proposal | No errors. |
App\Entity\User | No errors. |
App\Entity\ClientContact | No errors. |
App\Entity\GpReminder | No errors. |
App\Entity\HtItem |
|
App\Entity\HtVisit | No errors. |