Symfony Profiler

SELECT
  t0.userid AS userid_1,
  t0.otp_code AS otp_code_2,
  t0.otp_expiry_date AS otp_expiry_date_3,
  t0.password AS password_4,
  t0.last_password_change AS last_password_change_5,
  t0.forename AS forename_6,
  t0.surname AS surname_7,
  t0.full_name AS full_name_8,
  t0.email AS email_9,
  t0.status AS status_10,
  t0.initials AS initials_11,
  t0.xero_contact_id AS xero_contact_id_12,
  t0.created AS created_13,
  t0.color_code AS color_code_14,
  t0.modified AS modified_15,
  t0.is_system AS is_system_16,
  t0.is_member AS is_member_17,
  t0.member_id AS member_id_18,
  t0.lc_member_id AS lc_member_id_19,
  t0.reset_password_token AS reset_password_token_20,
  t0.createdby AS createdby_21,
  t0.modifiedby AS modifiedby_22,
  t0.user_profile_id AS user_profile_id_23
FROM
  user t0
WHERE
  t0.userid = ?

SELECT t0.userid AS userid_1, t0.otp_code AS otp_code_2, t0.otp_expiry_date AS otp_expiry_date_3, t0.password AS password_4, t0.last_password_change AS last_password_change_5, t0.forename AS forename_6, t0.surname AS surname_7, t0.full_name AS full_name_8, t0.email AS email_9, t0.status AS status_10, t0.initials AS initials_11, t0.xero_contact_id AS xero_contact_id_12, t0.created AS created_13, t0.color_code AS color_code_14, t0.modified AS modified_15, t0.is_system AS is_system_16, t0.is_member AS is_member_17, t0.member_id AS member_id_18, t0.lc_member_id AS lc_member_id_19, t0.reset_password_token AS reset_password_token_20, t0.createdby AS createdby_21, t0.modifiedby AS modifiedby_22, t0.user_profile_id AS user_profile_id_23 FROM user t0 WHERE t0.userid = 8;

