Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.kod AS kod_2,
  t0.nazwa AS nazwa_3,
  t0.dodatkowa_nazwa AS dodatkowa_nazwa_4,
  t0.cena_katalog_netto AS cena_katalog_netto_5,
  t0.cena_katalog_eur AS cena_katalog_eur_6,
  t0.ean AS ean_7,
  t0.kraj_pochodzenia AS kraj_pochodzenia_8,
  t0.slug AS slug_9,
  t0.main AS main_10,
  t0.moc_led_chip AS moc_led_chip_11,
  t0.moc_oprawy AS moc_oprawy_12,
  t0.lumen_led_chip AS lumen_led_chip_13,
  t0.lmw_zoprawy AS lmw_zoprawy_14,
  t0.klasa_efektywnosci AS klasa_efektywnosci_15,
  t0.l90b10 AS l90b10_16,
  t0.lumen_oprawa AS lumen_oprawa_17,
  t0.image_url AS image_url_18,
  t0.description AS description_19,
  t0.visibility AS visibility_20,
  t0.led AS led_21,
  t0.options AS options_22,
  t0.cover AS cover_23,
  t0.mcadam AS mcadam_24,
  t0.operating_voltage AS operating_voltage_25,
  t0.plik_fotometryczny AS plik_fotometryczny_26,
  t0.tech_image AS tech_image_27,
  t0.options_en AS options_en_28,
  t0.opis_pl AS opis_pl_29,
  t0.opis_en AS opis_en_30,
  t0.sterowanie_id AS sterowanie_id_31,
  t0.model_oprawy_id AS model_oprawy_id_32,
  t0.destiny_id AS destiny_id_33,
  t0.dioda_id AS dioda_id_34,
  t0.kolor_id AS kolor_id_35,
  t0.holder_id AS holder_id_36,
  t0.odblysnik_id AS odblysnik_id_37,
  t0.led_driver_id AS led_driver_id_38,
  t0.przeslona_id AS przeslona_id_39,
  t0.image_id AS image_id_40
FROM
  produkt t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.kod AS kod_2, t0.nazwa AS nazwa_3, t0.dodatkowa_nazwa AS dodatkowa_nazwa_4, t0.cena_katalog_netto AS cena_katalog_netto_5, t0.cena_katalog_eur AS cena_katalog_eur_6, t0.ean AS ean_7, t0.kraj_pochodzenia AS kraj_pochodzenia_8, t0.slug AS slug_9, t0.main AS main_10, t0.moc_led_chip AS moc_led_chip_11, t0.moc_oprawy AS moc_oprawy_12, t0.lumen_led_chip AS lumen_led_chip_13, t0.lmw_zoprawy AS lmw_zoprawy_14, t0.klasa_efektywnosci AS klasa_efektywnosci_15, t0.l90b10 AS l90b10_16, t0.lumen_oprawa AS lumen_oprawa_17, t0.image_url AS image_url_18, t0.description AS description_19, t0.visibility AS visibility_20, t0.led AS led_21, t0.options AS options_22, t0.cover AS cover_23, t0.mcadam AS mcadam_24, t0.operating_voltage AS operating_voltage_25, t0.plik_fotometryczny AS plik_fotometryczny_26, t0.tech_image AS tech_image_27, t0.options_en AS options_en_28, t0.opis_pl AS opis_pl_29, t0.opis_en AS opis_en_30, t0.sterowanie_id AS sterowanie_id_31, t0.model_oprawy_id AS model_oprawy_id_32, t0.destiny_id AS destiny_id_33, t0.dioda_id AS dioda_id_34, t0.kolor_id AS kolor_id_35, t0.holder_id AS holder_id_36, t0.odblysnik_id AS odblysnik_id_37, t0.led_driver_id AS led_driver_id_38, t0.przeslona_id AS przeslona_id_39, t0.image_id AS image_id_40 FROM produkt t0 WHERE t0.slug = '/N007-K0002-BB940-H5-M45-ZE52-500-S1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.kod AS kod_2,
  t0.nazwa AS nazwa_3,
  t0.dodatkowa_nazwa AS dodatkowa_nazwa_4,
  t0.cena_katalog_netto AS cena_katalog_netto_5,
  t0.cena_katalog_eur AS cena_katalog_eur_6,
  t0.ean AS ean_7,
  t0.kraj_pochodzenia AS kraj_pochodzenia_8,
  t0.slug AS slug_9,
  t0.main AS main_10,
  t0.moc_led_chip AS moc_led_chip_11,
  t0.moc_oprawy AS moc_oprawy_12,
  t0.lumen_led_chip AS lumen_led_chip_13,
  t0.lmw_zoprawy AS lmw_zoprawy_14,
  t0.klasa_efektywnosci AS klasa_efektywnosci_15,
  t0.l90b10 AS l90b10_16,
  t0.lumen_oprawa AS lumen_oprawa_17,
  t0.image_url AS image_url_18,
  t0.description AS description_19,
  t0.visibility AS visibility_20,
  t0.led AS led_21,
  t0.options AS options_22,
  t0.cover AS cover_23,
  t0.mcadam AS mcadam_24,
  t0.operating_voltage AS operating_voltage_25,
  t0.plik_fotometryczny AS plik_fotometryczny_26,
  t0.tech_image AS tech_image_27,
  t0.options_en AS options_en_28,
  t0.opis_pl AS opis_pl_29,
  t0.opis_en AS opis_en_30,
  t0.sterowanie_id AS sterowanie_id_31,
  t0.model_oprawy_id AS model_oprawy_id_32,
  t0.destiny_id AS destiny_id_33,
  t0.dioda_id AS dioda_id_34,
  t0.kolor_id AS kolor_id_35,
  t0.holder_id AS holder_id_36,
  t0.odblysnik_id AS odblysnik_id_37,
  t0.led_driver_id AS led_driver_id_38,
  t0.przeslona_id AS przeslona_id_39,
  t0.image_id AS image_id_40
