Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.active AS active_8,
  t0.locale AS locale_9,
  t0.newsletter AS newsletter_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deactivate_date AS deactivate_date_13,
  t0.group_id AS group_id_14,
  t0.company_id AS company_id_15,
  t0.client_id AS client_id_16,
  t0.division_id AS division_id_17,
  t0.client_localization_id AS client_localization_id_18,
  t19.id AS id_20,
  t19.notifications AS notifications_21,
  t19.user_id AS user_id_22,
  t23.id AS id_24,
  t23.after_login_route AS after_login_route_25,
  t23.user_id AS user_id_26,
  t23.printer_id AS printer_id_27,
  t23.mqtt_broker_id AS mqtt_broker_id_28,
  t0.worker_id AS worker_id_29,
  t0.created_by AS created_by_30,
  t0.updated_by AS updated_by_31
FROM
  user t0
  LEFT JOIN user_notification t19 ON t19.user_id = t0.id
  LEFT JOIN user_setting t23 ON t23.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.active AS active_8, t0.locale AS locale_9, t0.newsletter AS newsletter_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deactivate_date AS deactivate_date_13, t0.group_id AS group_id_14, t0.company_id AS company_id_15, t0.client_id AS client_id_16, t0.division_id AS division_id_17, t0.client_localization_id AS client_localization_id_18, t19.id AS id_20, t19.notifications AS notifications_21, t19.user_id AS user_id_22, t23.id AS id_24, t23.after_login_route AS after_login_route_25, t23.user_id AS user_id_26, t23.printer_id AS printer_id_27, t23.mqtt_broker_id AS mqtt_broker_id_28, t0.worker_id AS worker_id_29, t0.created_by AS created_by_30, t0.updated_by AS updated_by_31 FROM user t0 LEFT JOIN user_notification t19 ON t19.user_id = t0.id LEFT JOIN user_setting t23 ON t23.user_id = t0.id WHERE t0.id = 262;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.role AS role_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t6.id AS id_7,
  t6.permissions AS permissions_8,
  t6.role_id AS role_id_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11
FROM
  user_role t0
  LEFT JOIN role_permission t6 ON t6.role_id = t0.id
  INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id
WHERE
  user_role_user.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t6.id AS id_7, t6.permissions AS permissions_8, t6.role_id AS role_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM user_role t0 LEFT JOIN role_permission t6 ON t6.role_id = t0.id INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id WHERE user_role_user.user_id = 262;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.state AS state_3,
  t0.driver AS driver_4,
  t0.read_time AS read_time_5,
  t0.event_type AS event_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.company_id AS company_id_9,
  t0.client_id AS client_id_10,
  t0.state_status_id AS state_status_id_11,
  t0.current_state_status_id AS current_state_status_id_12,
  t0.client_localization_id AS client_localization_id_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15
FROM
  mqtt_broker t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3, t0.driver AS driver_4, t0.read_time AS read_time_5, t0.event_type AS event_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.company_id AS company_id_9, t0.client_id AS client_id_10, t0.state_status_id AS state_status_id_11, t0.current_state_status_id AS current_state_status_id_12, t0.client_localization_id AS client_localization_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM mqtt_broker t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.division AS division_2,
  t0.active AS active_3,
  t0.nip AS nip_4,
  t0.post_code AS post_code_5,
  t0.city AS city_6,
  t0.address AS address_7,
  t0.type_object AS type_object_8,
  t0.symbol AS symbol_9,
  t0.deleted_at AS deleted_at_10,
  t0.color AS color_11,
  t0.email AS email_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deactivate_date AS deactivate_date_15,
  t0.id_client_localization AS id_client_localization_16
FROM
  divisions t0
  INNER JOIN user_division ON t0.id = user_division.division_id
WHERE
  user_division.user_id = ?

