Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
268.78 ms
(90.82%)
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
  411702
  413035
  415753
  422498
  443151
  446208
  453236
  454470
  454966
  455950
  456037
  456061
  459098
  460349
  464298
  464631
  468033
  469500
  474142
  477414
  479487
  485720
  487796
  492930
  496255
  496549
  496686
  499533
  501703
  504656
  505515
  507267
  508868
  511624
  513581
  520286
  520296
  520528
  520761
  521704
  526578
  546116
  546870
  546882
  546887
  549652
  550450
  552811
  555485
  556554
  564367
  565288
  566743
  569401
  574432
  574712
  577086
  577111
  581487
  583577
  584025
  589242
  589680
  590499
  592064
  593068
  593422
  597214
  599429
  599503
  599638
  602181
  604857
  605568
  607632
  612276
  625142
  628037
  630142
  636449
  664186
  667928
  668542
  674604
  675705
  682270
  702364
  714925
  724467
  725152
  725451
  725458
  725514
  726486
  726689
  728009
  728497
  728499
  735871
  741784
  741799
  745938
  746101
  747036
  750791
  758278
  758823
  761028
  761293
  763242
  764869
  766248
  781904
  790736
  793845
  795757
  796072
  796118
  814111
  824174
]
16.59 ms
(5.61%)
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
  411702
  413035
  443151
  415753
  422498
  814111
  824174
  589242
  446208
  454966
  455950
  459098
  469500
  474142
  485720
  453236
  454470
  479487
  456037
  456061
  460349
  464631
  487796
  492930
  496549
  507267
  496255
  504656
  499533
  501703
  505515
  511624
  513581
  520286
  520528
  520761
  496686
  508868
  520296
  521704
  526578
  464298
  468033
  477414
  549652
  550450
  565288
  577086
  583577
  546116
  555485
  581487
  584025
  546870
  552811
  556554
  564367
  569401
  664186
  667928
  668542
  674604
  675705
  702364
  714925
  682270
  546882
  546887
  566743
  574432
  574712
  577111
  590499
  597214
  599429
  602181
  604857
  628037
  589680
  592064
  593068
  599503
  599638
  612276
  625142
  593422
  607632
  605568
  781904
  793845
  795757
  790736
  725451
  741784
  741799
  745938
  747036
  758823
  761293
  796072
  796118
  724467
  725152
  728497
  728499
  746101
  764869
  725514
  758278
  728009
  735871
  763242
  725458
  726486
  726689
  750791
  761028
  766248
  630142
  636449
]
2.81 ms
(0.95%)
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
  411702
  413035
  415753
  422498
  443151
  446208
  453236
  454470
  454966
  455950
  456037
  456061
  459098
  460349
  464298
  464631
  468033
  469500
  474142
  477414
  479487
  485720
  487796
  492930
  496255
  496549
  496686
  499533
  501703
  504656
  505515
  507267
  508868
  511624
  513581
  520286
  520296
  520528
  520761
  521704
  526578
  546116
  546870
  546882
  546887
  549652
  550450
  552811
  555485
  556554
  564367
  565288
  566743
  569401
  574432
  574712
  577086
  577111
  581487
  583577
  584025
  589242
  589680
  590499
  592064
  593068
  593422
  597214
  599429
  599503
  599638
  602181
  604857
  605568
  607632
  612276
  625142
  628037
  630142
  636449
  664186
  667928
  668542
  674604
  675705
  682270
  702364
  714925
  724467
  725152
  725451
  725458
  725514
  726486
  726689
  728009
  728497
  728499
  735871
  741784
  741799
  745938
  746101
  747036
  750791
  758278
  758823
  761028
  761293
  763242
  764869
  766248
  781904
  790736
  793845
  795757
  796072
  796118
  814111
  824174
]
2.08 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby cum"
]
2.06 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.01 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby cum"
]
1.60 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby 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.