Symfony Profiler

SELECT
  r0_.webspace AS webspace_0,
  r0_.locale AS locale_1,
  r0_.slug AS slug_2,
  r0_.resource_key AS resource_key_3,
  r0_.resource_id AS resource_id_4,
  r0_.id AS id_5,
  r0_.parent_id AS parent_id_6
FROM
  ro_routes r0_
WHERE
  (
    (
      r0_.webspace = ?
      OR r0_.webspace IS NULL
    )
  )
  AND r0_.locale = ?
  AND r0_.slug = ?
ORDER BY
  r0_.webspace DESC
LIMIT
  1

SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = 'tuhlla' OR r0_.webspace IS NULL)) AND r0_.locale = 'bg' AND r0_.slug = '/kukhni/baaaaaaa' ORDER BY r0_.webspace DESC LIMIT 1;

SELECT
  a0_.uuid AS uuid_0,
  a0_.created AS created_1,
  a0_.changed AS changed_2,
  a1_.title AS title_3,
  a1_.customizeWebspaceSettings AS customizeWebspaceSettings_4,
  a1_.id AS id_5,
  a1_.stage AS stage_6,
  a1_.locale AS locale_7,
  a1_.ghostLocale AS ghostLocale_8,
  a1_.availableLocales AS availableLocales_9,
  a1_.version AS version_10,
  a1_.shadowLocale AS shadowLocale_11,
  a1_.shadowLocales AS shadowLocales_12,
  a1_.templateKey AS templateKey_13,
  a1_.templateData AS templateData_14,
  a1_.seoData AS seoData_15,
  a1_.seoNoIndex AS seoNoIndex_16,
  a1_.seoNoFollow AS seoNoFollow_17,
  a1_.seoHideInSitemap AS seoHideInSitemap_18,
  a1_.excerptData AS excerptData_19,
  a1_.excerptSegment AS excerptSegment_20,
  a1_.mainWebspace AS mainWebspace_21,
  a1_.authored AS authored_22,
  a1_.lastModified AS lastModified_23,
  a1_.workflowPlace AS workflowPlace_24,
  a1_.workflowPublished AS workflowPublished_25,
  a1_.created AS created_26,
  a1_.changed AS changed_27,
  t2_.name AS name_28,
  t2_.id AS id_29,
  t2_.created AS created_30,
  t2_.changed AS changed_31,
  c3_.category_key AS category_key_32,
  c3_.default_locale AS default_locale_33,
  c3_.lft AS lft_34,
  c3_.rgt AS rgt_35,
  c3_.depth AS depth_36,
  c3_.id AS id_37,
  c3_.created AS created_38,
  c3_.changed AS changed_39,
  c4_.translation AS translation_40,
  c4_.locale AS locale_41,
  c4_.description AS description_42,
  c4_.id AS id_43,
  c4_.created AS created_44,
  c4_.changed AS changed_45,
  a0_.idUsersCreator AS idUsersCreator_46,
  a0_.idUsersChanger AS idUsersChanger_47,
  a1_.route_id AS route_id_48,
  a1_.articleUuid AS articleUuid_49,
  a1_.author_id AS author_id_50,
  a1_.idUsersCreator AS idUsersCreator_51,
  a1_.idUsersChanger AS idUsersChanger_52,
  t2_.idUsersCreator AS idUsersCreator_53,
  t2_.idUsersChanger AS idUsersChanger_54,
  c3_.idCategoriesParent AS idCategoriesParent_55,
  c3_.idUsersCreator AS idUsersCreator_56,
  c3_.idUsersChanger AS idUsersChanger_57,
  c4_.idCategories AS idCategories_58,
  c4_.idUsersCreator AS idUsersCreator_59,
  c4_.idUsersChanger AS idUsersChanger_60
FROM
  ar_articles a0_
  LEFT JOIN ar_article_dimension_contents a1_ ON a0_.uuid = a1_.articleUuid
  LEFT JOIN ar_article_dimension_content_excerpt_tags a5_ ON a1_.id = a5_.article_dimension_content_id
  LEFT JOIN ta_tags t2_ ON t2_.id = a5_.tag_id
  LEFT JOIN ar_article_dimension_content_excerpt_categories a6_ ON a1_.id = a6_.article_dimension_content_id
  LEFT JOIN ca_categories c3_ ON c3_.id = a6_.category_id
  LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories
  AND (
    c4_.locale = c3_.default_locale
    OR c4_.locale IN (?)
  )
