Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.34 ms
(87.50%)
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
  203645
  327786
  358259
  391956
  392599
  398971
  400721
  411327
  429954
  434384
  439662
  439686
  439723
  439758
  439790
  440598
  440891
  441511
  443425
  443690
  444134
  446647
  450550
  450684
  454164
  454249
  454274
  455228
  456694
  457464
  460293
  460444
  462133
  462307
  463858
  464154
  464530
  465350
  465378
  466018
  466112
  466164
  466195
  466250
  466275
  466752
  466875
  467935
  468016
  469367
  469715
  470190
  470202
  470295
  470695
  472270
  473785
  474205
  474418
  474635
  474679
  474695
  475901
  477376
  478365
  479143
  481400
  483260
  484014
  484384
  484669
  485273
  486583
  493155
  493337
  501508
  507674
  508603
  509043
  509161
  509193
  510880
  511830
  513338
  513480
  513663
  513665
  514457
  514904
  518865
  521758
  523032
  524370
  535446
  538001
  547932
  549639
  549739
  555089
  555126
  562989
  563123
  575815
  579547
  597150
  620259
  662412
  712567
  735902
  735908
  739925
  742742
  744400
  744416
  744432
  745336
  754278
  777564
  798799
  801025
]
14.21 ms
(7.26%)
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
  465378
  439686
  484384
  441511
  400721
  474679
  439723
  473785
  744432
  484014
  465350
  440891
  469367
  469715
  484669
  509193
  744416
  744400
  777564
  392599
  523032
  460444
  475901
  481400
  579547
  620259
  735908
  477376
  464530
  460293
  509161
  501508
  563123
  513663
  470295
  463858
  474695
  454274
  535446
  472270
  444134
  514904
  439758
  493337
  662412
  450550
  327786
  429954
  443425
  454164
  508603
  555126
  455228
  391956
  754278
  518865
  562989
  483260
  712567
  358259
  439790
  513338
  575815
  462307
  440598
  466250
  509043
  521758
  524370
  462133
  549639
  439662
  466275
  466875
  454249
  538001
  479143
  478365
  466195
  470190
  474635
  457464
  466018
  468016
  493155
  513665
  549739
  446647
  470695
  450684
  466164
  801025
  745336
  597150
  739925
  742742
  798799
  466752
  464154
  474205
  555089
  511830
  470202
  411327
  486583
  514457
  398971
  434384
  443690
  203645
  735902
  466112
  513480
  474418
  547932
  510880
  485273
  456694
  467935
  507674
]
3.17 ms
(1.62%)
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
  203645
  327786
  358259
  391956
  392599
  398971
  400721
  411327
  429954
  434384
  439662
  439686
  439723
  439758
  439790
  440598
  440891
  441511
  443425
  443690
  444134
  446647
  450550
  450684
  454164
  454249
  454274
  455228
  456694
  457464
  460293
  460444
  462133
  462307
  463858
  464154
  464530
  465350
  465378
  466018
  466112
  466164
  466195
  466250
  466275
  466752
  466875
  467935
  468016
  469367
  469715
  470190
  470202
  470295
  470695
  472270
  473785
  474205
  474418
  474635
  474679
  474695
  475901
  477376
  478365
  479143
  481400
  483260
  484014
  484384
  484669
  485273
  486583
  493155
  493337
  501508
  507674
  508603
  509043
  509161
  509193
  510880
  511830
  513338
  513480
  513663
  513665
  514457
  514904
  518865
  521758
  523032
  524370
  535446
  538001
  547932
  549639
  549739
  555089
  555126
  562989
  563123
  575815
  579547
  597150
  620259
  662412
  712567
  735902
  735908
  739925
  742742
  744400
  744416
  744432
  745336
  754278
  777564
  798799
  801025
]
2.15 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончают в зрелых русских"
]
1.75 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в зрелая женщин русск"
]
1.55 ms
(0.79%)
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.