Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.10 ms
(83.58%)
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
  7523
  282858
  373741
  382051
  384304
  388177
  395841
  395929
  395975
  397535
  398261
  410264
  413685
  413695
  414201
  415235
  417725
  418035
  424564
  430796
  433216
  444338
  445711
  446158
  447327
  447405
  447494
  447517
  447650
  447690
  448366
  448520
  450690
  450951
  451605
  453355
  453793
  453952
  454066
  454628
  455585
  457492
  458299
  460769
  461556
  462804
  463939
  463948
  465908
  466098
  468069
  468085
  473931
  474994
  476090
  477734
  478908
  479759
  482079
  484434
  495824
  497439
  501831
  503468
  506299
  510545
  511818
  514995
  516004
  526259
  528606
  530012
  530795
  532798
  533660
  534040
  536264
  536674
  536889
  537669
  537987
  558031
  567769
  568169
  573777
  574571
  574889
  575060
  575204
  575750
  595497
  596995
  597502
  598478
  598674
  598679
  603052
  620554
  627740
  630018
  630266
  641950
  642781
  663232
  666528
  681189
  719937
  719979
  720397
  721445
  722538
  732262
  748547
  753259
  753388
  753902
  770295
  788248
  795859
  806332
]
15.96 ms
(9.95%)
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
  806332
  641950
  373741
  530012
  536889
  722538
  603052
  595497
  795859
  770295
  497439
  533660
  681189
  630266
  482079
  511818
  501831
  620554
  495824
  450690
  503468
  506299
  666528
  720397
  753902
  532798
  530795
  534040
  575060
  663232
  574571
  598674
  598679
  597502
  642781
  788248
  732262
  748547
  719937
  596995
  598478
  7523
  384304
  567769
  575750
  753259
  753388
  719979
  395975
  382051
  388177
  398261
  413695
  417725
  430796
  413685
  414201
  433216
  424564
  448520
  450951
  463948
  468069
  453355
  453793
  453952
  455585
  458299
  454628
  468085
  536264
  526259
  537987
  510545
  516004
  536674
  514995
  537669
  474994
  478908
  568169
  574889
  558031
  573777
  575204
  721445
  627740
  630018
  415235
  445711
  447690
  448366
  460769
  462804
  282858
  397535
  410264
  418035
  446158
  447650
  457492
  477734
  479759
  395841
  444338
  451605
  454066
  473931
  395929
  447327
  447494
  461556
  463939
  465908
  476090
  447405
  447517
  466098
  528606
  484434
]
2.72 ms
(1.69%)
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
  7523
  282858
  373741
  382051
  384304
  388177
  395841
  395929
  395975
  397535
  398261
  410264
  413685
  413695
  414201
  415235
  417725
  418035
  424564
  430796
  433216
  444338
  445711
  446158
  447327
  447405
  447494
  447517
  447650
  447690
  448366
  448520
  450690
  450951
  451605
  453355
  453793
  453952
  454066
  454628
  455585
  457492
  458299
  460769
  461556
  462804
  463939
  463948
  465908
  466098
  468069
  468085
  473931
  474994
  476090
  477734
  478908
  479759
  482079
  484434
  495824
  497439
  501831
  503468
  506299
  510545
  511818
  514995
  516004
  526259
  528606
  530012
  530795
  532798
  533660
  534040
  536264
  536674
  536889
  537669
  537987
  558031
  567769
  568169
  573777
  574571
  574889
  575060
  575204
  575750
  595497
  596995
  597502
  598478
  598674
  598679
  603052
  620554
  627740
  630018
  630266
  641950
  642781
  663232
  666528
  681189
  719937
  719979
  720397
  721445
  722538
  732262
  748547
  753259
  753388
  753902
  770295
  788248
  795859
  806332
]
2.19 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big dick teen"
]
1.93 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие член teen"
]
1.92 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большой большие член teen"
]

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.