Symfony Profiler

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

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;

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

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;

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 '%en%' 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
  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 '%en%' 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;

select
  pc.char_id as cid,
  cv.id as cvid,
  pc.charval as val,
  pc.value as text,
  c.name as name,
  c.spec,
  c.type,
  c.par,
  c.search,
  c.compare,
  cv.value
from
  girlchar as pc
  left join `char` as c on c.id = pc.`char_id`
  left join charval as cv on pc.charval = cv.id
where
  pc.girl = '38'
  and c.charcat = 'bio'
  and c.visible = 1
order by
  c.prior desc,
  c.id asc

select pc.char_id as cid, cv.id as cvid, pc.charval as val, pc.value as text, c.name as name, c.spec, c.type, c.par, c.search, c.compare, cv.value
                from girlchar as pc 
                left join `char` as c on c.id = pc.`char_id`
                left join charval as cv on pc.charval = cv.id 
                where pc.girl = '38' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc;

SELECT
  t0.id AS id_1,
  t0.girl AS girl_2,
  t0.intname AS intname_3,
  t0.name AS name_4,
  t0.video AS video_5,
  t0.cont AS cont_6,
  t0.prior AS prior_7,
  t0.title AS title_8,
  t0.h1 AS h1_9,
  t0.kw AS kw_10,
  t0.descr AS descr_11,
  t0.visible AS visible_12,
  t0.hidden AS hidden_13
FROM
  ge_video t0
WHERE
  t0.girl = ?
ORDER BY
  t0.prior DESC

SELECT t0.id AS id_1, t0.girl AS girl_2, t0.intname AS intname_3, t0.name AS name_4, t0.video AS video_5, t0.cont AS cont_6, t0.prior AS prior_7, t0.title AS title_8, t0.h1 AS h1_9, t0.kw AS kw_10, t0.descr AS descr_11, t0.visible AS visible_12, t0.hidden AS hidden_13 FROM ge_video t0 WHERE t0.girl = 30 ORDER BY t0.prior DESC;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.cont AS cont_2,
  h0_.girl AS girl_3,
  h0_.begin AS begin_4,
  h0_.end AS end_5,
  h0_.visible AS visible_6
FROM
  hotoffer h0_
WHERE
  h0_.girl = ?
  AND h0_.end > ?

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.cont AS cont_2, h0_.girl AS girl_3, h0_.begin AS begin_4, h0_.end AS end_5, h0_.visible AS visible_6 FROM hotoffer h0_ WHERE h0_.girl = 30 AND h0_.end > 1772322248;

SELECT
  t0.id AS id_1,
  t0.lang AS lang_2,
  t0.par AS par_3,
  t0.type AS type_4,
  t0.user AS user_5,
  t0.author AS author_6,
  t0.tstamp AS tstamp_7,
  t0.cont AS cont_8,
  t0.visible AS visible_9,
  t0.confirmed AS confirmed_10,
  t0.rating AS rating_11,
  t0.meeting AS meeting_12,
  t0.phone AS phone_13,
  t0.email AS email_14,
  t0.ip AS ip_15
FROM
  ge_comment t0
WHERE
  t0.type = ?
  AND t0.par = ?
  AND t0.visible = ?
  AND t0.lang = ?
ORDER BY
  t0.tstamp DESC

SELECT t0.id AS id_1, t0.lang AS lang_2, t0.par AS par_3, t0.type AS type_4, t0.user AS user_5, t0.author AS author_6, t0.tstamp AS tstamp_7, t0.cont AS cont_8, t0.visible AS visible_9, t0.confirmed AS confirmed_10, t0.rating AS rating_11, t0.meeting AS meeting_12, t0.phone AS phone_13, t0.email AS email_14, t0.ip AS ip_15 FROM ge_comment t0 WHERE t0.type = 'girl' AND t0.par = 30 AND t0.visible = 1 AND t0.lang = 'en' ORDER BY t0.tstamp DESC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.spec AS spec_3,
  t0.par AS par_4,
  t0.name AS name_5,
  t0.prior AS prior_6,
  t0.visible AS visible_7,
  t0.tstamp AS tstamp_8
FROM
  spravka t0
WHERE
  t0.type = ?
  AND t0.par = ?
ORDER BY
  t0.prior DESC

