Symfony Profiler

UPDATE
  j1_audit
SET
  audited_object_description = 'CX-Haider Ali'
WHERE
  audited_object = 'StaffUser'
  AND audited_entity_id = 8

UPDATE j1_audit SET audited_object_description = 'CX-Haider Ali' WHERE audited_object = 'StaffUser' AND audited_entity_id = 8;

UPDATE
  user
SET
  otp_code = ?,
  otp_expiry_date = ?,
  modified = ?
WHERE
  userid = ?

UPDATE user SET otp_code = 5132, otp_expiry_date = '2025-04-20 20:00:34', modified = 1745179234 WHERE userid = 8;

"COMMIT"

"COMMIT";

INSERT INTO j1_audit (
  setting_id, audited_entity_id, audited_object,
  audited_object_description, action,
  old_data, new_data, details_route,
  created, createdby
)
VALUES
  (
    1, 8, 'StaffUser', 'CX-Haider Ali',
    'Modified User', 'a:0:{}', 'a:0:{}',
    'a:2:{s:4:"name";s:9:"user_edit";s:18:"identity_parameter";s:6:"userId";}',
    1745179234, 8
  )

INSERT INTO j1_audit
                    (setting_id, audited_entity_id, audited_object, audited_object_description, action, old_data, new_data, details_route, created, createdby)
                    VALUES (1, 8, 'StaffUser', 'CX-Haider Ali', 'Modified User', 'a:0:{}', 'a:0:{}', 'a:2:{s:4:"name";s:9:"user_edit";s:18:"identity_parameter";s:6:"userId";}', 1745179234, 8);

SELECT
  j0_.setting_id AS setting_id_0,
  j0_.feature_code AS feature_code_1,
  j0_.feature_description AS feature_description_2,
  j0_.audit_enabled AS audit_enabled_3,
  j0_.audit_insert AS audit_insert_4,
  j0_.audit_update AS audit_update_5,
  j0_.audit_delete AS audit_delete_6
FROM
  j1_audit_setting j0_
WHERE
  j0_.feature_code = ?

SELECT j0_.setting_id AS setting_id_0, j0_.feature_code AS feature_code_1, j0_.feature_description AS feature_description_2, j0_.audit_enabled AS audit_enabled_3, j0_.audit_insert AS audit_insert_4, j0_.audit_update AS audit_update_5, j0_.audit_delete AS audit_delete_6 FROM j1_audit_setting j0_ WHERE j0_.feature_code = 'USERS';

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

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

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

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

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

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

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO j1_user_login (login_date, portal, user_id)
VALUES
  (?, ?, ?)

INSERT INTO j1_user_login (login_date, portal, user_id) VALUES ('2025-04-20', 1, 8);

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

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

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

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

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

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

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

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