GET https://new.escort.vc/pl/videos/lillit111

Query Metrics

71 Database Queries
9 Different statements
37.79 ms Query time
0 Invalid entities
1190 Managed entities

Queries

Group similar statements

# Time Info
1 1.07 ms
SELECT p0_.id AS id_0, p0_.old_id AS old_id_1, p0_.type AS type_2, p0_.page AS page_3, p0_.girl AS girl_4, p0_.intname AS intname_5, p0_.mainpage AS mainpage_6, p0_.name AS name_7, p0_.href AS href_8, p0_.short AS short_9, p0_.cont AS cont_10, p0_.cont2 AS cont2_11, p0_.prior AS prior_12, p0_.visible AS visible_13, p0_.autosub AS autosub_14, p0_.title AS title_15, p0_.h1 AS h1_16, p0_.h3 AS h3_17, p0_.kw AS kw_18, p0_.descr AS descr_19, p0_.tstamp AS tstamp_20, p0_.rating AS rating_21, p0_.noindex AS noindex_22, p0_.footmenu AS footmenu_23, p0_.video AS video_24, p0_.showon AS showon_25, p0_.topmenu AS topmenu_26, p0_.topmenu2 AS topmenu2_27, p0_.spec AS spec_28 FROM page p0_ WHERE (p0_.showon LIKE ? OR p0_.showon = '') AND p0_.type = ? AND p0_.visible = 1 AND p0_.page = 0 AND p0_.footmenu = 1 ORDER BY p0_.prior DESC
Parameters:
[
  "%pl%"
  "page"
]
2 0.43 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  47
]
3 0.48 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  222
]
4 0.33 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  223
]
5 0.35 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  224
]
6 0.33 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  152
]
7 0.42 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  207
]
8 0.41 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  42
]
9 0.28 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  139
]
10 0.31 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  147
]
11 0.30 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  45
]
12 0.37 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  210
]
13 0.43 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  140
]
14 0.52 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  216
]
15 0.49 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  217
]
16 0.18 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  116
]
17 0.29 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  141
]
18 0.28 ms
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 page_translation t0 WHERE t0.object_id = ?
Parameters:
[
  57
]
19 0.27 ms
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:
[]
20 0.35 ms
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 = ?
Parameters:
[
  8
]
21 0.41 ms
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 = ?
Parameters:
[
  7
]
22 0.31 ms
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 = ?
Parameters:
[
  6
]
23 0.25 ms
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 = ?
Parameters:
[
  5
]
24 0.25 ms
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 = ?
Parameters:
[
  4
]
25 0.33 ms
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 = ?
Parameters:
[
  3
]
26 0.33 ms
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 = ?
Parameters:
[
  2
]
27 0.60 ms
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 = ?
Parameters:
[
  1
]
28 1.31 ms
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 video t0 WHERE t0.intname = ? LIMIT 1
Parameters:
[
  "lillit111"
]
29 0.69 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  326
]
30 0.99 ms
SELECT t0.id AS id_1, t0.intname AS intname_2, t0.name AS name_3, t0.about AS about_4, t0.price AS price_5, t0.price30 AS price30_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.vip AS vip_21, t0.recommend AS recommend_22, t0.odessa AS odessa_23, t0.prior AS prior_24, t0.title AS title_25, t0.h1 AS h1_26, t0.h3 AS h3_27, t0.kw AS kw_28, t0.descr AS descr_29, t0.spec AS spec_30, t0.tstamp AS tstamp_31, t0.views AS views_32, t0.title_cary AS title_cary_33, t0.h1_cary AS h1_cary_34, t0.h3_cary AS h3_cary_35, t0.descr_cary AS descr_cary_36, t0.about_cary AS about_cary_37, t0.title_ge AS title_ge_38, t0.h1_ge AS h1_ge_39, t0.h3_ge AS h3_ge_40, t0.descr_ge AS descr_ge_41, t0.about_ge AS about_ge_42, t0.title_kt AS title_kt_43, t0.h1_kt AS h1_kt_44, t0.h3_kt AS h3_kt_45, t0.descr_kt AS descr_kt_46, t0.about_kt AS about_kt_47, t0.title_ke AS title_ke_48, t0.h1_ke AS h1_ke_49, t0.h3_ke AS h3_ke_50, t0.descr_ke AS descr_ke_51, t0.about_ke AS about_ke_52, t0.searchindex AS searchindex_53, t0.hidden_photos AS hidden_photos_54, t0.videochat AS videochat_55, t0.only_open_photos AS only_open_photos_56, t0.closed_face AS closed_face_57 FROM girl t0 WHERE t0.id = ?
Parameters:
[
  893
]
31 0.94 ms
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 girl_translation t0 WHERE t0.object_id = ?
Parameters:
[
  893
]
32 1.22 ms
SELECT v0_.id AS id_0, v0_.girl AS girl_1, v0_.intname AS intname_2, v0_.name AS name_3, v0_.video AS video_4, v0_.cont AS cont_5, v0_.prior AS prior_6, v0_.title AS title_7, v0_.h1 AS h1_8, v0_.kw AS kw_9, v0_.descr AS descr_10, v0_.visible AS visible_11, v0_.hidden AS hidden_12 FROM video v0_ WHERE v0_.girl IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY v0_.prior DESC, v0_.id DESC
Parameters:
[
  1063
  1055
  1111
  871
  1092
  807
  1102
  716
  1114
  965
  568
  1037
  1088
  1116
  1118
  1108
  629
  1086
  605
  746
  622
  1045
  755
  1078
  1014
  1119
  863
  993
  1002
  893
  1110
  571
  1113
  983
  864
  561
  968
  1103
  1109
  1100
  1065
  947
  1070
  1029
  693
  940
  1107
  1020
  1098
  766
  1117
  1077
  1115
  971
  1084
  1076
  1057
  1050
  1046
  1112
]
33 0.52 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  325
]
34 0.86 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  324
]
35 0.58 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  323
]
36 0.67 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  321
]
37 0.63 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  320
]
38 0.64 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  318
]
39 0.59 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  317
]
40 0.70 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  316
]
41 0.78 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  315
]
42 0.60 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  311
]
43 0.57 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  310
]
44 0.55 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  309
]
45 0.62 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  307
]
46 0.71 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  293
]
47 0.86 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  289
]
48 0.45 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  288
]
49 0.54 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  274
]
50 0.39 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  257
]
51 0.58 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  255
]
52 0.46 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  251
]
53 0.63 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  247
]
54 0.69 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  241
]
55 0.52 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  240
]
56 0.60 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  236
]
57 0.51 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  233
]
58 0.53 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  231
]
59 0.54 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  219
]
60 0.60 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  201
]
61 0.55 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  195
]
62 0.49 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  194
]
63 0.42 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  187
]
64 0.46 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  137
]
65 0.48 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  128
]
66 0.47 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  118
]
67 0.58 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  116
]
68 0.43 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  107
]
69 0.62 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  95
]
70 0.40 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  88
]
71 0.45 ms
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 video_translation t0 WHERE t0.object_id = ?
Parameters:
[
  79
]

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\Translation\VideoTranslation 747
App\Entity\Translation\PageTranslation 233
App\Entity\Translation\FilterpageTranslation 80
App\Entity\Translation\GirlTranslation 64
App\Entity\Video 40
App\Entity\Page 17
App\Entity\Filterpage 8
App\Entity\Girl 1