Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.19 ms
(81.05%)
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
  382450
  415507
  423561
  429358
  447511
  448367
  456686
  461120
  464595
  472559
  473937
  483226
  490862
  491684
  492158
  506112
  517676
  520421
  521896
  522056
  529259
  537976
  540286
  541890
  548246
  548680
  548848
  554952
  559016
  560767
  564409
  569991
  571619
  571635
  572988
  573015
  573090
  573100
  573119
  573545
  573568
  573638
  573646
  573655
  573664
  573690
  573699
  573715
  573780
  573816
  573831
  573882
  573891
  574523
  574561
  574571
  574818
  574854
  574896
  574914
  575214
  575452
  575475
  575478
  575483
  575520
  575754
  575812
  575815
  576028
  576054
  576076
  576351
  578088
  581928
  584554
  597512
  605397
  606425
  607342
  613635
  619870
  619878
  620670
  625013
  628326
  629268
  636813
  639934
  647933
  669408
  679385
  693278
  693385
  701501
  707289
  714948
  718798
  721187
  722199
  740157
  741219
  765297
  771837
  775137
  780868
  780932
  788264
  805049
  805595
  806043
  809574
  810681
  810905
  810908
  810970
  811009
  811154
  820743
]
22.06 ms
(13.53%)
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
  560767
  571619
  573090
  573119
  573568
  573638
  573646
  573655
  573664
  573690
  573699
  573715
  573882
  574523
  574561
  574818
  574854
  574914
  575214
  575452
  575475
  575520
  575812
  576028
  576054
  578088
  581928
  584554
  693278
  701501
  707289
  679385
  693385
  714948
  722199
  548680
  559016
  564409
  569991
  571635
  572988
  573015
  573100
  573545
  573780
  573816
  573831
  573891
  574571
  574896
  575478
  575483
  575754
  576076
  576351
  597512
  619878
  628326
  620670
  625013
  639934
  605397
  636813
  606425
  810681
  811009
  780868
  780932
  810970
  811154
  805595
  806043
  810905
  810908
  741219
  724357
  740157
  613635
  619870
  775137
  415507
  429358
  521896
  529259
  491684
  492158
  506112
  472559
  548848
  647933
  788264
  522056
  423561
  820743
  461120
  541890
  554952
  721187
  669408
  629268
  607342
  765297
  805049
  771837
  809574
  382450
  473937
  447511
  456686
  520421
  483226
  718798
  575815
  464595
  448367
  490862
  537976
  517676
  540286
  548246
]
2.28 ms
(1.40%)
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
  382450
  415507
  423561
  429358
  447511
  448367
  456686
  461120
  464595
  472559
  473937
  483226
  490862
  491684
  492158
  506112
  517676
  520421
  521896
  522056
  529259
  537976
  540286
  541890
  548246
  548680
  548848
  554952
  559016
  560767
  564409
  569991
  571619
  571635
  572988
  573015
  573090
  573100
  573119
  573545
  573568
  573638
  573646
  573655
  573664
  573690
  573699
  573715
  573780
  573816
  573831
  573882
  573891
  574523
  574561
  574571
  574818
  574854
  574896
  574914
  575214
  575452
  575475
  575478
  575483
  575520
  575754
  575812
  575815
  576028
  576054
  576076
  576351
  578088
  581928
  584554
  597512
  605397
  606425
  607342
  613635
  619870
  619878
  620670
  625013
  628326
  629268
  636813
  639934
  647933
  669408
  679385
  693278
  693385
  701501
  707289
  714948
  718798
  721187
  722199
  740157
  741219
  765297
  771837
  775137
  780868
  780932
  788264
  805049
  805595
  806043
  809574
  810681
  810905
  810908
  810970
  811009
  811154
  820743
]
1.94 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "porn beauty big"
]
1.78 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "porn beauty большие"
]
1.32 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "porn beauty большие"
]

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.