Query Metrics
2
Database Queries
2
Different statements
337.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 336.56 ms |
SELECT t0.id AS id_1, t0.salutation AS salutation_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.street AS street_6, t0.zip_code AS zip_code_7, t0.phone AS phone_8, t0.cellphone AS cellphone_9, t0.city AS city_10, t0.purchase_date AS purchase_date_11, t0.purchase_price AS purchase_price_12, t0.cancel_date AS cancel_date_13, t0.sale_date AS sale_date_14, t0.sale_price AS sale_price_15, t0.company AS company_16, t0.street_additional AS street_additional_17, t0.reg_year AS reg_year_18, t0.address_import AS address_import_19, t0.reg_month AS reg_month_20, t0.is_active AS is_active_21, t0.reg_date AS reg_date_22, t0.fax AS fax_23, t0.reg_by AS reg_by_24, t0.cobra_id AS cobra_id_25, t0.dob AS dob_26, t0.profession AS profession_27, t0.martial_status AS martial_status_28, t0.ip_address AS ip_address_29, t0.ref_id AS ref_id_30, t0.reg_datetime AS reg_datetime_31, t0.is_interested AS is_interested_32, t0.email_state AS email_state_33, t0.evb AS evb_34, t0.product_name AS product_name_35, t0.mail_state AS mail_state_36, t0.general_state AS general_state_37, t0.marketing AS marketing_38, t0.completed_by_user AS completed_by_user_39, t0.completed_by_admin AS completed_by_admin_40, t0.availability AS availability_41, t0.is_client AS is_client_42, t0.amount_children AS amount_children_43, t0.is_processed AS is_processed_44, t0.phone_availability AS phone_availability_45, t0.is_visited_website AS is_visited_website_46, t0.is_kvr AS is_kvr_47, t0.is_lvr AS is_lvr_48, t0.is_vwl AS is_vwl_49, t0.is_foreigner AS is_foreigner_50, t0.is_unsubscribed AS is_unsubscribed_51, t0.is_800 AS is_800_52, t0.is_hp AS is_hp_53, t0.is_hr AS is_hr_54, t0.is_kfz AS is_kfz_55, t0.is_rs AS is_rs_56, t0.is_kv AS is_kv_57, t0.cancel_reason_id AS cancel_reason_id_58, t0.salesmen_id AS salesmen_id_59, t0.address_provider_id AS address_provider_id_60, t0.address_purchaser_id AS address_purchaser_id_61, t0.client_cancel_reason_id AS client_cancel_reason_id_62, t0.calendar_state_id AS calendar_state_id_63 FROM address_pool t0 WHERE t0.ref_id = ?
Parameters:
[
"#260224080033#"
]
|
| 2 | 0.74 ms |
SELECT t0.id AS id_1, t0.salutation AS salutation_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.street AS street_6, t0.zip_code AS zip_code_7, t0.phone AS phone_8, t0.cellphone AS cellphone_9, t0.city AS city_10, t0.purchase_date AS purchase_date_11, t0.purchase_price AS purchase_price_12, t0.cancel_date AS cancel_date_13, t0.sale_date AS sale_date_14, t0.sale_price AS sale_price_15, t0.company AS company_16, t0.street_additional AS street_additional_17, t0.reg_year AS reg_year_18, t0.address_import AS address_import_19, t0.reg_month AS reg_month_20, t0.is_active AS is_active_21, t0.reg_date AS reg_date_22, t0.fax AS fax_23, t0.reg_by AS reg_by_24, t0.cobra_id AS cobra_id_25, t0.dob AS dob_26, t0.profession AS profession_27, t0.martial_status AS martial_status_28, t0.ip_address AS ip_address_29, t0.ref_id AS ref_id_30, t0.reg_datetime AS reg_datetime_31, t0.is_interested AS is_interested_32, t0.email_state AS email_state_33, t0.evb AS evb_34, t0.product_name AS product_name_35, t0.mail_state AS mail_state_36, t0.general_state AS general_state_37, t0.marketing AS marketing_38, t0.completed_by_user AS completed_by_user_39, t0.completed_by_admin AS completed_by_admin_40, t0.availability AS availability_41, t0.is_client AS is_client_42, t0.amount_children AS amount_children_43, t0.is_processed AS is_processed_44, t0.phone_availability AS phone_availability_45, t0.is_visited_website AS is_visited_website_46, t0.is_kvr AS is_kvr_47, t0.is_lvr AS is_lvr_48, t0.is_vwl AS is_vwl_49, t0.is_foreigner AS is_foreigner_50, t0.is_unsubscribed AS is_unsubscribed_51, t0.is_800 AS is_800_52, t0.is_hp AS is_hp_53, t0.is_hr AS is_hr_54, t0.is_kfz AS is_kfz_55, t0.is_rs AS is_rs_56, t0.is_kv AS is_kv_57, t0.cancel_reason_id AS cancel_reason_id_58, t0.salesmen_id AS salesmen_id_59, t0.address_provider_id AS address_provider_id_60, t0.address_purchaser_id AS address_purchaser_id_61, t0.client_cancel_reason_id AS client_cancel_reason_id_62, t0.calendar_state_id AS calendar_state_id_63 FROM address_pool t0 WHERE t0.email = ?
Parameters:
[
"abood.bozer45@gmail.com"
]
|
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\AddressPool | No errors. |
| App\Entity\AddresspoolCancelReason | No errors. |
| App\Entity\User | No errors. |
| App\Entity\AddressProvider | No errors. |
| App\Entity\AddressPurchaser | No errors. |
| App\Entity\ClientCancelReason | No errors. |
| App\Entity\CalendarState | No errors. |
| App\Entity\AddressPoolInsurance | No errors. |
| App\Entity\AddressPoolProjectStatus | No errors. |
| App\Entity\AddressUnsubscribe | No errors. |
| App\Entity\Calendar | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\EmailOffer | No errors. |
| App\Entity\AddressPoolInquiry | No errors. |
| App\Entity\MailingList | No errors. |
| App\Entity\EmailInbox | No errors. |