Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
197.89 ms
(89.60%)
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
  123955
  213144
  271280
  366044
  382084
  386514
  398146
  400882
  401570
  425715
  457784
  475202
  484130
  485480
  490024
  505128
  506623
  519171
  519190
  520246
  533502
  533984
  536892
  545610
  573706
  573874
  574538
  577396
  581902
  593389
  603355
  604149
  616668
  619130
  622613
  626343
  629461
  630191
  644900
  650299
  652179
  653306
  659512
  660545
  668425
  668621
  670491
  671145
  671146
  672670
  676618
  683576
  684301
  692848
  695596
  701056
  702168
  704616
  705300
  713172
  719472
  720031
  721455
  721568
  722000
  722118
  730326
  733420
  733731
  734161
  734681
  736372
  742926
  746328
  747133
  753278
  753909
  754210
  754256
  758603
  758676
  766181
  767341
  767553
  770820
  774077
  774274
  775995
  776685
  777460
  778226
  778908
  779526
  780940
  781076
  781605
  783412
  784163
  784444
  786245
  789309
  791277
  793768
  796896
  799885
  802420
  807954
  809902
  810617
  814093
  814234
  816385
  818250
  823873
  826551
  827879
  827946
  828083
]
13.05 ms
(5.91%)
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
  733731
  746328
  784163
  802420
  766181
  753909
  774274
  767341
  789309
  519171
  626343
  742926
  425715
  475202
  484130
  828083
  659512
  670491
  671146
  733420
  754210
  401570
  822697
  705300
  695596
  791277
  796896
  701056
  823873
  827879
  827946
  828391
  653306
  722000
  672670
  683576
  722118
  719472
  721568
  603355
  616668
  630191
  778908
  783412
  778226
  736372
  807954
  810617
  753278
  754256
  758676
  767553
  774077
  747133
  622613
  776685
  793768
  386514
  652179
  573874
  619130
  593389
  398146
  536892
  545610
  809902
  213144
  818250
  650299
  604149
  730326
  734681
  775995
  123955
  758603
  770820
  581902
  702168
  520246
  457784
  485480
  506623
  519190
  574538
  577396
  505128
  490024
  366044
  271280
  382084
  400882
  644900
  814093
  814234
  816385
  826551
  533502
  533984
  573706
  660545
  692848
  713172
  720031
  668621
  671145
  684301
  704616
  668425
  676618
  721455
  629461
  780940
  781076
  781605
  784444
  786245
  799885
  777460
  779526
  734161
]
2.79 ms
(1.26%)
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
  123955
  213144
  271280
  366044
  382084
  386514
  398146
  400882
  401570
  425715
  457784
  475202
  484130
  485480
  490024
  505128
  506623
  519171
  519190
  520246
  533502
  533984
  536892
  545610
  573706
  573874
  574538
  577396
  581902
  593389
  603355
  604149
  616668
  619130
  622613
  626343
  629461
  630191
  644900
  650299
  652179
  653306
  659512
  660545
  668425
  668621
  670491
  671145
  671146
  672670
  676618
  683576
  684301
  692848
  695596
  701056
  702168
  704616
  705300
  713172
  719472
  720031
  721455
  721568
  722000
  722118
  730326
  733420
  733731
  734161
  734681
  736372
  742926
  746328
  747133
  753278
  753909
  754210
  754256
  758603
  758676
  766181
  767341
  767553
  770820
  774077
  774274
  775995
  776685
  777460
  778226
  778908
  779526
  780940
  781076
  781605
  783412
  784163
  784444
  786245
  789309
  791277
  793768
  796896
  799885
  802420
  807954
  809902
  810617
  814093
  814234
  816385
  818250
  823873
  826551
  827879
  827946
  828083
]
2.08 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck teens"
]
1.86 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс teens"
]
1.81 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс teens"
]

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.