SELECT
  t0.enquiry_id AS enquiry_id_1,
  t0.enquiry_type_id AS enquiry_type_id_2,
  t0.enquiry_status_id AS enquiry_status_id_3,
  t0.production_base_id AS production_base_id_4,
  t0.customer_id AS customer_id_5,
  t0.enquiry_handler AS enquiry_handler_6,
  t0.enquiry_date AS enquiry_date_7,
  t0.enquiry_updated_date AS enquiry_updated_date_8,
  t0.size AS size_9,
  t0.production_company_id AS production_company_id_10,
  t0.production_status AS production_status_11,
  t0.requirement AS requirement_12,
  t0.max_crew_cast AS max_crew_cast_13,
  t0.reference AS reference_14,
  t0.comments AS comments_15,
  t0.are_you_location_manager AS are_you_location_manager_16,
  t0.is_music_promo_reqs_confirmed AS is_music_promo_reqs_confirmed_17,
  t0.lead_source_other AS lead_source_other_18,
  t0.lead_source_rec AS lead_source_rec_19,
  t0.total_hired_period AS total_hired_period_20,
  t0.projected_film_days AS projected_film_days_21,
  t0.no_of_supporting_artist AS no_of_supporting_artist_22,
  t0.projected_prep_strike_days AS projected_prep_strike_days_23,
  t0.projected_hold_days AS projected_hold_days_24,
  t0.budget AS budget_25,
  t0.approx_quote AS approx_quote_26,
  t0.deadline AS deadline_27,
  t0.commission_perc_gross AS commission_perc_gross_28,
  t0.commission_perc_net AS commission_perc_net_29,
  t0.commission_perc_net_override AS commission_perc_net_override_30,
  t0.commission_perc_gross_override AS commission_perc_gross_override_31,
  t0.member_commission_value AS member_commission_value_32,
  t0.library_fee AS library_fee_33,
  t0.fom_fee AS fom_fee_34,
  t0.collective_fee_gross_without_lf AS collective_fee_gross_without_lf_35,
  t0.collective_fee_net_without_lf AS collective_fee_net_without_lf_36,
  t0.collective_fee_gross_with_lf AS collective_fee_gross_with_lf_37,
  t0.collective_fee_net_with_lf AS collective_fee_net_with_lf_38,
  t0.library_fee_status AS library_fee_status_39,
  t0.fom_fee_status AS fom_fee_status_40,
  t0.enquiry_total_value AS enquiry_total_value_41,
  t0.remaining_hire_fee_to_the_owner AS remaining_hire_fee_to_the_owner_42,
  t0.notes AS notes_43,
  t0.owner_additonal_knowledge AS owner_additonal_knowledge_44,
  t0.synopsis AS synopsis_45,
  t0.non_negotiable AS non_negotiable_46,
  t0.where_they_want AS where_they_want_47,
  t0.locations_not_interested AS locations_not_interested_48,
  t0.special_requirements AS special_requirements_49,
  t0.hire_date_from AS hire_date_from_50,
  t0.hire_date_to AS hire_date_to_51,
  t0.parking_requests AS parking_requests_52,
  t0.controversial_script_sex_scenes AS controversial_script_sex_scenes_53,
  t0.controversial_script_sex_scenes_val AS controversial_script_sex_scenes_val_54,
  t0.night_shoot AS night_shoot_55,
  t0.night_shoot_val AS night_shoot_val_56,
  t0.smoke_set_for_filming_purposes AS smoke_set_for_filming_purposes_57,
  t0.smoke_set_for_filming_purposes_val AS smoke_set_for_filming_purposes_val_58,
  t0.pyrotechnics_fire AS pyrotechnics_fire_59,
  t0.pyrotechnics_fire_val AS pyrotechnics_fire_val_60,
  t0.gunfire_weapon_props AS gunfire_weapon_props_61,
  t0.gunfire_weapon_props_val AS gunfire_weapon_props_val_62,
  t0.wet_down AS wet_down_63,
  t0.wet_down_val AS wet_down_val_64,
  t0.stunts_car AS stunts_car_65,
  t0.stunts_car_val AS stunts_car_val_66,
  t0.non_vehicle_stunts AS non_vehicle_stunts_67,
  t0.non_vehicle_stunts_val AS non_vehicle_stunts_val_68,
  t0.scaffolding AS scaffolding_69,
  t0.scaffolding_val AS scaffolding_val_70,
  t0.blackout AS blackout_71,
  t0.blackout_val AS blackout_val_72,
  t0.smoke_haze_machine AS smoke_haze_machine_73,
  t0.smoke_haze_machine_val AS smoke_haze_machine_val_74,
  t0.nudity AS nudity_75,
  t0.nudity_val AS nudity_val_76,
  t0.reconstruction_of_crime AS reconstruction_of_crime_77,
  t0.reconstruction_of_crime_val AS reconstruction_of_crime_val_78,
  t0.other AS other_79,
  t0.other_val AS other_val_80,
  t0.animals AS animals_81,
  t0.animals_val AS animals_val_82,
  t0.play_back_music AS play_back_music_83,
  t0.play_back_music_val AS play_back_music_val_84,
  t0.children AS children_85,
  t0.children_val AS children_val_86,
  t0.expected_number_of_crew AS expected_number_of_crew_87,
  t0.expected_number_of_cast AS expected_number_of_cast_88,
  t0.max_crew_and_cast_on_a_single_day AS max_crew_and_cast_on_a_single_day_89,
  t0.customer_lightbox_rejection_reason AS customer_lightbox_rejection_reason_90,
  t0.customer_lightbox_new_brief AS customer_lightbox_new_brief_91,
  t0.hourly_rate AS hourly_rate_92,
  t0.hourly_rate_value AS hourly_rate_value_93,
  t0.no_hire_dates AS no_hire_dates_94,
  t0.split_days AS split_days_95,
  t0.manual_budget AS manual_budget_96,
  t0.enquiry_source AS enquiry_source_97,
  t0.enquiry_status AS enquiry_status_98,
  t0.attrp_notes AS attrp_notes_99,
  t0.weapon_props AS weapon_props_100,
  t0.weapon_props_val AS weapon_props_val_101,
  t0.play_back AS play_back_102,
  t0.parking AS parking_103,
  t0.enquiry_production_id AS enquiry_production_id_104,
  t0.production_company_id AS production_company_id_105,
  t0.deputy_contract_handler AS deputy_contract_handler_106,
  t0.lead_source_id AS lead_source_id_107,
  t0.production_type_id AS production_type_id_108,
  t0.location_type_id AS location_type_id_109,
  t0.customer_id AS customer_id_110,
  t0.saved_lightbox_id AS saved_lightbox_id_111,
  t0.enquiry_type_id AS enquiry_type_id_112,
  t0.enquiry_status_id AS enquiry_status_id_113,
  t0.enquiry_loss_id AS enquiry_loss_id_114,
  t0.production_base_id AS production_base_id_115,
  t0.production_status AS production_status_116,
  t0.enquiry_handler AS enquiry_handler_117,
  t0.updated_by AS updated_by_118