SELECT t0.id AS id_1, t0.division AS division_2, t0.active AS active_3, t0.nip AS nip_4, t0.post_code AS post_code_5, t0.city AS city_6, t0.address AS address_7, t0.type_object AS type_object_8, t0.symbol AS symbol_9, t0.deleted_at AS deleted_at_10, t0.color AS color_11, t0.email AS email_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deactivate_date AS deactivate_date_15, t0.id_client_localization AS id_client_localization_16 FROM divisions t0 INNER JOIN user_division ON t0.id = user_division.division_id WHERE user_division.user_id = 262;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      t0_.id AS id_0,
      t0_.tid AS tid_1,
      t0_.id_hex AS id_hex_2,
      t0_.antenna AS antenna_3,
      t0_.peak_rssi AS peak_rssi_4,
      t0_.count AS count_5,
      t0_.created_at AS created_at_6,
      c1_.name AS name_7,
      s2_.name AS name_8,
      count(p3_.id) AS sclr_9
    FROM
      tag t0_
      LEFT JOIN user u4_ ON t0_.created_by = u4_.id
      INNER JOIN products p3_ ON (
        t0_.company_id = p3_.company_id
        AND p3_.active = 1
        AND t0_.id_hex = p3_.code
      )
      INNER JOIN divisions d5_ ON p3_.division_id = d5_.id
      INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id
      INNER JOIN client c7_ ON c6_.client_id = c7_.id
      INNER JOIN clothe c1_ ON p3_.clothe_id = c1_.id
      LEFT JOIN size s2_ ON p3_.product_size_id = s2_.id
    WHERE
      t0_.company_id = ?
      AND t0_.mqtt_broker_id = ?
      AND t0_.company_id = ?
    GROUP BY
      c1_.name,
      s2_.name
    ORDER BY
      c1_.name ASC
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT t0_.id AS id_0, t0_.tid AS tid_1, t0_.id_hex AS id_hex_2, t0_.antenna AS antenna_3, t0_.peak_rssi AS peak_rssi_4, t0_.count AS count_5, t0_.created_at AS created_at_6, c1_.name AS name_7, s2_.name AS name_8, count(p3_.id) AS sclr_9 FROM tag t0_ LEFT JOIN user u4_ ON t0_.created_by = u4_.id INNER JOIN products p3_ ON (t0_.company_id = p3_.company_id AND p3_.active = 1 AND t0_.id_hex = p3_.code) INNER JOIN divisions d5_ ON p3_.division_id = d5_.id INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id INNER JOIN client c7_ ON c6_.client_id = c7_.id INNER JOIN clothe c1_ ON p3_.clothe_id = c1_.id LEFT JOIN size s2_ ON p3_.product_size_id = s2_.id WHERE t0_.company_id = 18 AND t0_.mqtt_broker_id = 2 AND t0_.company_id = 18 GROUP BY c1_.name, s2_.name ORDER BY c1_.name ASC) dctrn_table;

SELECT
  t0_.id AS id_0,
  t0_.tid AS tid_1,
  t0_.id_hex AS id_hex_2,
  t0_.antenna AS antenna_3,
  t0_.peak_rssi AS peak_rssi_4,
  t0_.count AS count_5,
  t0_.created_at AS created_at_6,
  c1_.name AS name_7,
  s2_.name AS name_8,
  count(p3_.id) AS sclr_9,
  t0_.created_by AS created_by_10,
  t0_.mqtt_broker_id AS mqtt_broker_id_11,
  t0_.company_id AS company_id_12
FROM
  tag t0_
  LEFT JOIN user u4_ ON t0_.created_by = u4_.id
  INNER JOIN products p3_ ON (
    t0_.company_id = p3_.company_id
    AND p3_.active = 1
    AND t0_.id_hex = p3_.code
  )
  INNER JOIN divisions d5_ ON p3_.division_id = d5_.id
  INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id
  INNER JOIN client c7_ ON c6_.client_id = c7_.id
  INNER JOIN clothe c1_ ON p3_.clothe_id = c1_.id
  LEFT JOIN size s2_ ON p3_.product_size_id = s2_.id
WHERE
  t0_.company_id = ?
  AND t0_.mqtt_broker_id = ?
  AND t0_.company_id = ?
GROUP BY
  c1_.name,
  s2_.name
ORDER BY
  c1_.name ASC
LIMIT
  25

SELECT t0_.id AS id_0, t0_.tid AS tid_1, t0_.id_hex AS id_hex_2, t0_.antenna AS antenna_3, t0_.peak_rssi AS peak_rssi_4, t0_.count AS count_5, t0_.created_at AS created_at_6, c1_.name AS name_7, s2_.name AS name_8, count(p3_.id) AS sclr_9, t0_.created_by AS created_by_10, t0_.mqtt_broker_id AS mqtt_broker_id_11, t0_.company_id AS company_id_12 FROM tag t0_ LEFT JOIN user u4_ ON t0_.created_by = u4_.id INNER JOIN products p3_ ON (t0_.company_id = p3_.company_id AND p3_.active = 1 AND t0_.id_hex = p3_.code) INNER JOIN divisions d5_ ON p3_.division_id = d5_.id INNER JOIN client_localization c6_ ON d5_.id_client_localization = c6_.id INNER JOIN client c7_ ON c6_.client_id = c7_.id INNER JOIN clothe c1_ ON p3_.clothe_id = c1_.id LEFT JOIN size s2_ ON p3_.product_size_id = s2_.id WHERE t0_.company_id = 18 AND t0_.mqtt_broker_id = 2 AND t0_.company_id = 18 GROUP BY c1_.name, s2_.name ORDER BY c1_.name ASC LIMIT 25;