Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
255.65 ms
(88.40%)
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
  2779
  6698
  122767
  233532
  353774
  382761
  383244
  385138
  386775
  387186
  387296
  388559
  401088
  401582
  410873
  429830
  431213
  435520
  436862
  443415
  449249
  453652
  455363
  460962
  461464
  465903
  469813
  470387
  475899
  484131
  485019
  485958
  489071
  490806
  491800
  492663
  495801
  502920
  510637
  510642
  511202
  511638
  512302
  512533
  514785
  515015
  516736
  519238
  520033
  521366
  521379
  526480
  527737
  528046
  528254
  532023
  535108
  535365
  537678
  538379
  538847
  538996
  546719
  546732
  548648
  549309
  549328
  549961
  552238
  552243
  552563
  555253
  556843
  556864
  557001
  558829
  560397
  562280
  562836
  564370
  566716
  570245
  570256
  570526
  571895
  572121
  572124
  572350
  572442
  572525
  572568
  572801
  572822
  573095
  573855
  574389
  575796
  578257
  581301
  612303
  617102
  627056
  628175
  631986
  657674
  659105
  670177
  677584
  679104
  679108
  687098
  701505
  730790
  733202
  765306
  772118
  803648
  810384
  811820
  813312
]
18.61 ms
(6.43%)
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
  677584
  546719
  556864
  612303
  810384
  813312
  803648
  730790
  733202
  772118
  627056
  385138
  387186
  401582
  429830
  431213
  455363
  475899
  519238
  538379
  492663
  512302
  512533
  532023
  562836
  581301
  578257
  628175
  528254
  386775
  382761
  353774
  6698
  410873
  453652
  485019
  449249
  537678
  510642
  535108
  511638
  535365
  538847
  460962
  549328
  552238
  572525
  572822
  570245
  570256
  572801
  574389
  562280
  572568
  573095
  659105
  687098
  657674
  670177
  679104
  679108
  701505
  548648
  552243
  557001
  558829
  560397
  571895
  572121
  573855
  617102
  631986
  765306
  811820
  383244
  469813
  2779
  233532
  461464
  122767
  388559
  435520
  470387
  485958
  527737
  510637
  520033
  526480
  495801
  514785
  521366
  521379
  387296
  401088
  443415
  436862
  484131
  490806
  491800
  489071
  528046
  502920
  538996
  511202
  515015
  516736
  465903
  546732
  549961
  556843
  564370
  566716
  570526
  572124
  572350
  572442
  575796
  549309
  552563
  555253
]
7.88 ms
(2.72%)
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
  2779
  6698
  122767
  233532
  353774
  382761
  383244
  385138
  386775
  387186
  387296
  388559
  401088
  401582
  410873
  429830
  431213
  435520
  436862
  443415
  449249
  453652
  455363
  460962
  461464
  465903
  469813
  470387
  475899
  484131
  485019
  485958
  489071
  490806
  491800
  492663
  495801
  502920
  510637
  510642
  511202
  511638
  512302
  512533
  514785
  515015
  516736
  519238
  520033
  521366
  521379
  526480
  527737
  528046
  528254
  532023
  535108
  535365
  537678
  538379
  538847
  538996
  546719
  546732
  548648
  549309
  549328
  549961
  552238
  552243
  552563
  555253
  556843
  556864
  557001
  558829
  560397
  562280
  562836
  564370
  566716
  570245
  570256
  570526
  571895
  572121
  572124
  572350
  572442
  572525
  572568
  572801
  572822
  573095
  573855
  574389
  575796
  578257
  581301
  612303
  617102
  627056
  628175
  631986
  657674
  659105
  670177
  677584
  679104
  679108
  687098
  701505
  730790
  733202
  765306
  772118
  803648
  810384
  811820
  813312
]
1.96 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "поцел"
]
1.77 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "взасос"
]
1.70 ms
(0.59%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.56%)
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.