Symfony Profiler

SELECT
  u0_.userid AS userid_0,
  u0_.otp_code AS otp_code_1,
  u0_.otp_expiry_date AS otp_expiry_date_2,
  u0_.password AS password_3,
  u0_.last_password_change AS last_password_change_4,
  u0_.forename AS forename_5,
  u0_.surname AS surname_6,
  u0_.full_name AS full_name_7,
  u0_.email AS email_8,
  u0_.status AS status_9,
  u0_.initials AS initials_10,
  u0_.xero_contact_id AS xero_contact_id_11,
  u0_.created AS created_12,
  u0_.color_code AS color_code_13,
  u0_.modified AS modified_14,
  u0_.is_system AS is_system_15,
  u0_.is_member AS is_member_16,
  u0_.member_id AS member_id_17,
  u0_.lc_member_id AS lc_member_id_18,
  u0_.reset_password_token AS reset_password_token_19,
  u0_.createdby AS createdby_20,
  u0_.modifiedby AS modifiedby_21,
  u0_.user_profile_id AS user_profile_id_22
FROM
  user u0_
  INNER JOIN j1_user_group_association j2_ ON u0_.userid = j2_.userid
  INNER JOIN j1_user_group j1_ ON j1_.groupid = j2_.groupid
WHERE
  u0_.email = ?

SELECT u0_.userid AS userid_0, u0_.otp_code AS otp_code_1, u0_.otp_expiry_date AS otp_expiry_date_2, u0_.password AS password_3, u0_.last_password_change AS last_password_change_4, u0_.forename AS forename_5, u0_.surname AS surname_6, u0_.full_name AS full_name_7, u0_.email AS email_8, u0_.status AS status_9, u0_.initials AS initials_10, u0_.xero_contact_id AS xero_contact_id_11, u0_.created AS created_12, u0_.color_code AS color_code_13, u0_.modified AS modified_14, u0_.is_system AS is_system_15, u0_.is_member AS is_member_16, u0_.member_id AS member_id_17, u0_.lc_member_id AS lc_member_id_18, u0_.reset_password_token AS reset_password_token_19, u0_.createdby AS createdby_20, u0_.modifiedby AS modifiedby_21, u0_.user_profile_id AS user_profile_id_22 FROM user u0_ INNER JOIN j1_user_group_association j2_ ON u0_.userid = j2_.userid INNER JOIN j1_user_group j1_ ON j1_.groupid = j2_.groupid WHERE u0_.email = 'userapi@gmail.com';

SELECT
  t0.groupid AS groupid_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.description AS description_4,
  t0.is_staff AS is_staff_5,
  t0.created AS created_6,
  t0.modified AS modified_7,
  t0.createdby AS createdby_8,
  t0.modifiedby AS modifiedby_9
FROM
  j1_user_group t0
  INNER JOIN j1_user_group_association ON t0.groupid = j1_user_group_association.groupid
WHERE
  j1_user_group_association.userid = ?

SELECT t0.groupid AS groupid_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.description AS description_4, t0.is_staff AS is_staff_5, t0.created AS created_6, t0.modified AS modified_7, t0.createdby AS createdby_8, t0.modifiedby AS modifiedby_9 FROM j1_user_group t0 INNER JOIN j1_user_group_association ON t0.groupid = j1_user_group_association.groupid WHERE j1_user_group_association.userid = 2;

SELECT
  t0.id AS id_1,
  t0.login_date AS login_date_2,
  t0.portal AS portal_3,
  t0.user_id AS user_id_4
FROM
  j1_user_login t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.login_date AS login_date_2, t0.portal AS portal_3, t0.user_id AS user_id_4 FROM j1_user_login t0 WHERE t0.user_id = 2 ORDER BY t0.id DESC;

SELECT
  t0.roleid AS roleid_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.description AS description_4,
  t0.system_role AS system_role_5
FROM
  j1_user_role t0
  INNER JOIN j1_user_group_roles ON t0.roleid = j1_user_group_roles.roleid
WHERE
  j1_user_group_roles.groupid = ?