FROM
  j1_enquiry t0
WHERE
  t0.enquiry_id = ?

SELECT t0.enquiry_id AS enquiry_id_1, t0.enquiry_type_id AS enquiry_type_id_2, t0.enquiry_status_id AS enquiry_status_id_3, t0.production_base_id AS production_base_id_4, t0.customer_id AS customer_id_5, t0.enquiry_handler AS enquiry_handler_6, t0.enquiry_date AS enquiry_date_7, t0.enquiry_updated_date AS enquiry_updated_date_8, t0.size AS size_9, t0.production_company_id AS production_company_id_10, t0.production_status AS production_status_11, t0.requirement AS requirement_12, t0.max_crew_cast AS max_crew_cast_13, t0.reference AS reference_14, t0.comments AS comments_15, t0.are_you_location_manager AS are_you_location_manager_16, t0.is_music_promo_reqs_confirmed AS is_music_promo_reqs_confirmed_17, t0.lead_source_other AS lead_source_other_18, t0.lead_source_rec AS lead_source_rec_19, t0.total_hired_period AS total_hired_period_20, t0.projected_film_days AS projected_film_days_21, t0.no_of_supporting_artist AS no_of_supporting_artist_22, t0.projected_prep_strike_days AS projected_prep_strike_days_23, t0.projected_hold_days AS projected_hold_days_24, t0.budget AS budget_25, t0.approx_quote AS approx_quote_26, t0.deadline AS deadline_27, t0.commission_perc_gross AS commission_perc_gross_28, t0.commission_perc_net AS commission_perc_net_29, t0.commission_perc_net_override AS commission_perc_net_override_30, t0.commission_perc_gross_override AS commission_perc_gross_override_31, t0.member_commission_value AS member_commission_value_32, t0.library_fee AS library_fee_33, t0.fom_fee AS fom_fee_34, t0.collective_fee_gross_without_lf AS collective_fee_gross_without_lf_35, t0.collective_fee_net_without_lf AS collective_fee_net_without_lf_36, t0.collective_fee_gross_with_lf AS collective_fee_gross_with_lf_37, t0.collective_fee_net_with_lf AS collective_fee_net_with_lf_38, t0.library_fee_status AS library_fee_status_39, t0.fom_fee_status AS fom_fee_status_40, t0.enquiry_total_value AS enquiry_total_value_41, t0.remaining_hire_fee_to_the_owner AS remaining_hire_fee_to_the_owner_42, t0.notes AS notes_43, t0.owner_additonal_knowledge AS owner_additonal_knowledge_44, t0.synopsis AS synopsis_45, t0.non_negotiable AS non_negotiable_46, t0.where_they_want AS where_they_want_47, t0.locations_not_interested AS locations_not_interested_48, t0.special_requirements AS special_requirements_49, t0.hire_date_from AS hire_date_from_50, t0.hire_date_to AS hire_date_to_51, t0.parking_requests AS parking_requests_52, t0.controversial_script_sex_scenes AS controversial_script_sex_scenes_53, t0.controversial_script_sex_scenes_val AS controversial_script_sex_scenes_val_54, t0.night_shoot AS night_shoot_55, t0.night_shoot_val AS night_shoot_val_56, t0.smoke_set_for_filming_purposes AS smoke_set_for_filming_purposes_57, t0.smoke_set_for_filming_purposes_val AS smoke_set_for_filming_purposes_val_58, t0.pyrotechnics_fire AS pyrotechnics_fire_59, t0.pyrotechnics_fire_val AS pyrotechnics_fire_val_60, t0.gunfire_weapon_props AS gunfire_weapon_props_61, t0.gunfire_weapon_props_val AS gunfire_weapon_props_val_62, t0.wet_down AS wet_down_63, t0.wet_down_val AS wet_down_val_64, t0.stunts_car AS stunts_car_65, t0.stunts_car_val AS stunts_car_val_66, t0.non_vehicle_stunts AS non_vehicle_stunts_67, t0.non_vehicle_stunts_val AS non_vehicle_stunts_val_68, t0.scaffolding AS scaffolding_69, t0.scaffolding_val AS scaffolding_val_70, t0.blackout AS blackout_71, t0.blackout_val AS blackout_val_72, t0.smoke_haze_machine AS smoke_haze_machine_73, t0.smoke_haze_machine_val AS smoke_haze_machine_val_74, t0.nudity AS nudity_75, t0.nudity_val AS nudity_val_76, t0.reconstruction_of_crime AS reconstruction_of_crime_77, t0.reconstruction_of_crime_val AS reconstruction_of_crime_val_78, t0.other AS other_79, t0.other_val AS other_val_80, t0.animals AS animals_81, t0.animals_val AS animals_val_82, t0.play_back_music AS play_back_music_83, t0.play_back_music_val AS play_back_music_val_84, t0.children AS children_85, t0.children_val AS children_val_86, t0.expected_number_of_crew AS expected_number_of_crew_87, t0.expected_number_of_cast AS expected_number_of_cast_88, t0.max_crew_and_cast_on_a_single_day AS max_crew_and_cast_on_a_single_day_89, t0.customer_lightbox_rejection_reason AS customer_lightbox_rejection_reason_90, t0.customer_lightbox_new_brief AS customer_lightbox_new_brief_91, t0.hourly_rate AS hourly_rate_92, t0.hourly_rate_value AS hourly_rate_value_93, t0.no_hire_dates AS no_hire_dates_94, t0.split_days AS split_days_95, t0.manual_budget AS manual_budget_96, t0.enquiry_source AS enquiry_source_97, t0.enquiry_status AS enquiry_status_98, t0.attrp_notes AS attrp_notes_99, t0.weapon_props AS weapon_props_100, t0.weapon_props_val AS weapon_props_val_101, t0.play_back AS play_back_102, t0.parking AS parking_103, t0.enquiry_production_id AS enquiry_production_id_104, t0.production_company_id AS production_company_id_105, t0.deputy_contract_handler AS deputy_contract_handler_106, t0.lead_source_id AS lead_source_id_107, t0.production_type_id AS production_type_id_108, t0.location_type_id AS location_type_id_109, t0.customer_id AS customer_id_110, t0.saved_lightbox_id AS saved_lightbox_id_111, t0.enquiry_type_id AS enquiry_type_id_112, t0.enquiry_status_id AS enquiry_status_id_113, t0.enquiry_loss_id AS enquiry_loss_id_114, t0.production_base_id AS production_base_id_115, t0.production_status AS production_status_116, t0.enquiry_handler AS enquiry_handler_117, t0.updated_by AS updated_by_118 FROM j1_enquiry t0 WHERE t0.enquiry_id = '11780';

