Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
340.23 ms
(58.48%)
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
  190874
  381878
  383430
  383943
  395720
  406303
  407362
  407816
  409118
  409166
  411790
  420218
  428103
  442994
  445047
  449717
  453650
  454267
  454658
  455913
  460588
  462702
  466039
  466123
  466243
  466316
  467035
  468019
  469595
  470920
  470949
  471538
  474650
  477867
  480367
  480372
  481912
  482367
  484377
  484448
  484711
  485749
  485940
  487368
  490919
  490933
  491991
  492099
  492625
  493426
  500375
  503569
  506815
  513477
  513517
  521206
  528053
  532665
  540952
  556847
  599999
  605025
  611551
  615167
  620145
  621712
  627744
  644285
  663507
  676162
  690098
  691254
  710365
  710407
  714193
  716116
  720598
  721715
  726582
  727560
  728194
  728233
  728930
  729214
  732799
  734466
  735418
  745422
  748158
  770105
  779175
  785426
  786254
  788818
  789658
  789844
  790895
  792822
  793877
  794736
  794795
  795483
  797264
  798881
  801210
  801387
  802724
  803093
  804004
  804455
  805276
  805694
  806104
  807401
  808679
  810392
  810757
  810770
  811119
  811486
]
213.06 ms
(36.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фейсситтинг mature"
]
19.51 ms
(3.35%)
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
  710407
  714193
  690098
  691254
  556847
  611551
  620145
  644285
  599999
  615167
  605025
  779175
  793877
  795483
  802724
  805276
  806104
  807401
  808679
  810757
  810770
  811119
  789658
  790895
  792822
  798881
  801210
  803093
  729214
  732799
  734466
  745422
  786254
  789844
  794736
  804455
  805694
  811486
  728233
  726582
  727560
  735418
  748158
  770105
  710365
  716116
  720598
  721715
  785426
  788818
  794795
  797264
  801387
  804004
  810392
  381878
  383430
  466039
  470920
  466123
  471538
  409166
  487368
  491991
  506815
  490919
  428103
  383943
  395720
  406303
  407816
  407362
  411790
  445047
  409118
  442994
  449717
  454658
  470949
  460588
  468019
  481912
  503569
  521206
  528053
  532665
  467035
  482367
  540952
  663507
  676162
  627744
  728930
  728194
  621712
  453650
  190874
  474650
  480372
  462702
  480367
  454267
  455913
  466243
  484448
  493426
  513477
  513517
  484711
  485749
  485940
  492099
  500375
  484377
  490933
  477867
  420218
  466316
  492625
  469595
]
2.65 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facesitting mature"
]
2.44 ms
(0.42%)
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
  190874
  381878
  383430
  383943
  395720
  406303
  407362
  407816
  409118
  409166
  411790
  420218
  428103
  442994
  445047
  449717
  453650
  454267
  454658
  455913
  460588
  462702
  466039
  466123
  466243
  466316
  467035
  468019
  469595
  470920
  470949
  471538
  474650
  477867
  480367
  480372
  481912
  482367
  484377
  484448
  484711
  485749
  485940
  487368
  490919
  490933
  491991
  492099
  492625
  493426
  500375
  503569
  506815
  513477
  513517
  521206
  528053
  532665
  540952
  556847
  599999
  605025
  611551
  615167
  620145
  621712
  627744
  644285
  663507
  676162
  690098
  691254
  710365
  710407
  714193
  716116
  720598
  721715
  726582
  727560
  728194
  728233
  728930
  729214
  732799
  734466
  735418
  745422
  748158
  770105
  779175
  785426
  786254
  788818
  789658
  789844
  790895
  792822
  793877
  794736
  794795
  795483
  797264
  798881
  801210
  801387
  802724
  803093
  804004
  804455
  805276
  805694
  806104
  807401
  808679
  810392
  810757
  810770
  811119
  811486
]
2.19 ms
(0.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фейсситтинг mature"
]

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.