Symfony Profiler

SELECT
  u0_.target AS target_0,
  u0_.type AS type_1
FROM
  url u0_
WHERE
  u0_.service = ?
  AND (
    (
      u0_.locale = ?
      AND u0_.path = ?
    )
    OR (
      u0_.type = ?
      AND u0_.locale = ?
      AND u0_.path = ?
    )
  )
LIMIT
  1

SELECT u0_.target AS target_0, u0_.type AS type_1 FROM url u0_ WHERE u0_.service = 0 AND ((u0_.locale = 'pl' AND u0_.path = 'wylaczenia') OR (u0_.type = 'redirect' AND u0_.locale = 'xx' AND u0_.path = '/wylaczenia')) LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.service AS service_1,
          n0_.pos AS pos_2,
          n0_.type AS type_3,
          n0_.locale AS locale_4,
          n0_.external_id AS external_id_5,
          n0_.meta AS meta_6
        FROM
          node n0_
          INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id
          AND (
            n1_.name = 'public'
            AND n1_.locale IN (?, ?)
          )
          INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id
          AND (
            n2_.name = 'registration_type'
            AND n2_.locale IN (?, ?)
          )
          LEFT JOIN node_variable n3_ ON n0_.id = n3_.node_id
          AND (
            n3_.name = 'updateDate'
            AND n3_.locale IN (?, ?)
          )
        WHERE
          n0_.type = ?
          AND n0_.service = ?
          AND n0_.locale = ?
          AND n1_.int_value IN (?)
          AND n2_.string_value IN (?)
        ORDER BY
          n3_.date_time_value DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'public' AND n1_.locale IN ('xx', 'pl')) INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id AND (n2_.name = 'registration_type' AND n2_.locale IN ('xx', 'pl')) LEFT JOIN node_variable n3_ ON n0_.id = n3_.node_id AND (n3_.name = 'updateDate' AND n3_.locale IN ('xx', 'pl')) WHERE n0_.type = 'failures' AND n0_.service = 0 AND n0_.locale = 'pl' AND n1_.int_value IN (1) AND n2_.string_value IN ('turn_off') ORDER BY n3_.date_time_value DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_7) AS dctrn_minrownum
FROM
  (
    SELECT
      n0_.id AS id_0,
      n0_.service AS service_1,
      n0_.pos AS pos_2,
      n0_.type AS type_3,
      n0_.locale AS locale_4,
      n0_.external_id AS external_id_5,
      n0_.meta AS meta_6,
      ROW_NUMBER() OVER(
        ORDER BY
          n1_.date_time_value DESC
      ) AS sclr_7
    FROM
      node n0_
      INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id
      AND (
        n2_.name = 'public'
        AND n2_.locale IN (?, ?)
      )
      INNER JOIN node_variable n3_ ON n0_.id = n3_.node_id
      AND (
        n3_.name = 'registration_type'
        AND n3_.locale IN (?, ?)
      )
      LEFT JOIN node_variable n1_ ON n0_.id = n1_.node_id
      AND (
        n1_.name = 'updateDate'
        AND n1_.locale IN (?, ?)
      )
    WHERE
      n0_.type = ?
      AND n0_.service = ?
      AND n0_.locale = ?
      AND n2_.int_value IN (?)
      AND n3_.string_value IN (?)
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  10

SELECT DISTINCT id_0, MIN(sclr_7) AS dctrn_minrownum FROM (SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6, ROW_NUMBER() OVER(ORDER BY n1_.date_time_value DESC) AS sclr_7 FROM node n0_ INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id AND (n2_.name = 'public' AND n2_.locale IN ('xx', 'pl')) INNER JOIN node_variable n3_ ON n0_.id = n3_.node_id AND (n3_.name = 'registration_type' AND n3_.locale IN ('xx', 'pl')) LEFT JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'updateDate' AND n1_.locale IN ('xx', 'pl')) WHERE n0_.type = 'failures' AND n0_.service = 0 AND n0_.locale = 'pl' AND n2_.int_value IN (1) AND n3_.string_value IN ('turn_off')) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10;

SELECT
  n0_.id AS id_0,
  n0_.service AS service_1,
  n0_.pos AS pos_2,
  n0_.type AS type_3,
  n0_.locale AS locale_4,
  n0_.external_id AS external_id_5,
  n0_.meta AS meta_6,
  n0_.parent_id AS parent_id_7
