Query Metrics
2
Database Queries
2
Different statements
2.68 ms
Query time
2
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.00 ms (37.39%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.personal_username AS personal_username_4, t0.roles AS roles_5, t0.companies AS companies_6, t0.active_company AS active_company_7, t0.password AS password_8, t0.database_name AS database_name_9, t0.last_logged_in AS last_logged_in_10, t0.stripe_subscription_id AS stripe_subscription_id_11, t0.stripe_subscription_status AS stripe_subscription_status_12, t0.stripe_subscription_updated_at AS stripe_subscription_updated_at_13, t0.scid AS scid_14, t0.last_shuttle_at AS last_shuttle_at_15, t0.preferences AS preferences_16, t0.business_name AS business_name_17, t0.human_name AS human_name_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t21.id AS id_22, t21.token AS token_23, t21.expires_at AS expires_at_24, t21.generated_at AS generated_at_25, t21.user_id AS user_id_26, t27.id AS id_28, t27.last_value_date AS last_value_date_29, t27.total_value_count AS total_value_count_30, t27.value_types_json AS value_types_json_31, t27.user_id AS user_id_32, t33.id AS id_34, t33.last_shuttle_at AS last_shuttle_at_35, t33.last_email_sent_at AS last_email_sent_at_36, t33.last_email_received_at AS last_email_received_at_37, t33.last_form_submit_at AS last_form_submit_at_38, t33.last_esign_at AS last_esign_at_39, t33.last_login_at AS last_login_at_40, t33.last_page_view_at AS last_page_view_at_41, t33.total_emails_sent AS total_emails_sent_42, t33.total_forms_received AS total_forms_received_43, t33.total_esigns AS total_esigns_44, t33.total_shuttles AS total_shuttles_45, t33.signup_at AS signup_at_46, t33.pulse_score AS pulse_score_47, t33.extended_json AS extended_json_48, t33.updated_at AS updated_at_49, t33.user_id AS user_id_50 FROM 001_login t0 LEFT JOIN 010_user_password_reset t21 ON t21.user_id = t0.id LEFT JOIN 950_meaus t27 ON t27.user_id = t0.id LEFT JOIN 951_account_pulse t33 ON t33.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters:
[
"support"
]
|
dynamic_conn connection
| Time▼ | Count | Info |
|---|---|---|
|
1.68 ms (62.61%) |
1 |
SELECT t0.id AS id_1, t0.owner_id AS owner_id_2, t0.type AS type_3, t0.name_display AS name_display_4, t0.name_original AS name_original_5, t0.file_url AS file_url_6, t0.file_icon AS file_icon_7, t0.parent_id AS parent_id_8, t0.permissions AS permissions_9, t0.status AS status_10, t0.slug AS slug_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t14.id AS id_15, t14.item_name AS item_name_16, t14.product_details AS product_details_17, t14.permission AS permission_18, t14.note AS note_19, t14.user_experience_flow AS user_experience_flow_20, t14.data_handling_automation AS data_handling_automation_21, t14.more_options AS more_options_22, t14.ez_link_detail AS ez_link_detail_23, t14.created_at AS created_at_24, t14.updated_at AS updated_at_25, t14.drive_id AS drive_id_26, t14.drive_form_id AS drive_form_id_27, t28.id AS id_29, t28.doc_name AS doc_name_30, t28.content AS content_31, t28.json_content AS json_content_32, t28.html_content AS html_content_33, t28.parent_doc AS parent_doc_34, t28.version_hash_key AS version_hash_key_35, t28.version_detail AS version_detail_36, t28.drive_all_id AS drive_all_id_37, t28.drive_form_id AS drive_form_id_38, t39.id AS id_40, t39.doc_name AS doc_name_41, t39.content AS content_42, t39.parent_doc AS parent_doc_43, t39.version_hash_key AS version_hash_key_44, t39.version_detail AS version_detail_45, t39.drive_all_id AS drive_all_id_46, t39.drive_form_id AS drive_form_id_47, t48.id AS id_49, t48.form_name AS form_name_50, t48.generate_type AS generate_type_51, t48.intak_form AS intak_form_52, t48.video_data AS video_data_53, t48.ue_flow AS ue_flow_54, t48.dh_automation AS dh_automation_55, t48.more_options AS more_options_56, t48.ez_link_detail AS ez_link_detail_57, t48.roles_automation AS roles_automation_58, t48.meta_json AS meta_json_59, t48.drive_all_id AS drive_all_id_60, t61.id AS id_62, t61.file AS file_63, t61.drive_all_id AS drive_all_id_64, t61.drive_form_id AS drive_form_id_65, t66.id AS id_67, t66.invoice_name AS invoice_name_68, t66.content AS content_69, t66.totalDue AS totalDue_70, t66.invoice_type AS invoice_type_71, t66.invoice_status AS invoice_status_72, t66.html_content AS html_content_73, t66.drive_all_id AS drive_all_id_74, t66.drive_form_id AS drive_form_id_75, t76.id AS id_77, t76.workroom_name AS workroom_name_78, t76.created_at AS created_at_79, t76.updated_at AS updated_at_80, t76.drive_all_id AS drive_all_id_81, t76.drive_form_id AS drive_form_id_82, t83.id AS id_84, t83.phone_type AS phone_type_85, t83.phone_number AS phone_number_86, t83.phone_number_sid AS phone_number_sid_87, t83.twilio_auth_token AS twilio_auth_token_88, t83.details AS details_89, t83.created_at AS created_at_90, t83.updated_at AS updated_at_91, t83.drive_all_id AS drive_all_id_92, t83.drive_form_id AS drive_form_id_93, t94.id AS id_95, t94.name AS name_96, t94.data_json AS data_json_97, t94.created_at AS created_at_98, t94.updated_at AS updated_at_99, t94.drive_all_id AS drive_all_id_100, t94.drive_form_id AS drive_form_id_101, t102.id AS id_103, t102.name AS name_104, t102.events_json AS events_json_105, t102.meta_json AS meta_json_106, t102.history_json AS history_json_107, t102.tags AS tags_108, t102.drive_id AS drive_id_109, t110.id AS id_111, t110.name AS name_112, t110.original AS original_113, t110.underlay AS underlay_114, t110.overlay AS overlay_115, t110.html_content AS html_content_116, t110.permissions_json AS permissions_json_117, t110.drive_all_id AS drive_all_id_118, t110.drive_form_id AS drive_form_id_119, t120.id AS id_121, t120.name AS name_122, t120.description AS description_123, t120.history_json AS history_json_124, t120.availability_json AS availability_json_125, t120.more_options AS more_options_126, t120.created_at AS created_at_127, t120.updated_at AS updated_at_128, t120.drive_id AS drive_id_129, t130.id AS id_131, t130.name AS name_132, t130.description AS description_133, t130.time_required_json AS time_required_json_134, t130.location_json AS location_json_135, t130.ticketed_json AS ticketed_json_136, t130.membership_json AS membership_json_137, t130.price AS price_138, t130.paper_work_id AS paper_work_id_139, t130.visibility AS visibility_140, t130.scheduler_id AS scheduler_id_141, t130.drive_form_id AS drive_form_id_142, t130.drive_id AS drive_id_143, t144.id AS id_145, t144.title AS title_146, t144.mapped_url AS mapped_url_147, t144.inbound_url AS inbound_url_148, t144.slug AS slug_149, t144.inbound_json AS inbound_json_150, t144.outbound_json AS outbound_json_151, t144.history_json AS history_json_152, t144.reporting_json AS reporting_json_153, t144.meta_json AS meta_json_154, t144.created_at AS created_at_155, t144.updated_at AS updated_at_156, t144.drive_all_id AS drive_all_id_157, t158.id AS id_159, t158.owner_contact_id AS owner_contact_id_160, t158.title AS title_161, t158.content_html AS content_html_162, t158.status AS status_163, t158.language_code AS language_code_164, t158.header_type AS header_type_165, t158.logo_file_id AS logo_file_id_166, t158.phone_primary AS phone_primary_167, t158.phone_options_json AS phone_options_json_168, t158.menus_json AS menus_json_169, t158.sidebar_widgets_json AS sidebar_widgets_json_170, t158.footer_html AS footer_html_171, t158.theme_bg_color AS theme_bg_color_172, t158.theme_font_color AS theme_font_color_173, t158.theme_hover_bg_color AS theme_hover_bg_color_174, t158.theme_hover_font_color AS theme_hover_font_color_175, t158.heading_font_family AS heading_font_family_176, t158.body_font_family AS body_font_family_177, t158.featured_image AS featured_image_178, t158.custom_css_file_id AS custom_css_file_id_179, t158.custom_js_file_id AS custom_js_file_id_180, t158.google_tag_id AS google_tag_id_181, t158.chatbot_enabled AS chatbot_enabled_182, t158.who_can_modify AS who_can_modify_183, t158.modify_users_json AS modify_users_json_184, t158.who_can_copy AS who_can_copy_185, t158.copy_password_hash AS copy_password_hash_186, t158.version AS version_187, t158.published_at AS published_at_188, t158.membership_page_doc_id AS membership_page_doc_id_189, t158.published_by AS published_by_190, t158.notes AS notes_191, t158.privacy AS privacy_192, t158.privacy_password_hash AS privacy_password_hash_193, t158.view_users_json AS view_users_json_194, t158.tags AS tags_195, t158.created_at AS created_at_196, t158.updated_at AS updated_at_197, t158.drive_all_id AS drive_all_id_198 FROM 300_drive_all t0 LEFT JOIN 304_drive_item t14 ON t14.drive_id = t0.id LEFT JOIN 301_drive_doc t28 ON t28.drive_all_id = t0.id LEFT JOIN 301_drive_code t39 ON t39.drive_all_id = t0.id LEFT JOIN 303_drive_form t48 ON t48.drive_all_id = t0.id LEFT JOIN 302_drive_storage t61 ON t61.drive_all_id = t0.id LEFT JOIN 340_drive_invoices t66 ON t66.drive_all_id = t0.id LEFT JOIN 305_drive_workroom t76 ON t76.drive_all_id = t0.id LEFT JOIN 609_twilio_phone t83 ON t83.drive_all_id = t0.id LEFT JOIN 308_drive_spreadsheet t94 ON t94.drive_all_id = t0.id LEFT JOIN 350_drive_sequence t102 ON t102.drive_id = t0.id LEFT JOIN 306_drive_esign_overlay t110 ON t110.drive_all_id = t0.id LEFT JOIN 520_drive_scheduler t120 ON t120.drive_id = t0.id LEFT JOIN 525_scheduler_service t130 ON t130.drive_id = t0.id LEFT JOIN 005_mapped_url t144 ON t144.drive_all_id = t0.id LEFT JOIN 320_website t158 ON t158.drive_all_id = t0.id WHERE t0.file_url = ? LIMIT 1
Parameters:
[
"security"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| dynamic_conn | doctrine.dbal.dynamic_conn_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| dynamic_conn | doctrine.orm.dynamic_conn_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Main\User | No errors. |
| App\Entity\Main\UserPasswordReset | No errors. |
| App\Entity\Main\Meaus | No errors. |
| App\Entity\Main\AccountPulse | No errors. |
dynamic_conn entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User\DriveAll |
|
| App\Entity\User\DriveItem | No errors. |
| App\Entity\User\DriveForm | No errors. |
| App\Entity\User\DriveDoc | No errors. |
| App\Entity\User\DriveCode | No errors. |
| App\Entity\User\DriveStorage | No errors. |
| App\Entity\User\DriveInvoice | No errors. |
| App\Entity\User\DriveWorkroom |
|
| App\Entity\User\TwilioPhone | No errors. |
| App\Entity\User\DriveSpreadSheet | No errors. |
| App\Entity\User\DriveSequence | No errors. |
| App\Entity\User\DriveESignOverlay | No errors. |
| App\Entity\User\DriveScheduler | No errors. |
| App\Entity\User\SchedulerService | No errors. |
| App\Entity\User\MappedUrl | No errors. |
| App\Entity\User\Website | No errors. |