Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.43 ms
(84.77%)
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
  16971
  187450
  190204
  233707
  340635
  381838
  386858
  388537
  389273
  398940
  400156
  400513
  400837
  405993
  411381
  420163
  422358
  424429
  424439
  432350
  443408
  449428
  450583
  454029
  454213
  468072
  470964
  471005
  471107
  471654
  474159
  479106
  479148
  483537
  492991
  498037
  504424
  513635
  515726
  516491
  517272
  517332
  517870
  520813
  528093
  538480
  554407
  580934
  586583
  588202
  590498
  593044
  593486
  593495
  595438
  605535
  607599
  609071
  609657
  612056
  613676
  615022
  615693
  620220
  625227
  629851
  641807
  642065
  651216
  701239
  707487
  710402
  724264
  725426
  725739
  726487
  726565
  726849
  728229
  733446
  740553
  741699
  741726
  741733
  741752
  741756
  741758
  741773
  742383
  744359
  745026
  747151
  748463
  749234
  757860
  758210
  758234
  758281
  758792
  758793
  763121
  770131
  770157
  770602
  771023
  780704
  781779
  781924
  790193
  794216
  799027
  799693
  800745
  800767
  802071
  803049
  804427
  811736
  812390
  827655
]
17.05 ms
(9.30%)
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
  593044
  593495
  641807
  586583
  609071
  615022
  590498
  593486
  613676
  629851
  588202
  620220
  625227
  642065
  781924
  790193
  804427
  780704
  781779
  811736
  724264
  741752
  741756
  748463
  799693
  741726
  744359
  758234
  758792
  726565
  728229
  733446
  741733
  741758
  741773
  747151
  749234
  758793
  771023
  741699
  742383
  745026
  758281
  763121
  726849
  758210
  770602
  607599
  612056
  615693
  799027
  340635
  389273
  424429
  386858
  443408
  479148
  381838
  388537
  398940
  424439
  432350
  454029
  471107
  471654
  233707
  400156
  400513
  400837
  405993
  411381
  420163
  470964
  479106
  517332
  517870
  513635
  498037
  516491
  517272
  520813
  827655
  471005
  474159
  504424
  580934
  701239
  710402
  595438
  605535
  803049
  812390
  800745
  725426
  740553
  770131
  757860
  725739
  770157
  609657
  187450
  190204
  726487
  422358
  454213
  16971
  449428
  468072
  515726
  528093
  450583
  483537
  538480
  707487
  651216
  800767
  794216
  802071
  492991
  554407
]
3.61 ms
(1.97%)
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
  16971
  187450
  190204
  233707
  340635
  381838
  386858
  388537
  389273
  398940
  400156
  400513
  400837
  405993
  411381
  420163
  422358
  424429
  424439
  432350
  443408
  449428
  450583
  454029
  454213
  468072
  470964
  471005
  471107
  471654
  474159
  479106
  479148
  483537
  492991
  498037
  504424
  513635
  515726
  516491
  517272
  517332
  517870
  520813
  528093
  538480
  554407
  580934
  586583
  588202
  590498
  593044
  593486
  593495
  595438
  605535
  607599
  609071
  609657
  612056
  613676
  615022
  615693
  620220
  625227
  629851
  641807
  642065
  651216
  701239
  707487
  710402
  724264
  725426
  725739
  726487
  726565
  726849
  728229
  733446
  740553
  741699
  741726
  741733
  741752
  741756
  741758
  741773
  742383
  744359
  745026
  747151
  748463
  749234
  757860
  758210
  758234
  758281
  758792
  758793
  763121
  770131
  770157
  770602
  771023
  780704
  781779
  781924
  790193
  794216
  799027
  799693
  800745
  800767
  802071
  803049
  804427
  811736
  812390
  827655
]
2.10 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation mature"
]
1.89 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац mature"
]
1.75 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.83%)
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.