Symfony Profiler

SELECT
  t0.status AS status_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.slug AS slug_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.parent_id AS parent_id_10
FROM
  system_role t0
  INNER JOIN menu_system_role ON t0.id = menu_system_role.system_role_id
WHERE
  menu_system_role.menu_id = ?

SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.description AS description_6, t0.slug AS slug_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.parent_id AS parent_id_10 FROM system_role t0 INNER JOIN menu_system_role ON t0.id = menu_system_role.system_role_id WHERE menu_system_role.menu_id = 20;

SELECT
  t0.status AS status_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.code AS code_6,
  t0.timezone AS timezone_7,
  t0.postal_code AS postal_code_8,
  t0.street AS street_9,
  t0.number AS number_10,
  t0.neighborhood AS neighborhood_11,
  t0.municipality AS municipality_12,
  t0.carrier_contact_name AS carrier_contact_name_13,
  t0.carrier_rfc AS carrier_rfc_14,
  t0.carrier_reference AS carrier_reference_15,
  t0.carrier_phone AS carrier_phone_16,
  t0.carrier_email AS carrier_email_17,
  t0.latitude AS latitude_18,
  t0.longitude AS longitude_19,
  t0.number_internal AS number_internal_20,
  t0.map_width_px AS map_width_px_21,
  t0.map_height_px AS map_height_px_22,
  t0.map_scale_meters_per_px AS map_scale_meters_per_px_23,
  t0.map_north_rotation_deg AS map_north_rotation_deg_24,
  t0.default_perimeter_clearance_m AS default_perimeter_clearance_m_25,
  t0.default_inter_rack_gap_m AS default_inter_rack_gap_m_26,
  t0.default_operational_aisle_m AS default_operational_aisle_m_27,
  t0.default_cross_aisle_m AS default_cross_aisle_m_28,
  t0.default_safety_front_m AS default_safety_front_m_29,
  t0.created_by_id AS created_by_id_30,
  t0.updated_by_id AS updated_by_id_31,
  t0.state_id AS state_id_32
FROM
  warehouse t0
WHERE
  t0.status = ?
ORDER BY
  t0.name ASC

SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.code AS code_6, t0.timezone AS timezone_7, t0.postal_code AS postal_code_8, t0.street AS street_9, t0.number AS number_10, t0.neighborhood AS neighborhood_11, t0.municipality AS municipality_12, t0.carrier_contact_name AS carrier_contact_name_13, t0.carrier_rfc AS carrier_rfc_14, t0.carrier_reference AS carrier_reference_15, t0.carrier_phone AS carrier_phone_16, t0.carrier_email AS carrier_email_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19, t0.number_internal AS number_internal_20, t0.map_width_px AS map_width_px_21, t0.map_height_px AS map_height_px_22, t0.map_scale_meters_per_px AS map_scale_meters_per_px_23, t0.map_north_rotation_deg AS map_north_rotation_deg_24, t0.default_perimeter_clearance_m AS default_perimeter_clearance_m_25, t0.default_inter_rack_gap_m AS default_inter_rack_gap_m_26, t0.default_operational_aisle_m AS default_operational_aisle_m_27, t0.default_cross_aisle_m AS default_cross_aisle_m_28, t0.default_safety_front_m AS default_safety_front_m_29, t0.created_by_id AS created_by_id_30, t0.updated_by_id AS updated_by_id_31, t0.state_id AS state_id_32 FROM warehouse t0 WHERE t0.status = 1 ORDER BY t0.name ASC;

SELECT
  m0_.status AS status_0,
  m0_.created_at AS created_at_1,
  m0_.updated_at AS updated_at_2,
  m0_.id AS id_3,
  m0_.name AS name_4,
  m0_.icon AS icon_5,
  m0_.position AS position_6,
  m0_.app_route AS app_route_7,
  m0_.button AS button_8,
  m1_.status AS status_9,
  m1_.created_at AS created_at_10,
  m1_.updated_at AS updated_at_11,
  m1_.id AS id_12,
  m1_.name AS name_13,
  m1_.icon AS icon_14,
  m1_.position AS position_15,
  m1_.app_route AS app_route_16,
  m1_.button AS button_17,
  m0_.created_by_id AS created_by_id_18,
  m0_.updated_by_id AS updated_by_id_19,
  m0_.parent_id AS parent_id_20,
  m1_.created_by_id AS created_by_id_21,
  m1_.updated_by_id AS updated_by_id_22,
  m1_.parent_id AS parent_id_23