SELECT t0.id AS id_1, t0.type AS type_2, t0.spec AS spec_3, t0.par AS par_4, t0.name AS name_5, t0.prior AS prior_6, t0.visible AS visible_7, t0.tstamp AS tstamp_8 FROM spravka t0 WHERE t0.type = 'girl' AND t0.par = 30 ORDER BY t0.prior DESC;

select
  pc.char_id as cid,
  cv.id as cvid,
  pc.charval as val,
  pc.value as text,
  c.name as name,
  c.spec,
  c.type,
  c.par,
  c.search,
  c.compare,
  cv.value
from
  girlchar as pc
  left join `char` as c on c.id = pc.`char_id`
  left join charval as cv on pc.charval = cv.id
where
  pc.girl = '41'
  and c.charcat = 'bio'
  and c.visible = 1
order by
  c.prior desc,
  c.id asc

select pc.char_id as cid, cv.id as cvid, pc.charval as val, pc.value as text, c.name as name, c.spec, c.type, c.par, c.search, c.compare, cv.value
                from girlchar as pc 
                left join `char` as c on c.id = pc.`char_id`
                left join charval as cv on pc.charval = cv.id 
                where pc.girl = '41' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc;

select
  pc.char_id as cid,
  cv.id as cvid,
  pc.charval as val,
  pc.value as text,
  c.name as name,
  c.spec,
  c.type,
  c.par,
  c.search,
  c.compare,
  cv.value
from
  girlchar as pc
  left join `char` as c on c.id = pc.`char_id`
  left join charval as cv on pc.charval = cv.id
where
  pc.girl = '16'
  and c.charcat = 'bio'
  and c.visible = 1
order by
  c.prior desc,
  c.id asc

select pc.char_id as cid, cv.id as cvid, pc.charval as val, pc.value as text, c.name as name, c.spec, c.type, c.par, c.search, c.compare, cv.value
                from girlchar as pc 
                left join `char` as c on c.id = pc.`char_id`
                left join charval as cv on pc.charval = cv.id 
                where pc.girl = '16' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc;

select
  pc.char_id as cid,
  cv.id as cvid,
  pc.charval as val,
  pc.value as text,
  c.name as name,
  c.spec,
  c.type,
  c.par,
  c.search,
  c.compare,
  cv.value
from
  girlchar as pc
  left join `char` as c on c.id = pc.`char_id`
  left join charval as cv on pc.charval = cv.id
where
  pc.girl = '25'
  and c.charcat = 'bio'
  and c.visible = 1
order by
  c.prior desc,
  c.id asc

select pc.char_id as cid, cv.id as cvid, pc.charval as val, pc.value as text, c.name as name, c.spec, c.type, c.par, c.search, c.compare, cv.value
                from girlchar as pc 
                left join `char` as c on c.id = pc.`char_id`
                left join charval as cv on pc.charval = cv.id 
                where pc.girl = '25' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc;

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 '%en%' 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
  pc.char_id as cid,
  cv.id as cvid,
  pc.charval as val,
  pc.value as text,
  c.name as name,
  c.spec,
  c.type,
  c.par,
  c.search,
  c.compare,
  cv.value
from
  girlchar as pc
  left join `char` as c on c.id = pc.`char_id`
  left join charval as cv on pc.charval = cv.id
where
  pc.girl = '30'
  and c.charcat = 'bio'
  and c.visible = 1
order by
  c.prior desc,
  c.id asc

select pc.char_id as cid, cv.id as cvid, pc.charval as val, pc.value as text, c.name as name, c.spec, c.type, c.par, c.search, c.compare, cv.value
                from girlchar as pc 
                left join `char` as c on c.id = pc.`char_id`
                left join charval as cv on pc.charval = cv.id 
                where pc.girl = '30' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc;

select
  pc.char_id as cid,
  cv.id as cvid,
  pc.charval as val,
  pc.value as text,
  c.name as name,
  c.spec,
  c.type,
  c.par,
  c.search,
  c.compare,
  cv.value
from
  girlchar as pc
  left join `char` as c on c.id = pc.`char_id`
  left join charval as cv on pc.charval = cv.id
where
  pc.girl = '32'
  and c.charcat = 'bio'
  and c.visible = 1
order by
  c.prior desc,
  c.id asc

select pc.char_id as cid, cv.id as cvid, pc.charval as val, pc.value as text, c.name as name, c.spec, c.type, c.par, c.search, c.compare, cv.value
                from girlchar as pc 
                left join `char` as c on c.id = pc.`char_id`
                left join charval as cv on pc.charval = cv.id 
                where pc.girl = '32' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc;