SELECT
  t0.id AS id_1,
  t0.most_recent_enjoyed_film AS most_recent_enjoyed_film_2,
  t0.customer_grade AS customer_grade_3,
  t0.user_satisfaction_level AS user_satisfaction_level_4,
  t0.most_recent_disappointed_film AS most_recent_disappointed_film_5,
  t0.current_favourite_tv_show AS current_favourite_tv_show_6,
  t0.strange_fact AS strange_fact_7,
  t0.favorite_collective_exclusive1 AS favorite_collective_exclusive1_8,
  t0.favorite_collective_exclusive2 AS favorite_collective_exclusive2_9,
  t0.favorite_collective_exclusive3 AS favorite_collective_exclusive3_10,
  t0.favorite_shoot_worked_date AS favorite_shoot_worked_date_11,
  t0.favorite_location_and_why AS favorite_location_and_why_12,
  t0.favorite_shoot_worked_reason AS favorite_shoot_worked_reason_13,
  t0.bucket_list_shoot1 AS bucket_list_shoot1_14,
  t0.bucket_list_shoot2 AS bucket_list_shoot2_15,
  t0.bucket_list_shoot3 AS bucket_list_shoot3_16,
  t0.landline AS landline_17,
  t0.landline2 AS landline2_18,
  t0.mobile_number AS mobile_number_19,
  t0.mobile_number2 AS mobile_number2_20,
  t0.email2 AS email2_21,
  t0.additional_email AS additional_email_22,
  t0.address1 AS address1_23,
  t0.address2 AS address2_24,
  t0.address3 AS address3_25,
  t0.company AS company_26,
  t0.imdb_link AS imdb_link_27,
  t0.location_manager AS location_manager_28,
  t0.post_code AS post_code_29,
  t0.title AS title_30,
  t0.town AS town_31,
  t0.county AS county_32,
  t0.lead_source_other AS lead_source_other_33,
  t0.lead_source_rec AS lead_source_rec_34,
  t0.user_note AS user_note_35,
  t0.user_email_signature AS user_email_signature_36,
  t0.is_latest_locations AS is_latest_locations_37,
  t0.is_themed_locations_emails AS is_themed_locations_emails_38,
  t0.is_themed_production_emails AS is_themed_production_emails_39,
  t0.is_quarterly_newsletter AS is_quarterly_newsletter_40,
  t0.is_location_collective_events_updates AS is_location_collective_events_updates_41,
  t0.membership_signed_at AS membership_signed_at_42,
  t0.membership_proposed_at AS membership_proposed_at_43,
  t0.membership_prosed AS membership_prosed_44,
  t0.last_date_contacted AS last_date_contacted_45,
  t0.last_touched AS last_touched_46,
  t0.job_title AS job_title_47,
  t0.fax AS fax_48,
  t49.userid AS userid_50,
  t49.otp_code AS otp_code_51,
  t49.otp_expiry_date AS otp_expiry_date_52,
  t49.password AS password_53,
  t49.last_password_change AS last_password_change_54,
  t49.forename AS forename_55,
  t49.surname AS surname_56,
  t49.full_name AS full_name_57,
  t49.email AS email_58,
  t49.status AS status_59,
  t49.initials AS initials_60,
  t49.xero_contact_id AS xero_contact_id_61,
  t49.created AS created_62,
  t49.color_code AS color_code_63,
  t49.modified AS modified_64,
  t49.is_system AS is_system_65,
  t49.is_member AS is_member_66,
  t49.member_id AS member_id_67,
  t49.lc_member_id AS lc_member_id_68,
  t49.reset_password_token AS reset_password_token_69,
  t49.createdby AS createdby_70,
  t49.modifiedby AS modifiedby_71,
  t49.user_profile_id AS user_profile_id_72,
  t0.profile_image_id AS profile_image_id_73,
  t0.department_id AS department_id_74,
  t0.country_id AS country_id_75,
  t0.user_position_id AS user_position_id_76,
  t0.lead_source_id AS lead_source_id_77,
  t0.enquirer_type_id AS enquirer_type_id_78
