Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.61 ms
(85.46%)
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
  383748
  385334
  391574
  392601
  396287
  398227
  411765
  415873
  421215
  423042
  423199
  429820
  442836
  443831
  447308
  457182
  460756
  462508
  462597
  464538
  466706
  466885
  466976
  467062
  467100
  467484
  467507
  469380
  470532
  472624
  473154
  473837
  474034
  474114
  475704
  478829
  479031
  482188
  482992
  484203
  484373
  484401
  484402
  484546
  484696
  484776
  484856
  485934
  487340
  487928
  492779
  493387
  497583
  498697
  500190
  502702
  502857
  503535
  504271
  512459
  515732
  516485
  516653
  516976
  517496
  517557
  518577
  518833
  518859
  518867
  519148
  519270
  520864
  520903
  521977
  523607
  523784
  525490
  526329
  527253
  532352
  532893
  533613
  534733
  537848
  542648
  546371
  548057
  549227
  549249
  550236
  564813
  565119
  577357
  592512
  596807
  597123
  603236
  603691
  604383
  606771
  611365
  615517
  619397
  623982
  632626
  650326
  697229
  711297
  717929
  718928
  731777
  733587
  748251
  770896
  782427
  802781
  807976
  807991
  810061
]
17.85 ms
(8.89%)
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
  711297
  782427
  807991
  411765
  423199
  447308
  392601
  429820
  462508
  462597
  415873
  503535
  484776
  484402
  467507
  475704
  443831
  460756
  442836
  467100
  532352
  564813
  697229
  484856
  497583
  533613
  466885
  484696
  385334
  396287
  398227
  423042
  473154
  464538
  466706
  469380
  485934
  484203
  484546
  516976
  519270
  523607
  537848
  500190
  517557
  519148
  512459
  523784
  526329
  534733
  498697
  466976
  487340
  549227
  549249
  550236
  565119
  717929
  718928
  548057
  597123
  606771
  619397
  615517
  596807
  603691
  611365
  592512
  623982
  632626
  802781
  748251
  731777
  733587
  770896
  604383
  807976
  810061
  482188
  467062
  470532
  479031
  516485
  493387
  502857
  484373
  482992
  515732
  518859
  520864
  532893
  542648
  577357
  650326
  603236
  478829
  520903
  521977
  504271
  492779
  383748
  391574
  421215
  467484
  457182
  472624
  473837
  474114
  484401
  474034
  487928
  518833
  525490
  516653
  517496
  518577
  502702
  527253
  518867
  546371
]
3.96 ms
(1.97%)
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
  383748
  385334
  391574
  392601
  396287
  398227
  411765
  415873
  421215
  423042
  423199
  429820
  442836
  443831
  447308
  457182
  460756
  462508
  462597
  464538
  466706
  466885
  466976
  467062
  467100
  467484
  467507
  469380
  470532
  472624
  473154
  473837
  474034
  474114
  475704
  478829
  479031
  482188
  482992
  484203
  484373
  484401
  484402
  484546
  484696
  484776
  484856
  485934
  487340
  487928
  492779
  493387
  497583
  498697
  500190
  502702
  502857
  503535
  504271
  512459
  515732
  516485
  516653
  516976
  517496
  517557
  518577
  518833
  518859
  518867
  519148
  519270
  520864
  520903
  521977
  523607
  523784
  525490
  526329
  527253
  532352
  532893
  533613
  534733
  537848
  542648
  546371
  548057
  549227
  549249
  550236
  564813
  565119
  577357
  592512
  596807
  597123
  603236
  603691
  604383
  606771
  611365
  615517
  619397
  623982
  632626
  650326
  697229
  711297
  717929
  718928
  731777
  733587
  748251
  770896
  782427
  802781
  807976
  807991
  810061
]
2.03 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "short hair redhead"
]
1.94 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "short hair рыжая"
]
1.65 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "short hair рыжая"
]

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.