Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  ge_page_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ge_page_translation t0 WHERE t0.object_id = 263;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  filterpage_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id = 8;

SELECT
  f0_.id AS id_0,
  f0_.intname AS intname_1,
  COALESCE(t1_.content, f0_.name) AS name_2,
  COALESCE(t2_.content, f0_.cont) AS cont_3,
  f0_.visible AS visible_4,
  COALESCE(t3_.content, f0_.title) AS title_5,
  COALESCE(t4_.content, f0_.h1) AS h1_6,
  COALESCE(t5_.content, f0_.kw) AS kw_7,
  COALESCE(t6_.content, f0_.descr) AS descr_8
FROM
  filterpage f0_
  LEFT JOIN filterpage_translation t1_ ON t1_.locale = 'ru'
  AND t1_.field = 'name'
  AND t1_.object_id = f0_.id
  LEFT JOIN filterpage_translation t2_ ON t2_.locale = 'ru'
  AND t2_.field = 'cont'
  AND t2_.object_id = f0_.id
  LEFT JOIN filterpage_translation t3_ ON t3_.locale = 'ru'
  AND t3_.field = 'title'
  AND t3_.object_id = f0_.id
  LEFT JOIN filterpage_translation t4_ ON t4_.locale = 'ru'
  AND t4_.field = 'h1'
  AND t4_.object_id = f0_.id
  LEFT JOIN filterpage_translation t5_ ON t5_.locale = 'ru'
  AND t5_.field = 'kw'
  AND t5_.object_id = f0_.id
  LEFT JOIN filterpage_translation t6_ ON t6_.locale = 'ru'
  AND t6_.field = 'descr'
  AND t6_.object_id = f0_.id
WHERE
  f0_.intname = ?

SELECT f0_.id AS id_0, f0_.intname AS intname_1, COALESCE(t1_.content, f0_.name) AS name_2, COALESCE(t2_.content, f0_.cont) AS cont_3, f0_.visible AS visible_4, COALESCE(t3_.content, f0_.title) AS title_5, COALESCE(t4_.content, f0_.h1) AS h1_6, COALESCE(t5_.content, f0_.kw) AS kw_7, COALESCE(t6_.content, f0_.descr) AS descr_8 FROM filterpage f0_ LEFT JOIN filterpage_translation t1_ ON t1_.locale = 'ru' AND t1_.field = 'name' AND t1_.object_id = f0_.id LEFT JOIN filterpage_translation t2_ ON t2_.locale = 'ru' AND t2_.field = 'cont' AND t2_.object_id = f0_.id LEFT JOIN filterpage_translation t3_ ON t3_.locale = 'ru' AND t3_.field = 'title' AND t3_.object_id = f0_.id LEFT JOIN filterpage_translation t4_ ON t4_.locale = 'ru' AND t4_.field = 'h1' AND t4_.object_id = f0_.id LEFT JOIN filterpage_translation t5_ ON t5_.locale = 'ru' AND t5_.field = 'kw' AND t5_.object_id = f0_.id LEFT JOIN filterpage_translation t6_ ON t6_.locale = 'ru' AND t6_.field = 'descr' AND t6_.object_id = f0_.id WHERE f0_.intname = 'group-sex';

SELECT
  g0_.id AS id_0,
  g0_.old_id AS old_id_1,
  g0_.type AS type_2,
  g0_.page AS page_3,
  g0_.girl AS girl_4,
  g0_.intname AS intname_5,
  g0_.mainpage AS mainpage_6,
  g0_.name AS name_7,
  g0_.href AS href_8,
  g0_.short AS short_9,
  g0_.cont AS cont_10,
  g0_.cont2 AS cont2_11,
  g0_.prior AS prior_12,
  g0_.visible AS visible_13,
  g0_.autosub AS autosub_14,
  g0_.title AS title_15,
  g0_.h1 AS h1_16,
  g0_.h3 AS h3_17,
  g0_.kw AS kw_18,
  g0_.descr AS descr_19,
  g0_.tstamp AS tstamp_20,
  g0_.rating AS rating_21,
  g0_.noindex AS noindex_22,
  g0_.footmenu AS footmenu_23,
  g0_.video AS video_24,
  g0_.showon AS showon_25,
  g0_.topmenu AS topmenu_26,
  g0_.topmenu2 AS topmenu2_27,
  g0_.spec AS spec_28
FROM
  ge_page g0_
WHERE
  (
    g0_.showon LIKE ?
    OR g0_.showon = ''
  )
  AND g0_.type = ?
  AND g0_.visible = 1
  AND g0_.page = 0
  AND g0_.footmenu = 1
ORDER BY
  g0_.prior DESC

