Query Metrics
20
Database Queries
19
Different statements
27.62 ms
Query time
0
Invalid entities
153
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
10.72 ms (38.82%) |
1 |
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:
[
"8470"
]
|
|
2.28 ms (8.26%) |
1 |
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 INNER JOIN j1_location_filming_production_association ON t0.id = j1_location_filming_production_association.production_loc_id WHERE j1_location_filming_production_association.filming_loc_id = ?
Parameters:
[
8470
]
|
|
2.06 ms (7.44%) |
1 |
SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.short_name AS short_name_2, j0_.description AS description_3, j0_.show_desc_at_top AS show_desc_at_top_4, j0_.commission AS commission_5, j0_.published AS published_6, j0_.server_link_to_image AS server_link_to_image_7, j0_.seo_keywords AS seo_keywords_8, j0_.dropbox_link AS dropbox_link_9, j0_.video AS video_10, j0_.parking AS parking_11, j0_.business_rates_descriptions AS business_rates_descriptions_12, j0_.exclusive AS exclusive_13, j0_.noise_pollution AS noise_pollution_14, j0_.problem AS problem_15, j0_.commercial AS commercial_16, j0_.residential AS residential_17, j0_.be_spoke_contract AS be_spoke_contract_18, j0_.single_tenancy AS single_tenancy_19, j0_.order_index AS order_index_20, j0_.shortlisted_from_fe_website_count AS shortlisted_from_fe_website_count_21, j0_.production AS production_22, j0_.express_friendly AS express_friendly_23, j0_.address AS address_24, j0_.address1 AS address1_25, j0_.address2 AS address2_26, j0_.address3 AS address3_27, j0_.town AS town_28, j0_.county AS county_29, j0_.country_code AS country_code_30, j0_.postcode AS postcode_31, j0_.postcode_prefix AS postcode_prefix_32, j0_.latitude AS latitude_33, j0_.longitude AS longitude_34, j0_.expire_date AS expire_date_35, j0_.published_at AS published_at_36, j0_.signed_at AS signed_at_37, j0_.renewal_at AS renewal_at_38, j0_.created_at AS created_at_39, j0_.updated_at AS updated_at_40, j0_.location_owner_id AS location_owner_id_41, j0_.lc_location_id AS lc_location_id_42, j0_.borough_council_film_office AS borough_council_film_office_43, j0_.borough_council_film_office_no AS borough_council_film_office_no_44, j0_.borough_council_film_office_email AS borough_council_film_office_email_45, j0_.borough_council_film_office_postcode AS borough_council_film_office_postcode_46, j0_.size_sq_fit AS size_sq_fit_47, j0_.is_deleted AS is_deleted_48, j0_.hide_fe_map AS hide_fe_map_49, j0_.is_business_rates AS is_business_rates_50, j0_.preview_token AS preview_token_51, j0_.lc_recces AS lc_recces_52, j0_.revenue_generated AS revenue_generated_53, j0_.view_in_exclusive_dashboard AS view_in_exclusive_dashboard_54, j0_.contact_notes AS contact_notes_55, j0_.google_calendar_id AS google_calendar_id_56, j0_.tos_status AS tos_status_57, j0_.recce_requests_count AS recce_requests_count_58, j0_.availability_requests_count AS availability_requests_count_59, j0_.invoice_reference AS invoice_reference_60, j0_.legal_company_name AS legal_company_name_61, j0_.billing_address AS billing_address_62, j0_.billing_town AS billing_town_63, j0_.same_as_registered_address AS same_as_registered_address_64, j0_.vat_on_boarded AS vat_on_boarded_65, j0_.billing_postcode AS billing_postcode_66, j0_.trading_address AS trading_address_67, j0_.trading_address_town AS trading_address_town_68, j0_.trading_address_postcode AS trading_address_postcode_69, j0_.process_exceptions_status AS process_exceptions_status_70, j0_.process_exceptions AS process_exceptions_71, j0_.vat_applicable AS vat_applicable_72, j0_.vat_number AS vat_number_73, j0_.company_registration_no AS company_registration_no_74, j0_.bank_account_name AS bank_account_name_75, j0_.bank_name AS bank_name_76, j0_.bank_account_no AS bank_account_no_77, j0_.bank_sort_code AS bank_sort_code_78, j0_.xero_account_id AS xero_account_id_79, j0_.is_it_registered_company AS is_it_registered_company_80, j0_.is_vat_registered AS is_vat_registered_81, j0_.is_accounts_audited AS is_accounts_audited_82, j0_.j1_parent_location_id AS j1_parent_location_id_83, j0_.j1_location_type_id AS j1_location_type_id_84, j0_.region_id AS region_id_85, j0_.location_acquisition_id AS location_acquisition_id_86, j0_.account_manager AS account_manager_87, j0_.deputy_account_manager AS deputy_account_manager_88, j0_.production_account_manager AS production_account_manager_89, j0_.key_account_manager_id AS key_account_manager_id_90, j0_.location_owner_id AS location_owner_id_91, j0_.location_cull_status_id AS location_cull_status_id_92, j0_.location_risk_type_id AS location_risk_type_id_93, j0_.location_parent_account_id AS location_parent_account_id_94, j0_.location_borough AS location_borough_95 FROM j1_location j0_ WHERE (j0_.id = ? OR j0_.lc_location_id = ?) AND j0_.is_deleted = ? AND j0_.published = 1
Parameters:
[ "8470" "8470" 0 ] |
|
1.82 ms (6.59%) |
1 |
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 INNER JOIN j1_location_photos ON t0.id = j1_location_photos.j1_document_id WHERE j1_location_photos.j1_location_id = ? ORDER BY t0.sort_order ASC, t0.id ASC
Parameters:
[
8470
]
|
|
1.48 ms (5.35%) |
1 |
SELECT t0.id AS id_1, t0.note_type AS note_type_2, t0.note AS note_3, t0.file AS file_4, t0.j1_location_id AS j1_location_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.j1_location_id AS j1_location_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM j1_location_notes t0 WHERE t0.j1_location_id = ?
Parameters:
[
8470
]
|
|
1.21 ms (4.38%) |
1 |
SELECT j0_.id AS id_0, j0_.name AS name_1 FROM j1_location_category j0_ INNER JOIN j1_location_category_image j1_ ON j0_.id = j1_.j1_category_id WHERE j1_.j1_location_id = ? GROUP BY j1_.j1_category_id ORDER BY j0_.name * 1 ASC, j0_.name ASC
Parameters:
[
8470
]
|
|
1.21 ms (4.37%) |
1 |
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"
]
|
|
1.12 ms (4.05%) |
1 |
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 INNER JOIN j1_location_uploads ON t0.id = j1_location_uploads.j1_document_id WHERE j1_location_uploads.j1_location_id = ?
Parameters:
[
8470
]
|
|
1.11 ms (4.03%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.97 ms (3.51%) |
1 |
INSERT INTO j1_location_stats (type, ip_address, date_visited, location_id) VALUES (?, ?, ?, ?)
Parameters:
[ 0 "109.169.83.63" null 8470 ] |
|
0.95 ms (3.42%) |
2 |
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
]
|
|
0.69 ms (2.52%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3, t0.order_index AS order_index_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM j1_location_listing_type t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
0.38 ms (1.37%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.35 ms (1.27%) |
1 |
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
]
|
|
0.33 ms (1.20%) |
1 |
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
]
|
|
0.29 ms (1.05%) |
1 |
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
]
|
|
0.23 ms (0.81%) |
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_group_roles ON t0.roleid = j1_user_group_roles.roleid WHERE j1_user_group_roles.groupid = ?
Parameters:
[
1
]
|
|
0.21 ms (0.78%) |
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 = ?
Parameters:
[
2
]
|
|
0.21 ms (0.77%) |
1 |
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
]
|
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\J1Document | 13 |
| App\Entity\User | 7 |
| App\Entity\J1LocationNote | 6 |
| App\Entity\J1DocumentCategory | 2 |
| App\Entity\J1UserProfile | 1 |
| App\Entity\J1UserGroup | 1 |
| App\Entity\J1Location | 1 |
| App\Entity\J1LocationListingType | 1 |
| App\Entity\J1LocationBorough | 1 |
| App\Entity\J1LocationStat | 1 |