Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.username AS username_4,
  t0.address AS address_5,
  t0.roles AS roles_6,
  t0.company_relation AS company_relation_7,
  t0.avatar AS avatar_8,
  t0.phone AS phone_9,
  t0.birth_date AS birth_date_10,
  t0.card_number AS card_number_11,
  t0.cad_date_issue AS cad_date_issue_12,
  t0.card_expiry_date AS card_expiry_date_13,
  t0.license_number AS license_number_14,
  t0.license_date_issue AS license_date_issue_15,
  t0.license_expiry_date AS license_expiry_date_16,
  t0.stripecustomerid AS stripecustomerid_17,
  t0.phones AS phones_18,
  t0.discount_limit AS discount_limit_19,
  t0.points AS points_20,
  t0.deleted_at AS deleted_at_21,
  t0.reset_token AS reset_token_22,
  t0.reset_token_expires_at AS reset_token_expires_at_23,
  t0.visa_card_number AS visa_card_number_24,
  t0.car_transferred_points AS car_transferred_points_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.user_id AS user_id_28,
  t0.company_id AS company_id_29,
  t0.role_id AS role_id_30,
  t0.company_agency_id AS company_agency_id_31,
  t0.country_id AS country_id_32,
  t0.created_by_id AS created_by_id_33,
  t34.id AS id_35,
  t34.deleted_at AS deleted_at_36,
  t34.status AS status_37,
  t34.created_at AS created_at_38,
  t34.updated_at AS updated_at_39,
  t34.badge_id AS badge_id_40,
  t34.customer_id AS customer_id_41,
  t34.affected_by_id AS affected_by_id_42,
  t34.company_id AS company_id_43,
  t0.user_organization_id AS user_organization_id_44
FROM
  user_company t0
  LEFT JOIN user_badge t34 ON t34.customer_id = t0.id
WHERE
  t0.email = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.username AS username_4, t0.address AS address_5, t0.roles AS roles_6, t0.company_relation AS company_relation_7, t0.avatar AS avatar_8, t0.phone AS phone_9, t0.birth_date AS birth_date_10, t0.card_number AS card_number_11, t0.cad_date_issue AS cad_date_issue_12, t0.card_expiry_date AS card_expiry_date_13, t0.license_number AS license_number_14, t0.license_date_issue AS license_date_issue_15, t0.license_expiry_date AS license_expiry_date_16, t0.stripecustomerid AS stripecustomerid_17, t0.phones AS phones_18, t0.discount_limit AS discount_limit_19, t0.points AS points_20, t0.deleted_at AS deleted_at_21, t0.reset_token AS reset_token_22, t0.reset_token_expires_at AS reset_token_expires_at_23, t0.visa_card_number AS visa_card_number_24, t0.car_transferred_points AS car_transferred_points_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.user_id AS user_id_28, t0.company_id AS company_id_29, t0.role_id AS role_id_30, t0.company_agency_id AS company_agency_id_31, t0.country_id AS country_id_32, t0.created_by_id AS created_by_id_33, t34.id AS id_35, t34.deleted_at AS deleted_at_36, t34.status AS status_37, t34.created_at AS created_at_38, t34.updated_at AS updated_at_39, t34.badge_id AS badge_id_40, t34.customer_id AS customer_id_41, t34.affected_by_id AS affected_by_id_42, t34.company_id AS company_id_43, t0.user_organization_id AS user_organization_id_44 FROM user_company t0 LEFT JOIN user_badge t34 ON t34.customer_id = t0.id WHERE t0.email = 'jamel.abderrahim@omancar.com' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.star_date AS star_date_2,
  t0.end_date AS end_date_3,
  t0.start_date_transfer AS start_date_transfer_4,
  t0.end_date_transfer AS end_date_transfer_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.authority_role_id AS authority_role_id_9,
  t0.user_company_id AS user_company_id_10,
  t0.transfer_to_id AS transfer_to_id_11
FROM
  user_role t0
WHERE
  t0.user_company_id IN (?)
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.star_date AS star_date_2, t0.end_date AS end_date_3, t0.start_date_transfer AS start_date_transfer_4, t0.end_date_transfer AS end_date_transfer_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.authority_role_id AS authority_role_id_9, t0.user_company_id AS user_company_id_10, t0.transfer_to_id AS transfer_to_id_11 FROM user_role t0 WHERE t0.user_company_id IN (259) AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.code AS code_3,
  t0.flag AS flag_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.flag AS flag_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM language t0 WHERE t0.code = 'ar' LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.username AS username_3,
  u0_.address AS address_4,
  u0_.roles AS roles_5,
  u0_.company_relation AS company_relation_6,
  u0_.avatar AS avatar_7,
  u0_.phone AS phone_8,
  u0_.birth_date AS birth_date_9,
  u0_.card_number AS card_number_10,
  u0_.cad_date_issue AS cad_date_issue_11,
  u0_.card_expiry_date AS card_expiry_date_12,
  u0_.license_number AS license_number_13,
  u0_.license_date_issue AS license_date_issue_14,
  u0_.license_expiry_date AS license_expiry_date_15,
  u0_.stripecustomerid AS stripecustomerid_16,
  u0_.phones AS phones_17,
  u0_.discount_limit AS discount_limit_18,
  u0_.points AS points_19,
  u0_.deleted_at AS deleted_at_20,
  u0_.reset_token AS reset_token_21,
  u0_.reset_token_expires_at AS reset_token_expires_at_22,
  u0_.visa_card_number AS visa_card_number_23,
  u0_.car_transferred_points AS car_transferred_points_24,
  u0_.created_at AS created_at_25,
  u0_.updated_at AS updated_at_26,
  u0_.user_id AS user_id_27,
  u0_.company_id AS company_id_28,
  u0_.role_id AS role_id_29,
  u0_.company_agency_id AS company_agency_id_30,
  u0_.country_id AS country_id_31,
  u0_.created_by_id AS created_by_id_32,
  u0_.user_organization_id AS user_organization_id_33
