Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
229.94 ms
(62.72%)
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
  563902
  589595
  589663
  599742
  591122
  599236
  599527
  605480
  603257
  603339
  187595
  409048
  460406
  496547
  505281
  573801
  536661
  560902
  581292
  590503
  619614
  478835
  488900
  561757
  494252
  549243
  479112
  486798
  486810
  472864
  526077
  537848
  534586
  499881
  512543
  518562
  555083
  555264
  555389
  555413
  573739
  547426
  555360
  580707
  654174
  555204
  555258
  558494
  561991
  570160
  580288
  591664
  621964
  605906
  610006
  620170
  615554
  629847
  633540
  470032
  390940
  507263
  490801
  687105
  648209
  511686
  526731
  549197
  492346
  667250
  484716
  421995
  513738
  522486
  576685
  370829
  430002
  468097
  475780
  490423
  504509
  547551
  559881
  648211
  572351
  382206
  427196
  656526
  475908
  412222
  452642
  464561
  518545
  558622
  569030
  561526
  585363
  454176
  487632
  406030
  428583
  506212
  554899
  589666
  591260
  604331
  448708
  467913
  454143
  466109
  503407
  511273
  516281
  525092
  466726
  523371
  528774
  505663
  520875
  500905
]
126.37 ms
(34.47%)
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
  187595
  370829
  382206
  390940
  406030
  409048
  412222
  421995
  427196
  428583
  430002
  448708
  452642
  454143
  454176
  460406
  464561
  466109
  466726
  467913
  468097
  470032
  472864
  475780
  475908
  478835
  479112
  484716
  486798
  486810
  487632
  488900
  490423
  490801
  492346
  494252
  496547
  499881
  500905
  503407
  504509
  505281
  505663
  506212
  507263
  511273
  511686
  512543
  513738
  516281
  518545
  518562
  520875
  522486
  523371
  525092
  526077
  526731
  528774
  534586
  536661
  537848
  547426
  547551
  549197
  549243
  554899
  555083
  555204
  555258
  555264
  555360
  555389
  555413
  558494
  558622
  559881
  560902
  561526
  561757
  561991
  563902
  569030
  570160
  572351
  573739
  573801
  576685
  580288
  580707
  581292
  585363
  589595
  589663
  589666
  590503
  591122
  591260
  591664
  599236
  599527
  599742
  603257
  603339
  604331
  605480
  605906
  610006
  615554
  619614
  620170
  621964
  629847
  633540
  648209
  648211
  654174
  656526
  667250
  687105
]
2.58 ms
(0.70%)
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
  187595
  370829
  382206
  390940
  406030
  409048
  412222
  421995
  427196
  428583
  430002
  448708
  452642
  454143
  454176
  460406
  464561
  466109
  466726
  467913
  468097
  470032
  472864
  475780
  475908
  478835
  479112
  484716
  486798
  486810
  487632
  488900
  490423
  490801
  492346
  494252
  496547
  499881
  500905
  503407
  504509
  505281
  505663
  506212
  507263
  511273
  511686
  512543
  513738
  516281
  518545
  518562
  520875
  522486
  523371
  525092
  526077
  526731
  528774
  534586
  536661
  537848
  547426
  547551
  549197
  549243
  554899
  555083
  555204
  555258
  555264
  555360
  555389
  555413
  558494
  558622
  559881
  560902
  561526
  561757
  561991
  563902
  569030
  570160
  572351
  573739
  573801
  576685
  580288
  580707
  581292
  585363
  589595
  589663
  589666
  590503
  591122
  591260
  591664
  599236
  599527
  599742
  603257
  603339
  604331
  605480
  605906
  610006
  615554
  619614
  620170
  621964
  629847
  633540
  648209
  648211
  654174
  656526
  667250
  687105
]
2.14 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ðÀÐÇðÁð╗ð░ÐÅ ÐÇð░ðÀð┤ð▓ð©ð¢Ðâð╗ð░ ð¢ð¥ð%ÔǪ"
]
2.05 ms
(0.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин раздвинул"
]
1.81 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.47%)
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.