SELECT t0.roleid AS roleid_1, t0.name AS name_2, t0.category AS category_3, t0.description AS description_4, t0.system_role AS system_role_5 FROM j1_user_role t0 INNER JOIN j1_user_group_roles ON t0.roleid = j1_user_group_roles.roleid WHERE j1_user_group_roles.groupid = 1;

SELECT
  t0.roleid AS roleid_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.description AS description_4,
  t0.system_role AS system_role_5
FROM
  j1_user_role t0
  INNER JOIN j1_user_roles ON t0.roleid = j1_user_roles.roleid
WHERE
  j1_user_roles.userid = ?

SELECT t0.roleid AS roleid_1, t0.name AS name_2, t0.category AS category_3, t0.description AS description_4, t0.system_role AS system_role_5 FROM j1_user_role t0 INNER JOIN j1_user_roles ON t0.roleid = j1_user_roles.roleid WHERE j1_user_roles.userid = 2;

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 = 27;

SELECT
  t0.id AS id_1,
  t0.category_id AS category_id_2,
  t0.title AS title_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.file_name AS file_name_6,
  t0.sub_folder AS sub_folder_7,
  t0.sort_order AS sort_order_8,
  t0.extra_data AS extra_data_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.category_id AS category_id_12,
  t0.created_by AS created_by_13,
  t0.updated_by AS updated_by_14
FROM
  j1_document t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.title AS title_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.file_name AS file_name_6, t0.sub_folder AS sub_folder_7, t0.sort_order AS sort_order_8, t0.extra_data AS extra_data_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14 FROM j1_document t0 WHERE t0.id = 267176;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.base_folder AS base_folder_4,
  t0.public AS public_5,
  t0.max_width AS max_width_6,
  t0.max_height AS max_height_7
FROM
  j1_document_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.base_folder AS base_folder_4, t0.public AS public_5, t0.max_width AS max_width_6, t0.max_height AS max_height_7 FROM j1_document_category t0 WHERE t0.id = 1;

SELECT
  j0_.id AS id_0,
  j0_.name AS name_1,
  j0_.description AS description_2,
  j0_.base_folder AS base_folder_3,
  j0_.public AS public_4,
  j0_.max_width AS max_width_5,
  j0_.max_height AS max_height_6
FROM
  j1_document_category j0_
WHERE
  j0_.name = ?

SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.description AS description_2, j0_.base_folder AS base_folder_3, j0_.public AS public_4, j0_.max_width AS max_width_5, j0_.max_height AS max_height_6 FROM j1_document_category j0_ WHERE j0_.name = 'LOCATION_PHOTOS';

SELECT
  t0.id AS id_1,
  t0.parent_category_id AS parent_category_id_2,
  t0.name AS name_3,
  t0.status AS status_4,
  t0.parent_category_path AS parent_category_path_5,
  t0.category_path AS category_path_6,
  t0.parent_category_path_names AS parent_category_path_names_7,
  t0.category_path_names AS category_path_names_8,
  t0.full_hierarchy_published_locations AS full_hierarchy_published_locations_9,
  t0.category_published_locations AS category_published_locations_10,
  t0.lc_category_id AS lc_category_id_11,
  t0.lc_category_image AS lc_category_image_12,
  t0.order_index AS order_index_13,
  t0.parent_category_id AS parent_category_id_14,
  t0.image_id AS image_id_15
FROM
  j1_location_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.parent_category_id AS parent_category_id_2, t0.name AS name_3, t0.status AS status_4, t0.parent_category_path AS parent_category_path_5, t0.category_path AS category_path_6, t0.parent_category_path_names AS parent_category_path_names_7, t0.category_path_names AS category_path_names_8, t0.full_hierarchy_published_locations AS full_hierarchy_published_locations_9, t0.category_published_locations AS category_published_locations_10, t0.lc_category_id AS lc_category_id_11, t0.lc_category_image AS lc_category_image_12, t0.order_index AS order_index_13, t0.parent_category_id AS parent_category_id_14, t0.image_id AS image_id_15 FROM j1_location_category t0 WHERE t0.id = '705';

