Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.login AS login_3,
  t0.password_hash AS password_hash_4,
  t0.description AS description_5,
  t0.active AS active_6,
  t0.created_at AS created_at_7
FROM
  work_post t0
WHERE
  t0.active = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.login AS login_3, t0.password_hash AS password_hash_4, t0.description AS description_5, t0.active AS active_6, t0.created_at AS created_at_7 FROM work_post t0 WHERE t0.active = 1 ORDER BY t0.name ASC;

SELECT
  w0_.id AS id_0,
  w0_.type AS type_1,
  w0_.clocked_at AS clocked_at_2,
  w0_.created_at AS created_at_3,
  w0_.ip_address AS ip_address_4,
  w0_.user_agent AS user_agent_5,
  w0_.work_post_id AS work_post_id_6
FROM
  work_post_clocking w0_
WHERE
  w0_.work_post_id = ?
ORDER BY
  w0_.clocked_at DESC,
  w0_.id DESC
LIMIT
  1

SELECT w0_.id AS id_0, w0_.type AS type_1, w0_.clocked_at AS clocked_at_2, w0_.created_at AS created_at_3, w0_.ip_address AS ip_address_4, w0_.user_agent AS user_agent_5, w0_.work_post_id AS work_post_id_6 FROM work_post_clocking w0_ WHERE w0_.work_post_id = 3 ORDER BY w0_.clocked_at DESC, w0_.id DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.created_at AS created_at_3,
  w1_.id AS id_4,
  w1_.name AS name_5,
  w1_.login AS login_6,
  w1_.password_hash AS password_hash_7,
  w1_.description AS description_8,
  w1_.active AS active_9,
  w1_.created_at AS created_at_10,
  c2_.id AS id_11,
  c2_.name AS name_12,
  c2_.desired_quantity AS desired_quantity_13,
  c2_.position AS position_14,
  c2_.active AS active_15,
  c2_.checklist_id AS checklist_id_16,
  c2_.color_group_id AS color_group_id_17
FROM
  checklist_template c0_
  INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id
  INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id
  LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id
WHERE
  c0_.active = 1
  AND w1_.id = ?
ORDER BY
  c0_.name ASC,
  c2_.position ASC,
  c2_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.created_at AS created_at_3, w1_.id AS id_4, w1_.name AS name_5, w1_.login AS login_6, w1_.password_hash AS password_hash_7, w1_.description AS description_8, w1_.active AS active_9, w1_.created_at AS created_at_10, c2_.id AS id_11, c2_.name AS name_12, c2_.desired_quantity AS desired_quantity_13, c2_.position AS position_14, c2_.active AS active_15, c2_.checklist_id AS checklist_id_16, c2_.color_group_id AS color_group_id_17 FROM checklist_template c0_ INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id WHERE c0_.active = 1 AND w1_.id = 3 ORDER BY c0_.name ASC, c2_.position ASC, c2_.id ASC;

SELECT
  w0_.id AS id_0,
  w0_.type AS type_1,
  w0_.clocked_at AS clocked_at_2,
  w0_.created_at AS created_at_3,
  w0_.ip_address AS ip_address_4,
  w0_.user_agent AS user_agent_5,
  w0_.work_post_id AS work_post_id_6
FROM
  work_post_clocking w0_
WHERE
  w0_.work_post_id = ?
ORDER BY
  w0_.clocked_at DESC,
  w0_.id DESC
LIMIT
  1

SELECT w0_.id AS id_0, w0_.type AS type_1, w0_.clocked_at AS clocked_at_2, w0_.created_at AS created_at_3, w0_.ip_address AS ip_address_4, w0_.user_agent AS user_agent_5, w0_.work_post_id AS work_post_id_6 FROM work_post_clocking w0_ WHERE w0_.work_post_id = 4 ORDER BY w0_.clocked_at DESC, w0_.id DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.created_at AS created_at_3,
  w1_.id AS id_4,
  w1_.name AS name_5,
  w1_.login AS login_6,
  w1_.password_hash AS password_hash_7,
  w1_.description AS description_8,
  w1_.active AS active_9,
  w1_.created_at AS created_at_10,
  c2_.id AS id_11,
  c2_.name AS name_12,
  c2_.desired_quantity AS desired_quantity_13,
  c2_.position AS position_14,
  c2_.active AS active_15,
  c2_.checklist_id AS checklist_id_16,
  c2_.color_group_id AS color_group_id_17
