Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
263.69 ms
(88.75%)
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
  407130
  414710
  418520
  419128
  419804
  425863
  426404
  427794
  427819
  429161
  430638
  435346
  437156
  437838
  437847
  438375
  440247
  442870
  445951
  447475
  447515
  447536
  447828
  448472
  449885
  453125
  453888
  454676
  455818
  455984
  456328
  456606
  457542
  458957
  459143
  459316
  460211
  461342
  464133
  466682
  467130
  468220
  468893
  469069
  469452
  470521
  472190
  472906
  475270
  481663
  486403
  489249
  489279
  491589
  492567
  492837
  493037
  493320
  495082
  498285
  498899
  499276
  499857
  503403
  503468
  503577
  503730
  505078
  505627
  505779
  507077
  510098
  510675
  511362
  512607
  513458
  513473
  513481
  513552
  514489
  515123
  515796
  516454
  516513
  516787
  519489
  520092
  523476
  524069
  525472
  526094
  526405
  527765
  528007
  528178
  532848
  532976
  534342
  535577
  552375
  556835
  558804
  563108
  564860
  565099
  565496
  566128
  569683
  572263
  591593
  591623
  591867
  600390
  600671
  607717
  612356
  618690
  632903
  663222
  686020
]
21.81 ms
(7.34%)
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
  618690
  632903
  457542
  459143
  475270
  429161
  448472
  467130
  418520
  437156
  442870
  425863
  447536
  458957
  461342
  469452
  430638
  449885
  460211
  464133
  469069
  507077
  510098
  513552
  514489
  516454
  516513
  528007
  493320
  511362
  519489
  489249
  495082
  520092
  523476
  526094
  492837
  503577
  505779
  512607
  513458
  524069
  525472
  503730
  498285
  591867
  419128
  591623
  558804
  552375
  572263
  591593
  513481
  455818
  456606
  472906
  492567
  470521
  481663
  515123
  527765
  532976
  498899
  515796
  526405
  534342
  472190
  565099
  563108
  564860
  565496
  566128
  569683
  686020
  607717
  600671
  427819
  445951
  447515
  427794
  435346
  456328
  510675
  499276
  503468
  513473
  491589
  499857
  528178
  535577
  407130
  419804
  453125
  459316
  532848
  468220
  447828
  426404
  505627
  503403
  505078
  516787
  414710
  454676
  663222
  600390
  612356
  438375
  440247
  556835
  437838
  437847
  447475
  486403
  455984
  466682
  468893
  493037
  453888
  489279
]
4.29 ms
(1.45%)
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
  407130
  414710
  418520
  419128
  419804
  425863
  426404
  427794
  427819
  429161
  430638
  435346
  437156
  437838
  437847
  438375
  440247
  442870
  445951
  447475
  447515
  447536
  447828
  448472
  449885
  453125
  453888
  454676
  455818
  455984
  456328
  456606
  457542
  458957
  459143
  459316
  460211
  461342
  464133
  466682
  467130
  468220
  468893
  469069
  469452
  470521
  472190
  472906
  475270
  481663
  486403
  489249
  489279
  491589
  492567
  492837
  493037
  493320
  495082
  498285
  498899
  499276
  499857
  503403
  503468
  503577
  503730
  505078
  505627
  505779
  507077
  510098
  510675
  511362
  512607
  513458
  513473
  513481
  513552
  514489
  515123
  515796
  516454
  516513
  516787
  519489
  520092
  523476
  524069
  525472
  526094
  526405
  527765
  528007
  528178
  532848
  532976
  534342
  535577
  552375
  556835
  558804
  563108
  564860
  565099
  565496
  566128
  569683
  572263
  591593
  591623
  591867
  600390
  600671
  607717
  612356
  618690
  632903
  663222
  686020
]
2.10 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.61%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп шорт"
]
1.79 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass shorts"
]
1.62 ms
(0.54%)
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.