FROM
  node n0_
  INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id
  AND (
    n1_.name = 'public'
    AND n1_.locale IN (?, ?)
  )
  INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id
  AND (
    n2_.name = 'registration_type'
    AND n2_.locale IN (?, ?)
  )
  LEFT JOIN node_variable n3_ ON n0_.id = n3_.node_id
  AND (
    n3_.name = 'updateDate'
    AND n3_.locale IN (?, ?)
  )
WHERE
  n0_.type = ?
  AND n0_.service = ?
  AND n0_.locale = ?
  AND n1_.int_value IN (?)
  AND n2_.string_value IN (?)
  AND n0_.id IN (?, ?)
ORDER BY
  n3_.date_time_value DESC

SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6, n0_.parent_id AS parent_id_7 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'public' AND n1_.locale IN ('xx', 'pl')) INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id AND (n2_.name = 'registration_type' AND n2_.locale IN ('xx', 'pl')) LEFT JOIN node_variable n3_ ON n0_.id = n3_.node_id AND (n3_.name = 'updateDate' AND n3_.locale IN ('xx', 'pl')) WHERE n0_.type = 'failures' AND n0_.service = 0 AND n0_.locale = 'pl' AND n1_.int_value IN (1) AND n2_.string_value IN ('turn_off') AND n0_.id IN ('189', '191') ORDER BY n3_.date_time_value DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.service AS service_1,
          n0_.pos AS pos_2,
          n0_.type AS type_3,
          n0_.locale AS locale_4,
          n0_.external_id AS external_id_5,
          n0_.meta AS meta_6
        FROM
          node n0_
          INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id
          AND (
            n1_.name = 'public'
            AND n1_.locale IN (?, ?)
          )
          INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id
          AND (
            n2_.name = 'registration_type'
            AND n2_.locale IN (?, ?)
          )
          LEFT JOIN node_variable n3_ ON n0_.id = n3_.node_id
          AND (
            n3_.name = 'updateDate'
            AND n3_.locale IN (?, ?)
          )
        WHERE
          n0_.type = ?
          AND n0_.service = ?
          AND n0_.locale = ?
          AND n1_.int_value IN (?)
          AND n2_.string_value IN (?)
        ORDER BY
          n3_.date_time_value DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'public' AND n1_.locale IN ('xx', 'pl')) INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id AND (n2_.name = 'registration_type' AND n2_.locale IN ('xx', 'pl')) LEFT JOIN node_variable n3_ ON n0_.id = n3_.node_id AND (n3_.name = 'updateDate' AND n3_.locale IN ('xx', 'pl')) WHERE n0_.type = 'failures' AND n0_.service = 0 AND n0_.locale = 'pl' AND n1_.int_value IN (1) AND n2_.string_value IN ('turn_off') ORDER BY n3_.date_time_value DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_7) AS dctrn_minrownum
FROM
  (
    SELECT
      n0_.id AS id_0,
      n0_.service AS service_1,
      n0_.pos AS pos_2,
      n0_.type AS type_3,
      n0_.locale AS locale_4,
      n0_.external_id AS external_id_5,
      n0_.meta AS meta_6,
      ROW_NUMBER() OVER(
        ORDER BY
          n1_.date_time_value DESC
      ) AS sclr_7
    FROM
      node n0_
      INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id
      AND (
        n2_.name = 'public'
        AND n2_.locale IN (?, ?)
      )
      INNER JOIN node_variable n3_ ON n0_.id = n3_.node_id
      AND (
        n3_.name = 'registration_type'
        AND n3_.locale IN (?, ?)
      )
      LEFT JOIN node_variable n1_ ON n0_.id = n1_.node_id
      AND (
        n1_.name = 'updateDate'
        AND n1_.locale IN (?, ?)
      )
    WHERE
      n0_.type = ?
      AND n0_.service = ?
      AND n0_.locale = ?
      AND n2_.int_value IN (?)
      AND n3_.string_value IN (?)
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  10

SELECT DISTINCT id_0, MIN(sclr_7) AS dctrn_minrownum FROM (SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6, ROW_NUMBER() OVER(ORDER BY n1_.date_time_value DESC) AS sclr_7 FROM node n0_ INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id AND (n2_.name = 'public' AND n2_.locale IN ('xx', 'pl')) INNER JOIN node_variable n3_ ON n0_.id = n3_.node_id AND (n3_.name = 'registration_type' AND n3_.locale IN ('xx', 'pl')) LEFT JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'updateDate' AND n1_.locale IN ('xx', 'pl')) WHERE n0_.type = 'failures' AND n0_.service = 0 AND n0_.locale = 'pl' AND n2_.int_value IN (1) AND n3_.string_value IN ('turn_off')) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10;

