Query Metrics
3
Database Queries
3
Different statements
2.53 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.40 ms |
SELECT t0.eid AS eid_1, t0.proposal_id AS proposal_id_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.keyword AS keyword_5, t0.country AS country_6, t0.city AS city_7, t0.address AS address_8, t0.description AS description_9, t0.description_en AS description_en_10, t0.location AS location_11, t0.start_date AS start_date_12, t0.end_date AS end_date_13, t0.status AS status_14, t0.image AS image_15, t0.image_background AS image_background_16, t0.logo AS logo_17, t0.image_web AS image_web_18, t0.video AS video_19, t0.music AS music_20, t0.primaryColor AS primaryColor_21, t0.secondaryColor AS secondaryColor_22, t0.bg_color AS bg_color_23, t0.register_bg_color AS register_bg_color_24, t0.register_text_color AS register_text_color_25, t0.created_at AS created_at_26, t0.created_id AS created_id_27, t0.updated_at AS updated_at_28, t0.updated_id AS updated_id_29, t0.private_gallery AS private_gallery_30, t0.vote_gallery AS vote_gallery_31, t0.private_selfie AS private_selfie_32, t0.private_video AS private_video_33, t0.badge_multi AS badge_multi_34, t0.private_wall AS private_wall_35, t0.wall_view AS wall_view_36, t0.url_app_android AS url_app_android_37, t0.url_app_ios AS url_app_ios_38, t0.email_send AS email_send_39, t0.pass_email_send AS pass_email_send_40, t0.mail_content AS mail_content_41, t0.mail_content_qr AS mail_content_qr_42, t0.mail_content_confirmation AS mail_content_confirmation_43, t0.mail_content_reservation AS mail_content_reservation_44, t0.app_id_onesignal AS app_id_onesignal_45, t0.rest_key_api_onesignal AS rest_key_api_onesignal_46, t0.event_icon AS event_icon_47, t0.type_register AS type_register_48, t0.twitter AS twitter_49, t0.facebook AS facebook_50, t0.instagram AS instagram_51, t0.linkedin AS linkedin_52, t0.youtube AS youtube_53, t0.terms_conditions AS terms_conditions_54, t0.share_contact AS share_contact_55, t0.commercial_communications_title AS commercial_communications_title_56, t0.commercial_communications AS commercial_communications_57, t0.company_name AS company_name_58, t0.language AS language_59, t0.pre_registration AS pre_registration_60, t0.app_login_register AS app_login_register_61, t0.app_login_invitation AS app_login_invitation_62, t0.mail_content_invitation AS mail_content_invitation_63, t0.alfa AS alfa_64, t0.backgroundHome AS backgroundHome_65, t0.form_status AS form_status_66, t0.form_closed AS form_closed_67 FROM MobileApp_event t0 WHERE t0.keyword = ? LIMIT 1
Parameters:
[
"107a43a5e3ad2d60d48d6160016c9f72"
]
|
| 2 | 0.63 ms |
SELECT t0.id AS id_1, t0.data_form AS data_form_2, t0.terms AS terms_3, t0.create_date AS create_date_4, t0.update_date AS update_date_5, t0.eid AS eid_6 FROM event_form_entity t0 WHERE t0.eid = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
20
]
|
| 3 | 0.50 ms |
SELECT t0.id AS id_1, t0.eid AS eid_2, t0.date AS date_3, t0.time AS time_4 FROM event_custom_date t0 WHERE t0.eid = ? ORDER BY t0.date ASC
Parameters:
[
20
]
|
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\MobileAppEvent | No errors. |
| App\Entity\EventFormEntity | No errors. |
| App\Entity\EventCustomDate | No errors. |