Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.65 ms
(81.61%)
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
  325253
  337263
  340242
  385079
  387301
  387576
  389631
  391359
  396374
  396685
  396716
  396777
  398504
  400417
  401134
  401343
  405042
  413259
  418336
  419808
  421066
  422401
  426325
  426689
  429008
  429147
  429162
  429473
  434486
  442922
  444258
  445833
  447533
  452987
  453785
  458213
  460988
  463118
  468085
  469867
  469874
  474067
  475092
  481760
  485304
  485505
  492829
  493556
  495148
  495399
  496244
  500967
  501603
  504170
  510418
  511401
  512973
  548908
  552921
  557108
  565954
  567761
  574067
  575100
  575145
  577724
  578147
  587532
  596161
  597833
  598421
  598514
  603394
  611299
  614262
  624144
  632028
  633154
  636791
  641682
  641737
  642113
  649121
  649139
  652872
  653456
  653523
  654556
  655114
  655346
  656045
  660439
  664994
  669606
  670989
  671340
  671633
  676982
  684914
  689128
  691286
  693281
  707071
  710832
  716675
  724773
  738779
  742434
  753486
  756073
  761488
  765244
  766866
  783657
  784265
  784277
  785981
  797869
  807806
  810705
]
17.29 ms
(11.32%)
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
  396374
  396685
  421066
  691286
  655346
  656045
  671633
  636791
  624144
  810705
  785981
  724773
  756073
  761488
  641737
  693281
  445833
  653523
  463118
  468085
  641682
  596161
  603394
  753486
  742434
  387576
  485505
  337263
  716675
  614262
  598514
  707071
  429473
  442922
  676982
  389631
  797869
  807806
  419808
  429147
  577724
  426325
  325253
  396716
  413259
  671340
  649121
  653456
  664994
  669606
  670989
  654556
  642113
  784277
  765244
  784265
  447533
  565954
  766866
  783657
  501603
  400417
  469874
  655114
  578147
  587532
  426689
  474067
  418336
  422401
  429008
  434486
  469867
  500967
  548908
  611299
  493556
  511401
  481760
  512973
  398504
  552921
  495399
  649139
  458213
  495148
  510418
  567761
  460988
  496244
  652872
  633154
  738779
  405042
  396777
  453785
  660439
  475092
  444258
  492829
  485304
  429162
  340242
  575100
  575145
  391359
  597833
  684914
  710832
  387301
  632028
  401134
  504170
  452987
  385079
  401343
  574067
  689128
  557108
  598421
]
2.88 ms
(1.89%)
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
  325253
  337263
  340242
  385079
  387301
  387576
  389631
  391359
  396374
  396685
  396716
  396777
  398504
  400417
  401134
  401343
  405042
  413259
  418336
  419808
  421066
  422401
  426325
  426689
  429008
  429147
  429162
  429473
  434486
  442922
  444258
  445833
  447533
  452987
  453785
  458213
  460988
  463118
  468085
  469867
  469874
  474067
  475092
  481760
  485304
  485505
  492829
  493556
  495148
  495399
  496244
  500967
  501603
  504170
  510418
  511401
  512973
  548908
  552921
  557108
  565954
  567761
  574067
  575100
  575145
  577724
  578147
  587532
  596161
  597833
  598421
  598514
  603394
  611299
  614262
  624144
  632028
  633154
  636791
  641682
  641737
  642113
  649121
  649139
  652872
  653456
  653523
  654556
  655114
  655346
  656045
  660439
  664994
  669606
  670989
  671340
  671633
  676982
  684914
  689128
  691286
  693281
  707071
  710832
  716675
  724773
  738779
  742434
  753486
  756073
  761488
  765244
  766866
  783657
  784265
  784277
  785981
  797869
  807806
  810705
]
2.43 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодая отсос"
]
1.91 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодая девушк минет оральн секс"
]
1.86 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "молодая девушк минет оральн секс"
]
1.73 ms
(1.13%)
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.