FROM
  checklist_template c0_
  INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id
  INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id
  LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id
WHERE
  c0_.active = 1
  AND w1_.id = ?
ORDER BY
  c0_.name ASC,
  c2_.position ASC,
  c2_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.created_at AS created_at_3, w1_.id AS id_4, w1_.name AS name_5, w1_.login AS login_6, w1_.password_hash AS password_hash_7, w1_.description AS description_8, w1_.active AS active_9, w1_.created_at AS created_at_10, c2_.id AS id_11, c2_.name AS name_12, c2_.desired_quantity AS desired_quantity_13, c2_.position AS position_14, c2_.active AS active_15, c2_.checklist_id AS checklist_id_16, c2_.color_group_id AS color_group_id_17 FROM checklist_template c0_ INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id WHERE c0_.active = 1 AND w1_.id = 4 ORDER BY c0_.name ASC, c2_.position ASC, c2_.id ASC;

SELECT
  w0_.id AS id_0,
  w0_.type AS type_1,
  w0_.clocked_at AS clocked_at_2,
  w0_.created_at AS created_at_3,
  w0_.ip_address AS ip_address_4,
  w0_.user_agent AS user_agent_5,
  w0_.work_post_id AS work_post_id_6
FROM
  work_post_clocking w0_
WHERE
  w0_.work_post_id = ?
ORDER BY
  w0_.clocked_at DESC,
  w0_.id DESC
LIMIT
  1

SELECT w0_.id AS id_0, w0_.type AS type_1, w0_.clocked_at AS clocked_at_2, w0_.created_at AS created_at_3, w0_.ip_address AS ip_address_4, w0_.user_agent AS user_agent_5, w0_.work_post_id AS work_post_id_6 FROM work_post_clocking w0_ WHERE w0_.work_post_id = 1 ORDER BY w0_.clocked_at DESC, w0_.id DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.created_at AS created_at_3,
  w1_.id AS id_4,
  w1_.name AS name_5,
  w1_.login AS login_6,
  w1_.password_hash AS password_hash_7,
  w1_.description AS description_8,
  w1_.active AS active_9,
  w1_.created_at AS created_at_10,
  c2_.id AS id_11,
  c2_.name AS name_12,
  c2_.desired_quantity AS desired_quantity_13,
  c2_.position AS position_14,
  c2_.active AS active_15,
  c2_.checklist_id AS checklist_id_16,
  c2_.color_group_id AS color_group_id_17
FROM
  checklist_template c0_
  INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id
  INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id
  LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id
WHERE
  c0_.active = 1
  AND w1_.id = ?
ORDER BY
  c0_.name ASC,
  c2_.position ASC,
  c2_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.created_at AS created_at_3, w1_.id AS id_4, w1_.name AS name_5, w1_.login AS login_6, w1_.password_hash AS password_hash_7, w1_.description AS description_8, w1_.active AS active_9, w1_.created_at AS created_at_10, c2_.id AS id_11, c2_.name AS name_12, c2_.desired_quantity AS desired_quantity_13, c2_.position AS position_14, c2_.active AS active_15, c2_.checklist_id AS checklist_id_16, c2_.color_group_id AS color_group_id_17 FROM checklist_template c0_ INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id WHERE c0_.active = 1 AND w1_.id = 1 ORDER BY c0_.name ASC, c2_.position ASC, c2_.id ASC;

SELECT
  w0_.id AS id_0,
  w0_.type AS type_1,
  w0_.clocked_at AS clocked_at_2,
  w0_.created_at AS created_at_3,
  w0_.ip_address AS ip_address_4,
  w0_.user_agent AS user_agent_5,
  w0_.work_post_id AS work_post_id_6
FROM
  work_post_clocking w0_
WHERE
  w0_.work_post_id = ?
ORDER BY
  w0_.clocked_at DESC,
  w0_.id DESC
LIMIT
  1

