Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.89 ms
(86.97%)
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
  390525
  410563
  411820
  411884
  414131
  419738
  425643
  445466
  445550
  447445
  447509
  447557
  452383
  454085
  454627
  457499
  463849
  468540
  468704
  469373
  472223
  477745
  480380
  480389
  480411
  487189
  487352
  487721
  487724
  491268
  495660
  497879
  500907
  501533
  501535
  503426
  505130
  512508
  513261
  513690
  516218
  518519
  519015
  525676
  528942
  529025
  530510
  531091
  531103
  531143
  547477
  551226
  555912
  556336
  563827
  580592
  580646
  581242
  583679
  591082
  592380
  595024
  597469
  598478
  600796
  604324
  604562
  609052
  610350
  612247
  613843
  621675
  624281
  625289
  626553
  633512
  640466
  640538
  645393
  647626
  647950
  649857
  653268
  665622
  666816
  672383
  674936
  705789
  710500
  714458
  716116
  717820
  717905
  717918
  717929
  718658
  718838
  718945
  720118
  720290
  720707
  724037
  724281
  724707
  725113
  734483
  736802
  736846
  741187
  744266
  745352
  748475
  752105
  758540
  758959
  759980
  760911
  761464
  761567
  786768
]
15.80 ms
(7.77%)
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
  505130
  487189
  454085
  613843
  640538
  425643
  647950
  666816
  411820
  480411
  717929
  621675
  759980
  741187
  477745
  653268
  640466
  734483
  736802
  411884
  495660
  390525
  580592
  625289
  786768
  725113
  758959
  744266
  529025
  480380
  487721
  487724
  720290
  720118
  598478
  724707
  745352
  714458
  468540
  457499
  480389
  518519
  556336
  600796
  592380
  595024
  604562
  410563
  463849
  525676
  414131
  551226
  468704
  547477
  720707
  674936
  718945
  583679
  612247
  609052
  752105
  748475
  705789
  718658
  501535
  497879
  513690
  487352
  516218
  472223
  649857
  710500
  645393
  717905
  717918
  718838
  610350
  724037
  761464
  761567
  724281
  760911
  736846
  716116
  717820
  519015
  530510
  591082
  665622
  452383
  500907
  513261
  501533
  555912
  633512
  597469
  419738
  445466
  445550
  447445
  454627
  447509
  491268
  503426
  580646
  512508
  469373
  531103
  528942
  531091
  531143
  563827
  647626
  581242
  447557
  758540
  626553
  672383
  624281
  604324
]
3.31 ms
(1.63%)
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
  390525
  410563
  411820
  411884
  414131
  419738
  425643
  445466
  445550
  447445
  447509
  447557
  452383
  454085
  454627
  457499
  463849
  468540
  468704
  469373
  472223
  477745
  480380
  480389
  480411
  487189
  487352
  487721
  487724
  491268
  495660
  497879
  500907
  501533
  501535
  503426
  505130
  512508
  513261
  513690
  516218
  518519
  519015
  525676
  528942
  529025
  530510
  531091
  531103
  531143
  547477
  551226
  555912
  556336
  563827
  580592
  580646
  581242
  583679
  591082
  592380
  595024
  597469
  598478
  600796
  604324
  604562
  609052
  610350
  612247
  613843
  621675
  624281
  625289
  626553
  633512
  640466
  640538
  645393
  647626
  647950
  649857
  653268
  665622
  666816
  672383
  674936
  705789
  710500
  714458
  716116
  717820
  717905
  717918
  717929
  718658
  718838
  718945
  720118
  720290
  720707
  724037
  724281
  724707
  725113
  734483
  736802
  736846
  741187
  744266
  745352
  748475
  752105
  758540
  758959
  759980
  760911
  761464
  761567
  786768
]
2.02 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal ass casting"
]
1.74 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал жоп кастинг"
]
1.71 ms
(0.84%)
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.