FROM
  menu m0_
  LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id
  AND (
    m1_.status = ?
    AND m1_.button = ?
  )
  LEFT JOIN menu_system_role m3_ ON m0_.id = m3_.menu_id
  LEFT JOIN system_role s2_ ON s2_.id = m3_.system_role_id
  LEFT JOIN menu_system_role m5_ ON m1_.id = m5_.menu_id
  LEFT JOIN system_role s4_ ON s4_.id = m5_.system_role_id
WHERE
  m0_.status = ?
  AND m0_.parent_id IS NULL
  AND s2_.slug IN (?)
  AND (
    s4_.slug IN (?)
    OR s4_.id IS NULL
  )
  AND m0_.button = ?
ORDER BY
  m0_.position ASC,
  m1_.position ASC

SELECT m0_.status AS status_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.id AS id_3, m0_.name AS name_4, m0_.icon AS icon_5, m0_.position AS position_6, m0_.app_route AS app_route_7, m0_.button AS button_8, m1_.status AS status_9, m1_.created_at AS created_at_10, m1_.updated_at AS updated_at_11, m1_.id AS id_12, m1_.name AS name_13, m1_.icon AS icon_14, m1_.position AS position_15, m1_.app_route AS app_route_16, m1_.button AS button_17, m0_.created_by_id AS created_by_id_18, m0_.updated_by_id AS updated_by_id_19, m0_.parent_id AS parent_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.parent_id AS parent_id_23 FROM menu m0_ LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id AND (m1_.status = 1 AND m1_.button = 1) LEFT JOIN menu_system_role m3_ ON m0_.id = m3_.menu_id LEFT JOIN system_role s2_ ON s2_.id = m3_.system_role_id LEFT JOIN menu_system_role m5_ ON m1_.id = m5_.menu_id LEFT JOIN system_role s4_ ON s4_.id = m5_.system_role_id WHERE m0_.status = 1 AND m0_.parent_id IS NULL AND s2_.slug IN ('ROLE_SYS_ADMIN') AND (s4_.slug IN ('ROLE_SYS_ADMIN') OR s4_.id IS NULL) AND m0_.button = 1 ORDER BY m0_.position ASC, m1_.position ASC;

SELECT
  CASE WHEN u0_.status IS NULL THEN
    0
  ELSE
    1
  END AS sclr_0,
  CONCAT(u0_.name, ' ', u0_.lastname) AS sclr_1,
  u0_.status AS status_2,
  u0_.created_at AS created_at_3,
  u0_.updated_at AS updated_at_4,
  u0_.id AS id_5,
  u0_.name AS name_6,
  u0_.lastname AS lastname_7,
  u0_.mother_lastname AS mother_lastname_8,
  u0_.password AS password_9,
  u0_.email AS email_10,
  u0_.last_login AS last_login_11,
  u0_.roles AS roles_12,
  u0_.succesful_login AS succesful_login_13,
  s1_.status AS status_14,
  s1_.created_at AS created_at_15,
  s1_.updated_at AS updated_at_16,
  s1_.id AS id_17,
  s1_.name AS name_18,
  s1_.description AS description_19,
  s1_.slug AS slug_20,
  p2_.status AS status_21,
  p2_.created_at AS created_at_22,
  p2_.updated_at AS updated_at_23,
  p2_.id AS id_24,
  p2_.code AS code_25,
  p2_.name AS name_26,
  p2_.type AS type_27,
  p2_.provider_status AS provider_status_28,
  p2_.contact_name AS contact_name_29,
  p2_.email AS email_30,
  p2_.phone AS phone_31,
  p2_.tax_id AS tax_id_32,
  p2_.handles_transport AS handles_transport_33,
  p2_.handles_warehouse AS handles_warehouse_34,
  u0_.created_by_id AS created_by_id_35,
  u0_.updated_by_id AS updated_by_id_36,
  u0_.system_role_id AS system_role_id_37,
  u0_.client_id AS client_id_38,
  u0_.provider_id AS provider_id_39,
  s1_.created_by_id AS created_by_id_40,
  s1_.updated_by_id AS updated_by_id_41,
  s1_.parent_id AS parent_id_42,
  p2_.created_by_id AS created_by_id_43,
  p2_.updated_by_id AS updated_by_id_44
FROM
  user u0_
  LEFT JOIN system_role s1_ ON u0_.system_role_id = s1_.id
  LEFT JOIN provider p2_ ON u0_.provider_id = p2_.id
WHERE
  s1_.id NOT IN (?)
  AND u0_.system_role_id = ?
  AND u0_.id IN (?, ?, ?)
ORDER BY
  sclr_0 ASC,
  sclr_1 ASC