SELECT
  DISTINCT d.id,
  b.j1_document_id AS image,
  d.name AS location_title,
  d.j1_parent_location_id,
  d.latitude,
  u.full_name As deputyManager,
  d.id AS location_id,
  d.longitude,
  d.town,
  d.lc_location_id,
  d.postcode,
  d.exclusive,
  d.tos_status,
  d.production,
  llt.name as location_type,
  d.commercial,
  d.residential,
  d.hide_fe_map,
  d.published,
  d.published_at,
  d.created_at,
  r.name AS region,
  b.j1_location_id,
  c.name AS category_name,
  c.parent_category_path_names,
  c.category_path_names,
  c.id AS category_id,
  GROUP_CONCAT(
    CONCAT(
      a.sub_folder,
      '/',
      a.file_name,
      '_',
      COALESCE(b.sort_order, 0)
    ) SEPARATOR ', '
  ) AS images
FROM
  j1_location AS d
  LEFT JOIN j1_location_listing_type as llt ON llt.id = d.j1_location_type_id
  JOIN j1_location_category_image AS b ON b.j1_location_id = d.id
  JOIN j1_location_category AS c ON b.j1_category_id = c.id
  LEFT JOIN j1_document AS a ON (a.id = b.j1_document_id)
  LEFT JOIN j1_location_region AS r ON d.region_id = r.id
  LEFT JOIN user AS u ON d.deputy_account_manager = u.userid
WHERE
  b.j1_category_id IN(705)
  AND d.published = 1
  AND d.is_deleted = 0
  AND llt.name NOT IN (
    'Offices', 'Exterior Build', 'Set Build',
    'Prop Stores', 'Costume Store',
    'Production Site'
  )
GROUP BY
  d.id
ORDER BY
  d.published_at DESC,
  d.exclusive DESC
LIMIT
  12
OFFSET
  0