SELECT w0_.id AS id_0, w0_.type AS type_1, w0_.clocked_at AS clocked_at_2, w0_.created_at AS created_at_3, w0_.ip_address AS ip_address_4, w0_.user_agent AS user_agent_5, w0_.work_post_id AS work_post_id_6 FROM work_post_clocking w0_ WHERE w0_.work_post_id = 5 ORDER BY w0_.clocked_at DESC, w0_.id DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.created_at AS created_at_3,
  w1_.id AS id_4,
  w1_.name AS name_5,
  w1_.login AS login_6,
  w1_.password_hash AS password_hash_7,
  w1_.description AS description_8,
  w1_.active AS active_9,
  w1_.created_at AS created_at_10,
  c2_.id AS id_11,
  c2_.name AS name_12,
  c2_.desired_quantity AS desired_quantity_13,
  c2_.position AS position_14,
  c2_.active AS active_15,
  c2_.checklist_id AS checklist_id_16,
  c2_.color_group_id AS color_group_id_17
FROM
  checklist_template c0_
  INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id
  INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id
  LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id
WHERE
  c0_.active = 1
  AND w1_.id = ?
ORDER BY
  c0_.name ASC,
  c2_.position ASC,
  c2_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.created_at AS created_at_3, w1_.id AS id_4, w1_.name AS name_5, w1_.login AS login_6, w1_.password_hash AS password_hash_7, w1_.description AS description_8, w1_.active AS active_9, w1_.created_at AS created_at_10, c2_.id AS id_11, c2_.name AS name_12, c2_.desired_quantity AS desired_quantity_13, c2_.position AS position_14, c2_.active AS active_15, c2_.checklist_id AS checklist_id_16, c2_.color_group_id AS color_group_id_17 FROM checklist_template c0_ INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id WHERE c0_.active = 1 AND w1_.id = 5 ORDER BY c0_.name ASC, c2_.position ASC, c2_.id ASC;

SELECT
  w0_.id AS id_0,
  w0_.type AS type_1,
  w0_.clocked_at AS clocked_at_2,
  w0_.created_at AS created_at_3,
  w0_.ip_address AS ip_address_4,
  w0_.user_agent AS user_agent_5,
  w0_.work_post_id AS work_post_id_6
FROM
  work_post_clocking w0_
WHERE
  w0_.work_post_id = ?
ORDER BY
  w0_.clocked_at DESC,
  w0_.id DESC
LIMIT
  1

SELECT w0_.id AS id_0, w0_.type AS type_1, w0_.clocked_at AS clocked_at_2, w0_.created_at AS created_at_3, w0_.ip_address AS ip_address_4, w0_.user_agent AS user_agent_5, w0_.work_post_id AS work_post_id_6 FROM work_post_clocking w0_ WHERE w0_.work_post_id = 2 ORDER BY w0_.clocked_at DESC, w0_.id DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.created_at AS created_at_3,
  w1_.id AS id_4,
  w1_.name AS name_5,
  w1_.login AS login_6,
  w1_.password_hash AS password_hash_7,
  w1_.description AS description_8,
  w1_.active AS active_9,
  w1_.created_at AS created_at_10,
  c2_.id AS id_11,
  c2_.name AS name_12,
  c2_.desired_quantity AS desired_quantity_13,
  c2_.position AS position_14,
  c2_.active AS active_15,
  c2_.checklist_id AS checklist_id_16,
  c2_.color_group_id AS color_group_id_17
FROM
  checklist_template c0_
  INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id
  INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id
  LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id
WHERE
  c0_.active = 1
  AND w1_.id = ?
ORDER BY
  c0_.name ASC,
  c2_.position ASC,
  c2_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.created_at AS created_at_3, w1_.id AS id_4, w1_.name AS name_5, w1_.login AS login_6, w1_.password_hash AS password_hash_7, w1_.description AS description_8, w1_.active AS active_9, w1_.created_at AS created_at_10, c2_.id AS id_11, c2_.name AS name_12, c2_.desired_quantity AS desired_quantity_13, c2_.position AS position_14, c2_.active AS active_15, c2_.checklist_id AS checklist_id_16, c2_.color_group_id AS color_group_id_17 FROM checklist_template c0_ INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id WHERE c0_.active = 1 AND w1_.id = 2 ORDER BY c0_.name ASC, c2_.position ASC, c2_.id ASC;

SELECT
  w0_.id AS id_0,
  w0_.type AS type_1,
  w0_.clocked_at AS clocked_at_2,
  w0_.created_at AS created_at_3,
  w0_.ip_address AS ip_address_4,
  w0_.user_agent AS user_agent_5,
  w0_.work_post_id AS work_post_id_6