SELECT CASE WHEN u0_.status IS NULL THEN 0 ELSE 1 END AS sclr_0, CONCAT(u0_.name, ' ', u0_.lastname) AS sclr_1, u0_.status AS status_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4, u0_.id AS id_5, u0_.name AS name_6, u0_.lastname AS lastname_7, u0_.mother_lastname AS mother_lastname_8, u0_.password AS password_9, u0_.email AS email_10, u0_.last_login AS last_login_11, u0_.roles AS roles_12, u0_.succesful_login AS succesful_login_13, s1_.status AS status_14, s1_.created_at AS created_at_15, s1_.updated_at AS updated_at_16, s1_.id AS id_17, s1_.name AS name_18, s1_.description AS description_19, s1_.slug AS slug_20, p2_.status AS status_21, p2_.created_at AS created_at_22, p2_.updated_at AS updated_at_23, p2_.id AS id_24, p2_.code AS code_25, p2_.name AS name_26, p2_.type AS type_27, p2_.provider_status AS provider_status_28, p2_.contact_name AS contact_name_29, p2_.email AS email_30, p2_.phone AS phone_31, p2_.tax_id AS tax_id_32, p2_.handles_transport AS handles_transport_33, p2_.handles_warehouse AS handles_warehouse_34, u0_.created_by_id AS created_by_id_35, u0_.updated_by_id AS updated_by_id_36, u0_.system_role_id AS system_role_id_37, u0_.client_id AS client_id_38, u0_.provider_id AS provider_id_39, s1_.created_by_id AS created_by_id_40, s1_.updated_by_id AS updated_by_id_41, s1_.parent_id AS parent_id_42, p2_.created_by_id AS created_by_id_43, p2_.updated_by_id AS updated_by_id_44 FROM user u0_ LEFT JOIN system_role s1_ ON u0_.system_role_id = s1_.id LEFT JOIN provider p2_ ON u0_.provider_id = p2_.id WHERE s1_.id NOT IN (12) AND u0_.system_role_id = 8 AND u0_.id IN (8, 19, 18) ORDER BY sclr_0 ASC, sclr_1 ASC;

SELECT
  t0.status AS status_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.icon AS icon_6,
  t0.position AS position_7,
  t0.app_route AS app_route_8,
  t0.button AS button_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.parent_id AS parent_id_12
FROM
  menu t0

SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.icon AS icon_6, t0.position AS position_7, t0.app_route AS app_route_8, t0.button AS button_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.parent_id AS parent_id_12 FROM menu t0;

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN system_role s1_ ON u0_.system_role_id = s1_.id
  LEFT JOIN provider p2_ ON u0_.provider_id = p2_.id
WHERE
  s1_.id NOT IN (?)
  AND u0_.system_role_id = ?

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN system_role s1_ ON u0_.system_role_id = s1_.id LEFT JOIN provider p2_ ON u0_.provider_id = p2_.id WHERE s1_.id NOT IN (12) AND u0_.system_role_id = 8;

SELECT
  DISTINCT u0_.id AS id_0,
  CASE WHEN u0_.status IS NULL THEN
    0
  ELSE
    1
  END AS sclr_1,
  CONCAT(u0_.name, ' ', u0_.lastname) AS sclr_2
FROM
  user u0_
  LEFT JOIN system_role s1_ ON u0_.system_role_id = s1_.id
  LEFT JOIN provider p2_ ON u0_.provider_id = p2_.id
WHERE
  s1_.id NOT IN (?)
  AND u0_.system_role_id = ?
ORDER BY
  sclr_1 ASC,
  sclr_2 ASC
LIMIT
  20

SELECT DISTINCT u0_.id AS id_0, CASE WHEN u0_.status IS NULL THEN 0 ELSE 1 END AS sclr_1, CONCAT(u0_.name, ' ', u0_.lastname) AS sclr_2 FROM user u0_ LEFT JOIN system_role s1_ ON u0_.system_role_id = s1_.id LEFT JOIN provider p2_ ON u0_.provider_id = p2_.id WHERE s1_.id NOT IN (12) AND u0_.system_role_id = 8 ORDER BY sclr_1 ASC, sclr_2 ASC LIMIT 20;

SELECT
  t0.status AS status_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.icon AS icon_6,
  t0.position AS position_7,
  t0.app_route AS app_route_8,
  t0.button AS button_9,
  t0.created_by_id AS created_by_id_10,
  t0.updated_by_id AS updated_by_id_11,
  t0.parent_id AS parent_id_12
FROM
  menu t0
WHERE
  t0.app_route = ?
LIMIT
  1

SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.icon AS icon_6, t0.position AS position_7, t0.app_route AS app_route_8, t0.button AS button_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.parent_id AS parent_id_12 FROM menu t0 WHERE t0.app_route = 'app_provider_user_index' LIMIT 1;

SELECT
  t0.status AS status_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.code AS code_6,
  t0.timezone AS timezone_7,
  t0.postal_code AS postal_code_8,
  t0.street AS street_9,
  t0.number AS number_10,
  t0.neighborhood AS neighborhood_11,
  t0.municipality AS municipality_12,
  t0.carrier_contact_name AS carrier_contact_name_13,
  t0.carrier_rfc AS carrier_rfc_14,
  t0.carrier_reference AS carrier_reference_15,
  t0.carrier_phone AS carrier_phone_16,
  t0.carrier_email AS carrier_email_17,
  t0.latitude AS latitude_18,
  t0.longitude AS longitude_19,
  t0.number_internal AS number_internal_20,
  t0.map_width_px AS map_width_px_21,
  t0.map_height_px AS map_height_px_22,
  t0.map_scale_meters_per_px AS map_scale_meters_per_px_23,
  t0.map_north_rotation_deg AS map_north_rotation_deg_24,
  t0.default_perimeter_clearance_m AS default_perimeter_clearance_m_25,
  t0.default_inter_rack_gap_m AS default_inter_rack_gap_m_26,
  t0.default_operational_aisle_m AS default_operational_aisle_m_27,
  t0.default_cross_aisle_m AS default_cross_aisle_m_28,
  t0.default_safety_front_m AS default_safety_front_m_29,
  t0.created_by_id AS created_by_id_30,
  t0.updated_by_id AS updated_by_id_31,
  t0.state_id AS state_id_32
FROM
  warehouse t0
  INNER JOIN user_warehouse ON t0.id = user_warehouse.warehouse_id
WHERE
  user_warehouse.user_id = ?

SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.code AS code_6, t0.timezone AS timezone_7, t0.postal_code AS postal_code_8, t0.street AS street_9, t0.number AS number_10, t0.neighborhood AS neighborhood_11, t0.municipality AS municipality_12, t0.carrier_contact_name AS carrier_contact_name_13, t0.carrier_rfc AS carrier_rfc_14, t0.carrier_reference AS carrier_reference_15, t0.carrier_phone AS carrier_phone_16, t0.carrier_email AS carrier_email_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19, t0.number_internal AS number_internal_20, t0.map_width_px AS map_width_px_21, t0.map_height_px AS map_height_px_22, t0.map_scale_meters_per_px AS map_scale_meters_per_px_23, t0.map_north_rotation_deg AS map_north_rotation_deg_24, t0.default_perimeter_clearance_m AS default_perimeter_clearance_m_25, t0.default_inter_rack_gap_m AS default_inter_rack_gap_m_26, t0.default_operational_aisle_m AS default_operational_aisle_m_27, t0.default_cross_aisle_m AS default_cross_aisle_m_28, t0.default_safety_front_m AS default_safety_front_m_29, t0.created_by_id AS created_by_id_30, t0.updated_by_id AS updated_by_id_31, t0.state_id AS state_id_32 FROM warehouse t0 INNER JOIN user_warehouse ON t0.id = user_warehouse.warehouse_id WHERE user_warehouse.user_id = 1;

SELECT
  t0.status AS status_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.slug AS slug_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.parent_id AS parent_id_10
FROM
  system_role t0
WHERE
  t0.id = ?

SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.description AS description_6, t0.slug AS slug_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.parent_id AS parent_id_10 FROM system_role t0 WHERE t0.id = 1;

SELECT
  t0.status AS status_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.slug AS slug_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.parent_id AS parent_id_10
FROM
  system_role t0

SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.description AS description_6, t0.slug AS slug_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.parent_id AS parent_id_10 FROM system_role t0;

SELECT
  t0.status AS status_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.lastname AS lastname_6,
  t0.mother_lastname AS mother_lastname_7,
  t0.password AS password_8,
  t0.email AS email_9,
  t0.last_login AS last_login_10,
  t0.roles AS roles_11,
  t0.succesful_login AS succesful_login_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14,
  t0.system_role_id AS system_role_id_15,
  t0.client_id AS client_id_16,
  t0.provider_id AS provider_id_17
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.status AS status_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.mother_lastname AS mother_lastname_7, t0.password AS password_8, t0.email AS email_9, t0.last_login AS last_login_10, t0.roles AS roles_11, t0.succesful_login AS succesful_login_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t0.system_role_id AS system_role_id_15, t0.client_id AS client_id_16, t0.provider_id AS provider_id_17 FROM user t0 WHERE t0.id = 1;