FROM
  produkt t0
WHERE
  t0.model_oprawy_id = ?

SELECT t0.id AS id_1, t0.kod AS kod_2, t0.nazwa AS nazwa_3, t0.dodatkowa_nazwa AS dodatkowa_nazwa_4, t0.cena_katalog_netto AS cena_katalog_netto_5, t0.cena_katalog_eur AS cena_katalog_eur_6, t0.ean AS ean_7, t0.kraj_pochodzenia AS kraj_pochodzenia_8, t0.slug AS slug_9, t0.main AS main_10, t0.moc_led_chip AS moc_led_chip_11, t0.moc_oprawy AS moc_oprawy_12, t0.lumen_led_chip AS lumen_led_chip_13, t0.lmw_zoprawy AS lmw_zoprawy_14, t0.klasa_efektywnosci AS klasa_efektywnosci_15, t0.l90b10 AS l90b10_16, t0.lumen_oprawa AS lumen_oprawa_17, t0.image_url AS image_url_18, t0.description AS description_19, t0.visibility AS visibility_20, t0.led AS led_21, t0.options AS options_22, t0.cover AS cover_23, t0.mcadam AS mcadam_24, t0.operating_voltage AS operating_voltage_25, t0.plik_fotometryczny AS plik_fotometryczny_26, t0.tech_image AS tech_image_27, t0.options_en AS options_en_28, t0.opis_pl AS opis_pl_29, t0.opis_en AS opis_en_30, t0.sterowanie_id AS sterowanie_id_31, t0.model_oprawy_id AS model_oprawy_id_32, t0.destiny_id AS destiny_id_33, t0.dioda_id AS dioda_id_34, t0.kolor_id AS kolor_id_35, t0.holder_id AS holder_id_36, t0.odblysnik_id AS odblysnik_id_37, t0.led_driver_id AS led_driver_id_38, t0.przeslona_id AS przeslona_id_39, t0.image_id AS image_id_40 FROM produkt t0 WHERE t0.model_oprawy_id = 925;

SELECT
  t0.id AS id_1,
  t0.typ AS typ_2,
  t0.barwa_swiecenia AS barwa_swiecenia_3,
  t0.cri AS cri_4,
  t0.typ_diody_nazwa AS typ_diody_nazwa_5,
  t0.typ_diody_nazwa_dodatkowa AS typ_diody_nazwa_dodatkowa_6,
  t0.cct_kelvin AS cct_kelvin_7
