Symfony Profiler

SELECT
  t0.service AS service_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.pos AS pos_4,
  t0.type AS type_5,
  t0.string_value AS string_value_6,
  t0.int_value AS int_value_7,
  t0.float_value AS float_value_8,
  t0.text_value AS text_value_9,
  t0.date_time_value AS date_time_value_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
  setting t0
  LEFT JOIN file t12 ON t0.file_value = t12.id
  LEFT JOIN node t20 ON t0.node_value = t20.id
WHERE
  t0.locale IN (?, ?)
  AND t0.service = ?

SELECT t0.service AS service_1, t0.name AS name_2, t0.locale AS locale_3, t0.pos AS pos_4, t0.type AS type_5, t0.string_value AS string_value_6, t0.int_value AS int_value_7, t0.float_value AS float_value_8, t0.text_value AS text_value_9, t0.date_time_value AS date_time_value_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 setting t0 LEFT JOIN file t12 ON t0.file_value = t12.id LEFT JOIN node t20 ON t0.node_value = t20.id WHERE t0.locale IN ('xx', 'en') AND t0.service = 0;

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 = 'module_type'
    AND n1_.locale IN (?, ?)
  )
WHERE
  n0_.type = ?
  AND n0_.service = ?
  AND n0_.locale = ?
  AND n1_.string_value IN (?)
ORDER BY
  n0_.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, n0_.parent_id AS parent_id_7 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'module_type' AND n1_.locale IN ('xx', 'en')) WHERE n0_.type = 'winery_menu' AND n0_.service = 0 AND n0_.locale = 'en' AND n1_.string_value IN ('left') ORDER BY n0_.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 = '1709' 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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1708';

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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1709';

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 = '1719' 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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1711';

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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1719';

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 = '1720' 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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1712';

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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1720';

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 = 'module_type'
    AND n1_.locale IN (?, ?)
  )
WHERE
  n0_.type = ?
  AND n0_.service = ?
  AND n0_.locale = ?
  AND n1_.string_value IN (?)
ORDER BY
  n0_.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, n0_.parent_id AS parent_id_7 FROM node n0_ INNER JOIN node_variable n1_ ON n0_.id = n1_.node_id AND (n1_.name = 'module_type' AND n1_.locale IN ('xx', 'en')) WHERE n0_.type = 'winery_menu' AND n0_.service = 0 AND n0_.locale = 'en' AND n1_.string_value IN ('right') ORDER BY n0_.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 = '1721' 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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1717';

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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1721';

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 = '1722' 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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1718';

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.node_id AS node_id_7
FROM
  node_url t0
WHERE
  t0.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.node_id AS node_id_7 FROM node_url t0 WHERE t0.node_id = '1722';

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 = '1708' 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 = '1711' 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