Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.36 ms
(87.68%)
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
  386263
  388772
  393693
  395667
  395920
  399062
  404122
  408532
  421544
  421637
  426266
  441559
  458138
  460449
  461711
  468711
  480037
  484424
  490536
  495364
  499457
  511357
  528421
  529025
  536271
  540685
  541755
  547702
  552682
  553722
  556013
  565159
  565344
  570135
  581061
  588898
  597229
  597241
  598874
  605677
  608818
  609875
  613765
  618362
  619476
  623165
  623651
  627759
  631709
  633241
  633286
  634541
  637018
  640739
  649511
  656644
  664760
  668646
  671077
  671810
  672052
  674220
  678799
  678802
  685068
  687844
  687896
  697491
  698248
  699961
  702162
  703586
  704025
  712366
  715773
  719235
  720880
  722583
  722594
  723159
  728362
  728369
  731874
  735772
  740088
  742216
  750334
  750550
  752722
  756849
  760968
  761790
  765235
  766969
  770303
  770582
  772449
  772729
  777888
  782959
  785553
  790632
  792183
  793075
  793663
  794917
  796699
  797863
  798996
  805660
  811943
  812993
  813906
  814019
  818044
  821189
  822216
  822934
  823721
]
12.39 ms
(6.69%)
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
  623165
  640739
  408532
  528421
  722583
  792183
  404122
  458138
  823721
  540685
  671810
  680196
  605677
  597229
  785553
  756849
  818044
  822934
  678802
  765235
  386263
  395667
  634541
  805660
  770303
  395920
  813906
  814019
  490536
  499457
  547702
  553722
  565159
  565344
  674220
  678799
  687896
  664760
  671077
  672052
  697491
  698248
  712366
  723159
  633241
  627759
  637018
  619476
  790632
  793075
  797863
  777888
  782959
  796699
  770582
  793663
  794917
  752722
  766969
  728369
  728362
  731874
  735772
  750334
  760968
  608818
  609875
  699961
  715773
  426266
  529025
  656644
  618362
  750550
  742216
  421544
  581061
  552682
  633286
  588898
  597241
  812993
  388772
  468711
  511357
  772449
  703586
  704025
  772729
  822216
  623651
  631709
  811943
  740088
  798996
  461711
  484424
  570135
  702162
  556013
  598874
  613765
  761790
  460449
  495364
  393693
  399062
  441559
  421637
  821189
  480037
  536271
  541755
  649511
  685068
  720880
  722594
  668646
  687844
  719235
]
3.57 ms
(1.93%)
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
  386263
  388772
  393693
  395667
  395920
  399062
  404122
  408532
  421544
  421637
  426266
  441559
  458138
  460449
  461711
  468711
  480037
  484424
  490536
  495364
  499457
  511357
  528421
  529025
  536271
  540685
  541755
  547702
  552682
  553722
  556013
  565159
  565344
  570135
  581061
  588898
  597229
  597241
  598874
  605677
  608818
  609875
  613765
  618362
  619476
  623165
  623651
  627759
  631709
  633241
  633286
  634541
  637018
  640739
  649511
  656644
  664760
  668646
  671077
  671810
  672052
  674220
  678799
  678802
  685068
  687844
  687896
  697491
  698248
  699961
  702162
  703586
  704025
  712366
  715773
  719235
  720880
  722583
  722594
  723159
  728362
  728369
  731874
  735772
  740088
  742216
  750334
  750550
  752722
  756849
  760968
  761790
  765235
  766969
  770303
  770582
  772449
  772729
  777888
  782959
  785553
  790632
  792183
  793075
  793663
  794917
  796699
  797863
  798996
  805660
  811943
  812993
  813906
  814019
  818044
  821189
  822216
  822934
  823721
]
2.16 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens first anal"
]
1.77 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens first анал"
]
1.39 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teens first анал"
]

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.