FROM
  user_company u0_
  INNER JOIN role r1_ ON u0_.role_id = r1_.id
  INNER JOIN company c2_ ON u0_.company_id = c2_.id
  AND (c2_.deleted_at IS NULL)
WHERE
  (
    r1_.role = ?
    AND c2_.id = ?
    AND u0_.id <> ?
  )
  AND (u0_.deleted_at IS NULL)
ORDER BY
  u0_.created_at DESC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.username AS username_3, u0_.address AS address_4, u0_.roles AS roles_5, u0_.company_relation AS company_relation_6, u0_.avatar AS avatar_7, u0_.phone AS phone_8, u0_.birth_date AS birth_date_9, u0_.card_number AS card_number_10, u0_.cad_date_issue AS cad_date_issue_11, u0_.card_expiry_date AS card_expiry_date_12, u0_.license_number AS license_number_13, u0_.license_date_issue AS license_date_issue_14, u0_.license_expiry_date AS license_expiry_date_15, u0_.stripecustomerid AS stripecustomerid_16, u0_.phones AS phones_17, u0_.discount_limit AS discount_limit_18, u0_.points AS points_19, u0_.deleted_at AS deleted_at_20, u0_.reset_token AS reset_token_21, u0_.reset_token_expires_at AS reset_token_expires_at_22, u0_.visa_card_number AS visa_card_number_23, u0_.car_transferred_points AS car_transferred_points_24, u0_.created_at AS created_at_25, u0_.updated_at AS updated_at_26, u0_.user_id AS user_id_27, u0_.company_id AS company_id_28, u0_.role_id AS role_id_29, u0_.company_agency_id AS company_agency_id_30, u0_.country_id AS country_id_31, u0_.created_by_id AS created_by_id_32, u0_.user_organization_id AS user_organization_id_33 FROM user_company u0_ INNER JOIN role r1_ ON u0_.role_id = r1_.id INNER JOIN company c2_ ON u0_.company_id = c2_.id AND (c2_.deleted_at IS NULL) WHERE (r1_.role = 'ROLE_AGENT' AND c2_.id = 81 AND u0_.id <> 259) AND (u0_.deleted_at IS NULL) ORDER BY u0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.badge_id AS badge_id_6,
  t0.customer_id AS customer_id_7,
  t0.affected_by_id AS affected_by_id_8,
  t0.company_id AS company_id_9
FROM
  user_badge t0
WHERE
  t0.customer_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.badge_id AS badge_id_6, t0.customer_id AS customer_id_7, t0.affected_by_id AS affected_by_id_8, t0.company_id AS company_id_9 FROM user_badge t0 WHERE t0.customer_id = 260 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.star_date AS star_date_2,
  t0.end_date AS end_date_3,
  t0.start_date_transfer AS start_date_transfer_4,
  t0.end_date_transfer AS end_date_transfer_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.authority_role_id AS authority_role_id_9,
  t0.user_company_id AS user_company_id_10,
  t0.transfer_to_id AS transfer_to_id_11
FROM
  user_role t0
WHERE
  t0.user_company_id IN (?)
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.star_date AS star_date_2, t0.end_date AS end_date_3, t0.start_date_transfer AS start_date_transfer_4, t0.end_date_transfer AS end_date_transfer_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.authority_role_id AS authority_role_id_9, t0.user_company_id AS user_company_id_10, t0.transfer_to_id AS transfer_to_id_11 FROM user_role t0 WHERE t0.user_company_id IN (260) AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.nationality AS nationality_4,
  t0.id_card_type AS id_card_type_5,
  t0.address AS address_6,
  t0.card_place_issue AS card_place_issue_7,
  t0.license_place_issue AS license_place_issue_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.user_company_id AS user_company_id_11,
  t0.language_id AS language_id_12
FROM
  user_company_translate t0
