Query Metrics
378
Database Queries
31
Different statements
1016.04 ms
Query time
4
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
25.70 ms (2.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.email = ? LIMIT 1
Parameters:
[
"adamf@mgeonline.com"
]
|
|
0.73 ms (0.07%) |
1 |
SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = ?
Parameters:
[
"87ad6c1a03448a844764a5f94bc551a131445cd8dcb04e9cf03bb1d81c386ca982901bbafde253d0"
]
|
dynamic_conn connection
| Time▼ | Count | Info |
|---|---|---|
|
91.60 ms (9.02%) |
16 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.total_records AS total_records_4, t0.avg_rave_score AS avg_rave_score_5, t0.permission AS permission_6, t0.privacy AS privacy_7, t0.role_type AS role_type_8, t0.role AS role_9, t0.data_is_for AS data_is_for_10, t0.tags AS tags_11, t0.meta_json AS meta_json_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM 110_contact_group t0 INNER JOIN 120_contact_group_contacts ON t0.id = 120_contact_group_contacts.contact_group_id WHERE 120_contact_group_contacts.contact_id = ?
Parameters:
[
32
]
|
|
77.16 ms (7.59%) |
16 |
SELECT t0.id AS id_1, t0.global_human_id AS global_human_id_2, t0.name AS name_3, t0.contact_type AS contact_type_4, t0.rave_score AS rave_score_5, t0.profile_pic AS profile_pic_6, t0.company_name AS company_name_7, t0.job_title AS job_title_8, t0.job_role AS job_role_9, t0.primary_category AS primary_category_10, t0.role AS role_11, t0.is_data_only AS is_data_only_12, t0.is_starred AS is_starred_13, t0.tags AS tags_14, t0.private_meta_json AS private_meta_json_15, t0.meta_data_json AS meta_data_json_16, t0.merge_status AS merge_status_17, t0.merged_into AS merged_into_18, t0.accounting_records AS accounting_records_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21 FROM 100_contact t0 INNER JOIN 121_contact_sub_contacts ON t0.id = 121_contact_sub_contacts.sub_contact_id WHERE 121_contact_sub_contacts.contact_id = ?
Parameters:
[
32
]
|
|
68.56 ms (6.75%) |
16 |
SELECT t0.id AS id_1, t0.permission AS permission_2, t0.type AS type_3, t0.value AS value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.global_human_id AS global_human_id_10, t8.name AS name_11, t8.contact_type AS contact_type_12, t8.rave_score AS rave_score_13, t8.profile_pic AS profile_pic_14, t8.company_name AS company_name_15, t8.job_title AS job_title_16, t8.job_role AS job_role_17, t8.primary_category AS primary_category_18, t8.role AS role_19, t8.is_data_only AS is_data_only_20, t8.is_starred AS is_starred_21, t8.tags AS tags_22, t8.private_meta_json AS private_meta_json_23, t8.meta_data_json AS meta_data_json_24, t8.merge_status AS merge_status_25, t8.merged_into AS merged_into_26, t8.accounting_records AS accounting_records_27, t8.created_at AS created_at_28, t8.updated_at AS updated_at_29 FROM 104_contact_meta_data t0 LEFT JOIN 100_contact t8 ON t0.contact_id = t8.id WHERE t0.contact_id = ?
Parameters:
[
32
]
|
|
61.18 ms (6.02%) |
14 |
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_id = ?
Parameters:
[
122
]
|
|
52.28 ms (5.15%) |
16 |
SELECT t0.id AS id_1, t0.permission AS permission_2, t0.type AS type_3, t0.phone AS phone_4, t0.plain_phone AS plain_phone_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.contact_id AS contact_id_8, t9.id AS id_10, t9.global_human_id AS global_human_id_11, t9.name AS name_12, t9.contact_type AS contact_type_13, t9.rave_score AS rave_score_14, t9.profile_pic AS profile_pic_15, t9.company_name AS company_name_16, t9.job_title AS job_title_17, t9.job_role AS job_role_18, t9.primary_category AS primary_category_19, t9.role AS role_20, t9.is_data_only AS is_data_only_21, t9.is_starred AS is_starred_22, t9.tags AS tags_23, t9.private_meta_json AS private_meta_json_24, t9.meta_data_json AS meta_data_json_25, t9.merge_status AS merge_status_26, t9.merged_into AS merged_into_27, t9.accounting_records AS accounting_records_28, t9.created_at AS created_at_29, t9.updated_at AS updated_at_30 FROM 102_contact_phone t0 LEFT JOIN 100_contact t9 ON t0.contact_id = t9.id WHERE t0.contact_id = ?
Parameters:
[
32
]
|
|
50.76 ms (5.00%) |
14 |
SELECT t0.id AS id_1, t0.form_name AS form_name_2, t0.generate_type AS generate_type_3, t0.intak_form AS intak_form_4, t0.video_data AS video_data_5, t0.ue_flow AS ue_flow_6, t0.dh_automation AS dh_automation_7, t0.more_options AS more_options_8, t0.ez_link_detail AS ez_link_detail_9, t0.roles_automation AS roles_automation_10, t0.meta_json AS meta_json_11, t0.drive_all_id AS drive_all_id_12, t13.id AS id_14, t13.owner_id AS owner_id_15, t13.type AS type_16, t13.name_display AS name_display_17, t13.name_original AS name_original_18, t13.file_url AS file_url_19, t13.file_icon AS file_icon_20, t13.parent_id AS parent_id_21, t13.permissions AS permissions_22, t13.status AS status_23, t13.slug AS slug_24, t13.created_at AS created_at_25, t13.updated_at AS updated_at_26, t27.id AS id_28, t27.doc_name AS doc_name_29, t27.content AS content_30, t27.json_content AS json_content_31, t27.html_content AS html_content_32, t27.parent_doc AS parent_doc_33, t27.version_hash_key AS version_hash_key_34, t27.version_detail AS version_detail_35, t27.drive_all_id AS drive_all_id_36, t27.drive_form_id AS drive_form_id_37, t38.id AS id_39, t38.phone_type AS phone_type_40, t38.phone_number AS phone_number_41, t38.phone_number_sid AS phone_number_sid_42, t38.twilio_auth_token AS twilio_auth_token_43, t38.details AS details_44, t38.created_at AS created_at_45, t38.updated_at AS updated_at_46, t38.drive_all_id AS drive_all_id_47, t38.drive_form_id AS drive_form_id_48, t49.id AS id_50, t49.doc_name AS doc_name_51, t49.content AS content_52, t49.parent_doc AS parent_doc_53, t49.version_hash_key AS version_hash_key_54, t49.version_detail AS version_detail_55, t49.drive_all_id AS drive_all_id_56, t49.drive_form_id AS drive_form_id_57, t58.id AS id_59, t58.invoice_name AS invoice_name_60, t58.content AS content_61, t58.totalDue AS totalDue_62, t58.invoice_type AS invoice_type_63, t58.invoice_status AS invoice_status_64, t58.html_content AS html_content_65, t58.drive_all_id AS drive_all_id_66, t58.drive_form_id AS drive_form_id_67, t68.id AS id_69, t68.workroom_name AS workroom_name_70, t68.created_at AS created_at_71, t68.updated_at AS updated_at_72, t68.drive_all_id AS drive_all_id_73, t68.drive_form_id AS drive_form_id_74, t75.id AS id_76, t75.name AS name_77, t75.data_json AS data_json_78, t75.created_at AS created_at_79, t75.updated_at AS updated_at_80, t75.drive_all_id AS drive_all_id_81, t75.drive_form_id AS drive_form_id_82, t83.id AS id_84, t83.file AS file_85, t83.drive_all_id AS drive_all_id_86, t83.drive_form_id AS drive_form_id_87, t88.id AS id_89, t88.name AS name_90, t88.description AS description_91, t88.time_required_json AS time_required_json_92, t88.location_json AS location_json_93, t88.ticketed_json AS ticketed_json_94, t88.membership_json AS membership_json_95, t88.price AS price_96, t88.paper_work_id AS paper_work_id_97, t88.visibility AS visibility_98, t88.scheduler_id AS scheduler_id_99, t88.drive_form_id AS drive_form_id_100, t88.drive_id AS drive_id_101, t102.id AS id_103, t102.item_name AS item_name_104, t102.product_details AS product_details_105, t102.permission AS permission_106, t102.note AS note_107, t102.user_experience_flow AS user_experience_flow_108, t102.data_handling_automation AS data_handling_automation_109, t102.more_options AS more_options_110, t102.ez_link_detail AS ez_link_detail_111, t102.created_at AS created_at_112, t102.updated_at AS updated_at_113, t102.drive_id AS drive_id_114, t102.drive_form_id AS drive_form_id_115 FROM 303_drive_form t0 LEFT JOIN 300_drive_all t13 ON t0.drive_all_id = t13.id LEFT JOIN 301_drive_doc t27 ON t27.drive_form_id = t0.id LEFT JOIN 609_twilio_phone t38 ON t38.drive_form_id = t0.id LEFT JOIN 301_drive_code t49 ON t49.drive_form_id = t0.id LEFT JOIN 340_drive_invoices t58 ON t58.drive_form_id = t0.id LEFT JOIN 305_drive_workroom t68 ON t68.drive_form_id = t0.id LEFT JOIN 308_drive_spreadsheet t75 ON t75.drive_form_id = t0.id LEFT JOIN 302_drive_storage t83 ON t83.drive_form_id = t0.id LEFT JOIN 525_scheduler_service t88 ON t88.drive_form_id = t0.id LEFT JOIN 304_drive_item t102 ON t102.drive_form_id = t0.id WHERE t0.drive_all_id = ?
Parameters:
[
122
]
|
|
43.99 ms (4.33%) |
16 |
SELECT t0.id AS id_1, t0.permission AS permission_2, t0.type AS type_3, t0.email AS email_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.global_human_id AS global_human_id_10, t8.name AS name_11, t8.contact_type AS contact_type_12, t8.rave_score AS rave_score_13, t8.profile_pic AS profile_pic_14, t8.company_name AS company_name_15, t8.job_title AS job_title_16, t8.job_role AS job_role_17, t8.primary_category AS primary_category_18, t8.role AS role_19, t8.is_data_only AS is_data_only_20, t8.is_starred AS is_starred_21, t8.tags AS tags_22, t8.private_meta_json AS private_meta_json_23, t8.meta_data_json AS meta_data_json_24, t8.merge_status AS merge_status_25, t8.merged_into AS merged_into_26, t8.accounting_records AS accounting_records_27, t8.created_at AS created_at_28, t8.updated_at AS updated_at_29 FROM 101_contact_email t0 LEFT JOIN 100_contact t8 ON t0.contact_id = t8.id WHERE t0.contact_id = ?
Parameters:
[
32
]
|
|
43.78 ms (4.31%) |
16 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.task_id AS task_id_4, t0.contact_id AS contact_id_5, t0.setting_role_id AS setting_role_id_6 FROM 502_task_contacts t0 WHERE t0.contact_id = ?
Parameters:
[
32
]
|
|
41.24 ms (4.06%) |
14 |
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_all_id = ?
Parameters:
[
122
]
|
|
40.46 ms (3.98%) |
16 |
SELECT t0.id AS id_1, t0.permission AS permission_2, t0.type AS type_3, t0.address AS address_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.global_human_id AS global_human_id_10, t8.name AS name_11, t8.contact_type AS contact_type_12, t8.rave_score AS rave_score_13, t8.profile_pic AS profile_pic_14, t8.company_name AS company_name_15, t8.job_title AS job_title_16, t8.job_role AS job_role_17, t8.primary_category AS primary_category_18, t8.role AS role_19, t8.is_data_only AS is_data_only_20, t8.is_starred AS is_starred_21, t8.tags AS tags_22, t8.private_meta_json AS private_meta_json_23, t8.meta_data_json AS meta_data_json_24, t8.merge_status AS merge_status_25, t8.merged_into AS merged_into_26, t8.accounting_records AS accounting_records_27, t8.created_at AS created_at_28, t8.updated_at AS updated_at_29 FROM 103_contact_address t0 LEFT JOIN 100_contact t8 ON t0.contact_id = t8.id WHERE t0.contact_id = ?
Parameters:
[
32
]
|
|
40.12 ms (3.95%) |
16 |
SELECT t0.id AS id_1, t0.content AS content_2, t0.mode AS mode_3, t0.title AS title_4, t0.type AS type_5, t0.status AS status_6, t0.message_sent AS message_sent_7, t0.private_meta_json AS private_meta_json_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.contact_id AS contact_id_11, t12.id AS id_13, t12.global_human_id AS global_human_id_14, t12.name AS name_15, t12.contact_type AS contact_type_16, t12.rave_score AS rave_score_17, t12.profile_pic AS profile_pic_18, t12.company_name AS company_name_19, t12.job_title AS job_title_20, t12.job_role AS job_role_21, t12.primary_category AS primary_category_22, t12.role AS role_23, t12.is_data_only AS is_data_only_24, t12.is_starred AS is_starred_25, t12.tags AS tags_26, t12.private_meta_json AS private_meta_json_27, t12.meta_data_json AS meta_data_json_28, t12.merge_status AS merge_status_29, t12.merged_into AS merged_into_30, t12.accounting_records AS accounting_records_31, t12.created_at AS created_at_32, t12.updated_at AS updated_at_33, t0.contact_group_id AS contact_group_id_34, t35.id AS id_36, t35.name AS name_37, t35.type AS type_38, t35.total_records AS total_records_39, t35.avg_rave_score AS avg_rave_score_40, t35.permission AS permission_41, t35.privacy AS privacy_42, t35.role_type AS role_type_43, t35.role AS role_44, t35.data_is_for AS data_is_for_45, t35.tags AS tags_46, t35.meta_json AS meta_json_47, t35.created_at AS created_at_48, t35.updated_at AS updated_at_49, t0.drive_all_id AS drive_all_id_50, t51.id AS id_52, t51.owner_id AS owner_id_53, t51.type AS type_54, t51.name_display AS name_display_55, t51.name_original AS name_original_56, t51.file_url AS file_url_57, t51.file_icon AS file_icon_58, t51.parent_id AS parent_id_59, t51.permissions AS permissions_60, t51.status AS status_61, t51.slug AS slug_62, t51.created_at AS created_at_63, t51.updated_at AS updated_at_64, t0.campaign_id AS campaign_id_65, t66.id AS id_67, t66.name AS name_68, t66.type AS type_69, t66.permission AS permission_70, t66.privacy AS privacy_71, t66.role_type AS role_type_72, t66.role AS role_73, t66.data_is_for AS data_is_for_74, t66.request_via AS request_via_75, t66.status AS status_76, t66.click_through_url AS click_through_url_77, t66.remove_receipt AS remove_receipt_78, t66.pause_sequence AS pause_sequence_79, t66.tags AS tags_80, t66.meta_json AS meta_json_81, t66.created_at AS created_at_82, t66.updated_at AS updated_at_83, t66.contact_group_id AS contact_group_id_84, t66.doc_id AS doc_id_85, t66.drive_workroom_id AS drive_workroom_id_86, t0.drive_invoice_id AS drive_invoice_id_87, t88.id AS id_89, t88.invoice_name AS invoice_name_90, t88.content AS content_91, t88.totalDue AS totalDue_92, t88.invoice_type AS invoice_type_93, t88.invoice_status AS invoice_status_94, t88.html_content AS html_content_95, t88.drive_all_id AS drive_all_id_96, t88.drive_form_id AS drive_form_id_97 FROM 600_history_note t0 LEFT JOIN 100_contact t12 ON t0.contact_id = t12.id LEFT JOIN 110_contact_group t35 ON t0.contact_group_id = t35.id LEFT JOIN 300_drive_all t51 ON t0.drive_all_id = t51.id LEFT JOIN 700_campaigns t66 ON t0.campaign_id = t66.id LEFT JOIN 340_drive_invoices t88 ON t0.drive_invoice_id = t88.id WHERE t0.contact_id = ?
Parameters:
[
32
]
|
|
31.86 ms (3.14%) |
14 |
SELECT t0.id AS id_1, t0.owner_contact_id AS owner_contact_id_2, t0.title AS title_3, t0.content_html AS content_html_4, t0.status AS status_5, t0.language_code AS language_code_6, t0.header_type AS header_type_7, t0.logo_file_id AS logo_file_id_8, t0.phone_primary AS phone_primary_9, t0.phone_options_json AS phone_options_json_10, t0.menus_json AS menus_json_11, t0.sidebar_widgets_json AS sidebar_widgets_json_12, t0.footer_html AS footer_html_13, t0.theme_bg_color AS theme_bg_color_14, t0.theme_font_color AS theme_font_color_15, t0.theme_hover_bg_color AS theme_hover_bg_color_16, t0.theme_hover_font_color AS theme_hover_font_color_17, t0.heading_font_family AS heading_font_family_18, t0.body_font_family AS body_font_family_19, t0.featured_image AS featured_image_20, t0.custom_css_file_id AS custom_css_file_id_21, t0.custom_js_file_id AS custom_js_file_id_22, t0.google_tag_id AS google_tag_id_23, t0.chatbot_enabled AS chatbot_enabled_24, t0.who_can_modify AS who_can_modify_25, t0.modify_users_json AS modify_users_json_26, t0.who_can_copy AS who_can_copy_27, t0.copy_password_hash AS copy_password_hash_28, t0.version AS version_29, t0.published_at AS published_at_30, t0.membership_page_doc_id AS membership_page_doc_id_31, t0.published_by AS published_by_32, t0.notes AS notes_33, t0.privacy AS privacy_34, t0.privacy_password_hash AS privacy_password_hash_35, t0.view_users_json AS view_users_json_36, t0.tags AS tags_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.drive_all_id AS drive_all_id_40, t41.id AS id_42, t41.owner_id AS owner_id_43, t41.type AS type_44, t41.name_display AS name_display_45, t41.name_original AS name_original_46, t41.file_url AS file_url_47, t41.file_icon AS file_icon_48, t41.parent_id AS parent_id_49, t41.permissions AS permissions_50, t41.status AS status_51, t41.slug AS slug_52, t41.created_at AS created_at_53, t41.updated_at AS updated_at_54 FROM 320_website t0 LEFT JOIN 300_drive_all t41 ON t0.drive_all_id = t41.id WHERE t0.drive_all_id = ?
Parameters:
[
122
]
|
|
31.82 ms (3.13%) |
14 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.mapped_url AS mapped_url_3, t0.inbound_url AS inbound_url_4, t0.slug AS slug_5, t0.inbound_json AS inbound_json_6, t0.outbound_json AS outbound_json_7, t0.history_json AS history_json_8, t0.reporting_json AS reporting_json_9, t0.meta_json AS meta_json_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.drive_all_id AS drive_all_id_13, t14.id AS id_15, t14.owner_id AS owner_id_16, t14.type AS type_17, t14.name_display AS name_display_18, t14.name_original AS name_original_19, t14.file_url AS file_url_20, t14.file_icon AS file_icon_21, t14.parent_id AS parent_id_22, t14.permissions AS permissions_23, t14.status AS status_24, t14.slug AS slug_25, t14.created_at AS created_at_26, t14.updated_at AS updated_at_27 FROM 005_mapped_url t0 LEFT JOIN 300_drive_all t14 ON t0.drive_all_id = t14.id WHERE t0.drive_all_id = ?
Parameters:
[
122
]
|
|
28.86 ms (2.84%) |
16 |
SELECT t0.id AS id_1, t0.permission AS permission_2, t0.type AS type_3, t0.data AS data_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.contact_id AS contact_id_7, t8.id AS id_9, t8.global_human_id AS global_human_id_10, t8.name AS name_11, t8.contact_type AS contact_type_12, t8.rave_score AS rave_score_13, t8.profile_pic AS profile_pic_14, t8.company_name AS company_name_15, t8.job_title AS job_title_16, t8.job_role AS job_role_17, t8.primary_category AS primary_category_18, t8.role AS role_19, t8.is_data_only AS is_data_only_20, t8.is_starred AS is_starred_21, t8.tags AS tags_22, t8.private_meta_json AS private_meta_json_23, t8.meta_data_json AS meta_data_json_24, t8.merge_status AS merge_status_25, t8.merged_into AS merged_into_26, t8.accounting_records AS accounting_records_27, t8.created_at AS created_at_28, t8.updated_at AS updated_at_29, t0.setting_custom_field_id AS setting_custom_field_id_30, t31.id AS id_32, t31.label AS label_33, t31.icon AS icon_34, t31.type AS type_35, t31.default_value AS default_value_36, t31.created_at AS created_at_37, t31.updated_at AS updated_at_38 FROM 105_contact_custom_field t0 LEFT JOIN 100_contact t8 ON t0.contact_id = t8.id LEFT JOIN 007_setting_custom_field t31 ON t0.setting_custom_field_id = t31.id WHERE t0.contact_id = ?
Parameters:
[
32
]
|
|
28.83 ms (2.84%) |
14 |
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_all_id = ?
Parameters:
[
122
]
|
|
27.20 ms (2.68%) |
16 |
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 INNER JOIN 305_drive_workroom_contact ON t0.id = 305_drive_workroom_contact.drive_workroom_id WHERE 305_drive_workroom_contact.contact_id = ?
Parameters:
[
32
]
|
|
26.25 ms (2.58%) |
16 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.calendar_id AS calendar_id_4, t0.contact_id AS contact_id_5, t0.setting_role_id AS setting_role_id_6 FROM 503_calendar_contacts t0 WHERE t0.contact_id = ?
Parameters:
[
32
]
|
|
22.31 ms (2.20%) |
14 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.history_json AS history_json_4, t0.availability_json AS availability_json_5, t0.more_options AS more_options_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.drive_id AS drive_id_9 FROM 520_drive_scheduler t0 WHERE t0.drive_id = ?
Parameters:
[
122
]
|
|
21.87 ms (2.15%) |
14 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original AS original_3, t0.underlay AS underlay_4, t0.overlay AS overlay_5, t0.html_content AS html_content_6, t0.permissions_json AS permissions_json_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 306_drive_esign_overlay 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_all_id = ?
Parameters:
[
122
]
|
|
21.45 ms (2.11%) |
14 |
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_all_id = ?
Parameters:
[
122
]
|
|
20.43 ms (2.01%) |
14 |
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 = ?
Parameters:
[
122
]
|
|
20.40 ms (2.01%) |
14 |
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_all_id = ?
Parameters:
[
122
]
|
|
19.98 ms (1.97%) |
14 |
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_all_id = ?
Parameters:
[
122
]
|
|
18.70 ms (1.84%) |
14 |
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_id = ?
Parameters:
[
122
]
|
|
16.57 ms (1.63%) |
14 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.events_json AS events_json_3, t0.meta_json AS meta_json_4, t0.history_json AS history_json_5, t0.tags AS tags_6, t0.drive_id AS drive_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 FROM 350_drive_sequence t0 LEFT JOIN 300_drive_all t8 ON t0.drive_id = t8.id WHERE t0.drive_id = ?
Parameters:
[
122
]
|
|
13.85 ms (1.36%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_at_20 FROM (SELECT t0_.id AS id_0, t0_.global_human_id AS global_human_id_1, t0_.name AS name_2, t0_.contact_type AS contact_type_3, t0_.rave_score AS rave_score_4, t0_.profile_pic AS profile_pic_5, t0_.company_name AS company_name_6, t0_.job_title AS job_title_7, t0_.job_role AS job_role_8, t0_.primary_category AS primary_category_9, t0_.role AS role_10, t0_.is_data_only AS is_data_only_11, t0_.is_starred AS is_starred_12, t0_.tags AS tags_13, t0_.private_meta_json AS private_meta_json_14, t0_.meta_data_json AS meta_data_json_15, t0_.merge_status AS merge_status_16, t0_.merged_into AS merged_into_17, t0_.accounting_records AS accounting_records_18, t0_.created_at AS created_at_19, t0_.updated_at AS updated_at_20, t1_.type AS type_21 FROM 100_contact t0_ LEFT JOIN 120_contact_group_contacts t2_ ON t0_.id = t2_.contact_id LEFT JOIN 110_contact_group t1_ ON t1_.id = t2_.contact_group_id LEFT JOIN 101_contact_email t3_ ON t0_.id = t3_.contact_id LEFT JOIN 102_contact_phone t4_ ON t0_.id = t4_.contact_id LEFT JOIN 502_task_contacts t5_ ON t0_.id = t5_.contact_id LEFT JOIN 501_task t6_ ON t5_.task_id = t6_.id WHERE t1_.type = ? OR t1_.type IS NULL) dctrn_result_inner ORDER BY updated_at_20 DESC) dctrn_result LIMIT 25
Parameters:
[
"MyContacts"
]
|
|
13.75 ms (1.35%) |
1 |
SELECT t0_.id AS id_0, t0_.global_human_id AS global_human_id_1, t0_.name AS name_2, t0_.contact_type AS contact_type_3, t0_.rave_score AS rave_score_4, t0_.profile_pic AS profile_pic_5, t0_.company_name AS company_name_6, t0_.job_title AS job_title_7, t0_.job_role AS job_role_8, t0_.primary_category AS primary_category_9, t0_.role AS role_10, t0_.is_data_only AS is_data_only_11, t0_.is_starred AS is_starred_12, t0_.tags AS tags_13, t0_.private_meta_json AS private_meta_json_14, t0_.meta_data_json AS meta_data_json_15, t0_.merge_status AS merge_status_16, t0_.merged_into AS merged_into_17, t0_.accounting_records AS accounting_records_18, t0_.created_at AS created_at_19, t0_.updated_at AS updated_at_20 FROM 100_contact t0_ LEFT JOIN 120_contact_group_contacts t2_ ON t0_.id = t2_.contact_id LEFT JOIN 110_contact_group t1_ ON t1_.id = t2_.contact_group_id LEFT JOIN 101_contact_email t3_ ON t0_.id = t3_.contact_id LEFT JOIN 102_contact_phone t4_ ON t0_.id = t4_.contact_id LEFT JOIN 502_task_contacts t5_ ON t0_.id = t5_.contact_id LEFT JOIN 501_task t6_ ON t5_.task_id = t6_.id WHERE (t1_.type = ? OR t1_.type IS NULL) AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY t0_.updated_at DESC
Parameters:
[ "MyContacts" 32 31 30 29 28 27 26 25 24 23 19 15 14 11 6 4 ] |
|
11.99 ms (1.18%) |
1 |
SELECT COUNT(t0_.id) AS sclr_0 FROM 100_contact t0_
Parameters:
[] |
|
2.35 ms (0.23%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.global_human_id AS global_human_id_1, t0_.name AS name_2, t0_.contact_type AS contact_type_3, t0_.rave_score AS rave_score_4, t0_.profile_pic AS profile_pic_5, t0_.company_name AS company_name_6, t0_.job_title AS job_title_7, t0_.job_role AS job_role_8, t0_.primary_category AS primary_category_9, t0_.role AS role_10, t0_.is_data_only AS is_data_only_11, t0_.is_starred AS is_starred_12, t0_.tags AS tags_13, t0_.private_meta_json AS private_meta_json_14, t0_.meta_data_json AS meta_data_json_15, t0_.merge_status AS merge_status_16, t0_.merged_into AS merged_into_17, t0_.accounting_records AS accounting_records_18, t0_.created_at AS created_at_19, t0_.updated_at AS updated_at_20 FROM 100_contact t0_ LEFT JOIN 120_contact_group_contacts t2_ ON t0_.id = t2_.contact_id LEFT JOIN 110_contact_group t1_ ON t1_.id = t2_.contact_group_id LEFT JOIN 101_contact_email t3_ ON t0_.id = t3_.contact_id LEFT JOIN 102_contact_phone t4_ ON t0_.id = t4_.contact_id LEFT JOIN 502_task_contacts t5_ ON t0_.id = t5_.contact_id LEFT JOIN 501_task t6_ ON t5_.task_id = t6_.id WHERE t1_.type = ? OR t1_.type IS NULL ORDER BY t0_.updated_at DESC) dctrn_result) dctrn_table
Parameters:
[
"MyContacts"
]
|
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 |
|---|---|
| League\Bundle\OAuth2ServerBundle\Model\AccessToken | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\AbstractClient | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\Client | No 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\Contact |
|
| App\Entity\User\ContactGroup | No errors. |
| App\Entity\User\ContactEmail | No errors. |
| App\Entity\User\ContactPhone | No errors. |
| App\Entity\User\TaskContact | No errors. |
| App\Entity\User\Task |
|
| App\Entity\User\ContactAddress | No errors. |
| App\Entity\User\ContactMetaData | No errors. |
| App\Entity\User\ContactCustomField | No errors. |
| App\Entity\User\HistoryNote | No errors. |
| App\Entity\User\Campaign | No errors. |
| App\Entity\User\DriveWorkroom |
|
| App\Entity\User\CalendarContact | No errors. |
| App\Entity\User\EventsfeedAll | No errors. |
| App\Entity\User\SettingCustomField | No errors. |
| App\Entity\User\DriveAll |
|
| App\Entity\User\DriveDoc | No errors. |
| App\Entity\User\DriveInvoice | No errors. |
| App\Entity\User\DriveForm | No errors. |
| App\Entity\User\DriveItem | No errors. |
| App\Entity\User\DriveCode | No errors. |
| App\Entity\User\TwilioPhone | No errors. |
| App\Entity\User\DriveSpreadSheet | No errors. |
| App\Entity\User\DriveStorage | No errors. |
| App\Entity\User\SchedulerService | No errors. |
| App\Entity\User\DriveScheduler | No errors. |
| App\Entity\User\DriveSequence | No errors. |
| App\Entity\User\DriveESignOverlay | No errors. |
| App\Entity\User\MappedUrl | No errors. |
| App\Entity\User\Website | No errors. |
| App\Entity\User\SettingRole | No errors. |
| App\Entity\User\Calendar | No errors. |