GET https://new.kievescort.club/boys-contacts

Query Metrics

161 Database Queries
40 Different statements
83.50 ms Query time
0 Invalid entities
372 Managed entities

Grouped Statements

Show all queries

Time Count Info
12.06 ms
(14.44%)
37
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:
[]
11.14 ms
(13.35%)
36
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.34 ms
(8.79%)
18
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
]
6.45 ms
(7.72%)
9
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"
]
4.65 ms
(5.57%)
1
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
]
4.53 ms
(5.42%)
9
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
]
4.04 ms
(4.84%)
9
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
  1772322240
]
1.96 ms
(2.35%)
2
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:
[]
1.55 ms
(1.86%)
1
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.40 ms
(1.67%)
1
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:
[]
1.39 ms
(1.67%)
1
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.33 ms
(1.59%)
1
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:
[]
1.26 ms
(1.50%)
2
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:
[]
1.22 ms
(1.46%)
2
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.21 ms
(1.45%)
2
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.18 ms
(1.42%)
2
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:
[]
1.18 ms
(1.41%)
2
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:
[]
1.17 ms
(1.40%)
2
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:
[]
1.08 ms
(1.29%)
1
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:
[]
1.06 ms
(1.27%)
2
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:
[]
1.06 ms
(1.27%)
1
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:
[]
1.06 ms
(1.26%)
1
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:
[]
1.05 ms
(1.26%)
1
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:
[]
1.05 ms
(1.25%)
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"
]
1.05 ms
(1.25%)
2
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:
[]
1.04 ms
(1.25%)
1
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:
[]
1.02 ms
(1.22%)
1
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.98 ms
(1.17%)
1
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.95 ms
(1.14%)
1
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.90 ms
(1.07%)
1
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.88 ms
(1.05%)
1
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.85 ms
(1.02%)
1
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.84 ms
(1.00%)
1
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:
[]
0.79 ms
(0.95%)
1
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.78 ms
(0.93%)
1
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.57 ms
(0.69%)
1
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.56 ms
(0.67%)
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.38 ms
(0.46%)
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.31 ms
(0.37%)
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.21 ms
(0.25%)
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