SELECT
  n0_.id AS id_0,
  n0_.service AS service_1,
  n0_.pos AS pos_2,
  n0_.type AS type_3,
  n0_.locale AS locale_4,
  n0_.external_id AS external_id_5,
  n0_.meta AS meta_6,
  n0_.parent_id AS parent_id_7
FROM
  node n0_
  INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id
  AND (
    n1_.name = 'public'
    AND n1_.locale IN (?, ?)
  )
  INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id
  AND (
    n2_.name = 'registration_type'
    AND n2_.locale IN (?, ?)
  )
  LEFT JOIN node_variable n3_ ON n0_.id = n3_.node_id
  AND (
    n3_.name = 'updateDate'
    AND n3_.locale IN (?, ?)
  )
WHERE
  n0_.type = ?
  AND n0_.service = ?
  AND n0_.locale = ?
  AND n1_.int_value IN (?)
  AND n2_.string_value IN (?)
  AND n0_.id IN (?, ?)
ORDER BY
  n3_.date_time_value DESC

SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6, n0_.parent_id AS parent_id_7 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'public' AND n1_.locale IN ('xx', 'pl')) INNER JOIN node_variable n2_ ON n0_.id = n2_.node_id AND (n2_.name = 'registration_type' AND n2_.locale IN ('xx', 'pl')) LEFT JOIN node_variable n3_ ON n0_.id = n3_.node_id AND (n3_.name = 'updateDate' AND n3_.locale IN ('xx', 'pl')) WHERE n0_.type = 'failures' AND n0_.service = 0 AND n0_.locale = 'pl' AND n1_.int_value IN (1) AND n2_.string_value IN ('turn_off') AND n0_.id IN ('189', '191') ORDER BY n3_.date_time_value DESC;

SELECT
  t0.name AS name_1,
  t0.locale AS locale_2,
  t0.pos AS pos_3,
  t0.type AS type_4,
  t0.string_value AS string_value_5,
  t0.int_value AS int_value_6,
  t0.float_value AS float_value_7,
  t0.text_value AS text_value_8,
  t0.date_time_value AS date_time_value_9,
  t0.node_id AS node_id_10,
  t0.file_value AS file_value_11,
  t12.id AS id_13,
  t12.path AS path_14,
  t12.repository AS repository_15,
  t12.mime AS mime_16,
  t12.size AS size_17,
  t12.meta AS meta_18,
  t0.node_value AS node_value_19,
  t20.id AS id_21,
  t20.service AS service_22,
  t20.pos AS pos_23,
  t20.type AS type_24,
  t20.locale AS locale_25,
  t20.external_id AS external_id_26,
  t20.meta AS meta_27,
  t20.parent_id AS parent_id_28
FROM
  node_variable t0
  LEFT JOIN file t12 ON t0.file_value = t12.id
  LEFT JOIN node t20 ON t0.node_value = t20.id
WHERE
  t0.node_id = ?
ORDER BY
  t0.pos ASC

SELECT t0.name AS name_1, t0.locale AS locale_2, t0.pos AS pos_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.text_value AS text_value_8, t0.date_time_value AS date_time_value_9, t0.node_id AS node_id_10, t0.file_value AS file_value_11, t12.id AS id_13, t12.path AS path_14, t12.repository AS repository_15, t12.mime AS mime_16, t12.size AS size_17, t12.meta AS meta_18, t0.node_value AS node_value_19, t20.id AS id_21, t20.service AS service_22, t20.pos AS pos_23, t20.type AS type_24, t20.locale AS locale_25, t20.external_id AS external_id_26, t20.meta AS meta_27, t20.parent_id AS parent_id_28 FROM node_variable t0 LEFT JOIN file t12 ON t0.file_value = t12.id LEFT JOIN node t20 ON t0.node_value = t20.id WHERE t0.node_id = '189' ORDER BY t0.pos ASC;

