Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.92 ms
(86.35%)
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
  401500
  401849
  401880
  419452
  422600
  427530
  469534
  501641
  503167
  509163
  523856
  527412
  532785
  538473
  541879
  548548
  548609
  550684
  551081
  551223
  551477
  552120
  552160
  552267
  556014
  557449
  558126
  558131
  558135
  558820
  558976
  559140
  559942
  560387
  561192
  561652
  562619
  562826
  562837
  565162
  565249
  567166
  568315
  568324
  568457
  569260
  569692
  570708
  572023
  573748
  574184
  575806
  576393
  576417
  583677
  583725
  586693
  586770
  586786
  587864
  588520
  590343
  591612
  593729
  595873
  597227
  597476
  597550
  598057
  598752
  599711
  599921
  599945
  600295
  600330
  601579
  601917
  601922
  602246
  604289
  605338
  605345
  605349
  605952
  609897
  618865
  620100
  620641
  623205
  624505
  625185
  627804
  627813
  628379
  628388
  628406
  632614
  632695
  632979
  633114
  633733
  634482
  634777
  637003
  637008
  643376
  644962
  646007
  649215
  649578
  659258
  666874
  674953
  677294
  688369
  696212
  716032
  749924
  759639
  783468
]
17.01 ms
(9.13%)
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
  597550
  503167
  422600
  559140
  568457
  574184
  575806
  548548
  551477
  552160
  558820
  562826
  649215
  558976
  562837
  586786
  599945
  597227
  599921
  600330
  600295
  749924
  759639
  523856
  527412
  605952
  509163
  401849
  561192
  659258
  590343
  634482
  637008
  597476
  599711
  568315
  572023
  551081
  583677
  556014
  562619
  565162
  595873
  633733
  623205
  628406
  632614
  632979
  593729
  633114
  501641
  538473
  588520
  604289
  601922
  469534
  605349
  602246
  568324
  570708
  551223
  591612
  598752
  634777
  576417
  620641
  587864
  620100
  601917
  637003
  625185
  783468
  609897
  644962
  532785
  541879
  552267
  558126
  558135
  560387
  548609
  550684
  557449
  565249
  552120
  559942
  569692
  576393
  666874
  716032
  624505
  598057
  601579
  605345
  632695
  627804
  628379
  628388
  643376
  605338
  627813
  419452
  401500
  401880
  427530
  567166
  569260
  573748
  558131
  561652
  646007
  674953
  677294
  696212
  649578
  688369
  583725
  586693
  586770
  618865
]
2.67 ms
(1.43%)
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
  401500
  401849
  401880
  419452
  422600
  427530
  469534
  501641
  503167
  509163
  523856
  527412
  532785
  538473
  541879
  548548
  548609
  550684
  551081
  551223
  551477
  552120
  552160
  552267
  556014
  557449
  558126
  558131
  558135
  558820
  558976
  559140
  559942
  560387
  561192
  561652
  562619
  562826
  562837
  565162
  565249
  567166
  568315
  568324
  568457
  569260
  569692
  570708
  572023
  573748
  574184
  575806
  576393
  576417
  583677
  583725
  586693
  586770
  586786
  587864
  588520
  590343
  591612
  593729
  595873
  597227
  597476
  597550
  598057
  598752
  599711
  599921
  599945
  600295
  600330
  601579
  601917
  601922
  602246
  604289
  605338
  605345
  605349
  605952
  609897
  618865
  620100
  620641
  623205
  624505
  625185
  627804
  627813
  628379
  628388
  628406
  632614
  632695
  632979
  633114
  633733
  634482
  634777
  637003
  637008
  643376
  644962
  646007
  649215
  649578
  659258
  666874
  674953
  677294
  688369
  696212
  716032
  749924
  759639
  783468
]
1.62 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful butt anal"
]
1.54 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая butt анал"
]
1.29 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая butt анал"
]

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.