SELECT DISTINCT
        d.id,
        b.j1_document_id AS image,
        d.name AS location_title,
        d.j1_parent_location_id,
        d.latitude,
        u.full_name As deputyManager,
        d.id AS location_id,
        d.longitude,
        d.town,
        d.lc_location_id,
        d.postcode,
        d.exclusive,
        d.tos_status,
        d.production,
        llt.name as location_type,        
        d.commercial,
        d.residential,
        d.hide_fe_map,
        d.published,
        d.published_at,
        d.created_at,
        r.name AS region,
        b.j1_location_id,
        c.name AS category_name,
        c.parent_category_path_names,
        c.category_path_names,
        c.id AS category_id,
        GROUP_CONCAT(CONCAT(a.sub_folder, '/', a.file_name, '_', COALESCE(b.sort_order, 0)) SEPARATOR ', ') AS images
        FROM j1_location AS d
        
        LEFT JOIN j1_location_listing_type as llt ON llt.id = d.j1_location_type_id
        JOIN j1_location_category_image AS b ON b.j1_location_id = d.id
        JOIN j1_location_category AS c ON b.j1_category_id = c.id
        LEFT JOIN j1_document AS a ON (a.id = b.j1_document_id)       
        LEFT JOIN j1_location_region AS r ON d.region_id = r.id
        LEFT JOIN user AS u ON d.deputy_account_manager = u.userid
        WHERE b.j1_category_id IN(705) AND d.published = 1 AND d.is_deleted = 0 AND llt.name NOT IN ('Offices', 'Exterior Build', 'Set Build', 'Prop Stores', 'Costume Store', 'Production Site')
        GROUP BY d.id ORDER BY d.published_at DESC, d.exclusive DESC LIMIT 12 OFFSET 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.description AS description_4,
  t0.show_desc_at_top AS show_desc_at_top_5,
  t0.commission AS commission_6,
  t0.published AS published_7,
  t0.server_link_to_image AS server_link_to_image_8,
  t0.seo_keywords AS seo_keywords_9,
  t0.dropbox_link AS dropbox_link_10,
  t0.video AS video_11,
  t0.parking AS parking_12,
  t0.business_rates_descriptions AS business_rates_descriptions_13,
  t0.exclusive AS exclusive_14,
  t0.noise_pollution AS noise_pollution_15,
  t0.problem AS problem_16,
  t0.commercial AS commercial_17,
  t0.residential AS residential_18,
  t0.be_spoke_contract AS be_spoke_contract_19,
  t0.single_tenancy AS single_tenancy_20,
  t0.order_index AS order_index_21,
  t0.shortlisted_from_fe_website_count AS shortlisted_from_fe_website_count_22,
  t0.production AS production_23,
  t0.express_friendly AS express_friendly_24,
  t0.address AS address_25,
  t0.address1 AS address1_26,
  t0.address2 AS address2_27,
  t0.address3 AS address3_28,
  t0.town AS town_29,
  t0.county AS county_30,
  t0.country_code AS country_code_31,
  t0.postcode AS postcode_32,
  t0.postcode_prefix AS postcode_prefix_33,
  t0.latitude AS latitude_34,
  t0.longitude AS longitude_35,
  t0.expire_date AS expire_date_36,
  t0.published_at AS published_at_37,
  t0.signed_at AS signed_at_38,
  t0.renewal_at AS renewal_at_39,
  t0.created_at AS created_at_40,
  t0.updated_at AS updated_at_41,
  t0.location_owner_id AS location_owner_id_42,
  t0.lc_location_id AS lc_location_id_43,
  t0.borough_council_film_office AS borough_council_film_office_44,
  t0.borough_council_film_office_no AS borough_council_film_office_no_45,
  t0.borough_council_film_office_email AS borough_council_film_office_email_46,
  t0.borough_council_film_office_postcode AS borough_council_film_office_postcode_47,
  t0.size_sq_fit AS size_sq_fit_48,
  t0.is_deleted AS is_deleted_49,
  t0.hide_fe_map AS hide_fe_map_50,
  t0.is_business_rates AS is_business_rates_51,
  t0.preview_token AS preview_token_52,
  t0.lc_recces AS lc_recces_53,
  t0.revenue_generated AS revenue_generated_54,
  t0.view_in_exclusive_dashboard AS view_in_exclusive_dashboard_55,
  t0.contact_notes AS contact_notes_56,
  t0.google_calendar_id AS google_calendar_id_57,
  t0.tos_status AS tos_status_58,
  t0.recce_requests_count AS recce_requests_count_59,
  t0.availability_requests_count AS availability_requests_count_60,
  t0.invoice_reference AS invoice_reference_61,
  t0.legal_company_name AS legal_company_name_62,
  t0.billing_address AS billing_address_63,
  t0.billing_town AS billing_town_64,
  t0.same_as_registered_address AS same_as_registered_address_65,
  t0.vat_on_boarded AS vat_on_boarded_66,
  t0.billing_postcode AS billing_postcode_67,
  t0.trading_address AS trading_address_68,
  t0.trading_address_town AS trading_address_town_69,
  t0.trading_address_postcode AS trading_address_postcode_70,
  t0.process_exceptions_status AS process_exceptions_status_71,
  t0.process_exceptions AS process_exceptions_72,
  t0.vat_applicable AS vat_applicable_73,
  t0.vat_number AS vat_number_74,
  t0.company_registration_no AS company_registration_no_75,
  t0.bank_account_name AS bank_account_name_76,
  t0.bank_name AS bank_name_77,
  t0.bank_account_no AS bank_account_no_78,
  t0.bank_sort_code AS bank_sort_code_79,
  t0.xero_account_id AS xero_account_id_80,
  t0.is_it_registered_company AS is_it_registered_company_81,
  t0.is_vat_registered AS is_vat_registered_82,
  t0.is_accounts_audited AS is_accounts_audited_83,
  t0.j1_parent_location_id AS j1_parent_location_id_84,
  t85.id AS id_86,
  t85.measurement_type AS measurement_type_87,
  t85.total_area AS total_area_88,
  t85.width AS width_89,
  t85.length AS length_90,
  t85.ceiling_height AS ceiling_height_91,
  t85.working_height AS working_height_92,
  t85.weight_loading AS weight_loading_93,
  t85.floor_capacity AS floor_capacity_94,
  t85.ceiling_weight_capacity AS ceiling_weight_capacity_95,
  t85.clear_span AS clear_span_96,
  t85.power_capacity AS power_capacity_97,
  t85.power_type AS power_type_98,
  t85.ext_area AS ext_area_99,
  t85.ext_foot_print AS ext_foot_print_100,
  t85.no_of_parking_bays AS no_of_parking_bays_101,
  t85.has_internet AS has_internet_102,
  t85.internet_description AS internet_description_103,
  t85.blackout_status AS blackout_status_104,
  t85.blackout_description AS blackout_description_105,
  t85.access_door_sizes AS access_door_sizes_106,
  t85.availability_status AS availability_status_107,
  t85.availability_details AS availability_details_108,
  t85.available_from AS available_from_109,
  t85.available_to AS available_to_110,
  t85.price_per_sq_ft AS price_per_sq_ft_111,
  t85.service_charges AS service_charges_112,
  t85.cleaning_charges AS cleaning_charges_113,
  t85.security_charges AS security_charges_114,
  t85.sq_ft_override AS sq_ft_override_115,
  t85.furniture AS furniture_116,
  t85.metered_utilities AS metered_utilities_117,
  t85.waste_removal AS waste_removal_118,
  t85.recycling_services AS recycling_services_119,
  t85.location_id AS location_id_120,
  t0.j1_location_type_id AS j1_location_type_id_121,
  t0.region_id AS region_id_122,
  t0.location_acquisition_id AS location_acquisition_id_123,
  t0.account_manager AS account_manager_124,
  t0.deputy_account_manager AS deputy_account_manager_125,
  t0.production_account_manager AS production_account_manager_126,
  t0.key_account_manager_id AS key_account_manager_id_127,
  t0.location_owner_id AS location_owner_id_128,
  t0.location_cull_status_id AS location_cull_status_id_129,
  t0.location_risk_type_id AS location_risk_type_id_130,
  t0.location_parent_account_id AS location_parent_account_id_131,
  t0.location_borough AS location_borough_132
