Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.98 ms
(57.23%)
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
  102334
  154844
  182735
  383217
  387738
  388756
  391527
  392843
  393145
  398121
  401628
  401684
  403463
  413808
  416007
  416620
  418730
  421395
  421435
  423360
  423475
  424179
  424187
  428516
  432270
  435510
  435521
  437717
  438459
  438579
  439417
  445099
  447703
  448110
  450682
  452348
  453822
  455165
  456555
  457816
  459649
  461058
  461381
  462626
  464642
  466031
  466388
  467636
  468151
  468255
  468256
  468495
  469176
  471013
  471155
  471312
  471428
  472971
  475359
  475696
  476471
  477425
  484337
  490511
  495443
  495602
  498305
  499084
  499914
  502776
  507291
  508543
  510001
  513589
  518505
  523380
  523823
  529639
  545780
  559207
  560286
  560953
  566083
  567057
  568814
  569393
  579426
  586583
  589383
  593080
  599502
  602204
  616712
  618494
  628750
  640046
  647558
  660282
  675084
  713947
  736037
  739923
  742312
  742636
  750756
  756487
  758541
  758780
  764241
  782515
  782908
  786916
  796295
  803621
  811736
  812289
  812359
  813404
  824483
  828630
]
131.30 ms
(35.62%)
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
  102334
  154844
  182735
  383217
  387738
  388756
  391527
  392843
  393145
  398121
  401628
  401684
  403463
  413808
  416007
  416620
  418730
  421395
  421435
  423360
  423475
  424179
  424187
  428516
  432270
  435510
  435521
  437717
  438459
  438579
  439417
  445099
  447703
  448110
  450682
  452348
  453822
  455165
  456555
  457816
  459649
  461058
  461381
  462626
  464642
  466031
  466388
  467636
  468151
  468255
  468256
  468495
  469176
  471013
  471155
  471312
  471428
  472971
  475359
  475696
  476471
  477425
  484337
  490511
  495443
  495602
  498305
  499084
  499914
  502776
  507291
  508543
  510001
  513589
  518505
  523380
  523823
  529639
  545780
  559207
  560286
  560953
  566083
  567057
  568814
  569393
  579426
  586583
  589383
  593080
  599502
  602204
  616712
  618494
  628750
  640046
  647558
  660282
  675084
  713947
  736037
  739923
  742312
  742636
  750756
  756487
  758541
  758780
  764241
  782515
  782908
  786916
  796295
  803621
  811736
  812289
  812359
  813404
  824483
  828630
]
19.33 ms
(5.24%)
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
  628750
  736037
  640046
  182735
  499084
  459649
  393145
  388756
  428516
  423475
  523380
  566083
  599502
  758780
  782515
  739923
  750756
  713947
  391527
  424179
  468495
  435521
  472971
  416007
  418730
  448110
  647558
  439417
  392843
  824483
  452348
  466031
  468151
  508543
  529639
  559207
  545780
  786916
  782908
  742312
  424187
  475359
  450682
  495602
  567057
  438459
  445099
  457816
  461058
  461381
  510001
  438579
  471155
  468256
  502776
  499914
  490511
  387738
  421395
  477425
  495443
  475696
  660282
  560953
  602204
  589383
  618494
  796295
  813404
  764241
  812359
  471013
  398121
  455165
  462626
  758541
  421435
  432270
  447703
  498305
  513589
  464642
  675084
  560286
  586583
  593080
  803621
  811736
  403463
  471312
  476471
  828630
  154844
  102334
  401684
  413808
  423360
  469176
  453822
  467636
  579426
  568814
  569393
  812289
  756487
  401628
  468255
  416620
  435510
  437717
  456555
  471428
  466388
  484337
  518505
  616712
  523823
  742636
  507291
  383217
]
2.06 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ð░ÐüÐéÐâÐÇð▒ð©ÐÇÐâðÁÐé ÐÇð░ð║ð¥ð╝ ð░ð%ÔǪ"
]
1.89 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац рак"
]
1.74 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.36%)
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.