Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
197.46 ms
(88.60%)
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
  361315
  388078
  388545
  389630
  390538
  391926
  400837
  402207
  402718
  402736
  406982
  415196
  418774
  424155
  424274
  427308
  428961
  429384
  432552
  432580
  435406
  440534
  440878
  441495
  444035
  444197
  446216
  447147
  447511
  447530
  447551
  447734
  448392
  448431
  450659
  452769
  452791
  454343
  454581
  454633
  456413
  457089
  457524
  459872
  462021
  463304
  463950
  463968
  464578
  466752
  467953
  470181
  470337
  471958
  472323
  472337
  472346
  475499
  476728
  477133
  478220
  483369
  483613
  484193
  485508
  485646
  486841
  487712
  488713
  489876
  491916
  491961
  493660
  494443
  496733
  496869
  496910
  500849
  502440
  503682
  503704
  505287
  505846
  509645
  510247
  511955
  513487
  516157
  516480
  517973
  518731
  525028
  528020
  528781
  558060
  559021
  565964
  566405
  572307
  572692
  573607
  580712
  591933
  597057
  597502
  597552
  598489
  598674
  605764
  661933
  692440
  694660
  713392
  715410
  718643
  758241
  762969
  764821
  799905
]
15.96 ms
(7.16%)
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
  475499
  391926
  427308
  428961
  440878
  447511
  459872
  462021
  463950
  470337
  472323
  402207
  406982
  418774
  424274
  432580
  452769
  452791
  466752
  470181
  390538
  400837
  402718
  402736
  440534
  447530
  454343
  454581
  456413
  463968
  471958
  472337
  435406
  447147
  447551
  450659
  472346
  478220
  500849
  503704
  518731
  486841
  487712
  494443
  502440
  503682
  517973
  528020
  483369
  488713
  489876
  491916
  491961
  496733
  496869
  516480
  525028
  483613
  505287
  505846
  509645
  510247
  513487
  516157
  528781
  692440
  715410
  661933
  694660
  713392
  597552
  598489
  791973
  799905
  762969
  764821
  758241
  718643
  361315
  389630
  444197
  448392
  448431
  457089
  415196
  424155
  432552
  454633
  511955
  484193
  496910
  605764
  388545
  444035
  441495
  429384
  446216
  457524
  447734
  477133
  485508
  485646
  476728
  463304
  464578
  467953
  493660
  559021
  565964
  566405
  572692
  573607
  558060
  572307
  580712
  597057
  598674
  591933
  597502
  388078
]
2.54 ms
(1.14%)
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
  361315
  388078
  388545
  389630
  390538
  391926
  400837
  402207
  402718
  402736
  406982
  415196
  418774
  424155
  424274
  427308
  428961
  429384
  432552
  432580
  435406
  440534
  440878
  441495
  444035
  444197
  446216
  447147
  447511
  447530
  447551
  447734
  448392
  448431
  450659
  452769
  452791
  454343
  454581
  454633
  456413
  457089
  457524
  459872
  462021
  463304
  463950
  463968
  464578
  466752
  467953
  470181
  470337
  471958
  472323
  472337
  472346
  475499
  476728
  477133
  478220
  483369
  483613
  484193
  485508
  485646
  486841
  487712
  488713
  489876
  491916
  491961
  493660
  494443
  496733
  496869
  496910
  500849
  502440
  503682
  503704
  505287
  505846
  509645
  510247
  511955
  513487
  516157
  516480
  517973
  518731
  525028
  528020
  528781
  558060
  559021
  565964
  566405
  572307
  572692
  573607
  580712
  591933
  597057
  597502
  597552
  598489
  598674
  605764
  661933
  692440
  694660
  713392
  715410
  718643
  758241
  762969
  764821
  799905
]
2.09 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð░ð¢ð░ð╗Ðîð¢Ðïð╣ ð┐ð¥ÐÇð¢ð¥ ÐÇð¥ÐüÐüð©ð%ÔǪ"
]
1.91 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал порн русск"
]
1.36 ms
(0.61%)
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.