WHERE
  t0.user_company_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.nationality AS nationality_4, t0.id_card_type AS id_card_type_5, t0.address AS address_6, t0.card_place_issue AS card_place_issue_7, t0.license_place_issue AS license_place_issue_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_company_id AS user_company_id_11, t0.language_id AS language_id_12 FROM user_company_translate t0 WHERE t0.user_company_id = 260;

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.website AS website_4,
  t0.tax_number AS tax_number_5,
  t0.logo AS logo_6,
  t0.fax AS fax_7,
  t0.type AS type_8,
  t0.longitude AS longitude_9,
  t0.latitude AS latitude_10,
  t0.online_payment AS online_payment_11,
  t0.cash_payment AS cash_payment_12,
  t0.phones AS phones_13,
  t0.installment_payment AS installment_payment_14,
  t0.deleted_at AS deleted_at_15,
  t0.vat AS vat_16,
  t0.letter_head AS letter_head_17,
  t0.company_number AS company_number_18,
  t0.last_import_violation AS last_import_violation_19,
  t0.last_violation_number AS last_violation_number_20,
  t0.footer_content AS footer_content_21,
  t0.booking_notification_duration AS booking_notification_duration_22,
  t0.is_new_partner AS is_new_partner_23,
  t0.agent_request_point AS agent_request_point_24,
  t0.agent_response_point AS agent_response_point_25,
  t0.booking_transfer_point AS booking_transfer_point_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t29.id AS id_30,
  t29.primary_color AS primary_color_31,
  t29.secondary_color AS secondary_color_32,
  t29.favicon AS favicon_33,
  t29.logo AS logo_34,
  t29.active AS active_35,
  t29.disable AS disable_36,
  t29.lable AS lable_37,
  t29.button AS button_38,
  t29.border AS border_39,
  t29.danger AS danger_40,
  t29.created_at AS created_at_41,
  t29.updated_at AS updated_at_42,
  t29.company_id AS company_id_43,
  t0.country_id AS country_id_44,
  t0.company_type_id AS company_type_id_45,
  t46.id AS id_47,
  t46.created_at AS created_at_48,
  t46.updated_at AS updated_at_49,
  t46.country_id AS country_id_50,
  t46.company_id AS company_id_51,
  t0.booking_charge_id AS booking_charge_id_52
FROM
  company t0
  LEFT JOIN company_setting t29 ON t29.company_id = t0.id
  LEFT JOIN terms t46 ON t46.company_id = t0.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.website AS website_4, t0.tax_number AS tax_number_5, t0.logo AS logo_6, t0.fax AS fax_7, t0.type AS type_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.online_payment AS online_payment_11, t0.cash_payment AS cash_payment_12, t0.phones AS phones_13, t0.installment_payment AS installment_payment_14, t0.deleted_at AS deleted_at_15, t0.vat AS vat_16, t0.letter_head AS letter_head_17, t0.company_number AS company_number_18, t0.last_import_violation AS last_import_violation_19, t0.last_violation_number AS last_violation_number_20, t0.footer_content AS footer_content_21, t0.booking_notification_duration AS booking_notification_duration_22, t0.is_new_partner AS is_new_partner_23, t0.agent_request_point AS agent_request_point_24, t0.agent_response_point AS agent_response_point_25, t0.booking_transfer_point AS booking_transfer_point_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t29.id AS id_30, t29.primary_color AS primary_color_31, t29.secondary_color AS secondary_color_32, t29.favicon AS favicon_33, t29.logo AS logo_34, t29.active AS active_35, t29.disable AS disable_36, t29.lable AS lable_37, t29.button AS button_38, t29.border AS border_39, t29.danger AS danger_40, t29.created_at AS created_at_41, t29.updated_at AS updated_at_42, t29.company_id AS company_id_43, t0.country_id AS country_id_44, t0.company_type_id AS company_type_id_45, t46.id AS id_47, t46.created_at AS created_at_48, t46.updated_at AS updated_at_49, t46.country_id AS country_id_50, t46.company_id AS company_id_51, t0.booking_charge_id AS booking_charge_id_52 FROM company t0 LEFT JOIN company_setting t29 ON t29.company_id = t0.id LEFT JOIN terms t46 ON t46.company_id = t0.id WHERE t0.id = 81 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.company_id AS company_id_6,
  t0.language_id AS language_id_7
FROM
  company_translate t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_id AS company_id_6, t0.language_id AS language_id_7 FROM company_translate t0 WHERE t0.company_id = 81;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.code AS code_3,
  t0.flag AS flag_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.flag AS flag_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM language t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.role AS role_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  role t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.role AS role_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM role t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.fax AS fax_3,
  t0.repair_center AS repair_center_4,
  t0.email AS email_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.location AS location_8,
  t0.phones AS phones_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.company_id AS company_id_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14,
  t0.city_id AS city_id_15
FROM
  company_agency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.fax AS fax_3, t0.repair_center AS repair_center_4, t0.email AS email_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.location AS location_8, t0.phones AS phones_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.company_id AS company_id_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.city_id AS city_id_15 FROM company_agency t0 WHERE t0.id = 192;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.company_agency_id AS company_agency_id_6,
  t0.language_id AS language_id_7,
  t0.user_id AS user_id_8
FROM
  company_agency_translate t0
WHERE
  t0.company_agency_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_agency_id AS company_agency_id_6, t0.language_id AS language_id_7, t0.user_id AS user_id_8 FROM company_agency_translate t0 WHERE t0.company_agency_id = 192;