Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.32 ms
(87.14%)
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
  192223
  206386
  381788
  383582
  388960
  389317
  391510
  396808
  396971
  400892
  401465
  402539
  405488
  407064
  409984
  418912
  422144
  423299
  423511
  437310
  440764
  446940
  455381
  455453
  466492
  466813
  469342
  470046
  475293
  475681
  476968
  480931
  485973
  489921
  491853
  504535
  505344
  513721
  517686
  530565
  532386
  532393
  537558
  541023
  541125
  541903
  546085
  548321
  555521
  557513
  557840
  562464
  571755
  576998
  578431
  579608
  579622
  581680
  585475
  588411
  592075
  592510
  601096
  604929
  609959
  620507
  628633
  629522
  629600
  631575
  635845
  638178
  641162
  646412
  668544
  675956
  710002
  713036
  714654
  715459
  716877
  717471
  726795
  750374
  752826
  754057
  755411
  759140
  771968
  774741
  781950
  792623
  798743
  799751
  800276
  802288
  804551
  805610
  806320
  806984
  807876
  814293
  818488
  821139
  822590
  823716
  823777
  824269
  824952
  825887
  825888
  825965
  826393
  826612
  828090
  828416
  828439
  828460
  828486
]
13.41 ms
(6.82%)
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
  754057
  799751
  437310
  401465
  455381
  400892
  422144
  475293
  505344
  475681
  476968
  579608
  822590
  726795
  446940
  802288
  192223
  824269
  825965
  826612
  823716
  825888
  828416
  828298
  828486
  530565
  646412
  548321
  792623
  381788
  555521
  396808
  825887
  826393
  828439
  541023
  557513
  717471
  715459
  571755
  578431
  585475
  635845
  805610
  759140
  774741
  391510
  588411
  750374
  824952
  537558
  389317
  388960
  409984
  407064
  423511
  423299
  818488
  485973
  513721
  541125
  546085
  579622
  714654
  675956
  710002
  557840
  592510
  629522
  604929
  804551
  771968
  752826
  755411
  638178
  800276
  418912
  470046
  716877
  821139
  823777
  455453
  466813
  489921
  828090
  806320
  491853
  628633
  609959
  440764
  798743
  828460
  532386
  532393
  668544
  629600
  631575
  641162
  592075
  601096
  620507
  806984
  781950
  562464
  713036
  807876
  581680
  383582
  206386
  396971
  402539
  405488
  814293
  466492
  480931
  517686
  504535
  469342
  541903
  576998
]
4.24 ms
(2.16%)
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
  192223
  206386
  381788
  383582
  388960
  389317
  391510
  396808
  396971
  400892
  401465
  402539
  405488
  407064
  409984
  418912
  422144
  423299
  423511
  437310
  440764
  446940
  455381
  455453
  466492
  466813
  469342
  470046
  475293
  475681
  476968
  480931
  485973
  489921
  491853
  504535
  505344
  513721
  517686
  530565
  532386
  532393
  537558
  541023
  541125
  541903
  546085
  548321
  555521
  557513
  557840
  562464
  571755
  576998
  578431
  579608
  579622
  581680
  585475
  588411
  592075
  592510
  601096
  604929
  609959
  620507
  628633
  629522
  629600
  631575
  635845
  638178
  641162
  646412
  668544
  675956
  710002
  713036
  714654
  715459
  716877
  717471
  726795
  750374
  752826
  754057
  755411
  759140
  771968
  774741
  781950
  792623
  798743
  799751
  800276
  802288
  804551
  805610
  806320
  806984
  807876
  814293
  818488
  821139
  822590
  823716
  823777
  824269
  824952
  825887
  825888
  825965
  826393
  826612
  828090
  828416
  828439
  828460
  828486
]
2.20 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big natural milf"
]
2.03 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие натуральная натуральные milf"
]
1.85 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие натуральная натуральные milf"
]

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.