FROM
  dioda t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.typ AS typ_2, t0.barwa_swiecenia AS barwa_swiecenia_3, t0.cri AS cri_4, t0.typ_diody_nazwa AS typ_diody_nazwa_5, t0.typ_diody_nazwa_dodatkowa AS typ_diody_nazwa_dodatkowa_6, t0.cct_kelvin AS cct_kelvin_7 FROM dioda t0 WHERE t0.id = 831;

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
    AND (
      (
        (
          0 != FIND_IN_SET(
            "2",
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:pl-state"]/sv:value'
              ),
              " ",
              ","
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:pl-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:pl-navContexts"]/sv:value[text()="main"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/cora-www/contents/%'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET("2", REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:pl-state"]/sv:value'), " ", ",")) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:pl-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:pl-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/cora-www/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
    AND (
      (
        (
          0 != FIND_IN_SET(
            "2",
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:pl-state"]/sv:value'
              ),
              " ",
              ","
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:pl-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:pl-navContexts"]/sv:value[text()="footer_nav_right"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/cora-www/contents/%'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET("2", REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:pl-state"]/sv:value'), " ", ",")) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:pl-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:pl-navContexts"]/sv:value[text()="footer_nav_right"]) > 0')) AND n0.path LIKE '/cmf/cora-www/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
    AND (
      (
        (
          0 != FIND_IN_SET(
            "2",
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:pl-state"]/sv:value'
              ),
              " ",
              ","
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:pl-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:pl-navContexts"]/sv:value[text()="footer_nav_center"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/cora-www/contents/%'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET("2", REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:pl-state"]/sv:value'), " ", ",")) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:pl-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:pl-navContexts"]/sv:value[text()="footer_nav_center"]) > 0')) AND n0.path LIKE '/cmf/cora-www/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
    AND (
      (
        (
          0 != FIND_IN_SET(
            "2",
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:pl-state"]/sv:value'
              ),
              " ",
              ","
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:pl-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:pl-navContexts"]/sv:value[text()="footer_nav_left"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/cora-www/contents/%'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET("2", REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:pl-state"]/sv:value'), " ", ",")) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:pl-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:pl-navContexts"]/sv:value[text()="footer_nav_left"]) > 0')) AND n0.path LIKE '/cmf/cora-www/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;

SELECT
  t0.id AS id_1,
  t0.typ AS typ_2,
  t0.kat AS kat_3
FROM
  odblysnik t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.typ AS typ_2, t0.kat AS kat_3 FROM odblysnik t0 WHERE t0.id = 2028;

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value AS property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value AS property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.kod AS kod_2,
  t0.nazwa AS nazwa_3,
  t0.ral AS ral_4
FROM
  color t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.kod AS kod_2, t0.nazwa AS nazwa_3, t0.ral AS ral_4 FROM color t0 WHERE t0.id = 76;

SELECT
  w0_.title AS title_0,
  w0_.webspace_key AS webspace_key_1,
  w0_.all_domains AS all_domains_2,
  w0_.content AS content_3,
  w0_.type AS type_4,
  w0_.id AS id_5,
  w1_.url AS url_6,
  w1_.environment AS environment_7,
  w1_.id AS id_8
FROM
  we_analytics w0_
  LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics
  LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain
WHERE
  (
    w0_.all_domains = 1
    OR (
      w1_.url = ?
      AND w1_.environment = ?
    )
  )
  AND w0_.webspace_key = ?
ORDER BY
  w0_.id ASC,
  w1_.id ASC

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'cora.pl' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'cora-www' ORDER BY w0_.id ASC, w1_.id ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?, ?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/cora-www/contents/o-nas', '/cmf/cora-www/contents/test/reflektory', '/cmf/cora-www/contents/test', '/cmf/cora-www/contents/test/downlight', '/cmf/cora-www/contents/test/led-line', '/cmf/cora-www/contents/do-pobrania', '/cmf/cora-www/contents/realizacje', '/cmf/cora-www/contents/kontakt') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.nazwa AS nazwa_2,
  t0.description AS description_3,
  t0.klasa_ip AS klasa_ip_4,
  t0.klasa_ik AS klasa_ik_5,
  t0.zakres_temp AS zakres_temp_6,
  t0.klasa_ochronnosci AS klasa_ochronnosci_7,
  t0.dlugosc AS dlugosc_8,
  t0.szerokosc AS szerokosc_9,
  t0.wysokosc AS wysokosc_10,
  t0.srednica_oprawy AS srednica_oprawy_11,
  t0.otwor_montazowy AS otwor_montazowy_12,
  t0.waga_netto AS waga_netto_13,
  t0.waga_opakowania_foliowego AS waga_opakowania_foliowego_14,
  t0.opakowanie_jednostkowe_l AS opakowanie_jednostkowe_l_15,
  t0.opakowanie_jednostkowe_w AS opakowanie_jednostkowe_w_16,
  t0.opakowanie_jednostkowe_h AS opakowanie_jednostkowe_h_17,
  t0.opakowanie_jednostkowe_brutto AS opakowanie_jednostkowe_brutto_18,
  t0.opakowanie_zbiorcze_l AS opakowanie_zbiorcze_l_19,
  t0.opakowanie_zbiorcze_w AS opakowanie_zbiorcze_w_20,
  t0.opakowanie_zbiorcze_h AS opakowanie_zbiorcze_h_21,
  t0.opakowanie_zbiorcze_netto AS opakowanie_zbiorcze_netto_22,
  t0.opakowanie_zbiorcze_brutto AS opakowanie_zbiorcze_brutto_23,
  t0.opakowanie_zbiorcze_il_sztuk AS opakowanie_zbiorcze_il_sztuk_24,
  t0.paleta_l AS paleta_l_25,
  t0.paleta_w AS paleta_w_26,
  t0.paleta_h AS paleta_h_27,
  t0.paleta_netto AS paleta_netto_28,
  t0.paleta_brutto AS paleta_brutto_29,
  t0.paleta_il_sztuk AS paleta_il_sztuk_30,
  t0.grupa_towarowa AS grupa_towarowa_31,
  t0.kod_celny AS kod_celny_32,
  t0.kraj_pochodzenia AS kraj_pochodzenia_33,
  t0.kraj_pochodzenia_kod AS kraj_pochodzenia_kod_34,
  t0.kod AS kod_35,
  t0.typ AS typ_36,
  t0.opis_modelu_oprawy AS opis_modelu_oprawy_37,
  t0.visibility AS visibility_38,
  t0.kategoria_id AS kategoria_id_39,
  t0.image_id AS image_id_40
FROM
  model_oprawy t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nazwa AS nazwa_2, t0.description AS description_3, t0.klasa_ip AS klasa_ip_4, t0.klasa_ik AS klasa_ik_5, t0.zakres_temp AS zakres_temp_6, t0.klasa_ochronnosci AS klasa_ochronnosci_7, t0.dlugosc AS dlugosc_8, t0.szerokosc AS szerokosc_9, t0.wysokosc AS wysokosc_10, t0.srednica_oprawy AS srednica_oprawy_11, t0.otwor_montazowy AS otwor_montazowy_12, t0.waga_netto AS waga_netto_13, t0.waga_opakowania_foliowego AS waga_opakowania_foliowego_14, t0.opakowanie_jednostkowe_l AS opakowanie_jednostkowe_l_15, t0.opakowanie_jednostkowe_w AS opakowanie_jednostkowe_w_16, t0.opakowanie_jednostkowe_h AS opakowanie_jednostkowe_h_17, t0.opakowanie_jednostkowe_brutto AS opakowanie_jednostkowe_brutto_18, t0.opakowanie_zbiorcze_l AS opakowanie_zbiorcze_l_19, t0.opakowanie_zbiorcze_w AS opakowanie_zbiorcze_w_20, t0.opakowanie_zbiorcze_h AS opakowanie_zbiorcze_h_21, t0.opakowanie_zbiorcze_netto AS opakowanie_zbiorcze_netto_22, t0.opakowanie_zbiorcze_brutto AS opakowanie_zbiorcze_brutto_23, t0.opakowanie_zbiorcze_il_sztuk AS opakowanie_zbiorcze_il_sztuk_24, t0.paleta_l AS paleta_l_25, t0.paleta_w AS paleta_w_26, t0.paleta_h AS paleta_h_27, t0.paleta_netto AS paleta_netto_28, t0.paleta_brutto AS paleta_brutto_29, t0.paleta_il_sztuk AS paleta_il_sztuk_30, t0.grupa_towarowa AS grupa_towarowa_31, t0.kod_celny AS kod_celny_32, t0.kraj_pochodzenia AS kraj_pochodzenia_33, t0.kraj_pochodzenia_kod AS kraj_pochodzenia_kod_34, t0.kod AS kod_35, t0.typ AS typ_36, t0.opis_modelu_oprawy AS opis_modelu_oprawy_37, t0.visibility AS visibility_38, t0.kategoria_id AS kategoria_id_39, t0.image_id AS image_id_40 FROM model_oprawy t0 WHERE t0.id = 925;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  TYPE,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, TYPE, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/cora-www/contents/o-nas' OR path = '/cmf/cora-www/contents/test/reflektory' OR path = '/cmf/cora-www/contents/test' OR path = '/cmf/cora-www/contents/test/downlight' OR path = '/cmf/cora-www/contents/test/led-line' OR path = '/cmf/cora-www/contents/do-pobrania' OR path = '/cmf/cora-www/contents/realizacje' OR path = '/cmf/cora-www/contents/kontakt') ORDER BY sort_order ASC;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/cora-www/contents'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/cora-www/contents') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  TYPE,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, TYPE, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/cora-www/contents/formularz-reklamacyjny' OR path = '/cmf/cora-www/contents/polityka-prywatnosci' OR path = '/cmf/cora-www/contents/general-terms-and-conditions-of-sales' OR path = '/cmf/cora-www/contents/owg-ogolne-warunki-gwarancji' OR path = '/cmf/cora-www/contents/general-warranty-terms-and-conditions' OR path = '/cmf/cora-www/contents/dfbgvdxf') ORDER BY sort_order ASC;

SELECT
  path AS arraykey,
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  TYPE,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND (
    path = ?
    OR path = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, TYPE, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/cora-www/contents/dotacje' OR path = '/cmf/cora-www/contents/praca') ORDER BY sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/cora-www/contents/polityka-prywatnosci', '/cmf/cora-www/contents/formularz-reklamacyjny', '/cmf/cora-www/contents/dfbgvdxf', '/cmf/cora-www/contents/general-terms-and-conditions-of-sales', '/cmf/cora-www/contents/owg-ogolne-warunki-gwarancji', '/cmf/cora-www/contents/general-warranty-terms-and-conditions') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.changed AS changed_3,
  t0.idMediaTypes AS idMediaTypes_4,
  t0.idPreviewImage AS idPreviewImage_5,
  t0.idCollections AS idCollections_6,
  t0.idUsersCreator AS idUsersCreator_7,
  t0.idUsersChanger AS idUsersChanger_8
FROM
  me_media t0
  INNER JOIN produkt_media_interface ON t0.id = produkt_media_interface.media_interface_id
WHERE
  produkt_media_interface.produkt_id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 INNER JOIN produkt_media_interface ON t0.id = produkt_media_interface.media_interface_id WHERE produkt_media_interface.produkt_id = 1348224;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/cora-www/contents/dotacje', '/cmf/cora-www/contents/praca') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

SELECT
  t0.id AS id_1,
  t0.kod AS kod_2,
  t0.nazwa AS nazwa_3
FROM
  sterowanie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.kod AS kod_2, t0.nazwa AS nazwa_3 FROM sterowanie t0 WHERE t0.id = 64;

SELECT
  t0.id AS id_1,
  t0.typ AS typ_2,
  t0.nazwa AS nazwa_3
FROM
  holder t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.typ AS typ_2, t0.nazwa AS nazwa_3 FROM holder t0 WHERE t0.id = 170;

SELECT
  t0.id AS id_1,
  t0.typ AS typ_2,
  t0.prad_zasilania AS prad_zasilania_3
FROM
  led_driver t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.typ AS typ_2, t0.prad_zasilania AS prad_zasilania_3 FROM led_driver t0 WHERE t0.id = 381;

SELECT
  t0.id AS id_1,
  t0.typ AS typ_2,
  t0.opis AS opis_3
FROM
  przeslona t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.typ AS typ_2, t0.opis AS opis_3 FROM przeslona t0 WHERE t0.id = 306;