Symfony Profiler

Query Metrics

19 Database Queries

15 Different statements

17.31 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
1.30 ms (7.53%)	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: [`"template_activity"`] View formatted query View runnable query Explain query 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 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 = 'template_activity' LIMIT 1;
0.91 ms (5.26%)	1	SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.symbol AS symbol_2, t0_.name AS name_3, t0_.icon AS icon_4 FROM 807_currency t0_ WHERE t0_.code = ? Parameters: [`"USD"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.symbol AS symbol_2, t0_.name AS name_3, t0_.icon AS icon_4 FROM 807_currency t0_ WHERE t0_.code = ? SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.symbol AS symbol_2, t0_.name AS name_3, t0_.icon AS icon_4 FROM 807_currency t0_ WHERE t0_.code = 'USD';

Time▼

Count

Info

1.30 ms
(7.53%)

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:

[
  "template_activity"
]

View formatted query View runnable query Explain query

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

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 = 'template_activity' LIMIT 1;

0.91 ms
(5.26%)

SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.symbol AS symbol_2, t0_.name AS name_3, t0_.icon AS icon_4 FROM 807_currency t0_ WHERE t0_.code = ?

Parameters:

[
  "USD"
]

View formatted query View runnable query Explain query

SELECT
  t0_.id AS id_0,
  t0_.code AS code_1,
  t0_.symbol AS symbol_2,
  t0_.name AS name_3,
  t0_.icon AS icon_4
FROM
  807_currency t0_
WHERE
  t0_.code = ?

SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.symbol AS symbol_2, t0_.name AS name_3, t0_.icon AS icon_4 FROM 807_currency t0_ WHERE t0_.code = 'USD';

dynamic_conn connection

Time▼	Count	Info
3.99 ms (23.06%)	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.slug = ? LIMIT 1 Parameters: [`"kayak_liability_waiver"`] View formatted query View runnable query Explain query 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.slug = ? LIMIT 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.slug = 'kayak_liability_waiver' LIMIT 1;
3.12 ms (18.05%)	5	SELECT t0.id AS id_1, t0.value AS value_2, t0.type AS type_3, t0.privacy AS privacy_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM 001_setting_essential t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"FirstName"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.value AS value_2, t0.type AS type_3, t0.privacy AS privacy_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM 001_setting_essential t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.value AS value_2, t0.type AS type_3, t0.privacy AS privacy_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM 001_setting_essential t0 WHERE t0.type = 'FirstName' LIMIT 1;
1.29 ms (7.46%)	1	SELECT t0.id AS id_1, t0.doc_name AS doc_name_2, t0.content AS content_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.parent_doc AS parent_doc_6, t0.version_hash_key AS version_hash_key_7, t0.version_detail AS version_detail_8, t0.drive_all_id AS drive_all_id_9, t10.id AS id_11, t10.owner_id AS owner_id_12, t10.type AS type_13, t10.name_display AS name_display_14, t10.name_original AS name_original_15, t10.file_url AS file_url_16, t10.file_icon AS file_icon_17, t10.parent_id AS parent_id_18, t10.permissions AS permissions_19, t10.status AS status_20, t10.slug AS slug_21, t10.created_at AS created_at_22, t10.updated_at AS updated_at_23, t0.drive_form_id AS drive_form_id_24, t25.id AS id_26, t25.form_name AS form_name_27, t25.generate_type AS generate_type_28, t25.intak_form AS intak_form_29, t25.video_data AS video_data_30, t25.ue_flow AS ue_flow_31, t25.dh_automation AS dh_automation_32, t25.more_options AS more_options_33, t25.ez_link_detail AS ez_link_detail_34, t25.roles_automation AS roles_automation_35, t25.meta_json AS meta_json_36, t25.drive_all_id AS drive_all_id_37 FROM 301_drive_doc t0 LEFT JOIN 300_drive_all t10 ON t0.drive_all_id = t10.id LEFT JOIN 303_drive_form t25 ON t0.drive_form_id = t25.id WHERE t0.drive_form_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.doc_name AS doc_name_2, t0.content AS content_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.parent_doc AS parent_doc_6, t0.version_hash_key AS version_hash_key_7, t0.version_detail AS version_detail_8, t0.drive_all_id AS drive_all_id_9, t10.id AS id_11, t10.owner_id AS owner_id_12, t10.type AS type_13, t10.name_display AS name_display_14, t10.name_original AS name_original_15, t10.file_url AS file_url_16, t10.file_icon AS file_icon_17, t10.parent_id AS parent_id_18, t10.permissions AS permissions_19, t10.status AS status_20, t10.slug AS slug_21, t10.created_at AS created_at_22, t10.updated_at AS updated_at_23, t0.drive_form_id AS drive_form_id_24, t25.id AS id_26, t25.form_name AS form_name_27, t25.generate_type AS generate_type_28, t25.intak_form AS intak_form_29, t25.video_data AS video_data_30, t25.ue_flow AS ue_flow_31, t25.dh_automation AS dh_automation_32, t25.more_options AS more_options_33, t25.ez_link_detail AS ez_link_detail_34, t25.roles_automation AS roles_automation_35, t25.meta_json AS meta_json_36, t25.drive_all_id AS drive_all_id_37 FROM 301_drive_doc t0 LEFT JOIN 300_drive_all t10 ON t0.drive_all_id = t10.id LEFT JOIN 303_drive_form t25 ON t0.drive_form_id = t25.id WHERE t0.drive_form_id = ? SELECT t0.id AS id_1, t0.doc_name AS doc_name_2, t0.content AS content_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.parent_doc AS parent_doc_6, t0.version_hash_key AS version_hash_key_7, t0.version_detail AS version_detail_8, t0.drive_all_id AS drive_all_id_9, t10.id AS id_11, t10.owner_id AS owner_id_12, t10.type AS type_13, t10.name_display AS name_display_14, t10.name_original AS name_original_15, t10.file_url AS file_url_16, t10.file_icon AS file_icon_17, t10.parent_id AS parent_id_18, t10.permissions AS permissions_19, t10.status AS status_20, t10.slug AS slug_21, t10.created_at AS created_at_22, t10.updated_at AS updated_at_23, t0.drive_form_id AS drive_form_id_24, t25.id AS id_26, t25.form_name AS form_name_27, t25.generate_type AS generate_type_28, t25.intak_form AS intak_form_29, t25.video_data AS video_data_30, t25.ue_flow AS ue_flow_31, t25.dh_automation AS dh_automation_32, t25.more_options AS more_options_33, t25.ez_link_detail AS ez_link_detail_34, t25.roles_automation AS roles_automation_35, t25.meta_json AS meta_json_36, t25.drive_all_id AS drive_all_id_37 FROM 301_drive_doc t0 LEFT JOIN 300_drive_all t10 ON t0.drive_all_id = t10.id LEFT JOIN 303_drive_form t25 ON t0.drive_form_id = t25.id WHERE t0.drive_form_id = 22;
1.04 ms (6.01%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.time_required_json AS time_required_json_4, t0.location_json AS location_json_5, t0.ticketed_json AS ticketed_json_6, t0.membership_json AS membership_json_7, t0.price AS price_8, t0.paper_work_id AS paper_work_id_9, t0.visibility AS visibility_10, t0.scheduler_id AS scheduler_id_11, t12.id AS id_13, t12.name AS name_14, t12.description AS description_15, t12.history_json AS history_json_16, t12.availability_json AS availability_json_17, t12.more_options AS more_options_18, t12.created_at AS created_at_19, t12.updated_at AS updated_at_20, t12.drive_id AS drive_id_21, t0.drive_form_id AS drive_form_id_22, t23.id AS id_24, t23.form_name AS form_name_25, t23.generate_type AS generate_type_26, t23.intak_form AS intak_form_27, t23.video_data AS video_data_28, t23.ue_flow AS ue_flow_29, t23.dh_automation AS dh_automation_30, t23.more_options AS more_options_31, t23.ez_link_detail AS ez_link_detail_32, t23.roles_automation AS roles_automation_33, t23.meta_json AS meta_json_34, t23.drive_all_id AS drive_all_id_35, t0.drive_id AS drive_id_36 FROM 525_scheduler_service t0 LEFT JOIN 520_drive_scheduler t12 ON t0.scheduler_id = t12.id LEFT JOIN 303_drive_form t23 ON t0.drive_form_id = t23.id WHERE t0.drive_form_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.time_required_json AS time_required_json_4, t0.location_json AS location_json_5, t0.ticketed_json AS ticketed_json_6, t0.membership_json AS membership_json_7, t0.price AS price_8, t0.paper_work_id AS paper_work_id_9, t0.visibility AS visibility_10, t0.scheduler_id AS scheduler_id_11, t12.id AS id_13, t12.name AS name_14, t12.description AS description_15, t12.history_json AS history_json_16, t12.availability_json AS availability_json_17, t12.more_options AS more_options_18, t12.created_at AS created_at_19, t12.updated_at AS updated_at_20, t12.drive_id AS drive_id_21, t0.drive_form_id AS drive_form_id_22, t23.id AS id_24, t23.form_name AS form_name_25, t23.generate_type AS generate_type_26, t23.intak_form AS intak_form_27, t23.video_data AS video_data_28, t23.ue_flow AS ue_flow_29, t23.dh_automation AS dh_automation_30, t23.more_options AS more_options_31, t23.ez_link_detail AS ez_link_detail_32, t23.roles_automation AS roles_automation_33, t23.meta_json AS meta_json_34, t23.drive_all_id AS drive_all_id_35, t0.drive_id AS drive_id_36 FROM 525_scheduler_service t0 LEFT JOIN 520_drive_scheduler t12 ON t0.scheduler_id = t12.id LEFT JOIN 303_drive_form t23 ON t0.drive_form_id = t23.id WHERE t0.drive_form_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.time_required_json AS time_required_json_4, t0.location_json AS location_json_5, t0.ticketed_json AS ticketed_json_6, t0.membership_json AS membership_json_7, t0.price AS price_8, t0.paper_work_id AS paper_work_id_9, t0.visibility AS visibility_10, t0.scheduler_id AS scheduler_id_11, t12.id AS id_13, t12.name AS name_14, t12.description AS description_15, t12.history_json AS history_json_16, t12.availability_json AS availability_json_17, t12.more_options AS more_options_18, t12.created_at AS created_at_19, t12.updated_at AS updated_at_20, t12.drive_id AS drive_id_21, t0.drive_form_id AS drive_form_id_22, t23.id AS id_24, t23.form_name AS form_name_25, t23.generate_type AS generate_type_26, t23.intak_form AS intak_form_27, t23.video_data AS video_data_28, t23.ue_flow AS ue_flow_29, t23.dh_automation AS dh_automation_30, t23.more_options AS more_options_31, t23.ez_link_detail AS ez_link_detail_32, t23.roles_automation AS roles_automation_33, t23.meta_json AS meta_json_34, t23.drive_all_id AS drive_all_id_35, t0.drive_id AS drive_id_36 FROM 525_scheduler_service t0 LEFT JOIN 520_drive_scheduler t12 ON t0.scheduler_id = t12.id LEFT JOIN 303_drive_form t23 ON t0.drive_form_id = t23.id WHERE t0.drive_form_id = 22;
0.88 ms (5.08%)	1	SELECT t0.id AS id_1, t0.workroom_name AS workroom_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.drive_all_id AS drive_all_id_5, t6.id AS id_7, t6.owner_id AS owner_id_8, t6.type AS type_9, t6.name_display AS name_display_10, t6.name_original AS name_original_11, t6.file_url AS file_url_12, t6.file_icon AS file_icon_13, t6.parent_id AS parent_id_14, t6.permissions AS permissions_15, t6.status AS status_16, t6.slug AS slug_17, t6.created_at AS created_at_18, t6.updated_at AS updated_at_19, t0.drive_form_id AS drive_form_id_20, t21.id AS id_22, t21.form_name AS form_name_23, t21.generate_type AS generate_type_24, t21.intak_form AS intak_form_25, t21.video_data AS video_data_26, t21.ue_flow AS ue_flow_27, t21.dh_automation AS dh_automation_28, t21.more_options AS more_options_29, t21.ez_link_detail AS ez_link_detail_30, t21.roles_automation AS roles_automation_31, t21.meta_json AS meta_json_32, t21.drive_all_id AS drive_all_id_33, t34.id AS id_35, t34.name AS name_36, t34.type AS type_37, t34.permission AS permission_38, t34.privacy AS privacy_39, t34.role_type AS role_type_40, t34.role AS role_41, t34.data_is_for AS data_is_for_42, t34.request_via AS request_via_43, t34.status AS status_44, t34.click_through_url AS click_through_url_45, t34.remove_receipt AS remove_receipt_46, t34.pause_sequence AS pause_sequence_47, t34.tags AS tags_48, t34.meta_json AS meta_json_49, t34.created_at AS created_at_50, t34.updated_at AS updated_at_51, t34.contact_group_id AS contact_group_id_52, t34.doc_id AS doc_id_53, t34.drive_workroom_id AS drive_workroom_id_54 FROM 305_drive_workroom t0 LEFT JOIN 300_drive_all t6 ON t0.drive_all_id = t6.id LEFT JOIN 303_drive_form t21 ON t0.drive_form_id = t21.id LEFT JOIN 700_campaigns t34 ON t34.drive_workroom_id = t0.id WHERE t0.drive_form_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.workroom_name AS workroom_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.drive_all_id AS drive_all_id_5, t6.id AS id_7, t6.owner_id AS owner_id_8, t6.type AS type_9, t6.name_display AS name_display_10, t6.name_original AS name_original_11, t6.file_url AS file_url_12, t6.file_icon AS file_icon_13, t6.parent_id AS parent_id_14, t6.permissions AS permissions_15, t6.status AS status_16, t6.slug AS slug_17, t6.created_at AS created_at_18, t6.updated_at AS updated_at_19, t0.drive_form_id AS drive_form_id_20, t21.id AS id_22, t21.form_name AS form_name_23, t21.generate_type AS generate_type_24, t21.intak_form AS intak_form_25, t21.video_data AS video_data_26, t21.ue_flow AS ue_flow_27, t21.dh_automation AS dh_automation_28, t21.more_options AS more_options_29, t21.ez_link_detail AS ez_link_detail_30, t21.roles_automation AS roles_automation_31, t21.meta_json AS meta_json_32, t21.drive_all_id AS drive_all_id_33, t34.id AS id_35, t34.name AS name_36, t34.type AS type_37, t34.permission AS permission_38, t34.privacy AS privacy_39, t34.role_type AS role_type_40, t34.role AS role_41, t34.data_is_for AS data_is_for_42, t34.request_via AS request_via_43, t34.status AS status_44, t34.click_through_url AS click_through_url_45, t34.remove_receipt AS remove_receipt_46, t34.pause_sequence AS pause_sequence_47, t34.tags AS tags_48, t34.meta_json AS meta_json_49, t34.created_at AS created_at_50, t34.updated_at AS updated_at_51, t34.contact_group_id AS contact_group_id_52, t34.doc_id AS doc_id_53, t34.drive_workroom_id AS drive_workroom_id_54 FROM 305_drive_workroom t0 LEFT JOIN 300_drive_all t6 ON t0.drive_all_id = t6.id LEFT JOIN 303_drive_form t21 ON t0.drive_form_id = t21.id LEFT JOIN 700_campaigns t34 ON t34.drive_workroom_id = t0.id WHERE t0.drive_form_id = ? SELECT t0.id AS id_1, t0.workroom_name AS workroom_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.drive_all_id AS drive_all_id_5, t6.id AS id_7, t6.owner_id AS owner_id_8, t6.type AS type_9, t6.name_display AS name_display_10, t6.name_original AS name_original_11, t6.file_url AS file_url_12, t6.file_icon AS file_icon_13, t6.parent_id AS parent_id_14, t6.permissions AS permissions_15, t6.status AS status_16, t6.slug AS slug_17, t6.created_at AS created_at_18, t6.updated_at AS updated_at_19, t0.drive_form_id AS drive_form_id_20, t21.id AS id_22, t21.form_name AS form_name_23, t21.generate_type AS generate_type_24, t21.intak_form AS intak_form_25, t21.video_data AS video_data_26, t21.ue_flow AS ue_flow_27, t21.dh_automation AS dh_automation_28, t21.more_options AS more_options_29, t21.ez_link_detail AS ez_link_detail_30, t21.roles_automation AS roles_automation_31, t21.meta_json AS meta_json_32, t21.drive_all_id AS drive_all_id_33, t34.id AS id_35, t34.name AS name_36, t34.type AS type_37, t34.permission AS permission_38, t34.privacy AS privacy_39, t34.role_type AS role_type_40, t34.role AS role_41, t34.data_is_for AS data_is_for_42, t34.request_via AS request_via_43, t34.status AS status_44, t34.click_through_url AS click_through_url_45, t34.remove_receipt AS remove_receipt_46, t34.pause_sequence AS pause_sequence_47, t34.tags AS tags_48, t34.meta_json AS meta_json_49, t34.created_at AS created_at_50, t34.updated_at AS updated_at_51, t34.contact_group_id AS contact_group_id_52, t34.doc_id AS doc_id_53, t34.drive_workroom_id AS drive_workroom_id_54 FROM 305_drive_workroom t0 LEFT JOIN 300_drive_all t6 ON t0.drive_all_id = t6.id LEFT JOIN 303_drive_form t21 ON t0.drive_form_id = t21.id LEFT JOIN 700_campaigns t34 ON t34.drive_workroom_id = t0.id WHERE t0.drive_form_id = 22;
0.81 ms (4.67%)	1	SELECT t0_.id AS id_0, t0_.value AS value_1, t0_.type AS type_2, t0_.privacy AS privacy_3, t0_.position AS position_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6 FROM 001_setting_essential t0_ WHERE t0_.type IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"BrandingSetting" "BrandingLightBgLogo" "BrandingDarkBgLogo" "BrandingFavicon" "BrandingCustomBg" "BrandingLightBgColor" "BrandingDarkBgColor" "BrandingAccentLighterColor" "BrandingAccentDarkerColor" "BrandingFont"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.value AS value_1, t0_.type AS type_2, t0_.privacy AS privacy_3, t0_.position AS position_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6 FROM 001_setting_essential t0_ WHERE t0_.type IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT t0_.id AS id_0, t0_.value AS value_1, t0_.type AS type_2, t0_.privacy AS privacy_3, t0_.position AS position_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6 FROM 001_setting_essential t0_ WHERE t0_.type IN ('BrandingSetting', 'BrandingLightBgLogo', 'BrandingDarkBgLogo', 'BrandingFavicon', 'BrandingCustomBg', 'BrandingLightBgColor', 'BrandingDarkBgColor', 'BrandingAccentLighterColor', 'BrandingAccentDarkerColor', 'BrandingFont');
0.67 ms (3.85%)	1	SELECT t0.id AS id_1, t0.doc_name AS doc_name_2, t0.content AS content_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.parent_doc AS parent_doc_6, t0.version_hash_key AS version_hash_key_7, t0.version_detail AS version_detail_8, t0.drive_all_id AS drive_all_id_9, t10.id AS id_11, t10.owner_id AS owner_id_12, t10.type AS type_13, t10.name_display AS name_display_14, t10.name_original AS name_original_15, t10.file_url AS file_url_16, t10.file_icon AS file_icon_17, t10.parent_id AS parent_id_18, t10.permissions AS permissions_19, t10.status AS status_20, t10.slug AS slug_21, t10.created_at AS created_at_22, t10.updated_at AS updated_at_23, t0.drive_form_id AS drive_form_id_24, t25.id AS id_26, t25.form_name AS form_name_27, t25.generate_type AS generate_type_28, t25.intak_form AS intak_form_29, t25.video_data AS video_data_30, t25.ue_flow AS ue_flow_31, t25.dh_automation AS dh_automation_32, t25.more_options AS more_options_33, t25.ez_link_detail AS ez_link_detail_34, t25.roles_automation AS roles_automation_35, t25.meta_json AS meta_json_36, t25.drive_all_id AS drive_all_id_37 FROM 301_drive_doc t0 LEFT JOIN 300_drive_all t10 ON t0.drive_all_id = t10.id LEFT JOIN 303_drive_form t25 ON t0.drive_form_id = t25.id WHERE t0.drive_all_id = ? LIMIT 1 Parameters: [`23`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.doc_name AS doc_name_2, t0.content AS content_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.parent_doc AS parent_doc_6, t0.version_hash_key AS version_hash_key_7, t0.version_detail AS version_detail_8, t0.drive_all_id AS drive_all_id_9, t10.id AS id_11, t10.owner_id AS owner_id_12, t10.type AS type_13, t10.name_display AS name_display_14, t10.name_original AS name_original_15, t10.file_url AS file_url_16, t10.file_icon AS file_icon_17, t10.parent_id AS parent_id_18, t10.permissions AS permissions_19, t10.status AS status_20, t10.slug AS slug_21, t10.created_at AS created_at_22, t10.updated_at AS updated_at_23, t0.drive_form_id AS drive_form_id_24, t25.id AS id_26, t25.form_name AS form_name_27, t25.generate_type AS generate_type_28, t25.intak_form AS intak_form_29, t25.video_data AS video_data_30, t25.ue_flow AS ue_flow_31, t25.dh_automation AS dh_automation_32, t25.more_options AS more_options_33, t25.ez_link_detail AS ez_link_detail_34, t25.roles_automation AS roles_automation_35, t25.meta_json AS meta_json_36, t25.drive_all_id AS drive_all_id_37 FROM 301_drive_doc t0 LEFT JOIN 300_drive_all t10 ON t0.drive_all_id = t10.id LEFT JOIN 303_drive_form t25 ON t0.drive_form_id = t25.id WHERE t0.drive_all_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.doc_name AS doc_name_2, t0.content AS content_3, t0.json_content AS json_content_4, t0.html_content AS html_content_5, t0.parent_doc AS parent_doc_6, t0.version_hash_key AS version_hash_key_7, t0.version_detail AS version_detail_8, t0.drive_all_id AS drive_all_id_9, t10.id AS id_11, t10.owner_id AS owner_id_12, t10.type AS type_13, t10.name_display AS name_display_14, t10.name_original AS name_original_15, t10.file_url AS file_url_16, t10.file_icon AS file_icon_17, t10.parent_id AS parent_id_18, t10.permissions AS permissions_19, t10.status AS status_20, t10.slug AS slug_21, t10.created_at AS created_at_22, t10.updated_at AS updated_at_23, t0.drive_form_id AS drive_form_id_24, t25.id AS id_26, t25.form_name AS form_name_27, t25.generate_type AS generate_type_28, t25.intak_form AS intak_form_29, t25.video_data AS video_data_30, t25.ue_flow AS ue_flow_31, t25.dh_automation AS dh_automation_32, t25.more_options AS more_options_33, t25.ez_link_detail AS ez_link_detail_34, t25.roles_automation AS roles_automation_35, t25.meta_json AS meta_json_36, t25.drive_all_id AS drive_all_id_37 FROM 301_drive_doc t0 LEFT JOIN 300_drive_all t10 ON t0.drive_all_id = t10.id LEFT JOIN 303_drive_form t25 ON t0.drive_form_id = t25.id WHERE t0.drive_all_id = 23 LIMIT 1;
0.66 ms (3.80%)	1	SELECT t0.id AS id_1, t0.phone_type AS phone_type_2, t0.phone_number AS phone_number_3, t0.phone_number_sid AS phone_number_sid_4, t0.twilio_auth_token AS twilio_auth_token_5, t0.details AS details_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.drive_all_id AS drive_all_id_9, t0.drive_form_id AS drive_form_id_10 FROM 609_twilio_phone t0 WHERE t0.drive_form_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.phone_type AS phone_type_2, t0.phone_number AS phone_number_3, t0.phone_number_sid AS phone_number_sid_4, t0.twilio_auth_token AS twilio_auth_token_5, t0.details AS details_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.drive_all_id AS drive_all_id_9, t0.drive_form_id AS drive_form_id_10 FROM 609_twilio_phone t0 WHERE t0.drive_form_id = ? SELECT t0.id AS id_1, t0.phone_type AS phone_type_2, t0.phone_number AS phone_number_3, t0.phone_number_sid AS phone_number_sid_4, t0.twilio_auth_token AS twilio_auth_token_5, t0.details AS details_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.drive_all_id AS drive_all_id_9, t0.drive_form_id AS drive_form_id_10 FROM 609_twilio_phone t0 WHERE t0.drive_form_id = 22;
0.63 ms (3.66%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.data_json AS data_json_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.drive_all_id AS drive_all_id_6, t7.id AS id_8, t7.owner_id AS owner_id_9, t7.type AS type_10, t7.name_display AS name_display_11, t7.name_original AS name_original_12, t7.file_url AS file_url_13, t7.file_icon AS file_icon_14, t7.parent_id AS parent_id_15, t7.permissions AS permissions_16, t7.status AS status_17, t7.slug AS slug_18, t7.created_at AS created_at_19, t7.updated_at AS updated_at_20, t0.drive_form_id AS drive_form_id_21, t22.id AS id_23, t22.form_name AS form_name_24, t22.generate_type AS generate_type_25, t22.intak_form AS intak_form_26, t22.video_data AS video_data_27, t22.ue_flow AS ue_flow_28, t22.dh_automation AS dh_automation_29, t22.more_options AS more_options_30, t22.ez_link_detail AS ez_link_detail_31, t22.roles_automation AS roles_automation_32, t22.meta_json AS meta_json_33, t22.drive_all_id AS drive_all_id_34 FROM 308_drive_spreadsheet t0 LEFT JOIN 300_drive_all t7 ON t0.drive_all_id = t7.id LEFT JOIN 303_drive_form t22 ON t0.drive_form_id = t22.id WHERE t0.drive_form_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.data_json AS data_json_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.drive_all_id AS drive_all_id_6, t7.id AS id_8, t7.owner_id AS owner_id_9, t7.type AS type_10, t7.name_display AS name_display_11, t7.name_original AS name_original_12, t7.file_url AS file_url_13, t7.file_icon AS file_icon_14, t7.parent_id AS parent_id_15, t7.permissions AS permissions_16, t7.status AS status_17, t7.slug AS slug_18, t7.created_at AS created_at_19, t7.updated_at AS updated_at_20, t0.drive_form_id AS drive_form_id_21, t22.id AS id_23, t22.form_name AS form_name_24, t22.generate_type AS generate_type_25, t22.intak_form AS intak_form_26, t22.video_data AS video_data_27, t22.ue_flow AS ue_flow_28, t22.dh_automation AS dh_automation_29, t22.more_options AS more_options_30, t22.ez_link_detail AS ez_link_detail_31, t22.roles_automation AS roles_automation_32, t22.meta_json AS meta_json_33, t22.drive_all_id AS drive_all_id_34 FROM 308_drive_spreadsheet t0 LEFT JOIN 300_drive_all t7 ON t0.drive_all_id = t7.id LEFT JOIN 303_drive_form t22 ON t0.drive_form_id = t22.id WHERE t0.drive_form_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.data_json AS data_json_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.drive_all_id AS drive_all_id_6, t7.id AS id_8, t7.owner_id AS owner_id_9, t7.type AS type_10, t7.name_display AS name_display_11, t7.name_original AS name_original_12, t7.file_url AS file_url_13, t7.file_icon AS file_icon_14, t7.parent_id AS parent_id_15, t7.permissions AS permissions_16, t7.status AS status_17, t7.slug AS slug_18, t7.created_at AS created_at_19, t7.updated_at AS updated_at_20, t0.drive_form_id AS drive_form_id_21, t22.id AS id_23, t22.form_name AS form_name_24, t22.generate_type AS generate_type_25, t22.intak_form AS intak_form_26, t22.video_data AS video_data_27, t22.ue_flow AS ue_flow_28, t22.dh_automation AS dh_automation_29, t22.more_options AS more_options_30, t22.ez_link_detail AS ez_link_detail_31, t22.roles_automation AS roles_automation_32, t22.meta_json AS meta_json_33, t22.drive_all_id AS drive_all_id_34 FROM 308_drive_spreadsheet t0 LEFT JOIN 300_drive_all t7 ON t0.drive_all_id = t7.id LEFT JOIN 303_drive_form t22 ON t0.drive_form_id = t22.id WHERE t0.drive_form_id = 22;
0.63 ms (3.64%)	1	SELECT t0.id AS id_1, t0.item_name AS item_name_2, t0.product_details AS product_details_3, t0.permission AS permission_4, t0.note AS note_5, t0.user_experience_flow AS user_experience_flow_6, t0.data_handling_automation AS data_handling_automation_7, t0.more_options AS more_options_8, t0.ez_link_detail AS ez_link_detail_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.drive_id AS drive_id_12, t0.drive_form_id AS drive_form_id_13, t14.id AS id_15, t14.form_name AS form_name_16, t14.generate_type AS generate_type_17, t14.intak_form AS intak_form_18, t14.video_data AS video_data_19, t14.ue_flow AS ue_flow_20, t14.dh_automation AS dh_automation_21, t14.more_options AS more_options_22, t14.ez_link_detail AS ez_link_detail_23, t14.roles_automation AS roles_automation_24, t14.meta_json AS meta_json_25, t14.drive_all_id AS drive_all_id_26 FROM 304_drive_item t0 LEFT JOIN 303_drive_form t14 ON t0.drive_form_id = t14.id WHERE t0.drive_form_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.item_name AS item_name_2, t0.product_details AS product_details_3, t0.permission AS permission_4, t0.note AS note_5, t0.user_experience_flow AS user_experience_flow_6, t0.data_handling_automation AS data_handling_automation_7, t0.more_options AS more_options_8, t0.ez_link_detail AS ez_link_detail_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.drive_id AS drive_id_12, t0.drive_form_id AS drive_form_id_13, t14.id AS id_15, t14.form_name AS form_name_16, t14.generate_type AS generate_type_17, t14.intak_form AS intak_form_18, t14.video_data AS video_data_19, t14.ue_flow AS ue_flow_20, t14.dh_automation AS dh_automation_21, t14.more_options AS more_options_22, t14.ez_link_detail AS ez_link_detail_23, t14.roles_automation AS roles_automation_24, t14.meta_json AS meta_json_25, t14.drive_all_id AS drive_all_id_26 FROM 304_drive_item t0 LEFT JOIN 303_drive_form t14 ON t0.drive_form_id = t14.id WHERE t0.drive_form_id = ? SELECT t0.id AS id_1, t0.item_name AS item_name_2, t0.product_details AS product_details_3, t0.permission AS permission_4, t0.note AS note_5, t0.user_experience_flow AS user_experience_flow_6, t0.data_handling_automation AS data_handling_automation_7, t0.more_options AS more_options_8, t0.ez_link_detail AS ez_link_detail_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.drive_id AS drive_id_12, t0.drive_form_id AS drive_form_id_13, t14.id AS id_15, t14.form_name AS form_name_16, t14.generate_type AS generate_type_17, t14.intak_form AS intak_form_18, t14.video_data AS video_data_19, t14.ue_flow AS ue_flow_20, t14.dh_automation AS dh_automation_21, t14.more_options AS more_options_22, t14.ez_link_detail AS ez_link_detail_23, t14.roles_automation AS roles_automation_24, t14.meta_json AS meta_json_25, t14.drive_all_id AS drive_all_id_26 FROM 304_drive_item t0 LEFT JOIN 303_drive_form t14 ON t0.drive_form_id = t14.id WHERE t0.drive_form_id = 22;
0.51 ms (2.92%)	1	SELECT t0.id AS id_1, t0.file AS file_2, t0.drive_all_id AS drive_all_id_3, t4.id AS id_5, t4.owner_id AS owner_id_6, t4.type AS type_7, t4.name_display AS name_display_8, t4.name_original AS name_original_9, t4.file_url AS file_url_10, t4.file_icon AS file_icon_11, t4.parent_id AS parent_id_12, t4.permissions AS permissions_13, t4.status AS status_14, t4.slug AS slug_15, t4.created_at AS created_at_16, t4.updated_at AS updated_at_17, t0.drive_form_id AS drive_form_id_18, t19.id AS id_20, t19.form_name AS form_name_21, t19.generate_type AS generate_type_22, t19.intak_form AS intak_form_23, t19.video_data AS video_data_24, t19.ue_flow AS ue_flow_25, t19.dh_automation AS dh_automation_26, t19.more_options AS more_options_27, t19.ez_link_detail AS ez_link_detail_28, t19.roles_automation AS roles_automation_29, t19.meta_json AS meta_json_30, t19.drive_all_id AS drive_all_id_31 FROM 302_drive_storage t0 LEFT JOIN 300_drive_all t4 ON t0.drive_all_id = t4.id LEFT JOIN 303_drive_form t19 ON t0.drive_form_id = t19.id WHERE t0.drive_form_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.file AS file_2, t0.drive_all_id AS drive_all_id_3, t4.id AS id_5, t4.owner_id AS owner_id_6, t4.type AS type_7, t4.name_display AS name_display_8, t4.name_original AS name_original_9, t4.file_url AS file_url_10, t4.file_icon AS file_icon_11, t4.parent_id AS parent_id_12, t4.permissions AS permissions_13, t4.status AS status_14, t4.slug AS slug_15, t4.created_at AS created_at_16, t4.updated_at AS updated_at_17, t0.drive_form_id AS drive_form_id_18, t19.id AS id_20, t19.form_name AS form_name_21, t19.generate_type AS generate_type_22, t19.intak_form AS intak_form_23, t19.video_data AS video_data_24, t19.ue_flow AS ue_flow_25, t19.dh_automation AS dh_automation_26, t19.more_options AS more_options_27, t19.ez_link_detail AS ez_link_detail_28, t19.roles_automation AS roles_automation_29, t19.meta_json AS meta_json_30, t19.drive_all_id AS drive_all_id_31 FROM 302_drive_storage t0 LEFT JOIN 300_drive_all t4 ON t0.drive_all_id = t4.id LEFT JOIN 303_drive_form t19 ON t0.drive_form_id = t19.id WHERE t0.drive_form_id = ? SELECT t0.id AS id_1, t0.file AS file_2, t0.drive_all_id AS drive_all_id_3, t4.id AS id_5, t4.owner_id AS owner_id_6, t4.type AS type_7, t4.name_display AS name_display_8, t4.name_original AS name_original_9, t4.file_url AS file_url_10, t4.file_icon AS file_icon_11, t4.parent_id AS parent_id_12, t4.permissions AS permissions_13, t4.status AS status_14, t4.slug AS slug_15, t4.created_at AS created_at_16, t4.updated_at AS updated_at_17, t0.drive_form_id AS drive_form_id_18, t19.id AS id_20, t19.form_name AS form_name_21, t19.generate_type AS generate_type_22, t19.intak_form AS intak_form_23, t19.video_data AS video_data_24, t19.ue_flow AS ue_flow_25, t19.dh_automation AS dh_automation_26, t19.more_options AS more_options_27, t19.ez_link_detail AS ez_link_detail_28, t19.roles_automation AS roles_automation_29, t19.meta_json AS meta_json_30, t19.drive_all_id AS drive_all_id_31 FROM 302_drive_storage t0 LEFT JOIN 300_drive_all t4 ON t0.drive_all_id = t4.id LEFT JOIN 303_drive_form t19 ON t0.drive_form_id = t19.id WHERE t0.drive_form_id = 22;
0.45 ms (2.58%)	1	SELECT t0.id AS id_1, t0.invoice_name AS invoice_name_2, t0.content AS content_3, t0.totalDue AS totalDue_4, t0.invoice_type AS invoice_type_5, t0.invoice_status AS invoice_status_6, t0.html_content AS html_content_7, t0.drive_all_id AS drive_all_id_8, t9.id AS id_10, t9.owner_id AS owner_id_11, t9.type AS type_12, t9.name_display AS name_display_13, t9.name_original AS name_original_14, t9.file_url AS file_url_15, t9.file_icon AS file_icon_16, t9.parent_id AS parent_id_17, t9.permissions AS permissions_18, t9.status AS status_19, t9.slug AS slug_20, t9.created_at AS created_at_21, t9.updated_at AS updated_at_22, t0.drive_form_id AS drive_form_id_23, t24.id AS id_25, t24.form_name AS form_name_26, t24.generate_type AS generate_type_27, t24.intak_form AS intak_form_28, t24.video_data AS video_data_29, t24.ue_flow AS ue_flow_30, t24.dh_automation AS dh_automation_31, t24.more_options AS more_options_32, t24.ez_link_detail AS ez_link_detail_33, t24.roles_automation AS roles_automation_34, t24.meta_json AS meta_json_35, t24.drive_all_id AS drive_all_id_36 FROM 340_drive_invoices t0 LEFT JOIN 300_drive_all t9 ON t0.drive_all_id = t9.id LEFT JOIN 303_drive_form t24 ON t0.drive_form_id = t24.id WHERE t0.drive_form_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.invoice_name AS invoice_name_2, t0.content AS content_3, t0.totalDue AS totalDue_4, t0.invoice_type AS invoice_type_5, t0.invoice_status AS invoice_status_6, t0.html_content AS html_content_7, t0.drive_all_id AS drive_all_id_8, t9.id AS id_10, t9.owner_id AS owner_id_11, t9.type AS type_12, t9.name_display AS name_display_13, t9.name_original AS name_original_14, t9.file_url AS file_url_15, t9.file_icon AS file_icon_16, t9.parent_id AS parent_id_17, t9.permissions AS permissions_18, t9.status AS status_19, t9.slug AS slug_20, t9.created_at AS created_at_21, t9.updated_at AS updated_at_22, t0.drive_form_id AS drive_form_id_23, t24.id AS id_25, t24.form_name AS form_name_26, t24.generate_type AS generate_type_27, t24.intak_form AS intak_form_28, t24.video_data AS video_data_29, t24.ue_flow AS ue_flow_30, t24.dh_automation AS dh_automation_31, t24.more_options AS more_options_32, t24.ez_link_detail AS ez_link_detail_33, t24.roles_automation AS roles_automation_34, t24.meta_json AS meta_json_35, t24.drive_all_id AS drive_all_id_36 FROM 340_drive_invoices t0 LEFT JOIN 300_drive_all t9 ON t0.drive_all_id = t9.id LEFT JOIN 303_drive_form t24 ON t0.drive_form_id = t24.id WHERE t0.drive_form_id = ? SELECT t0.id AS id_1, t0.invoice_name AS invoice_name_2, t0.content AS content_3, t0.totalDue AS totalDue_4, t0.invoice_type AS invoice_type_5, t0.invoice_status AS invoice_status_6, t0.html_content AS html_content_7, t0.drive_all_id AS drive_all_id_8, t9.id AS id_10, t9.owner_id AS owner_id_11, t9.type AS type_12, t9.name_display AS name_display_13, t9.name_original AS name_original_14, t9.file_url AS file_url_15, t9.file_icon AS file_icon_16, t9.parent_id AS parent_id_17, t9.permissions AS permissions_18, t9.status AS status_19, t9.slug AS slug_20, t9.created_at AS created_at_21, t9.updated_at AS updated_at_22, t0.drive_form_id AS drive_form_id_23, t24.id AS id_25, t24.form_name AS form_name_26, t24.generate_type AS generate_type_27, t24.intak_form AS intak_form_28, t24.video_data AS video_data_29, t24.ue_flow AS ue_flow_30, t24.dh_automation AS dh_automation_31, t24.more_options AS more_options_32, t24.ez_link_detail AS ez_link_detail_33, t24.roles_automation AS roles_automation_34, t24.meta_json AS meta_json_35, t24.drive_all_id AS drive_all_id_36 FROM 340_drive_invoices t0 LEFT JOIN 300_drive_all t9 ON t0.drive_all_id = t9.id LEFT JOIN 303_drive_form t24 ON t0.drive_form_id = t24.id WHERE t0.drive_form_id = 22;
0.42 ms (2.45%)	1	SELECT t0.id AS id_1, t0.doc_name AS doc_name_2, t0.content AS content_3, t0.parent_doc AS parent_doc_4, t0.version_hash_key AS version_hash_key_5, t0.version_detail AS version_detail_6, t0.drive_all_id AS drive_all_id_7, t8.id AS id_9, t8.owner_id AS owner_id_10, t8.type AS type_11, t8.name_display AS name_display_12, t8.name_original AS name_original_13, t8.file_url AS file_url_14, t8.file_icon AS file_icon_15, t8.parent_id AS parent_id_16, t8.permissions AS permissions_17, t8.status AS status_18, t8.slug AS slug_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t0.drive_form_id AS drive_form_id_22, t23.id AS id_24, t23.form_name AS form_name_25, t23.generate_type AS generate_type_26, t23.intak_form AS intak_form_27, t23.video_data AS video_data_28, t23.ue_flow AS ue_flow_29, t23.dh_automation AS dh_automation_30, t23.more_options AS more_options_31, t23.ez_link_detail AS ez_link_detail_32, t23.roles_automation AS roles_automation_33, t23.meta_json AS meta_json_34, t23.drive_all_id AS drive_all_id_35 FROM 301_drive_code t0 LEFT JOIN 300_drive_all t8 ON t0.drive_all_id = t8.id LEFT JOIN 303_drive_form t23 ON t0.drive_form_id = t23.id WHERE t0.drive_form_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.doc_name AS doc_name_2, t0.content AS content_3, t0.parent_doc AS parent_doc_4, t0.version_hash_key AS version_hash_key_5, t0.version_detail AS version_detail_6, t0.drive_all_id AS drive_all_id_7, t8.id AS id_9, t8.owner_id AS owner_id_10, t8.type AS type_11, t8.name_display AS name_display_12, t8.name_original AS name_original_13, t8.file_url AS file_url_14, t8.file_icon AS file_icon_15, t8.parent_id AS parent_id_16, t8.permissions AS permissions_17, t8.status AS status_18, t8.slug AS slug_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t0.drive_form_id AS drive_form_id_22, t23.id AS id_24, t23.form_name AS form_name_25, t23.generate_type AS generate_type_26, t23.intak_form AS intak_form_27, t23.video_data AS video_data_28, t23.ue_flow AS ue_flow_29, t23.dh_automation AS dh_automation_30, t23.more_options AS more_options_31, t23.ez_link_detail AS ez_link_detail_32, t23.roles_automation AS roles_automation_33, t23.meta_json AS meta_json_34, t23.drive_all_id AS drive_all_id_35 FROM 301_drive_code t0 LEFT JOIN 300_drive_all t8 ON t0.drive_all_id = t8.id LEFT JOIN 303_drive_form t23 ON t0.drive_form_id = t23.id WHERE t0.drive_form_id = ? SELECT t0.id AS id_1, t0.doc_name AS doc_name_2, t0.content AS content_3, t0.parent_doc AS parent_doc_4, t0.version_hash_key AS version_hash_key_5, t0.version_detail AS version_detail_6, t0.drive_all_id AS drive_all_id_7, t8.id AS id_9, t8.owner_id AS owner_id_10, t8.type AS type_11, t8.name_display AS name_display_12, t8.name_original AS name_original_13, t8.file_url AS file_url_14, t8.file_icon AS file_icon_15, t8.parent_id AS parent_id_16, t8.permissions AS permissions_17, t8.status AS status_18, t8.slug AS slug_19, t8.created_at AS created_at_20, t8.updated_at AS updated_at_21, t0.drive_form_id AS drive_form_id_22, t23.id AS id_24, t23.form_name AS form_name_25, t23.generate_type AS generate_type_26, t23.intak_form AS intak_form_27, t23.video_data AS video_data_28, t23.ue_flow AS ue_flow_29, t23.dh_automation AS dh_automation_30, t23.more_options AS more_options_31, t23.ez_link_detail AS ez_link_detail_32, t23.roles_automation AS roles_automation_33, t23.meta_json AS meta_json_34, t23.drive_all_id AS drive_all_id_35 FROM 301_drive_code t0 LEFT JOIN 300_drive_all t8 ON t0.drive_all_id = t8.id LEFT JOIN 303_drive_form t23 ON t0.drive_form_id = t23.id WHERE t0.drive_form_id = 22;

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.
App\Entity\Main\Currency	No errors.

dynamic_conn entity manager

Class	Mapping errors
App\Entity\User\DriveAll	The field App\Entity\User\DriveAll#eventsfeedAll is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\EventsfeedAll#asset does not contain the required 'inversedBy="eventsfeedAll"' attribute.
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	The field App\Entity\User\DriveWorkroom#eventsfeedAll is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\EventsfeedAll#driveWorkroom does not contain the required 'inversedBy="eventsfeedAll"' attribute.
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.
App\Entity\User\HistoryNote	No errors.
App\Entity\User\EventsfeedAll	No errors.
App\Entity\User\Campaign	No errors.
App\Entity\User\ContactGroup	No errors.
App\Entity\User\SettingEssential	No errors.