Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.01 ms
(87.35%)
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
  371202
  400713
  405727
  409031
  420314
  420322
  423305
  423685
  424397
  431723
  432442
  432496
  438335
  441378
  444791
  446175
  451292
  452710
  455244
  456787
  466172
  470827
  476007
  499092
  508262
  508590
  509276
  511605
  518244
  519237
  519324
  521939
  523598
  530188
  530256
  531270
  532286
  534620
  544062
  545636
  546140
  546580
  555958
  556708
  559239
  563383
  576771
  579830
  581009
  581229
  583091
  583569
  584948
  586146
  587394
  592830
  593189
  594468
  600712
  600726
  610309
  617589
  627154
  628772
  629585
  632140
  636558
  651544
  652451
  656268
  659483
  668971
  670234
  677861
  693013
  709430
  710377
  710941
  721042
  724479
  727920
  727972
  728044
  729759
  730404
  733325
  734218
  736787
  740508
  744790
  745229
  746587
  747571
  758869
  759669
  762330
  764651
  765118
  768144
  768722
  769346
  773532
  777536
  778804
  778931
  779293
  779633
  781064
  781097
  781574
  786778
  788854
  789823
  793172
  800611
  803667
  808712
  812596
  816634
  819151
]
14.08 ms
(7.19%)
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
  724479
  727972
  759669
  765118
  740508
  745229
  746587
  747571
  727920
  769346
  629585
  710941
  788854
  420322
  446175
  423305
  438335
  519324
  508590
  546140
  579830
  546580
  371202
  511605
  519237
  455244
  452710
  521939
  499092
  523598
  531270
  532286
  530256
  444791
  456787
  544062
  556708
  677861
  583091
  432442
  518244
  405727
  431723
  420314
  555958
  584948
  651544
  659483
  709430
  587394
  803667
  736787
  762330
  793172
  508262
  400713
  583569
  632140
  779633
  800611
  808712
  812596
  777536
  778804
  781064
  730404
  773532
  786778
  764651
  768144
  768722
  627154
  778931
  779293
  781574
  530188
  409031
  509276
  545636
  559239
  586146
  432496
  476007
  424397
  423685
  451292
  466172
  534620
  470827
  441378
  819151
  816634
  581229
  563383
  576771
  581009
  668971
  652451
  656268
  670234
  693013
  710377
  721042
  594468
  600726
  636558
  600712
  610309
  617589
  628772
  592830
  593189
  781097
  729759
  744790
  758869
  789823
  728044
  733325
  734218
]
3.05 ms
(1.56%)
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
  371202
  400713
  405727
  409031
  420314
  420322
  423305
  423685
  424397
  431723
  432442
  432496
  438335
  441378
  444791
  446175
  451292
  452710
  455244
  456787
  466172
  470827
  476007
  499092
  508262
  508590
  509276
  511605
  518244
  519237
  519324
  521939
  523598
  530188
  530256
  531270
  532286
  534620
  544062
  545636
  546140
  546580
  555958
  556708
  559239
  563383
  576771
  579830
  581009
  581229
  583091
  583569
  584948
  586146
  587394
  592830
  593189
  594468
  600712
  600726
  610309
  617589
  627154
  628772
  629585
  632140
  636558
  651544
  652451
  656268
  659483
  668971
  670234
  677861
  693013
  709430
  710377
  710941
  721042
  724479
  727920
  727972
  728044
  729759
  730404
  733325
  734218
  736787
  740508
  744790
  745229
  746587
  747571
  758869
  759669
  762330
  764651
  765118
  768144
  768722
  769346
  773532
  777536
  778804
  778931
  779293
  779633
  781064
  781097
  781574
  786778
  788854
  789823
  793172
  800611
  803667
  808712
  812596
  816634
  819151
]
2.31 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "handjob cumshot"
]
1.82 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член cumshot"
]
1.80 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дрочк член cumshot"
]

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.