SELECT g0_.id AS id_0, g0_.old_id AS old_id_1, g0_.type AS type_2, g0_.page AS page_3, g0_.girl AS girl_4, g0_.intname AS intname_5, g0_.mainpage AS mainpage_6, g0_.name AS name_7, g0_.href AS href_8, g0_.short AS short_9, g0_.cont AS cont_10, g0_.cont2 AS cont2_11, g0_.prior AS prior_12, g0_.visible AS visible_13, g0_.autosub AS autosub_14, g0_.title AS title_15, g0_.h1 AS h1_16, g0_.h3 AS h3_17, g0_.kw AS kw_18, g0_.descr AS descr_19, g0_.tstamp AS tstamp_20, g0_.rating AS rating_21, g0_.noindex AS noindex_22, g0_.footmenu AS footmenu_23, g0_.video AS video_24, g0_.showon AS showon_25, g0_.topmenu AS topmenu_26, g0_.topmenu2 AS topmenu2_27, g0_.spec AS spec_28 FROM ge_page g0_ WHERE (g0_.showon LIKE '%ru%' OR g0_.showon = '') AND g0_.type = 'page' AND g0_.visible = 1 AND g0_.page = 0 AND g0_.footmenu = 1 ORDER BY g0_.prior DESC;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  filterpage_translation t0
WHERE
  t0.object_id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id IN (8, 7, 6, 5, 4, 3, 2, 1);

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  filterpage_translation t0
WHERE
  t0.object_id IN (?)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM filterpage_translation t0 WHERE t0.object_id IN (6);

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  char_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM char_translation t0 WHERE t0.object_id = 111;

SELECT
  f0_.id AS id_0,
  f0_.intname AS intname_1,
  f0_.name AS name_2,
  f0_.cont AS cont_3,
  f0_.visible AS visible_4,
  f0_.title AS title_5,
  f0_.h1 AS h1_6,
  f0_.kw AS kw_7,
  f0_.descr AS descr_8
FROM
  filterpage f0_
WHERE
  f0_.visible = 1
ORDER BY
  f0_.id DESC
LIMIT
  8

SELECT f0_.id AS id_0, f0_.intname AS intname_1, f0_.name AS name_2, f0_.cont AS cont_3, f0_.visible AS visible_4, f0_.title AS title_5, f0_.h1 AS h1_6, f0_.kw AS kw_7, f0_.descr AS descr_8 FROM filterpage f0_ WHERE f0_.visible = 1 ORDER BY f0_.id DESC LIMIT 8;

SELECT
  f0_.id AS id_0,
  f0_.char_id AS char_id_1,
  f0_.filterpage AS filterpage_2,
  f0_.charval AS charval_3,
  f0_.value AS value_4
FROM
  filterpagechar f0_
WHERE
  f0_.filterpage = ?
ORDER BY
  f0_.id DESC

SELECT f0_.id AS id_0, f0_.char_id AS char_id_1, f0_.filterpage AS filterpage_2, f0_.charval AS charval_3, f0_.value AS value_4 FROM filterpagechar f0_ WHERE f0_.filterpage = 6 ORDER BY f0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.old_id AS old_id_2,
  t0.par AS par_3,
  t0.charcat AS charcat_4,
  t0.name AS name_5,
  t0.type AS type_6,
  t0.gender AS gender_7,
  t0.search AS search_8,
  t0.compare AS compare_9,
  t0.buy AS buy_10,
  t0.izm AS izm_11,
  t0.prior AS prior_12,
  t0.visible AS visible_13,
  t0.spec AS spec_14,
  t0.hint AS hint_15,
  t0.hint_ge AS hint_ge_16,
  t0.hint_kt AS hint_kt_17
FROM
  `char` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.par AS par_3, t0.charcat AS charcat_4, t0.name AS name_5, t0.type AS type_6, t0.gender AS gender_7, t0.search AS search_8, t0.compare AS compare_9, t0.buy AS buy_10, t0.izm AS izm_11, t0.prior AS prior_12, t0.visible AS visible_13, t0.spec AS spec_14, t0.hint AS hint_15, t0.hint_ge AS hint_ge_16, t0.hint_kt AS hint_kt_17 FROM `char` t0 WHERE t0.id = 111;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  charval_translation t0
WHERE
  t0.object_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM charval_translation t0 WHERE t0.object_id = 182;

SELECT
  g0_.id AS id_0,
  g0_.old_id AS old_id_1,
  g0_.type AS type_2,
  g0_.page AS page_3,
  g0_.girl AS girl_4,
  g0_.intname AS intname_5,
  g0_.mainpage AS mainpage_6,
  g0_.name AS name_7,
  g0_.href AS href_8,
  g0_.short AS short_9,
  g0_.cont AS cont_10,
  g0_.cont2 AS cont2_11,
  g0_.prior AS prior_12,
  g0_.visible AS visible_13,
  g0_.autosub AS autosub_14,
  g0_.title AS title_15,
  g0_.h1 AS h1_16,
  g0_.h3 AS h3_17,
  g0_.kw AS kw_18,
  g0_.descr AS descr_19,
  g0_.tstamp AS tstamp_20,
  g0_.rating AS rating_21,
  g0_.noindex AS noindex_22,
  g0_.footmenu AS footmenu_23,
  g0_.video AS video_24,
  g0_.showon AS showon_25,
  g0_.topmenu AS topmenu_26,
  g0_.topmenu2 AS topmenu2_27,
  g0_.spec AS spec_28