FROM
  work_post_clocking w0_
WHERE
  w0_.work_post_id = ?
ORDER BY
  w0_.clocked_at DESC,
  w0_.id DESC
LIMIT
  1

SELECT w0_.id AS id_0, w0_.type AS type_1, w0_.clocked_at AS clocked_at_2, w0_.created_at AS created_at_3, w0_.ip_address AS ip_address_4, w0_.user_agent AS user_agent_5, w0_.work_post_id AS work_post_id_6 FROM work_post_clocking w0_ WHERE w0_.work_post_id = 6 ORDER BY w0_.clocked_at DESC, w0_.id DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.created_at AS created_at_3,
  w1_.id AS id_4,
  w1_.name AS name_5,
  w1_.login AS login_6,
  w1_.password_hash AS password_hash_7,
  w1_.description AS description_8,
  w1_.active AS active_9,
  w1_.created_at AS created_at_10,
  c2_.id AS id_11,
  c2_.name AS name_12,
  c2_.desired_quantity AS desired_quantity_13,
  c2_.position AS position_14,
  c2_.active AS active_15,
  c2_.checklist_id AS checklist_id_16,
  c2_.color_group_id AS color_group_id_17
FROM
  checklist_template c0_
  INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id
  INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id
  LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id
WHERE
  c0_.active = 1
  AND w1_.id = ?
ORDER BY
  c0_.name ASC,
  c2_.position ASC,
  c2_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.created_at AS created_at_3, w1_.id AS id_4, w1_.name AS name_5, w1_.login AS login_6, w1_.password_hash AS password_hash_7, w1_.description AS description_8, w1_.active AS active_9, w1_.created_at AS created_at_10, c2_.id AS id_11, c2_.name AS name_12, c2_.desired_quantity AS desired_quantity_13, c2_.position AS position_14, c2_.active AS active_15, c2_.checklist_id AS checklist_id_16, c2_.color_group_id AS color_group_id_17 FROM checklist_template c0_ INNER JOIN checklist_template_work_post c3_ ON c0_.id = c3_.checklist_template_id INNER JOIN work_post w1_ ON w1_.id = c3_.work_post_id LEFT JOIN checklist_item c2_ ON c0_.id = c2_.checklist_id WHERE c0_.active = 1 AND w1_.id = 6 ORDER BY c0_.name ASC, c2_.position ASC, c2_.id ASC;

SELECT
  s0_.id AS id_0,
  s0_.quantity AS quantity_1,
  s0_.updated_at AS updated_at_2,
  s1_.id AS id_3,
  s1_.name AS name_4,
  s1_.unit AS unit_5,
  s1_.description AS description_6,
  s1_.active AS active_7,
  s1_.created_at AS created_at_8,
  s2_.id AS id_9,
  s2_.name AS name_10,
  s2_.description AS description_11,
  s2_.active AS active_12,
  s2_.created_at AS created_at_13,
  s0_.item_id AS item_id_14,
  s0_.location_id AS location_id_15
FROM
  stock_level s0_
  INNER JOIN stock_item s1_ ON s0_.item_id = s1_.id
  INNER JOIN stock_location s2_ ON s0_.location_id = s2_.id
WHERE
  s1_.active = ?
  AND s2_.active = ?
ORDER BY
  s2_.name ASC,
  s1_.name ASC

SELECT s0_.id AS id_0, s0_.quantity AS quantity_1, s0_.updated_at AS updated_at_2, s1_.id AS id_3, s1_.name AS name_4, s1_.unit AS unit_5, s1_.description AS description_6, s1_.active AS active_7, s1_.created_at AS created_at_8, s2_.id AS id_9, s2_.name AS name_10, s2_.description AS description_11, s2_.active AS active_12, s2_.created_at AS created_at_13, s0_.item_id AS item_id_14, s0_.location_id AS location_id_15 FROM stock_level s0_ INNER JOIN stock_item s1_ ON s0_.item_id = s1_.id INNER JOIN stock_location s2_ ON s0_.location_id = s2_.id WHERE s1_.active = 1 AND s2_.active = 1 ORDER BY s2_.name ASC, s1_.name ASC;