Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.34 ms
(82.31%)
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
  191179
  389608
  393775
  405175
  412097
  417485
  417647
  420028
  420714
  422824
  423298
  423551
  423684
  424254
  426359
  427455
  432719
  436591
  437839
  437914
  437997
  442611
  443269
  445243
  445366
  445733
  446293
  447008
  447487
  450657
  452227
  453298
  453800
  454737
  455130
  456120
  456345
  456940
  457071
  458427
  458471
  459364
  459615
  460368
  461377
  463409
  463458
  463518
  463630
  464058
  464905
  464977
  466860
  467065
  467590
  468959
  471635
  471754
  471759
  473526
  475404
  476598
  477695
  479638
  479937
  481792
  485537
  486876
  486879
  487516
  488474
  490440
  490665
  491796
  496553
  498657
  498825
  499612
  502778
  502870
  509259
  509620
  510219
  510881
  513031
  515497
  518165
  521556
  523668
  523845
  526319
  526380
  527549
  527555
  528838
  534676
  539991
  545667
  547767
  552355
  552460
  553247
  553673
  555090
  557038
  559564
  559617
  562869
  564378
  572245
  584421
  589442
  591385
  592446
  599102
  626064
  630500
  670107
  756209
  815648
]
19.95 ms
(11.62%)
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
  459364
  461377
  464905
  471759
  491796
  446293
  454737
  455130
  477695
  481792
  539991
  502870
  510219
  460368
  466860
  490665
  553247
  559564
  559617
  572245
  552460
  557038
  589442
  592446
  756209
  626064
  389608
  432719
  442611
  443269
  456940
  436591
  437997
  458471
  467065
  471754
  479937
  422824
  423551
  437914
  450657
  457071
  447487
  453800
  463458
  468959
  420028
  447008
  456345
  518165
  521556
  526319
  485537
  490440
  502778
  513031
  523845
  534676
  498657
  498825
  499612
  510881
  523668
  527555
  486879
  488474
  509259
  509620
  527549
  545667
  191179
  393775
  423298
  417647
  417485
  437839
  445366
  815648
  456120
  458427
  464977
  479638
  445733
  487516
  452227
  453298
  464058
  496553
  526380
  515497
  528838
  463518
  486876
  555090
  562869
  547767
  552355
  553673
  584421
  670107
  564378
  591385
  599102
  630500
  427455
  463630
  473526
  423684
  445243
  424254
  426359
  459615
  467590
  476598
  405175
  420714
  463409
  475404
  412097
  471635
]
3.16 ms
(1.84%)
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
  191179
  389608
  393775
  405175
  412097
  417485
  417647
  420028
  420714
  422824
  423298
  423551
  423684
  424254
  426359
  427455
  432719
  436591
  437839
  437914
  437997
  442611
  443269
  445243
  445366
  445733
  446293
  447008
  447487
  450657
  452227
  453298
  453800
  454737
  455130
  456120
  456345
  456940
  457071
  458427
  458471
  459364
  459615
  460368
  461377
  463409
  463458
  463518
  463630
  464058
  464905
  464977
  466860
  467065
  467590
  468959
  471635
  471754
  471759
  473526
  475404
  476598
  477695
  479638
  479937
  481792
  485537
  486876
  486879
  487516
  488474
  490440
  490665
  491796
  496553
  498657
  498825
  499612
  502778
  502870
  509259
  509620
  510219
  510881
  513031
  515497
  518165
  521556
  523668
  523845
  526319
  526380
  527549
  527555
  528838
  534676
  539991
  545667
  547767
  552355
  552460
  553247
  553673
  555090
  557038
  559564
  559617
  562869
  564378
  572245
  584421
  589442
  591385
  592446
  599102
  626064
  630500
  670107
  756209
  815648
]
2.11 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde cum"
]
1.82 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая cum"
]
1.74 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая cum"
]

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.