FROM
  j1_user_profile t0
  LEFT JOIN user t49 ON t49.user_profile_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.most_recent_enjoyed_film AS most_recent_enjoyed_film_2, t0.customer_grade AS customer_grade_3, t0.user_satisfaction_level AS user_satisfaction_level_4, t0.most_recent_disappointed_film AS most_recent_disappointed_film_5, t0.current_favourite_tv_show AS current_favourite_tv_show_6, t0.strange_fact AS strange_fact_7, t0.favorite_collective_exclusive1 AS favorite_collective_exclusive1_8, t0.favorite_collective_exclusive2 AS favorite_collective_exclusive2_9, t0.favorite_collective_exclusive3 AS favorite_collective_exclusive3_10, t0.favorite_shoot_worked_date AS favorite_shoot_worked_date_11, t0.favorite_location_and_why AS favorite_location_and_why_12, t0.favorite_shoot_worked_reason AS favorite_shoot_worked_reason_13, t0.bucket_list_shoot1 AS bucket_list_shoot1_14, t0.bucket_list_shoot2 AS bucket_list_shoot2_15, t0.bucket_list_shoot3 AS bucket_list_shoot3_16, t0.landline AS landline_17, t0.landline2 AS landline2_18, t0.mobile_number AS mobile_number_19, t0.mobile_number2 AS mobile_number2_20, t0.email2 AS email2_21, t0.additional_email AS additional_email_22, t0.address1 AS address1_23, t0.address2 AS address2_24, t0.address3 AS address3_25, t0.company AS company_26, t0.imdb_link AS imdb_link_27, t0.location_manager AS location_manager_28, t0.post_code AS post_code_29, t0.title AS title_30, t0.town AS town_31, t0.county AS county_32, t0.lead_source_other AS lead_source_other_33, t0.lead_source_rec AS lead_source_rec_34, t0.user_note AS user_note_35, t0.user_email_signature AS user_email_signature_36, t0.is_latest_locations AS is_latest_locations_37, t0.is_themed_locations_emails AS is_themed_locations_emails_38, t0.is_themed_production_emails AS is_themed_production_emails_39, t0.is_quarterly_newsletter AS is_quarterly_newsletter_40, t0.is_location_collective_events_updates AS is_location_collective_events_updates_41, t0.membership_signed_at AS membership_signed_at_42, t0.membership_proposed_at AS membership_proposed_at_43, t0.membership_prosed AS membership_prosed_44, t0.last_date_contacted AS last_date_contacted_45, t0.last_touched AS last_touched_46, t0.job_title AS job_title_47, t0.fax AS fax_48, t49.userid AS userid_50, t49.otp_code AS otp_code_51, t49.otp_expiry_date AS otp_expiry_date_52, t49.password AS password_53, t49.last_password_change AS last_password_change_54, t49.forename AS forename_55, t49.surname AS surname_56, t49.full_name AS full_name_57, t49.email AS email_58, t49.status AS status_59, t49.initials AS initials_60, t49.xero_contact_id AS xero_contact_id_61, t49.created AS created_62, t49.color_code AS color_code_63, t49.modified AS modified_64, t49.is_system AS is_system_65, t49.is_member AS is_member_66, t49.member_id AS member_id_67, t49.lc_member_id AS lc_member_id_68, t49.reset_password_token AS reset_password_token_69, t49.createdby AS createdby_70, t49.modifiedby AS modifiedby_71, t49.user_profile_id AS user_profile_id_72, t0.profile_image_id AS profile_image_id_73, t0.department_id AS department_id_74, t0.country_id AS country_id_75, t0.user_position_id AS user_position_id_76, t0.lead_source_id AS lead_source_id_77, t0.enquirer_type_id AS enquirer_type_id_78 FROM j1_user_profile t0 LEFT JOIN user t49 ON t49.user_profile_id = t0.id WHERE t0.id = 13967;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.enquiry_id AS enquiry_id_4,
  t0.user_id AS user_id_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7
FROM
  j1_enquiry_contact t0
WHERE
  t0.enquiry_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enquiry_id AS enquiry_id_4, t0.user_id AS user_id_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM j1_enquiry_contact t0 WHERE t0.enquiry_id = 11780;