Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.95 ms
(83.11%)
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
  398612
  406935
  417824
  419616
  454291
  454301
  460611
  469668
  474771
  482418
  482439
  483439
  483779
  484729
  486878
  492208
  492218
  498685
  499648
  507510
  512876
  513977
  525798
  526804
  534037
  535254
  536720
  541283
  543647
  545747
  553749
  570882
  578614
  582742
  583077
  584392
  585229
  591535
  592219
  594552
  600904
  605564
  605743
  606667
  606804
  607378
  607859
  615045
  615416
  618224
  620568
  622011
  625240
  627336
  628441
  629750
  631073
  635201
  635734
  636646
  636708
  636718
  636739
  637249
  643149
  643645
  645795
  651011
  651520
  656619
  661625
  663808
  664613
  668532
  692818
  695474
  696291
  696827
  699988
  703825
  704097
  705026
  705030
  705117
  705481
  705502
  705506
  705861
  710363
  715154
  715358
  717437
  739910
  741061
  744982
  746848
  748048
  753581
  754487
  755443
  762556
  762757
  763393
  765937
  768839
  771232
  773427
  782671
  783357
  783414
  783417
  792721
  792728
  795032
  801208
  803211
  804020
  809004
  809337
  809877
]
21.33 ms
(10.75%)
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
  570882
  635734
  615045
  592219
  600904
  741061
  792728
  699988
  705117
  804020
  499648
  715154
  606804
  620568
  631073
  637249
  643645
  783357
  755443
  512876
  541283
  661625
  705861
  636718
  636708
  783414
  783417
  513977
  585229
  525798
  535254
  484729
  668532
  717437
  704097
  705030
  663808
  705481
  705502
  606667
  615416
  635201
  594552
  607378
  762556
  762757
  753581
  765937
  636646
  809877
  398612
  583077
  656619
  645795
  629750
  636739
  803211
  763393
  739910
  618224
  792721
  454291
  483779
  492208
  454301
  492218
  406935
  486878
  628441
  460611
  703825
  710363
  692818
  605743
  625240
  748048
  622011
  534037
  578614
  543647
  651011
  664613
  696291
  696827
  705026
  705506
  651520
  695474
  643149
  607859
  801208
  809337
  746848
  768839
  771232
  715358
  795032
  498685
  545747
  809004
  526804
  536720
  584392
  627336
  754487
  744982
  417824
  482439
  553749
  582742
  591535
  605564
  782671
  773427
  419616
  483439
  482418
  474771
  469668
  507510
]
4.38 ms
(2.21%)
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
  398612
  406935
  417824
  419616
  454291
  454301
  460611
  469668
  474771
  482418
  482439
  483439
  483779
  484729
  486878
  492208
  492218
  498685
  499648
  507510
  512876
  513977
  525798
  526804
  534037
  535254
  536720
  541283
  543647
  545747
  553749
  570882
  578614
  582742
  583077
  584392
  585229
  591535
  592219
  594552
  600904
  605564
  605743
  606667
  606804
  607378
  607859
  615045
  615416
  618224
  620568
  622011
  625240
  627336
  628441
  629750
  631073
  635201
  635734
  636646
  636708
  636718
  636739
  637249
  643149
  643645
  645795
  651011
  651520
  656619
  661625
  663808
  664613
  668532
  692818
  695474
  696291
  696827
  699988
  703825
  704097
  705026
  705030
  705117
  705481
  705502
  705506
  705861
  710363
  715154
  715358
  717437
  739910
  741061
  744982
  746848
  748048
  753581
  754487
  755443
  762556
  762757
  763393
  765937
  768839
  771232
  773427
  782671
  783357
  783414
  783417
  792721
  792728
  795032
  801208
  803211
  804020
  809004
  809337
  809877
]
2.15 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.08 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pregnant girls"
]
1.96 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беремен девушк"
]
1.63 ms
(0.82%)
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.