GET https://new.kievescort.club/boy/max2

Query Metrics

317 Database Queries
40 Different statements
86.62 ms Query time
0 Invalid entities
372 Managed entities

Grouped Statements

Show all queries

Time Count Info
26.06 ms
(30.09%)
74
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
Parameters:
[]
17.01 ms
(19.63%)
72
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
Parameters:
[]
7.37 ms
(8.51%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.hint_ge as hint, c.search, c.compare, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '44' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
7.15 ms
(8.26%)
36
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
Parameters:
[
  30
]
3.97 ms
(4.59%)
18
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 > ?
Parameters:
[
  30
  1772327223
]
3.33 ms
(3.85%)
18
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
Parameters:
[
  "girl"
  30
  1
  "en"
]
2.67 ms
(3.09%)
18
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
Parameters:
[
  "girl"
  30
]
2.26 ms
(2.61%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.hint_ge as hint, c.search, c.compare, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '32' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
1.18 ms
(1.36%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.search, c.compare, c.hint_ge as hint, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '16' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
1.18 ms
(1.36%)
4
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
Parameters:
[]
1.16 ms
(1.34%)
4
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
Parameters:
[]
1.00 ms
(1.15%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.search, c.compare, c.hint_ge as hint, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '44' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.98 ms
(1.13%)
1
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
Parameters:
[
  "%en%"
  "page"
]
0.79 ms
(0.91%)
4
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
Parameters:
[]
0.73 ms
(0.84%)
4
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
Parameters:
[]
0.69 ms
(0.79%)
4
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
Parameters:
[]
0.64 ms
(0.74%)
4
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
Parameters:
[]
0.63 ms
(0.73%)
4
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
Parameters:
[]
0.63 ms
(0.72%)
4
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
Parameters:
[]
0.62 ms
(0.71%)
4
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
Parameters:
[]
0.53 ms
(0.61%)
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 (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  8
  7
  6
  5
  4
  3
  2
  1
]
0.39 ms
(0.45%)
2
SELECT b0_.id AS id_0, b0_.intname AS intname_1, b0_.name AS name_2 FROM boy b0_ WHERE b0_.visible = 1 ORDER BY b0_.tstamp DESC LIMIT 6
Parameters:
[]
0.39 ms
(0.44%)
2
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
Parameters:
[
  1
]
0.38 ms
(0.44%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.hint_ge as hint, c.search, c.compare, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '16' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.38 ms
(0.44%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.search, c.compare, c.hint_ge as hint, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '30' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.38 ms
(0.44%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.hint_ge as hint, c.search, c.compare, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '41' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.34 ms
(0.39%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.hint_ge as hint, c.search, c.compare, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '28' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.33 ms
(0.38%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.search, c.compare, c.hint_ge as hint, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '28' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.33 ms
(0.38%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.search, c.compare, c.hint_ge as hint, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '41' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.32 ms
(0.37%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.hint_ge as hint, c.search, c.compare, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '38' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.32 ms
(0.37%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.search, c.compare, c.hint_ge as hint, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '38' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.32 ms
(0.36%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.hint_ge as hint, c.search, c.compare, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '36' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.31 ms
(0.35%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.hint_ge as hint, c.search, c.compare, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '30' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.31 ms
(0.35%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.search, c.compare, c.hint_ge as hint, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '25' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.31 ms
(0.35%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.search, c.compare, c.hint_ge as hint, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '36' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.29 ms
(0.33%)
1
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
Parameters:
[
  "%en%"
  "page"
]
0.28 ms
(0.32%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.search, c.compare, c.hint_ge as hint, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '32' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.28 ms
(0.32%)
2
select c.id as cid, c.par, c.name as name, c.type as type, c.izm, c.spec, c.hint_ge as hint, c.search, c.compare, cv.value as value, pc.charval as val, pc.value as text
				from girlchar as pc 
				left join `char` as c on c.id = pc.`char_id` 
				left join charval as cv on cv.id = pc.charval 
				where pc.girl = '25' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
0.26 ms
(0.29%)
1
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
Parameters:
[]
0.18 ms
(0.21%)
1
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
Parameters:
[
  "%en%"
  "page"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Charval 195
App\Entity\Translation\FilterpageTranslation 80
App\Entity\Char 63
App\Entity\Page 17
App\Entity\Boy 9
App\Entity\Filterpage 8