Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.role AS role_3,
  t0.importance AS importance_4,
  t0.enabled AS enabled_5
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.importance AS importance_4, t0.enabled AS enabled_5 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 703;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.facebook_id AS facebook_id_6,
  t0.google_id AS google_id_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.gender AS gender_10,
  t0.phone AS phone_11,
  t0.landline_phone AS landline_phone_12,
  t0.accepted_tou AS accepted_tou_13,
  t0.image_url AS image_url_14,
  t0.deleted AS deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.image_name AS image_name_19,
  t0.image_original_name AS image_original_name_20,
  t0.image_mime_type AS image_mime_type_21,
  t0.image_size AS image_size_22,
  t0.image_dimensions AS image_dimensions_23,
  t0.discr,
  t0.franchise_id AS franchise_id_24,
  t0.shop_id AS shop_id_25,
  t0.device_id AS device_id_26,
  t0.notification_email AS notification_email_27,
  t0.notification_sms AS notification_sms_28,
  t0.receive_qoodos_notification AS receive_qoodos_notification_29,
  t0.default_language AS default_language_30,
  t0.source AS source_31,
  t0.phone_verified AS phone_verified_32
FROM
  user t0
WHERE
  t0.email = ?
  AND t0.discr IN (
    'user', 'manager', 'shopmanager',
    'customer', 'administrator', 'support',
    'developer'
  )
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.facebook_id AS facebook_id_6, t0.google_id AS google_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.gender AS gender_10, t0.phone AS phone_11, t0.landline_phone AS landline_phone_12, t0.accepted_tou AS accepted_tou_13, t0.image_url AS image_url_14, t0.deleted AS deleted_15, t0.deleted_at AS deleted_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.image_name AS image_name_19, t0.image_original_name AS image_original_name_20, t0.image_mime_type AS image_mime_type_21, t0.image_size AS image_size_22, t0.image_dimensions AS image_dimensions_23, t0.discr, t0.franchise_id AS franchise_id_24, t0.shop_id AS shop_id_25, t0.device_id AS device_id_26, t0.notification_email AS notification_email_27, t0.notification_sms AS notification_sms_28, t0.receive_qoodos_notification AS receive_qoodos_notification_29, t0.default_language AS default_language_30, t0.source AS source_31, t0.phone_verified AS phone_verified_32 FROM user t0 WHERE t0.email = 'api@foxorders.com' AND t0.discr IN ('user', 'manager', 'shopmanager', 'customer', 'administrator', 'support', 'developer') AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.qoodos_id AS qoodos_id_1,
  f0_.multiple AS multiple_2,
  f0_.name AS name_3,
  f0_.status AS status_4,
  f0_.qoodos_tokens AS qoodos_tokens_5,
  f0_.created_at AS created_at_6,
  f0_.updated_at AS updated_at_7,
  f0_.token AS token_8
FROM
  franchise f0_
  INNER JOIN domain d1_ ON f0_.id = d1_.franchise_id
WHERE
  d1_.url = ?
LIMIT
  1

SELECT f0_.id AS id_0, f0_.qoodos_id AS qoodos_id_1, f0_.multiple AS multiple_2, f0_.name AS name_3, f0_.status AS status_4, f0_.qoodos_tokens AS qoodos_tokens_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7, f0_.token AS token_8 FROM franchise f0_ INNER JOIN domain d1_ ON f0_.id = d1_.franchise_id WHERE d1_.url = 'https://bornelouvine.dev-foxorders.fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.header AS header_2,
  t0.enable_header AS enable_header_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.keywords AS keywords_6,
  t0.map AS map_7,
  t0.google_auth_enabled AS google_auth_enabled_8,
  t0.apple_auth_enabled AS apple_auth_enabled_9,
  t0.signup_text AS signup_text_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.franchise_id AS franchise_id_13,
  t0.locale_id AS locale_id_14
FROM
  parameter t0
WHERE
  t0.franchise_id = ?

SELECT t0.id AS id_1, t0.header AS header_2, t0.enable_header AS enable_header_3, t0.title AS title_4, t0.description AS description_5, t0.keywords AS keywords_6, t0.map AS map_7, t0.google_auth_enabled AS google_auth_enabled_8, t0.apple_auth_enabled AS apple_auth_enabled_9, t0.signup_text AS signup_text_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.franchise_id AS franchise_id_13, t0.locale_id AS locale_id_14 FROM parameter t0 WHERE t0.franchise_id = 14;

SELECT
  count(s0_.id) AS sclr_0
FROM
  source s0_
WHERE
  s0_.code = ?
  AND s0_.enabled = ?
  AND s0_.api = ?

SELECT count(s0_.id) AS sclr_0 FROM source s0_ WHERE s0_.code = 'foxorders-front' AND s0_.enabled = 1 AND s0_.api = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone AS phone_3,
  t0.secondary_phone AS secondary_phone_4,
  t0.fax AS fax_5,
  t0.email AS email_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.franchise_id AS franchise_id_9
FROM
  company t0
WHERE
  t0.franchise_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.secondary_phone AS secondary_phone_4, t0.fax AS fax_5, t0.email AS email_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.franchise_id AS franchise_id_9 FROM company t0 WHERE t0.franchise_id = 14;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.dsn AS dsn_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  mail_transport t0
WHERE
  t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.dsn AS dsn_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM mail_transport t0 WHERE t0.enabled = 1 LIMIT 1;