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

Query Metrics

318 Database Queries
41 Different statements
80.76 ms Query time
0 Invalid entities
373 Managed entities

Grouped Statements

Show all queries

Time Count Info
14.45 ms
(17.90%)
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:
[]
11.10 ms
(13.75%)
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:
[]
6.57 ms
(8.13%)
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
]
5.64 ms
(6.98%)
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"
]
4.68 ms
(5.79%)
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
  1772315085
]
4.32 ms
(5.35%)
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
]
1.65 ms
(2.05%)
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:
[]
1.62 ms
(2.00%)
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 ? AND g0_.type = ? AND g0_.visible = 1 AND g0_.intname = ?
Parameters:
[
  "%en%"
  "page"
  "boys"
]
1.30 ms
(1.61%)
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
]
1.23 ms
(1.52%)
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:
[]
1.20 ms
(1.49%)
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:
[]
1.19 ms
(1.47%)
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:
[]
1.19 ms
(1.47%)
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.17 ms
(1.45%)
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.44%)
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:
[]
1.16 ms
(1.43%)
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:
[]
1.15 ms
(1.42%)
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:
[]
1.11 ms
(1.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 = '32' and c.charcat = 'paid' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
1.11 ms
(1.37%)
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:
[]
1.10 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 = '32' and c.charcat = 'service' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
1.08 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 = '44' and c.charcat = 'bio' and c.visible = 1 order by c.prior desc, c.id asc
Parameters:
[]
1.04 ms
(1.29%)
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:
[]
1.04 ms
(1.29%)
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:
[]
1.02 ms
(1.26%)
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.01 ms
(1.25%)
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.98 ms
(1.21%)
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.97 ms
(1.20%)
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.96 ms
(1.19%)
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.96 ms
(1.19%)
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.89 ms
(1.10%)
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.85 ms
(1.05%)
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.82 ms
(1.01%)
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:
[]
0.82 ms
(1.01%)
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.81 ms
(1.01%)
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.80 ms
(0.99%)
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.80 ms
(0.99%)
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.53 ms
(0.66%)
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.49 ms
(0.61%)
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.31 ms
(0.39%)
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.34%)
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.20 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 18
App\Entity\Boy 9
App\Entity\Filterpage 8