Query Metrics

7 Database Queries
7 Different statements
569.87 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
218.61 ms
(38.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс teens"
]
216.72 ms
(38.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс teens"
]
115.37 ms
(20.25%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  395793
  397686
  400263
  417283
  418294
  418297
  420403
  456741
  475503
  493532
  495928
  497212
  529508
  530253
  530266
  531694
  542662
  542687
  548281
  549304
  549423
  556957
  557464
  559277
  560801
  574005
  574468
  574638
  575963
  579069
  580014
  583876
  586767
  616646
  622926
  626826
  626846
  628302
  633881
  633932
  634194
  638051
  640540
  648490
  649723
  651425
  651659
  653273
  654852
  654979
  655388
  657834
  658229
  660877
  661922
  663798
  663996
  668022
  674485
  681741
  682167
  684379
  689246
  692075
  693437
  694645
  697699
  701280
  701388
  706260
  713862
  716671
  717227
  717263
  717957
  718424
  719215
  719803
  721604
  721651
  723430
  723447
  775199
  775478
  776351
  779498
  779719
  779807
  780003
  784380
  786516
  787577
  789607
  789615
  792194
  794074
  794551
  799581
  803701
  811596
  812455
  813618
  816189
  816955
  816987
  817077
  819763
  820632
  821276
  821724
  822259
  823392
  823980
  825223
  825224
  827234
  828777
]
12.34 ms
(2.17%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  420403
  456741
  395793
  418297
  400263
  418294
  475503
  417283
  495928
  493532
  529508
  397686
  821276
  813618
  816987
  820632
  821724
  827234
  816955
  817077
  819763
  825224
  816189
  822259
  823392
  823980
  825223
  828777
  497212
  530253
  531694
  530266
  574638
  575963
  580014
  583876
  542687
  548281
  559277
  574005
  542662
  549304
  549423
  557464
  653273
  654852
  655388
  663798
  663996
  684379
  692075
  693437
  701388
  716671
  719215
  721604
  721651
  651425
  654979
  658229
  674485
  706260
  713862
  717263
  717957
  718424
  723430
  648490
  649723
  651659
  657834
  660877
  661922
  668022
  681741
  682167
  689246
  694645
  697699
  701280
  717227
  719803
  723447
  556957
  560801
  574468
  579069
  617264
  633881
  634194
  586767
  622926
  616646
  626826
  626846
  628302
  638051
  640540
  633932
  775199
  775478
  779719
  779807
  780496
  784380
  786516
  787577
  789607
  789615
  792194
  794074
  794551
  799581
  803701
  811596
  812455
  776351
  777101
  779498
  780003
]
2.86 ms
(0.50%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  395793
  397686
  400263
  417283
  418294
  418297
  420403
  456741
  475503
  493532
  495928
  497212
  529508
  530253
  530266
  531694
  542662
  542687
  548281
  549304
  549423
  556957
  557464
  559277
  560801
  574005
  574468
  574638
  575963
  579069
  580014
  583876
  586767
  616646
  622926
  626826
  626846
  628302
  633881
  633932
  634194
  638051
  640540
  648490
  649723
  651425
  651659
  653273
  654852
  654979
  655388
  657834
  658229
  660877
  661922
  663798
  663996
  668022
  674485
  681741
  682167
  684379
  689246
  692075
  693437
  694645
  697699
  701280
  701388
  706260
  713862
  716671
  717227
  717263
  717957
  718424
  719215
  719803
  721604
  721651
  723430
  723447
  775199
  775478
  776351
  779498
  779719
  779807
  780003
  784380
  786516
  787577
  789607
  789615
  792194
  794074
  794551
  799581
  803701
  811596
  812455
  813618
  816189
  816955
  816987
  817077
  819763
  820632
  821276
  821724
  822259
  823392
  823980
  825223
  825224
  827234
  828777
]
2.00 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob teens"
]
1.96 ms
(0.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.

Entities Mapping

No loaded entities.