Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.82 ms
(80.15%)
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
  318700
  383985
  391287
  400826
  405128
  407442
  411693
  413286
  419979
  420178
  426294
  426600
  428697
  430297
  431691
  443134
  443622
  446029
  446964
  447882
  452194
  453239
  453574
  454177
  454428
  454560
  455979
  458000
  459379
  459637
  460418
  461036
  462461
  462817
  464031
  464985
  467705
  468900
  469285
  470041
  470432
  471190
  473823
  475260
  476319
  476321
  489272
  491164
  491860
  492449
  494325
  495287
  496329
  506345
  507199
  515356
  517697
  518941
  520520
  521875
  525307
  526201
  526967
  527420
  527426
  529294
  531538
  531541
  532700
  536503
  539329
  543970
  555007
  556586
  560123
  562423
  562962
  567063
  573196
  574678
  575656
  575703
  577037
  580642
  581744
  582449
  582833
  584044
  584045
  590870
  592985
  595097
  599354
  601660
  603507
  605565
  610647
  615031
  621787
  663427
  664368
  665113
  667644
  696513
  707464
  727900
  733148
  733587
  734572
  761066
  771482
  781787
  781792
  781812
  781875
  782024
  784922
  792819
  799180
  812943
]
19.53 ms
(13.17%)
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
  577037
  603507
  601660
  781792
  781812
  784922
  799180
  781787
  781875
  727900
  733587
  761066
  782024
  454560
  443134
  529294
  491164
  792819
  734572
  405128
  407442
  575703
  733148
  615031
  464031
  446029
  573196
  574678
  621787
  318700
  491860
  536503
  515356
  556586
  582833
  431691
  464985
  471190
  476321
  525307
  555007
  567063
  663427
  562423
  599354
  470041
  459379
  496329
  539329
  543970
  664368
  584045
  610647
  605565
  812943
  452194
  475260
  411693
  454428
  462817
  467705
  469285
  453574
  461036
  492449
  494325
  521875
  526201
  531541
  518941
  527420
  531538
  526967
  462461
  470432
  575656
  562962
  665113
  582449
  420178
  454177
  458000
  468900
  430297
  506345
  489272
  507199
  426294
  459637
  447882
  453239
  473823
  495287
  707464
  383985
  413286
  400826
  592985
  391287
  446964
  428697
  426600
  443622
  419979
  455979
  476319
  520520
  527426
  517697
  532700
  460418
  581744
  584044
  667644
  696513
  560123
  580642
  590870
  595097
  771482
]
2.65 ms
(1.79%)
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
  318700
  383985
  391287
  400826
  405128
  407442
  411693
  413286
  419979
  420178
  426294
  426600
  428697
  430297
  431691
  443134
  443622
  446029
  446964
  447882
  452194
  453239
  453574
  454177
  454428
  454560
  455979
  458000
  459379
  459637
  460418
  461036
  462461
  462817
  464031
  464985
  467705
  468900
  469285
  470041
  470432
  471190
  473823
  475260
  476319
  476321
  489272
  491164
  491860
  492449
  494325
  495287
  496329
  506345
  507199
  515356
  517697
  518941
  520520
  521875
  525307
  526201
  526967
  527420
  527426
  529294
  531538
  531541
  532700
  536503
  539329
  543970
  555007
  556586
  560123
  562423
  562962
  567063
  573196
  574678
  575656
  575703
  577037
  580642
  581744
  582449
  582833
  584044
  584045
  590870
  592985
  595097
  599354
  601660
  603507
  605565
  610647
  615031
  621787
  663427
  664368
  665113
  667644
  696513
  707464
  727900
  733148
  733587
  734572
  761066
  771482
  781787
  781792
  781812
  781875
  782024
  784922
  792819
  799180
  812943
]
2.22 ms
(1.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbw milf tits"
]
1.60 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbw milf сиськ"
]
1.50 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbw milf сиськ"
]

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.