select
  pc.char_id as cid,
  cv.id as cvid,
  pc.charval as val,
  pc.value as text,
  c.name as name,
  c.spec,
  c.type,
  c.par,
  c.search,
  c.compare,
  cv.value
from
  girlchar as pc
  left join `char` as c on c.id = pc.`char_id`
  left join charval as cv on pc.charval = cv.id
where
  pc.girl = '28'
  and c.charcat = 'bio'
  and c.visible = 1
order by
  c.prior desc,
  c.id asc

select pc.char_id as cid, cv.id as cvid, pc.charval as val, pc.value as text, c.name as name, c.spec, c.type, c.par, c.search, c.compare, cv.value
                from girlchar as pc 
                left join `char` as c on c.id = pc.`char_id`
                left join charval as cv on pc.charval = cv.id 
                where pc.girl = '28' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc;

select
  pc.char_id as cid,
  cv.id as cvid,
  pc.charval as val,
  pc.value as text,
  c.name as name,
  c.spec,
  c.type,
  c.par,
  c.search,
  c.compare,
  cv.value
from
  girlchar as pc
  left join `char` as c on c.id = pc.`char_id`
  left join charval as cv on pc.charval = cv.id
where
  pc.girl = '36'
  and c.charcat = 'bio'
  and c.visible = 1
order by
  c.prior desc,
  c.id asc

select pc.char_id as cid, cv.id as cvid, pc.charval as val, pc.value as text, c.name as name, c.spec, c.type, c.par, c.search, c.compare, cv.value
                from girlchar as pc 
                left join `char` as c on c.id = pc.`char_id`
                left join charval as cv on pc.charval = cv.id 
                where pc.girl = '36' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc;

select
  pc.char_id as cid,
  cv.id as cvid,
  pc.charval as val,
  pc.value as text,
  c.name as name,
  c.spec,
  c.type,
  c.par,
  c.search,
  c.compare,
  cv.value
from
  girlchar as pc
  left join `char` as c on c.id = pc.`char_id`
  left join charval as cv on pc.charval = cv.id
where
  pc.girl = '44'
  and c.charcat = 'bio'
  and c.visible = 1
order by
  c.prior desc,
  c.id asc

select pc.char_id as cid, cv.id as cvid, pc.charval as val, pc.value as text, c.name as name, c.spec, c.type, c.par, c.search, c.compare, cv.value
                from girlchar as pc 
                left join `char` as c on c.id = pc.`char_id`
                left join charval as cv on pc.charval = cv.id 
                where pc.girl = '44' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc;

SELECT
  t0.id AS id_1,
  t0.intname AS intname_2,
  t0.name AS name_3,
  t0.about AS about_4,
  t0.about_ge AS about_ge_5,
  t0.price AS price_6,
  t0.price1 AS price1_7,
  t0.price2 AS price2_8,
  t0.price3 AS price3_9,
  t0.price4 AS price4_10,
  t0.num AS num_11,
  t0.visible AS visible_12,
  t0.showon AS showon_13,
  t0.confirmed AS confirmed_14,
  t0.main AS main_15,
  t0.best AS best_16,
  t0.gotd AS gotd_17,
  t0.today AS today_18,
  t0.profy AS profy_19,
  t0.elite AS elite_20,
  t0.prior AS prior_21,
  t0.title AS title_22,
  t0.h1 AS h1_23,
  t0.kw AS kw_24,
  t0.descr AS descr_25,
  t0.spec AS spec_26,
  t0.tstamp AS tstamp_27,
  t0.views AS views_28
FROM
  boy t0
WHERE
  t0.visible = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.about AS about_4, t0.about_ge AS about_ge_5, t0.price AS price_6, t0.price1 AS price1_7, t0.price2 AS price2_8, t0.price3 AS price3_9, t0.price4 AS price4_10, t0.num AS num_11, t0.visible AS visible_12, t0.showon AS showon_13, t0.confirmed AS confirmed_14, t0.main AS main_15, t0.best AS best_16, t0.gotd AS gotd_17, t0.today AS today_18, t0.profy AS profy_19, t0.elite AS elite_20, t0.prior AS prior_21, t0.title AS title_22, t0.h1 AS h1_23, t0.kw AS kw_24, t0.descr AS descr_25, t0.spec AS spec_26, t0.tstamp AS tstamp_27, t0.views AS views_28 FROM boy t0 WHERE t0.visible = 1 ORDER BY t0.name ASC;

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);