FROM
  j1_location t0
  LEFT JOIN j1_location_space_details t85 ON t85.location_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.show_desc_at_top AS show_desc_at_top_5, t0.commission AS commission_6, t0.published AS published_7, t0.server_link_to_image AS server_link_to_image_8, t0.seo_keywords AS seo_keywords_9, t0.dropbox_link AS dropbox_link_10, t0.video AS video_11, t0.parking AS parking_12, t0.business_rates_descriptions AS business_rates_descriptions_13, t0.exclusive AS exclusive_14, t0.noise_pollution AS noise_pollution_15, t0.problem AS problem_16, t0.commercial AS commercial_17, t0.residential AS residential_18, t0.be_spoke_contract AS be_spoke_contract_19, t0.single_tenancy AS single_tenancy_20, t0.order_index AS order_index_21, t0.shortlisted_from_fe_website_count AS shortlisted_from_fe_website_count_22, t0.production AS production_23, t0.express_friendly AS express_friendly_24, t0.address AS address_25, t0.address1 AS address1_26, t0.address2 AS address2_27, t0.address3 AS address3_28, t0.town AS town_29, t0.county AS county_30, t0.country_code AS country_code_31, t0.postcode AS postcode_32, t0.postcode_prefix AS postcode_prefix_33, t0.latitude AS latitude_34, t0.longitude AS longitude_35, t0.expire_date AS expire_date_36, t0.published_at AS published_at_37, t0.signed_at AS signed_at_38, t0.renewal_at AS renewal_at_39, t0.created_at AS created_at_40, t0.updated_at AS updated_at_41, t0.location_owner_id AS location_owner_id_42, t0.lc_location_id AS lc_location_id_43, t0.borough_council_film_office AS borough_council_film_office_44, t0.borough_council_film_office_no AS borough_council_film_office_no_45, t0.borough_council_film_office_email AS borough_council_film_office_email_46, t0.borough_council_film_office_postcode AS borough_council_film_office_postcode_47, t0.size_sq_fit AS size_sq_fit_48, t0.is_deleted AS is_deleted_49, t0.hide_fe_map AS hide_fe_map_50, t0.is_business_rates AS is_business_rates_51, t0.preview_token AS preview_token_52, t0.lc_recces AS lc_recces_53, t0.revenue_generated AS revenue_generated_54, t0.view_in_exclusive_dashboard AS view_in_exclusive_dashboard_55, t0.contact_notes AS contact_notes_56, t0.google_calendar_id AS google_calendar_id_57, t0.tos_status AS tos_status_58, t0.recce_requests_count AS recce_requests_count_59, t0.availability_requests_count AS availability_requests_count_60, t0.invoice_reference AS invoice_reference_61, t0.legal_company_name AS legal_company_name_62, t0.billing_address AS billing_address_63, t0.billing_town AS billing_town_64, t0.same_as_registered_address AS same_as_registered_address_65, t0.vat_on_boarded AS vat_on_boarded_66, t0.billing_postcode AS billing_postcode_67, t0.trading_address AS trading_address_68, t0.trading_address_town AS trading_address_town_69, t0.trading_address_postcode AS trading_address_postcode_70, t0.process_exceptions_status AS process_exceptions_status_71, t0.process_exceptions AS process_exceptions_72, t0.vat_applicable AS vat_applicable_73, t0.vat_number AS vat_number_74, t0.company_registration_no AS company_registration_no_75, t0.bank_account_name AS bank_account_name_76, t0.bank_name AS bank_name_77, t0.bank_account_no AS bank_account_no_78, t0.bank_sort_code AS bank_sort_code_79, t0.xero_account_id AS xero_account_id_80, t0.is_it_registered_company AS is_it_registered_company_81, t0.is_vat_registered AS is_vat_registered_82, t0.is_accounts_audited AS is_accounts_audited_83, t0.j1_parent_location_id AS j1_parent_location_id_84, t85.id AS id_86, t85.measurement_type AS measurement_type_87, t85.total_area AS total_area_88, t85.width AS width_89, t85.length AS length_90, t85.ceiling_height AS ceiling_height_91, t85.working_height AS working_height_92, t85.weight_loading AS weight_loading_93, t85.floor_capacity AS floor_capacity_94, t85.ceiling_weight_capacity AS ceiling_weight_capacity_95, t85.clear_span AS clear_span_96, t85.power_capacity AS power_capacity_97, t85.power_type AS power_type_98, t85.ext_area AS ext_area_99, t85.ext_foot_print AS ext_foot_print_100, t85.no_of_parking_bays AS no_of_parking_bays_101, t85.has_internet AS has_internet_102, t85.internet_description AS internet_description_103, t85.blackout_status AS blackout_status_104, t85.blackout_description AS blackout_description_105, t85.access_door_sizes AS access_door_sizes_106, t85.availability_status AS availability_status_107, t85.availability_details AS availability_details_108, t85.available_from AS available_from_109, t85.available_to AS available_to_110, t85.price_per_sq_ft AS price_per_sq_ft_111, t85.service_charges AS service_charges_112, t85.cleaning_charges AS cleaning_charges_113, t85.security_charges AS security_charges_114, t85.sq_ft_override AS sq_ft_override_115, t85.furniture AS furniture_116, t85.metered_utilities AS metered_utilities_117, t85.waste_removal AS waste_removal_118, t85.recycling_services AS recycling_services_119, t85.location_id AS location_id_120, t0.j1_location_type_id AS j1_location_type_id_121, t0.region_id AS region_id_122, t0.location_acquisition_id AS location_acquisition_id_123, t0.account_manager AS account_manager_124, t0.deputy_account_manager AS deputy_account_manager_125, t0.production_account_manager AS production_account_manager_126, t0.key_account_manager_id AS key_account_manager_id_127, t0.location_owner_id AS location_owner_id_128, t0.location_cull_status_id AS location_cull_status_id_129, t0.location_risk_type_id AS location_risk_type_id_130, t0.location_parent_account_id AS location_parent_account_id_131, t0.location_borough AS location_borough_132 FROM j1_location t0 LEFT JOIN j1_location_space_details t85 ON t85.location_id = t0.id WHERE t0.id = 10165;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO j1_location_stats (
  type, ip_address, date_visited, location_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (1, '109.169.83.63', NULL, 10165);

"COMMIT"

"COMMIT";