Query Metrics
29
Database Queries
19
Different statements
14.55 ms
Query time
0
Invalid entities
95
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.84 ms (12.65%) |
2 |
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13, t0.whatsapp_number AS whatsapp_number_14, t0.website_tagline AS website_tagline_15, t0.primary_color AS primary_color_16, t0.secondary_color AS secondary_color_17, t0.background_color AS background_color_18, t0.custom_css_overrides AS custom_css_overrides_19, t0.booking_available_days AS booking_available_days_20, t0.automatic_confirmation AS automatic_confirmation_21, t0.booking_cutoff_hours AS booking_cutoff_hours_22, t0.default_payment_terms AS default_payment_terms_23, t0.late_payment_grace_period_days AS late_payment_grace_period_days_24, t0.wire_transfer_account_details AS wire_transfer_account_details_25, t0.stripe_public_key AS stripe_public_key_26, t0.stripe_private_key AS stripe_private_key_27, t0.default_booking_amounts AS default_booking_amounts_28, t0.currency AS currency_29, t0.tax_rate AS tax_rate_30, t0.payment_reminder_schedule AS payment_reminder_schedule_31, t0.bank_account_name AS bank_account_name_32, t0.bank_name AS bank_name_33, t0.bank_routing_number AS bank_routing_number_34, t0.bank_wire_routing_number AS bank_wire_routing_number_35, t0.bank_international_wire_routing AS bank_international_wire_routing_36, t0.bank_swift_code AS bank_swift_code_37, t0.bank_account_number AS bank_account_number_38, t0.account_holder_address AS account_holder_address_39, t0.bank_address AS bank_address_40, t0.wire_transfer_instructions AS wire_transfer_instructions_41, t0.display_price_publicly AS display_price_publicly_42, t0.smtp_host AS smtp_host_43, t0.smtp_port AS smtp_port_44, t0.smtp_username AS smtp_username_45, t0.smtp_password AS smtp_password_46, t0.smtp_encryption AS smtp_encryption_47, t0.default_from_email AS default_from_email_48, t0.default_from_name AS default_from_name_49, t0.auto_send_welcome_letter AS auto_send_welcome_letter_50, t0.email_signature AS email_signature_51, t0.welcome_email_template AS welcome_email_template_52, t0.payment_reminder_email_template AS payment_reminder_email_template_53, t0.birthday_reminder_email_template AS birthday_reminder_email_template_54, t0.agreement_email_template AS agreement_email_template_55, t0.booking_confirmation_template AS booking_confirmation_template_56, t0.service_completion_template AS service_completion_template_57, t0.appointment_reminder_template AS appointment_reminder_template_58, t0.default_cancellation_policy AS default_cancellation_policy_59, t0.refund_policy_text AS refund_policy_text_60, t0.public_edit_mode AS public_edit_mode_61, t0.terms_and_conditions_text AS terms_and_conditions_text_62, t0.privacy_policy_text AS privacy_policy_text_63, t0.no_cure_disclaimer_text AS no_cure_disclaimer_text_64, t0.calendar_view_default AS calendar_view_default_65, t0.first_day_of_week AS first_day_of_week_66, t0.time_slot_intervals AS time_slot_intervals_67, t0.calendar_timezone AS calendar_timezone_68, t0.application_timezone AS application_timezone_69, t0.available_months_advance AS available_months_advance_70, t0.weekend_availability AS weekend_availability_71, t0.admin_notification_emails AS admin_notification_emails_72, t0.new_booking_notifications AS new_booking_notifications_73, t0.payment_received_notifications AS payment_received_notifications_74, t0.contact_form_notifications AS contact_form_notifications_75, t0.birthday_reminder_advance_days AS birthday_reminder_advance_days_76, t0.newsletter_from_address AS newsletter_from_address_77, t0.unsubscribe_page_text AS unsubscribe_page_text_78, t0.contact_form_auto_response AS contact_form_auto_response_79, t0.default_email_campaign_template AS default_email_campaign_template_80, t0.session_timeout_duration AS session_timeout_duration_81, t0.data_retention_period_days AS data_retention_period_days_82, t0.cookie_policy_text AS cookie_policy_text_83, t0.qualification_certificate_templates AS qualification_certificate_templates_84, t0.travel_cost_calculation_rules AS travel_cost_calculation_rules_85, t0.speaking_engagement_minimum_notice_hours AS speaking_engagement_minimum_notice_hours_86, t0.house_call_service_areas AS house_call_service_areas_87, t0.stripe_webhook_endpoint AS stripe_webhook_endpoint_88, t0.analytics_tracking_codes AS analytics_tracking_codes_89, t0.twilio_account_sid AS twilio_account_sid_90, t0.twilio_auth_token AS twilio_auth_token_91, t0.twilio_phone_number AS twilio_phone_number_92, t0.twilio_messaging_service_sid AS twilio_messaging_service_sid_93, t0.welcome_sequence_timing AS welcome_sequence_timing_94, t0.follow_up_email_schedules AS follow_up_email_schedules_95, t0.abandoned_booking_recovery_emails AS abandoned_booking_recovery_emails_96, t0.post_service_feedback_requests AS post_service_feedback_requests_97, t0.birthday_campaign_automation AS birthday_campaign_automation_98, t0.payment_reminder_sequences AS payment_reminder_sequences_99 FROM setting t0 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.28 ms (8.81%) |
5 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0 WHERE t0.description = ? LIMIT 1
Parameters:
[
"page_title_description"
]
|
||||||||||||||||||||||||||||
|
1.10 ms (7.54%) |
2 |
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.phone_number AS phone_number_3, t0.work_hours AS work_hours_4, t0.instagram_link AS instagram_link_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.tiktok_link AS tiktok_link_8, t0.business_location AS business_location_9, t0.twitter_link AS twitter_link_10, t0.linkedin_link AS linkedin_link_11, t0.google_map_embed AS google_map_embed_12, t0.email_address AS email_address_13, t0.whatsapp_number AS whatsapp_number_14, t0.website_tagline AS website_tagline_15, t0.primary_color AS primary_color_16, t0.secondary_color AS secondary_color_17, t0.background_color AS background_color_18, t0.custom_css_overrides AS custom_css_overrides_19, t0.booking_available_days AS booking_available_days_20, t0.automatic_confirmation AS automatic_confirmation_21, t0.booking_cutoff_hours AS booking_cutoff_hours_22, t0.default_payment_terms AS default_payment_terms_23, t0.late_payment_grace_period_days AS late_payment_grace_period_days_24, t0.wire_transfer_account_details AS wire_transfer_account_details_25, t0.stripe_public_key AS stripe_public_key_26, t0.stripe_private_key AS stripe_private_key_27, t0.default_booking_amounts AS default_booking_amounts_28, t0.currency AS currency_29, t0.tax_rate AS tax_rate_30, t0.payment_reminder_schedule AS payment_reminder_schedule_31, t0.bank_account_name AS bank_account_name_32, t0.bank_name AS bank_name_33, t0.bank_routing_number AS bank_routing_number_34, t0.bank_wire_routing_number AS bank_wire_routing_number_35, t0.bank_international_wire_routing AS bank_international_wire_routing_36, t0.bank_swift_code AS bank_swift_code_37, t0.bank_account_number AS bank_account_number_38, t0.account_holder_address AS account_holder_address_39, t0.bank_address AS bank_address_40, t0.wire_transfer_instructions AS wire_transfer_instructions_41, t0.display_price_publicly AS display_price_publicly_42, t0.smtp_host AS smtp_host_43, t0.smtp_port AS smtp_port_44, t0.smtp_username AS smtp_username_45, t0.smtp_password AS smtp_password_46, t0.smtp_encryption AS smtp_encryption_47, t0.default_from_email AS default_from_email_48, t0.default_from_name AS default_from_name_49, t0.auto_send_welcome_letter AS auto_send_welcome_letter_50, t0.email_signature AS email_signature_51, t0.welcome_email_template AS welcome_email_template_52, t0.payment_reminder_email_template AS payment_reminder_email_template_53, t0.birthday_reminder_email_template AS birthday_reminder_email_template_54, t0.agreement_email_template AS agreement_email_template_55, t0.booking_confirmation_template AS booking_confirmation_template_56, t0.service_completion_template AS service_completion_template_57, t0.appointment_reminder_template AS appointment_reminder_template_58, t0.default_cancellation_policy AS default_cancellation_policy_59, t0.refund_policy_text AS refund_policy_text_60, t0.public_edit_mode AS public_edit_mode_61, t0.terms_and_conditions_text AS terms_and_conditions_text_62, t0.privacy_policy_text AS privacy_policy_text_63, t0.no_cure_disclaimer_text AS no_cure_disclaimer_text_64, t0.calendar_view_default AS calendar_view_default_65, t0.first_day_of_week AS first_day_of_week_66, t0.time_slot_intervals AS time_slot_intervals_67, t0.calendar_timezone AS calendar_timezone_68, t0.application_timezone AS application_timezone_69, t0.available_months_advance AS available_months_advance_70, t0.weekend_availability AS weekend_availability_71, t0.admin_notification_emails AS admin_notification_emails_72, t0.new_booking_notifications AS new_booking_notifications_73, t0.payment_received_notifications AS payment_received_notifications_74, t0.contact_form_notifications AS contact_form_notifications_75, t0.birthday_reminder_advance_days AS birthday_reminder_advance_days_76, t0.newsletter_from_address AS newsletter_from_address_77, t0.unsubscribe_page_text AS unsubscribe_page_text_78, t0.contact_form_auto_response AS contact_form_auto_response_79, t0.default_email_campaign_template AS default_email_campaign_template_80, t0.session_timeout_duration AS session_timeout_duration_81, t0.data_retention_period_days AS data_retention_period_days_82, t0.cookie_policy_text AS cookie_policy_text_83, t0.qualification_certificate_templates AS qualification_certificate_templates_84, t0.travel_cost_calculation_rules AS travel_cost_calculation_rules_85, t0.speaking_engagement_minimum_notice_hours AS speaking_engagement_minimum_notice_hours_86, t0.house_call_service_areas AS house_call_service_areas_87, t0.stripe_webhook_endpoint AS stripe_webhook_endpoint_88, t0.analytics_tracking_codes AS analytics_tracking_codes_89, t0.twilio_account_sid AS twilio_account_sid_90, t0.twilio_auth_token AS twilio_auth_token_91, t0.twilio_phone_number AS twilio_phone_number_92, t0.twilio_messaging_service_sid AS twilio_messaging_service_sid_93, t0.welcome_sequence_timing AS welcome_sequence_timing_94, t0.follow_up_email_schedules AS follow_up_email_schedules_95, t0.abandoned_booking_recovery_emails AS abandoned_booking_recovery_emails_96, t0.post_service_feedback_requests AS post_service_feedback_requests_97, t0.birthday_campaign_automation AS birthday_campaign_automation_98, t0.payment_reminder_sequences AS payment_reminder_sequences_99 FROM setting t0
Parameters:
[] |
||||||||||||||||||||||||||||
|
1.07 ms (7.32%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.template_path AS template_path_3, t0.priority AS priority_4 FROM section t0 INNER JOIN page_section ON t0.id = page_section.section_id WHERE page_section.page_id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||
|
0.97 ms (6.65%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content_text AS content_text_4, t0.screenshot AS screenshot_5 FROM content t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.84 ms (5.75%) |
2 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.is_published = ? ORDER BY b0_.id DESC LIMIT 3
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.73 ms (5.00%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.service_type AS service_type_4, t0.duration AS duration_5, t0.full_fee AS full_fee_6, t0.booking_amount AS booking_amount_7, t0.starting_date_is_flexible AS starting_date_is_flexible_8, t0.duration_is_flexible AS duration_is_flexible_9, t0.conflicts_with_events AS conflicts_with_events_10, t0.can_book_service_only AS can_book_service_only_11, t0.missed_deadline_payment_forfeited AS missed_deadline_payment_forfeited_12, t0.slug AS slug_13, t0.is_active AS is_active_14, t0.requires_full_profile AS requires_full_profile_15, t0.image_url AS image_url_16, t0.max_participants AS max_participants_17, t0.icon_name AS icon_name_18, t0.terms_and_conditions AS terms_and_conditions_19, t0.testimonial_videos AS testimonial_videos_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22 FROM service t0 WHERE t0.is_active = ? ORDER BY t0.title ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.71 ms (4.87%) |
2 |
SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.meta_title AS meta_title_2, p0_.meta_description AS meta_description_3, p0_.url AS url_4, p0_.featured_image AS featured_image_5, p0_.page_content AS page_content_6, p0_.content_first AS content_first_7, p0_.is_service AS is_service_8, p0_.header AS header_9, p0_.type AS type_10, p0_.keywords AS keywords_11 FROM page p0_ WHERE p0_.is_service = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.68 ms (4.66%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.photo AS photo_4, t0.description AS description_5 FROM team_member t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.68 ms (4.65%) |
1 |
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3 FROM faq t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.68 ms (4.65%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.photo AS photo_3, t0.title AS title_4, t0.content AS content_5, t0.video_url AS video_url_6 FROM testimonials t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.63 ms (4.30%) |
2 |
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.light_logo_path AS light_logo_path_6, t0.keywords AS keywords_7 FROM seo t0
Parameters:
[] |
||||||||||||||||||||||||||||
|
0.62 ms (4.30%) |
1 |
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.logo_path AS logo_path_5, t0.light_logo_path AS light_logo_path_6, t0.keywords AS keywords_7 FROM seo t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.60 ms (4.12%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.51 ms (3.50%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.src AS src_4 FROM image t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"var-banner-image"
]
|
||||||||||||||||||||||||||||
|
0.46 ms (3.18%) |
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.publication_date AS publication_date_3, b0_.is_published AS is_published_4, b0_.slug AS slug_5, b0_.featured_image AS featured_image_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.video_url AS video_url_9, b0_.author_id AS author_id_10 FROM blog b0_ WHERE b0_.is_published = ? ORDER BY b0_.id DESC LIMIT 50
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.43 ms (2.98%) |
1 |
SELECT t0.id AS id_1, t0.heading AS heading_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.featured_image AS featured_image_6, t0.page_content AS page_content_7, t0.content_first AS content_first_8, t0.is_service AS is_service_9, t0.header AS header_10, t0.type AS type_11, t0.keywords AS keywords_12 FROM page t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"our-services"
]
|
||||||||||||||||||||||||||||
|
0.38 ms (2.64%) |
1 |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.description AS description_3 FROM blog_category t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.35 ms (2.43%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.url AS url_4, t0.thumbnail AS thumbnail_5, t0.category AS category_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM video t0
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\FAQ | 35 |
| App\Entity\BlogCategory | 21 |
| App\Entity\Service | 6 |
| App\Entity\Video | 6 |
| App\Entity\Page | 5 |
| App\Entity\Image | 5 |
| App\Entity\Section | 4 |
| App\Entity\Testimonials | 3 |
| App\Entity\Blog | 3 |
| App\Entity\TeamMember | 3 |
| App\Entity\Content | 1 |
| App\Entity\User | 1 |
| App\Entity\SEO | 1 |
| App\Entity\Setting | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Content | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Section | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Booking | No errors. |
| App\Entity\Calendar | No errors. |
| App\Entity\AvailabilityRule | No errors. |
| App\Entity\BlockedDate | No errors. |
| App\Entity\CalendarEvent | No errors. |
| App\Entity\Testimonials | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\FAQ | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\User | No errors. |
| App\Entity\BlogCategory | No errors. |
| App\Entity\TeamMember | No errors. |
| App\Entity\SEO | No errors. |
| App\Entity\Setting | No errors. |