Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.47 ms
(52.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп stepmom"
]
168.05 ms
(42.19%)
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
  191069
  387453
  395731
  400484
  433249
  452464
  466710
  507805
  541793
  547568
  555032
  561520
  565648
  568343
  571132
  601468
  618019
  618181
  629612
  661918
  682612
  686158
  689369
  691376
  693087
  696745
  696990
  700611
  701243
  708259
  712620
  713416
  715511
  717171
  717911
  717920
  720008
  720514
  720906
  724123
  724632
  725159
  725179
  725538
  726735
  726989
  733015
  736861
  737980
  739951
  742529
  745164
  746071
  746639
  749009
  749363
  749760
  753497
  754990
  755517
  756354
  756859
  758342
  759094
  760974
  760982
  761025
  761234
  765502
  771483
  775736
  777996
  780109
  781496
  782928
  785107
  788214
  789181
  792523
  793814
  794215
  794324
  794338
  794639
  795043
  795303
  795364
  795815
  795869
  796062
  796066
  796656
  798801
  799751
  800816
  801175
  801253
  801521
  801545
  802048
  803725
  804224
  805713
  813684
  816605
  817536
  817972
  818510
  819917
  819929
  819936
  820736
  823694
  823705
  823848
  824744
  824772
  825825
  827483
  828788
]
12.22 ms
(3.07%)
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
  724123
  761025
  696990
  191069
  827483
  817972
  759094
  824772
  823848
  819929
  819936
  823694
  816605
  817536
  818510
  819917
  820736
  823705
  824744
  825825
  828788
  452464
  507805
  541793
  547568
  561520
  565648
  568343
  571132
  708259
  720514
  682612
  693087
  696745
  713416
  689369
  691376
  629612
  601468
  618181
  795043
  795815
  798801
  781496
  794215
  794639
  796066
  801521
  803725
  725159
  726735
  749363
  754990
  793814
  795869
  805713
  724632
  725179
  733015
  765502
  771483
  725538
  739951
  745164
  746639
  760974
  760982
  761234
  726989
  742529
  749760
  756354
  758342
  700611
  701243
  712620
  717171
  717911
  775736
  780109
  782928
  788214
  789181
  792523
  794324
  794338
  795364
  799751
  802048
  804224
  395731
  555032
  618019
  801175
  795303
  796656
  801253
  746071
  753497
  755517
  801545
  736861
  737980
  749009
  777996
  800816
  661918
  756859
  796062
  400484
  387453
  433249
  813684
  466710
  686158
  715511
  717920
  720008
  720906
  785107
]
2.42 ms
(0.61%)
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
  191069
  387453
  395731
  400484
  433249
  452464
  466710
  507805
  541793
  547568
  555032
  561520
  565648
  568343
  571132
  601468
  618019
  618181
  629612
  661918
  682612
  686158
  689369
  691376
  693087
  696745
  696990
  700611
  701243
  708259
  712620
  713416
  715511
  717171
  717911
  717920
  720008
  720514
  720906
  724123
  724632
  725159
  725179
  725538
  726735
  726989
  733015
  736861
  737980
  739951
  742529
  745164
  746071
  746639
  749009
  749363
  749760
  753497
  754990
  755517
  756354
  756859
  758342
  759094
  760974
  760982
  761025
  761234
  765502
  771483
  775736
  777996
  780109
  781496
  782928
  785107
  788214
  789181
  792523
  793814
  794215
  794324
  794338
  794639
  795043
  795303
  795364
  795815
  795869
  796062
  796066
  796656
  798801
  799751
  800816
  801175
  801253
  801521
  801545
  802048
  803725
  804224
  805713
  813684
  816605
  817536
  817972
  818510
  819917
  819929
  819936
  820736
  823694
  823705
  823848
  824744
  824772
  825825
  827483
  828788
]
1.92 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass stepmom"
]
1.72 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп stepmom"
]
1.54 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.