SELECT
  t0.name AS name_1,
  t0.locale AS locale_2,
  t0.pos AS pos_3,
  t0.type AS type_4,
  t0.string_value AS string_value_5,
  t0.int_value AS int_value_6,
  t0.float_value AS float_value_7,
  t0.text_value AS text_value_8,
  t0.date_time_value AS date_time_value_9,
  t0.node_id AS node_id_10,
  t0.file_value AS file_value_11,
  t12.id AS id_13,
  t12.path AS path_14,
  t12.repository AS repository_15,
  t12.mime AS mime_16,
  t12.size AS size_17,
  t12.meta AS meta_18,
  t0.node_value AS node_value_19,
  t20.id AS id_21,
  t20.service AS service_22,
  t20.pos AS pos_23,
  t20.type AS type_24,
  t20.locale AS locale_25,
  t20.external_id AS external_id_26,
  t20.meta AS meta_27,
  t20.parent_id AS parent_id_28
FROM
  node_variable t0
  LEFT JOIN file t12 ON t0.file_value = t12.id
  LEFT JOIN node t20 ON t0.node_value = t20.id
WHERE
  t0.node_id = ?
ORDER BY
  t0.pos ASC

SELECT t0.name AS name_1, t0.locale AS locale_2, t0.pos AS pos_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.text_value AS text_value_8, t0.date_time_value AS date_time_value_9, t0.node_id AS node_id_10, t0.file_value AS file_value_11, t12.id AS id_13, t12.path AS path_14, t12.repository AS repository_15, t12.mime AS mime_16, t12.size AS size_17, t12.meta AS meta_18, t0.node_value AS node_value_19, t20.id AS id_21, t20.service AS service_22, t20.pos AS pos_23, t20.type AS type_24, t20.locale AS locale_25, t20.external_id AS external_id_26, t20.meta AS meta_27, t20.parent_id AS parent_id_28 FROM node_variable t0 LEFT JOIN file t12 ON t0.file_value = t12.id LEFT JOIN node t20 ON t0.node_value = t20.id WHERE t0.node_id = '191' ORDER BY t0.pos ASC;

SELECT
  n0_.id AS id_0,
  n0_.service AS service_1,
  n0_.pos AS pos_2,
  n0_.type AS type_3,
  n0_.locale AS locale_4,
  n0_.external_id AS external_id_5,
  n0_.meta AS meta_6,
  n1_.name AS name_7,
  n1_.locale AS locale_8,
  n1_.pos AS pos_9,
  n1_.type AS type_10,
  n1_.string_value AS string_value_11,
  n1_.int_value AS int_value_12,
  n1_.float_value AS float_value_13,
  n1_.text_value AS text_value_14,
  n1_.date_time_value AS date_time_value_15,
  f2_.id AS id_16,
  f2_.path AS path_17,
  f2_.repository AS repository_18,
  f2_.mime AS mime_19,
  f2_.size AS size_20,
  f2_.meta AS meta_21,
  n3_.id AS id_22,
  n3_.service AS service_23,
  n3_.pos AS pos_24,
  n3_.type AS type_25,
  n3_.locale AS locale_26,
  n3_.external_id AS external_id_27,
  n3_.meta AS meta_28,
  n0_.parent_id AS parent_id_29,
  n1_.node_id AS node_id_30,
  n1_.file_value AS file_value_31,
  n1_.node_value AS node_value_32,
  n3_.parent_id AS parent_id_33
FROM
  node n0_
  INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id
  LEFT JOIN file f2_ ON n1_.file_value = f2_.id
  LEFT JOIN node n3_ ON n1_.node_value = n3_.id
WHERE
  n0_.type = ?
  AND n0_.service = ?
  AND n0_.locale = ?
  AND n0_.parent_id IS NULL
ORDER BY
  n0_.pos ASC,
  n0_.pos ASC,
  n0_.id ASC,
  n1_.pos asc

