Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.80 ms
(87.75%)
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
  86241
  382105
  384546
  391759
  393713
  398993
  401322
  404263
  405234
  412137
  413869
  415833
  417941
  417950
  418294
  418693
  418856
  422362
  422444
  423106
  437232
  437786
  437901
  439656
  444200
  445384
  446006
  446466
  449171
  452498
  455390
  455473
  456065
  456144
  456565
  458638
  459113
  462158
  466125
  467750
  470245
  471935
  475165
  477176
  478067
  478280
  478999
  480140
  485053
  491094
  495254
  495928
  496007
  496228
  497617
  497815
  503635
  512713
  518288
  523268
  523277
  525221
  526331
  526580
  529339
  533973
  542075
  543705
  548910
  552784
  552864
  559795
  560801
  565019
  571419
  574005
  576190
  588173
  590402
  595424
  597017
  598591
  612877
  620211
  626483
  628792
  630191
  652865
  655388
  655539
  660877
  661907
  671236
  673170
  679228
  716629
  721450
  729786
  736113
  753444
  754641
  758734
  761669
  764503
  780138
  781036
  783017
  783724
  783785
  789246
  791110
  791152
  793360
  806868
  809340
  816110
  816189
  816796
  819267
  819895
]
15.04 ms
(7.43%)
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
  480140
  478280
  437232
  523277
  497617
  523268
  533973
  404263
  721450
  791110
  458638
  417950
  630191
  673170
  598591
  626483
  809340
  793360
  620211
  455473
  401322
  422444
  496228
  526331
  655539
  716629
  590402
  529339
  391759
  548910
  628792
  459113
  495254
  816796
  816110
  816189
  574005
  655388
  660877
  560801
  783785
  754641
  736113
  753444
  384546
  806868
  478067
  405234
  652865
  819267
  86241
  462158
  418856
  437901
  552784
  446466
  456565
  437786
  475165
  526580
  444200
  471935
  470245
  485053
  512713
  415833
  679228
  588173
  783017
  418294
  495928
  412137
  819895
  543705
  398993
  542075
  576190
  661907
  671236
  552864
  783724
  780138
  781036
  791152
  789246
  729786
  758734
  764503
  418693
  525221
  559795
  597017
  466125
  446006
  518288
  503635
  595424
  612877
  761669
  571419
  439656
  417941
  497815
  491094
  496007
  565019
  422362
  452498
  456144
  382105
  449171
  456065
  477176
  423106
  445384
  478999
  393713
  413869
  467750
  455390
]
2.99 ms
(1.48%)
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
  86241
  382105
  384546
  391759
  393713
  398993
  401322
  404263
  405234
  412137
  413869
  415833
  417941
  417950
  418294
  418693
  418856
  422362
  422444
  423106
  437232
  437786
  437901
  439656
  444200
  445384
  446006
  446466
  449171
  452498
  455390
  455473
  456065
  456144
  456565
  458638
  459113
  462158
  466125
  467750
  470245
  471935
  475165
  477176
  478067
  478280
  478999
  480140
  485053
  491094
  495254
  495928
  496007
  496228
  497617
  497815
  503635
  512713
  518288
  523268
  523277
  525221
  526331
  526580
  529339
  533973
  542075
  543705
  548910
  552784
  552864
  559795
  560801
  565019
  571419
  574005
  576190
  588173
  590402
  595424
  597017
  598591
  612877
  620211
  626483
  628792
  630191
  652865
  655388
  655539
  660877
  661907
  671236
  673170
  679228
  716629
  721450
  729786
  736113
  753444
  754641
  758734
  761669
  764503
  780138
  781036
  783017
  783724
  783785
  789246
  791110
  791152
  793360
  806868
  809340
  816110
  816189
  816796
  819267
  819895
]
2.05 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deepthroat russian"
]
2.01 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "глубокийминет минет оральн секс русск"
]
1.43 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.29 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.