Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.58 ms
(78.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
  57971
  107216
  172322
  191690
  293121
  353299
  382278
  385229
  393331
  393571
  400534
  404470
  406685
  410029
  415547
  417775
  418704
  419715
  420551
  421025
  421048
  421105
  421567
  430297
  432707
  435505
  445373
  447466
  447550
  447601
  451706
  454825
  456249
  456395
  459128
  462824
  464727
  467374
  469020
  469405
  469576
  469681
  471809
  474563
  474760
  482319
  482549
  483223
  485957
  486034
  487621
  488536
  490831
  493482
  495877
  507667
  515850
  520704
  521201
  522610
  526594
  526775
  527031
  535434
  545519
  548833
  550354
  551762
  555984
  561344
  561688
  563413
  563416
  565067
  569665
  570742
  576352
  576681
  588642
  590796
  599670
  599707
  606102
  610607
  611984
  617674
  632576
  648634
  650028
  671832
  678726
  684117
  684197
  689622
  705258
  714119
  715836
  719067
  725616
  729818
  730616
  731379
  758143
  771163
  773522
  776523
  784304
  788963
  792530
  795514
  799172
  804773
  807687
  810665
  813874
  814554
  815524
  818172
  818428
  822094
]
22.90 ms
(14.26%)
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
  507667
  565067
  590796
  393331
  410029
  456395
  487621
  191690
  293121
  420551
  421567
  818428
  563416
  678726
  684197
  725616
  731379
  771163
  776523
  799172
  447550
  57971
  107216
  393571
  404470
  421105
  474760
  611984
  417775
  469576
  545519
  526775
  617674
  483223
  482549
  588642
  464727
  488536
  382278
  671832
  705258
  814554
  818172
  469405
  451706
  486034
  561344
  548833
  550354
  570742
  576681
  719067
  648634
  689622
  551762
  561688
  569665
  576352
  606102
  599670
  810665
  729818
  430297
  495877
  521201
  172322
  400534
  822094
  788963
  730616
  773522
  353299
  385229
  421025
  418704
  435505
  415547
  421048
  445373
  813874
  815524
  490831
  493482
  447466
  454825
  456249
  467374
  535434
  520704
  471809
  555984
  563413
  684117
  714119
  650028
  715836
  599707
  632576
  784304
  804773
  758143
  795514
  807687
  610607
  792530
  432707
  462824
  482319
  469020
  474563
  447601
  469681
  419715
  459128
  406685
  515850
  522610
  526594
  527031
  485957
]
3.86 ms
(2.40%)
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
  57971
  107216
  172322
  191690
  293121
  353299
  382278
  385229
  393331
  393571
  400534
  404470
  406685
  410029
  415547
  417775
  418704
  419715
  420551
  421025
  421048
  421105
  421567
  430297
  432707
  435505
  445373
  447466
  447550
  447601
  451706
  454825
  456249
  456395
  459128
  462824
  464727
  467374
  469020
  469405
  469576
  469681
  471809
  474563
  474760
  482319
  482549
  483223
  485957
  486034
  487621
  488536
  490831
  493482
  495877
  507667
  515850
  520704
  521201
  522610
  526594
  526775
  527031
  535434
  545519
  548833
  550354
  551762
  555984
  561344
  561688
  563413
  563416
  565067
  569665
  570742
  576352
  576681
  588642
  590796
  599670
  599707
  606102
  610607
  611984
  617674
  632576
  648634
  650028
  671832
  678726
  684117
  684197
  689622
  705258
  714119
  715836
  719067
  725616
  729818
  730616
  731379
  758143
  771163
  773522
  776523
  784304
  788963
  792530
  795514
  799172
  804773
  807687
  810665
  813874
  814554
  815524
  818172
  818428
  822094
]
2.30 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лижет зад мужчина"
]
2.15 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза жоп мужчин"
]
1.28 ms
(0.80%)
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.