Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.99 ms
(83.29%)
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
  78637
  188176
  228393
  383235
  397218
  401230
  402101
  408249
  409709
  410889
  417512
  418038
  418436
  422167
  422866
  448517
  450307
  450985
  451791
  453181
  454911
  455174
  455498
  459518
  460178
  466918
  470952
  471972
  480033
  480630
  481389
  484545
  484720
  485537
  489826
  493394
  499794
  500197
  502048
  502524
  504498
  508782
  510658
  511436
  512045
  513725
  514406
  518477
  519554
  522657
  524092
  525966
  528276
  529451
  545172
  545811
  546375
  549158
  549589
  551511
  555917
  558284
  559151
  560626
  560946
  564617
  571317
  572024
  572776
  578116
  580309
  581495
  583549
  586460
  589595
  592253
  598207
  603730
  605727
  610044
  613248
  615853
  618815
  621845
  624266
  625259
  625631
  627660
  629965
  636328
  653333
  682267
  692806
  695333
  695488
  695691
  706411
  708424
  720161
  727055
  732964
  737082
  740084
  741104
  744850
  750785
  752407
  758227
  764132
  765451
  788086
  796627
  798889
  800384
  804230
  806886
  806914
  818488
  821671
  821870
]
13.84 ms
(9.69%)
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
  410889
  525966
  818488
  821671
  480033
  625259
  586460
  613248
  788086
  796627
  752407
  750785
  629965
  471972
  453181
  418436
  454911
  592253
  485537
  744850
  459518
  564617
  692806
  589595
  188176
  583549
  765451
  228393
  518477
  572776
  549158
  500197
  493394
  514406
  422866
  551511
  555917
  558284
  615853
  737082
  800384
  806914
  764132
  804230
  422167
  489826
  522657
  451791
  625631
  401230
  417512
  450985
  484720
  529451
  549589
  580309
  653333
  695333
  695691
  706411
  605727
  618815
  806886
  732964
  624266
  510658
  519554
  528276
  524092
  603730
  508782
  572024
  455174
  502048
  821870
  484545
  559151
  571317
  695488
  708424
  720161
  682267
  560626
  740084
  741104
  727055
  610044
  798889
  418038
  448517
  499794
  545172
  581495
  758227
  455498
  480630
  460178
  504498
  598207
  512045
  502524
  78637
  466918
  560946
  402101
  578116
  546375
  636328
  621845
  627660
  450307
  397218
  470952
  481389
  545811
  513725
  511436
  383235
  408249
  409709
]
2.83 ms
(1.98%)
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
  78637
  188176
  228393
  383235
  397218
  401230
  402101
  408249
  409709
  410889
  417512
  418038
  418436
  422167
  422866
  448517
  450307
  450985
  451791
  453181
  454911
  455174
  455498
  459518
  460178
  466918
  470952
  471972
  480033
  480630
  481389
  484545
  484720
  485537
  489826
  493394
  499794
  500197
  502048
  502524
  504498
  508782
  510658
  511436
  512045
  513725
  514406
  518477
  519554
  522657
  524092
  525966
  528276
  529451
  545172
  545811
  546375
  549158
  549589
  551511
  555917
  558284
  559151
  560626
  560946
  564617
  571317
  572024
  572776
  578116
  580309
  581495
  583549
  586460
  589595
  592253
  598207
  603730
  605727
  610044
  613248
  615853
  618815
  621845
  624266
  625259
  625631
  627660
  629965
  636328
  653333
  682267
  692806
  695333
  695488
  695691
  706411
  708424
  720161
  727055
  732964
  737082
  740084
  741104
  744850
  750785
  752407
  758227
  764132
  765451
  788086
  796627
  798889
  800384
  804230
  806886
  806914
  818488
  821671
  821870
]
1.98 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "good blowjob"
]
1.91 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "good минет оральн секс"
]
1.60 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "good минет оральн секс"
]

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.