Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.86 ms
(86.47%)
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
  278442
  403229
  417263
  419267
  421413
  422448
  427455
  428028
  429105
  433051
  433078
  433541
  433620
  434093
  434207
  434616
  436490
  437335
  447609
  447692
  449115
  450779
  451981
  452654
  457013
  457014
  459560
  461316
  465863
  466027
  470120
  478220
  480331
  499868
  505795
  513371
  521836
  523541
  524192
  530803
  533333
  535425
  535521
  536682
  540272
  541861
  549571
  557677
  559045
  560668
  565721
  569332
  569443
  574224
  576546
  577087
  578025
  595361
  597700
  597830
  601427
  601978
  602199
  605437
  613443
  615818
  617533
  624320
  625605
  628037
  632696
  637023
  637129
  650034
  656320
  671523
  682916
  688376
  695316
  696225
  696500
  702635
  704208
  704261
  706118
  707650
  708450
  709850
  712541
  717845
  717986
  721150
  722101
  723131
  723287
  732878
  733857
  735614
  736265
  758780
  760955
  765357
  767236
  770376
  780610
  781621
  788923
  791160
  792173
  794090
  800565
  803485
  806162
  806797
  811621
  812827
  814257
  814556
  821765
  826182
]
14.30 ms
(7.99%)
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
  419267
  421413
  422448
  434093
  480331
  478220
  576546
  505795
  434616
  814257
  821765
  826182
  452654
  499868
  540272
  569443
  565721
  557677
  656320
  671523
  708450
  707650
  709850
  722101
  717845
  717986
  637129
  625605
  597700
  780610
  792173
  794090
  800565
  788923
  791160
  811621
  812827
  736265
  758780
  760955
  767236
  806162
  733857
  735614
  765357
  770376
  613443
  632696
  702635
  704261
  721150
  781621
  803485
  806797
  433051
  433620
  447609
  278442
  403229
  434207
  457013
  459560
  461316
  417263
  450779
  637023
  732878
  615818
  574224
  569332
  427455
  429105
  437335
  470120
  533333
  521836
  523541
  535521
  465863
  577087
  560668
  602199
  617533
  597830
  601978
  624320
  601427
  433078
  428028
  513371
  524192
  449115
  433541
  436490
  814556
  447692
  457014
  451981
  466027
  535425
  530803
  536682
  578025
  541861
  559045
  696500
  723131
  650034
  682916
  688376
  704208
  712541
  695316
  696225
  706118
  723287
  549571
  628037
  595361
  605437
]
2.87 ms
(1.60%)
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
  278442
  403229
  417263
  419267
  421413
  422448
  427455
  428028
  429105
  433051
  433078
  433541
  433620
  434093
  434207
  434616
  436490
  437335
  447609
  447692
  449115
  450779
  451981
  452654
  457013
  457014
  459560
  461316
  465863
  466027
  470120
  478220
  480331
  499868
  505795
  513371
  521836
  523541
  524192
  530803
  533333
  535425
  535521
  536682
  540272
  541861
  549571
  557677
  559045
  560668
  565721
  569332
  569443
  574224
  576546
  577087
  578025
  595361
  597700
  597830
  601427
  601978
  602199
  605437
  613443
  615818
  617533
  624320
  625605
  628037
  632696
  637023
  637129
  650034
  656320
  671523
  682916
  688376
  695316
  696225
  696500
  702635
  704208
  704261
  706118
  707650
  708450
  709850
  712541
  717845
  717986
  721150
  722101
  723131
  723287
  732878
  733857
  735614
  736265
  758780
  760955
  765357
  767236
  770376
  780610
  781621
  788923
  791160
  792173
  794090
  800565
  803485
  806162
  806797
  811621
  812827
  814257
  814556
  821765
  826182
]
2.10 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tattoo teen cum"
]
1.84 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "татуированные teen cum"
]
1.83 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "татуированные teen cum"
]
1.30 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.