SELECT n0_.id AS id_0, n0_.service AS service_1, n0_.pos AS pos_2, n0_.type AS type_3, n0_.locale AS locale_4, n0_.external_id AS external_id_5, n0_.meta AS meta_6, n1_.name AS name_7, n1_.locale AS locale_8, n1_.pos AS pos_9, n1_.type AS type_10, n1_.string_value AS string_value_11, n1_.int_value AS int_value_12, n1_.float_value AS float_value_13, n1_.text_value AS text_value_14, n1_.date_time_value AS date_time_value_15, f2_.id AS id_16, f2_.path AS path_17, f2_.repository AS repository_18, f2_.mime AS mime_19, f2_.size AS size_20, f2_.meta AS meta_21, n3_.id AS id_22, n3_.service AS service_23, n3_.pos AS pos_24, n3_.type AS type_25, n3_.locale AS locale_26, n3_.external_id AS external_id_27, n3_.meta AS meta_28, n0_.parent_id AS parent_id_29, n1_.node_id AS node_id_30, n1_.file_value AS file_value_31, n1_.node_value AS node_value_32, n3_.parent_id AS parent_id_33 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id LEFT JOIN file f2_ ON n1_.file_value = f2_.id LEFT JOIN node n3_ ON n1_.node_value = n3_.id WHERE n0_.type = 'menu' AND n0_.service = 0 AND n0_.locale = 'pl' AND n0_.parent_id IS NULL ORDER BY n0_.pos ASC, n0_.pos ASC, n0_.id ASC, n1_.pos asc;

SELECT
  t0.name AS name_1,
  t0.locale AS locale_2,
  t0.pos AS pos_3,
  t0.type AS type_4,
  t0.string_value AS string_value_5,
  t0.int_value AS int_value_6,
  t0.float_value AS float_value_7,
  t0.text_value AS text_value_8,
  t0.date_time_value AS date_time_value_9,
  t0.node_id AS node_id_10,
  t0.file_value AS file_value_11,
  t12.id AS id_13,
  t12.path AS path_14,
  t12.repository AS repository_15,
  t12.mime AS mime_16,
  t12.size AS size_17,
  t12.meta AS meta_18,
  t0.node_value AS node_value_19,
  t20.id AS id_21,
  t20.service AS service_22,
  t20.pos AS pos_23,
  t20.type AS type_24,
  t20.locale AS locale_25,
  t20.external_id AS external_id_26,
  t20.meta AS meta_27,
  t20.parent_id AS parent_id_28
FROM
  node_variable t0
  LEFT JOIN file t12 ON t0.file_value = t12.id
  LEFT JOIN node t20 ON t0.node_value = t20.id
WHERE
  t0.node_id = ?
ORDER BY
  t0.pos ASC

SELECT t0.name AS name_1, t0.locale AS locale_2, t0.pos AS pos_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.text_value AS text_value_8, t0.date_time_value AS date_time_value_9, t0.node_id AS node_id_10, t0.file_value AS file_value_11, t12.id AS id_13, t12.path AS path_14, t12.repository AS repository_15, t12.mime AS mime_16, t12.size AS size_17, t12.meta AS meta_18, t0.node_value AS node_value_19, t20.id AS id_21, t20.service AS service_22, t20.pos AS pos_23, t20.type AS type_24, t20.locale AS locale_25, t20.external_id AS external_id_26, t20.meta AS meta_27, t20.parent_id AS parent_id_28 FROM node_variable t0 LEFT JOIN file t12 ON t0.file_value = t12.id LEFT JOIN node t20 ON t0.node_value = t20.id WHERE t0.node_id = '52' ORDER BY t0.pos ASC;

SELECT
  t0.id AS id_1,
  t0.service AS service_2,
  t0.locale AS locale_3,
  t0.slug AS slug_4,
  t0.path AS path_5,
  t0.type AS type_6,
  t0.target AS target_7
FROM
  url t0
  INNER JOIN node_urls ON t0.id = node_urls.url_id
WHERE
  node_urls.node_id = ?

SELECT t0.id AS id_1, t0.service AS service_2, t0.locale AS locale_3, t0.slug AS slug_4, t0.path AS path_5, t0.type AS type_6, t0.target AS target_7 FROM url t0 INNER JOIN node_urls ON t0.id = node_urls.url_id WHERE node_urls.node_id = '52';

SELECT
  t0.id AS id_1,
  t0.service AS service_2,
  t0.pos AS pos_3,
  t0.type AS type_4,
  t0.locale AS locale_5,
  t0.external_id AS external_id_6,
  t0.meta AS meta_7,
  t0.parent_id AS parent_id_8
FROM
  node t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.pos ASC

SELECT t0.id AS id_1, t0.service AS service_2, t0.pos AS pos_3, t0.type AS type_4, t0.locale AS locale_5, t0.external_id AS external_id_6, t0.meta AS meta_7, t0.parent_id AS parent_id_8 FROM node t0 WHERE t0.parent_id = '51' ORDER BY t0.pos ASC;