WHERE
  a0_.uuid = ?
  AND (
    (
      (
        a1_.locale IS NULL
        OR a1_.locale IN (?)
      )
      AND (
        a1_.stage IS NULL
        OR a1_.stage IN (?)
      )
    )
    AND (
      a1_.version IS NULL
      OR a1_.version IN (?)
    )
  )

SELECT a0_.uuid AS uuid_0, a0_.created AS created_1, a0_.changed AS changed_2, a1_.title AS title_3, a1_.customizeWebspaceSettings AS customizeWebspaceSettings_4, a1_.id AS id_5, a1_.stage AS stage_6, a1_.locale AS locale_7, a1_.ghostLocale AS ghostLocale_8, a1_.availableLocales AS availableLocales_9, a1_.version AS version_10, a1_.shadowLocale AS shadowLocale_11, a1_.shadowLocales AS shadowLocales_12, a1_.templateKey AS templateKey_13, a1_.templateData AS templateData_14, a1_.seoData AS seoData_15, a1_.seoNoIndex AS seoNoIndex_16, a1_.seoNoFollow AS seoNoFollow_17, a1_.seoHideInSitemap AS seoHideInSitemap_18, a1_.excerptData AS excerptData_19, a1_.excerptSegment AS excerptSegment_20, a1_.mainWebspace AS mainWebspace_21, a1_.authored AS authored_22, a1_.lastModified AS lastModified_23, a1_.workflowPlace AS workflowPlace_24, a1_.workflowPublished AS workflowPublished_25, a1_.created AS created_26, a1_.changed AS changed_27, t2_.name AS name_28, t2_.id AS id_29, t2_.created AS created_30, t2_.changed AS changed_31, c3_.category_key AS category_key_32, c3_.default_locale AS default_locale_33, c3_.lft AS lft_34, c3_.rgt AS rgt_35, c3_.depth AS depth_36, c3_.id AS id_37, c3_.created AS created_38, c3_.changed AS changed_39, c4_.translation AS translation_40, c4_.locale AS locale_41, c4_.description AS description_42, c4_.id AS id_43, c4_.created AS created_44, c4_.changed AS changed_45, a0_.idUsersCreator AS idUsersCreator_46, a0_.idUsersChanger AS idUsersChanger_47, a1_.route_id AS route_id_48, a1_.articleUuid AS articleUuid_49, a1_.author_id AS author_id_50, a1_.idUsersCreator AS idUsersCreator_51, a1_.idUsersChanger AS idUsersChanger_52, t2_.idUsersCreator AS idUsersCreator_53, t2_.idUsersChanger AS idUsersChanger_54, c3_.idCategoriesParent AS idCategoriesParent_55, c3_.idUsersCreator AS idUsersCreator_56, c3_.idUsersChanger AS idUsersChanger_57, c4_.idCategories AS idCategories_58, c4_.idUsersCreator AS idUsersCreator_59, c4_.idUsersChanger AS idUsersChanger_60 FROM ar_articles a0_ LEFT JOIN ar_article_dimension_contents a1_ ON a0_.uuid = a1_.articleUuid LEFT JOIN ar_article_dimension_content_excerpt_tags a5_ ON a1_.id = a5_.article_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = a5_.tag_id LEFT JOIN ar_article_dimension_content_excerpt_categories a6_ ON a1_.id = a6_.article_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = a6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN ('bg')) WHERE a0_.uuid = '019e87c7-3606-76fa-b81b-6c72fa705cbf' AND (((a1_.locale IS NULL OR a1_.locale IN ('bg')) AND (a1_.stage IS NULL OR a1_.stage IN ('live'))) AND (a1_.version IS NULL OR a1_.version IN (0)));

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.article_dimension_content_id AS article_dimension_content_id_3
FROM
  ar_article_dimension_content_additional_webspaces t0
WHERE
  t0.article_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = 11;

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.article_dimension_content_id AS article_dimension_content_id_3
FROM
  ar_article_dimension_content_additional_webspaces t0
WHERE
  t0.article_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = 12;

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

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 = 'tuhlla.fxrm.eu' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'tuhlla' ORDER BY w0_.id ASC;