Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.37 ms
(58.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "her минет оральн секс"
]
131.14 ms
(35.59%)
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
  12775
  21576
  381809
  390041
  400956
  401307
  403085
  426471
  428515
  452314
  463933
  466045
  481601
  486125
  496270
  504757
  507803
  514615
  521510
  522503
  528391
  532255
  533692
  540071
  554808
  555796
  556933
  562491
  569596
  617331
  633243
  638873
  643368
  644951
  649536
  649622
  650992
  654086
  659206
  661896
  668789
  668976
  671335
  675380
  676915
  676920
  678017
  679195
  691481
  693246
  693576
  694006
  694442
  700652
  703370
  705696
  705732
  707059
  715415
  721616
  728795
  730486
  730736
  734165
  738493
  740777
  742453
  745495
  748995
  750151
  756225
  756318
  758108
  759612
  760940
  761727
  764186
  766034
  768281
  772821
  778277
  779039
  779388
  779490
  786064
  788293
  789277
  794921
  795572
  795948
  798768
  802835
  802838
  803798
  804086
  805977
  808044
  810256
  813109
  815148
  815498
  815839
  816206
  817800
  818782
  819966
  820190
  820423
  820577
  820625
  820956
  821527
  821600
  823319
  823342
  825209
  825369
  825808
  826828
  826907
]
14.43 ms
(3.92%)
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
  795572
  786064
  426471
  820577
  815839
  820190
  554808
  638873
  705732
  779039
  21576
  668976
  703370
  721616
  659206
  556933
  643368
  813109
  738493
  802835
  768281
  750151
  778277
  810256
  826828
  679195
  789277
  504757
  428515
  693246
  694442
  805977
  486125
  676915
  756318
  821527
  507803
  617331
  772821
  819966
  522503
  676920
  779388
  748995
  496270
  818782
  668789
  705696
  691481
  794921
  756225
  734165
  758108
  728795
  745495
  452314
  528391
  700652
  788293
  650992
  649622
  693576
  766034
  678017
  715415
  730736
  759612
  761727
  466045
  820956
  820423
  400956
  532255
  403085
  540071
  562491
  815148
  675380
  381809
  649536
  569596
  514615
  633243
  760940
  12775
  820625
  644951
  815498
  481601
  654086
  661896
  707059
  764186
  798768
  521510
  808044
  463933
  817800
  816206
  671335
  742453
  821600
  825209
  825369
  825808
  826907
  823319
  823342
  533692
  802838
  803798
  740777
  555796
  401307
  694006
  779490
  795948
  804086
  730486
  390041
]
2.64 ms
(0.72%)
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
  12775
  21576
  381809
  390041
  400956
  401307
  403085
  426471
  428515
  452314
  463933
  466045
  481601
  486125
  496270
  504757
  507803
  514615
  521510
  522503
  528391
  532255
  533692
  540071
  554808
  555796
  556933
  562491
  569596
  617331
  633243
  638873
  643368
  644951
  649536
  649622
  650992
  654086
  659206
  661896
  668789
  668976
  671335
  675380
  676915
  676920
  678017
  679195
  691481
  693246
  693576
  694006
  694442
  700652
  703370
  705696
  705732
  707059
  715415
  721616
  728795
  730486
  730736
  734165
  738493
  740777
  742453
  745495
  748995
  750151
  756225
  756318
  758108
  759612
  760940
  761727
  764186
  766034
  768281
  772821
  778277
  779039
  779388
  779490
  786064
  788293
  789277
  794921
  795572
  795948
  798768
  802835
  802838
  803798
  804086
  805977
  808044
  810256
  813109
  815148
  815498
  815839
  816206
  817800
  818782
  819966
  820190
  820423
  820577
  820625
  820956
  821527
  821600
  823319
  823342
  825209
  825369
  825808
  826828
  826907
]
2.03 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "her blowjob"
]
1.93 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "her минет оральн секс"
]
1.89 ms
(0.51%)
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.