FROM
  ge_page g0_
WHERE
  (
    g0_.showon LIKE ?
    OR g0_.showon = ''
  )
  AND g0_.type = ?
  AND g0_.visible = 1
  AND g0_.page = 0
  AND g0_.topmenu = 1
ORDER BY
  g0_.prior DESC

SELECT g0_.id AS id_0, g0_.old_id AS old_id_1, g0_.type AS type_2, g0_.page AS page_3, g0_.girl AS girl_4, g0_.intname AS intname_5, g0_.mainpage AS mainpage_6, g0_.name AS name_7, g0_.href AS href_8, g0_.short AS short_9, g0_.cont AS cont_10, g0_.cont2 AS cont2_11, g0_.prior AS prior_12, g0_.visible AS visible_13, g0_.autosub AS autosub_14, g0_.title AS title_15, g0_.h1 AS h1_16, g0_.h3 AS h3_17, g0_.kw AS kw_18, g0_.descr AS descr_19, g0_.tstamp AS tstamp_20, g0_.rating AS rating_21, g0_.noindex AS noindex_22, g0_.footmenu AS footmenu_23, g0_.video AS video_24, g0_.showon AS showon_25, g0_.topmenu AS topmenu_26, g0_.topmenu2 AS topmenu2_27, g0_.spec AS spec_28 FROM ge_page g0_ WHERE (g0_.showon LIKE '%ru%' OR g0_.showon = '') AND g0_.type = 'page' AND g0_.visible = 1 AND g0_.page = 0 AND g0_.topmenu = 1 ORDER BY g0_.prior DESC;

SELECT
  t0.id AS id_1,
  t0.old_id AS old_id_2,
  t0.char AS char_3,
  t0.value AS value_4,
  t0.visible AS visible_5,
  t0.search AS search_6,
  t0.hint AS hint_7,
  t0.prior AS prior_8
FROM
  charval t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.char AS char_3, t0.value AS value_4, t0.visible AS visible_5, t0.search AS search_6, t0.hint AS hint_7, t0.prior AS prior_8 FROM charval t0 WHERE t0.id = 182;

SELECT
  g0_.id AS id_0,
  g0_.old_id AS old_id_1,
  g0_.type AS type_2,
  g0_.page AS page_3,
  g0_.girl AS girl_4,
  g0_.intname AS intname_5,
  g0_.mainpage AS mainpage_6,
  g0_.name AS name_7,
  g0_.href AS href_8,
  g0_.short AS short_9,
  g0_.cont AS cont_10,
  g0_.cont2 AS cont2_11,
  g0_.prior AS prior_12,
  g0_.visible AS visible_13,
  g0_.autosub AS autosub_14,
  g0_.title AS title_15,
  g0_.h1 AS h1_16,
  g0_.h3 AS h3_17,
  g0_.kw AS kw_18,
  g0_.descr AS descr_19,
  g0_.tstamp AS tstamp_20,
  g0_.rating AS rating_21,
  g0_.noindex AS noindex_22,
  g0_.footmenu AS footmenu_23,
  g0_.video AS video_24,
  g0_.showon AS showon_25,
  g0_.topmenu AS topmenu_26,
  g0_.topmenu2 AS topmenu2_27,
  g0_.spec AS spec_28
FROM
  ge_page g0_
WHERE
  (
    g0_.showon LIKE ?
    OR g0_.showon = ''
  )
  AND g0_.type = ?
  AND g0_.visible = 1
  AND g0_.page = 0
  AND g0_.prior > 200
  AND g0_.prior < 300
ORDER BY
  g0_.prior DESC

SELECT g0_.id AS id_0, g0_.old_id AS old_id_1, g0_.type AS type_2, g0_.page AS page_3, g0_.girl AS girl_4, g0_.intname AS intname_5, g0_.mainpage AS mainpage_6, g0_.name AS name_7, g0_.href AS href_8, g0_.short AS short_9, g0_.cont AS cont_10, g0_.cont2 AS cont2_11, g0_.prior AS prior_12, g0_.visible AS visible_13, g0_.autosub AS autosub_14, g0_.title AS title_15, g0_.h1 AS h1_16, g0_.h3 AS h3_17, g0_.kw AS kw_18, g0_.descr AS descr_19, g0_.tstamp AS tstamp_20, g0_.rating AS rating_21, g0_.noindex AS noindex_22, g0_.footmenu AS footmenu_23, g0_.video AS video_24, g0_.showon AS showon_25, g0_.topmenu AS topmenu_26, g0_.topmenu2 AS topmenu2_27, g0_.spec AS spec_28 FROM ge_page g0_ WHERE (g0_.showon LIKE '%ru%' OR g0_.showon = '') AND g0_.type = 'page' AND g0_.visible = 1 AND g0_.page = 0 AND g0_.prior > 200 AND g0_.prior < 300 ORDER BY g0_.prior DESC;