Query Metrics
60
Database Queries
16
Different statements
290.58 ms
Query time
0
Invalid entities
168
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.14 ms |
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 = ?
Parameters:
[
"userapi@gmail.com"
]
|
2 | 0.29 ms |
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 = ?
Parameters:
[
2
]
|
3 | 0.19 ms |
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
Parameters:
[
2
]
|
4 | 0.31 ms |
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 = ?
Parameters:
[
1
]
|
5 | 0.25 ms |
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 = ?
Parameters:
[
2
]
|
6 | 0.40 ms |
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 = ?
Parameters:
[
27
]
|
7 | 0.29 ms |
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 = ?
Parameters:
[
267176
]
|
8 | 0.32 ms |
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 = ?
Parameters:
[
1
]
|
9 | 0.81 ms |
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 = ?
Parameters:
[
"LOCATION_PHOTOS"
]
|
10 | 0.74 ms |
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 = ?
Parameters:
[
"705"
]
|
11 | 216.59 ms |
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
Parameters:
[] |
12 | 14.74 ms |
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 = ?
Parameters:
[
10165
]
|
13 | 0.32 ms |
"START TRANSACTION"
Parameters:
[] |
14 | 1.04 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 10165 ] |
15 | 1.36 ms |
"COMMIT"
Parameters:
[] |
16 | 1.65 ms |
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 = ?
Parameters:
[
10145
]
|
17 | 0.26 ms |
"START TRANSACTION"
Parameters:
[] |
18 | 0.47 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 10145 ] |
19 | 0.87 ms |
"COMMIT"
Parameters:
[] |
20 | 1.86 ms |
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 = ?
Parameters:
[
10146
]
|
21 | 0.31 ms |
"START TRANSACTION"
Parameters:
[] |
22 | 0.55 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 10146 ] |
23 | 0.81 ms |
"COMMIT"
Parameters:
[] |
24 | 1.54 ms |
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 = ?
Parameters:
[
8967
]
|
25 | 0.48 ms |
"START TRANSACTION"
Parameters:
[] |
26 | 0.48 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 8967 ] |
27 | 0.87 ms |
"COMMIT"
Parameters:
[] |
28 | 1.63 ms |
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 = ?
Parameters:
[
9096
]
|
29 | 0.24 ms |
"START TRANSACTION"
Parameters:
[] |
30 | 0.42 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 9096 ] |
31 | 0.65 ms |
"COMMIT"
Parameters:
[] |
32 | 1.56 ms |
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 = ?
Parameters:
[
8826
]
|
33 | 0.23 ms |
"START TRANSACTION"
Parameters:
[] |
34 | 0.45 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 8826 ] |
35 | 0.60 ms |
"COMMIT"
Parameters:
[] |
36 | 1.48 ms |
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 = ?
Parameters:
[
9433
]
|
37 | 0.22 ms |
"START TRANSACTION"
Parameters:
[] |
38 | 0.40 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 9433 ] |
39 | 0.59 ms |
"COMMIT"
Parameters:
[] |
40 | 1.54 ms |
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 = ?
Parameters:
[
9985
]
|
41 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
42 | 16.81 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 9985 ] |
43 | 0.66 ms |
"COMMIT"
Parameters:
[] |
44 | 1.50 ms |
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 = ?
Parameters:
[
9965
]
|
45 | 0.29 ms |
"START TRANSACTION"
Parameters:
[] |
46 | 0.44 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 9965 ] |
47 | 0.66 ms |
"COMMIT"
Parameters:
[] |
48 | 1.52 ms |
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 = ?
Parameters:
[
9934
]
|
49 | 0.38 ms |
"START TRANSACTION"
Parameters:
[] |
50 | 0.49 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 9934 ] |
51 | 0.67 ms |
"COMMIT"
Parameters:
[] |
52 | 1.53 ms |
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 = ?
Parameters:
[
4856
]
|
53 | 0.24 ms |
"START TRANSACTION"
Parameters:
[] |
54 | 0.40 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 4856 ] |
55 | 0.76 ms |
"COMMIT"
Parameters:
[] |
56 | 1.51 ms |
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 = ?
Parameters:
[
5317
]
|
57 | 0.27 ms |
"START TRANSACTION"
Parameters:
[] |
58 | 0.43 ms |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "109.169.83.63" null 5317 ] |
59 | 0.70 ms |
"COMMIT"
Parameters:
[] |
60 | 2.18 ms |
SELECT count(DISTINCT(d.id)) as TotalCount FROM j1_location AS d INNER JOIN j1_location_category_image AS b ON b.j1_location_id = d.id INNER JOIN j1_location_category AS c ON b.j1_category_id = c.id LEFT JOIN j1_location_listing_type as llt ON llt.id = d.j1_location_type_id 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')
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\J1UserRole | 119 |
App\Entity\J1Location | 12 |
App\Entity\J1LocationStat | 12 |
App\Entity\User | 9 |
App\Entity\J1LocationBorough | 4 |
App\Entity\J1Document | 2 |
App\Entity\J1DocumentCategory | 2 |
App\Entity\J1LocationCategory | 2 |
App\Entity\J1LocationListingType | 2 |
App\Entity\J1UserProfile | 1 |
App\Entity\J1UserGroup | 1 |
App\Entity\J1LocationCullStatus | 1 |
App\Entity\J1LocationRiskType | 1 |