SELECT
  t0.name AS name_1,
  t0.locale AS locale_2,
  t0.pos AS pos_3,
  t0.type AS type_4,
  t0.string_value AS string_value_5,
  t0.int_value AS int_value_6,
  t0.float_value AS float_value_7,
  t0.text_value AS text_value_8,
  t0.date_time_value AS date_time_value_9,
  t0.node_id AS node_id_10,
  t0.file_value AS file_value_11,
  t12.id AS id_13,
  t12.path AS path_14,
  t12.repository AS repository_15,
  t12.mime AS mime_16,
  t12.size AS size_17,
  t12.meta AS meta_18,
  t0.node_value AS node_value_19,
  t20.id AS id_21,
  t20.service AS service_22,
  t20.pos AS pos_23,
  t20.type AS type_24,
  t20.locale AS locale_25,
  t20.external_id AS external_id_26,
  t20.meta AS meta_27,
  t20.parent_id AS parent_id_28
FROM
  node_variable t0
  LEFT JOIN file t12 ON t0.file_value = t12.id
  LEFT JOIN node t20 ON t0.node_value = t20.id
WHERE
  t0.node_id = ?
ORDER BY
  t0.pos ASC

SELECT t0.name AS name_1, t0.locale AS locale_2, t0.pos AS pos_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.text_value AS text_value_8, t0.date_time_value AS date_time_value_9, t0.node_id AS node_id_10, t0.file_value AS file_value_11, t12.id AS id_13, t12.path AS path_14, t12.repository AS repository_15, t12.mime AS mime_16, t12.size AS size_17, t12.meta AS meta_18, t0.node_value AS node_value_19, t20.id AS id_21, t20.service AS service_22, t20.pos AS pos_23, t20.type AS type_24, t20.locale AS locale_25, t20.external_id AS external_id_26, t20.meta AS meta_27, t20.parent_id AS parent_id_28 FROM node_variable t0 LEFT JOIN file t12 ON t0.file_value = t12.id LEFT JOIN node t20 ON t0.node_value = t20.id WHERE t0.node_id = '122' ORDER BY t0.pos ASC;

SELECT
  t0.name AS name_1,
  t0.locale AS locale_2,
  t0.pos AS pos_3,
  t0.type AS type_4,
  t0.string_value AS string_value_5,
  t0.int_value AS int_value_6,
  t0.float_value AS float_value_7,
  t0.text_value AS text_value_8,
  t0.date_time_value AS date_time_value_9,
  t0.node_id AS node_id_10,
  t0.file_value AS file_value_11,
  t12.id AS id_13,
  t12.path AS path_14,
  t12.repository AS repository_15,
  t12.mime AS mime_16,
  t12.size AS size_17,
  t12.meta AS meta_18,
  t0.node_value AS node_value_19,
  t20.id AS id_21,
  t20.service AS service_22,
  t20.pos AS pos_23,
  t20.type AS type_24,
  t20.locale AS locale_25,
  t20.external_id AS external_id_26,
  t20.meta AS meta_27,
  t20.parent_id AS parent_id_28
FROM
  node_variable t0
  LEFT JOIN file t12 ON t0.file_value = t12.id
  LEFT JOIN node t20 ON t0.node_value = t20.id
WHERE
  t0.node_id = ?
ORDER BY
  t0.pos ASC

SELECT t0.name AS name_1, t0.locale AS locale_2, t0.pos AS pos_3, t0.type AS type_4, t0.string_value AS string_value_5, t0.int_value AS int_value_6, t0.float_value AS float_value_7, t0.text_value AS text_value_8, t0.date_time_value AS date_time_value_9, t0.node_id AS node_id_10, t0.file_value AS file_value_11, t12.id AS id_13, t12.path AS path_14, t12.repository AS repository_15, t12.mime AS mime_16, t12.size AS size_17, t12.meta AS meta_18, t0.node_value AS node_value_19, t20.id AS id_21, t20.service AS service_22, t20.pos AS pos_23, t20.type AS type_24, t20.locale AS locale_25, t20.external_id AS external_id_26, t20.meta AS meta_27, t20.parent_id AS parent_id_28 FROM node_variable t0 LEFT JOIN file t12 ON t0.file_value = t12.id LEFT JOIN node t20 ON t0.node_value = t20.id WHERE t0.node_id = '123' ORDER BY t0.pos ASC;