Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.14 ms
(85.20%)
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
  80777
  81637
  118472
  126104
  131615
  161528
  193342
  233547
  285846
  339474
  342206
  366267
  383211
  385296
  385321
  387113
  387905
  389823
  391049
  393590
  395132
  395392
  395860
  395955
  396023
  396542
  396907
  397366
  401842
  403243
  404483
  404598
  404773
  406041
  406299
  407124
  414973
  415105
  417064
  419113
  419483
  420768
  421070
  421357
  425033
  425046
  425131
  425835
  425945
  428269
  429978
  431765
  432823
  433139
  433343
  437815
  439203
  442691
  445608
  447481
  448552
  448801
  449953
  451796
  454191
  458394
  459544
  459807
  459907
  466490
  466572
  468671
  469070
  470676
  471586
  471629
  472544
  472750
  473184
  474147
  480772
  482605
  495905
  499889
  505012
  514715
  514717
  525946
  535358
  541336
  545080
  546861
  551184
  554511
  562838
  571445
  581112
  582480
  586468
  596192
  597813
  598038
  598786
  601161
  612442
  624853
  653523
  653876
  664954
  672469
  684283
  692887
  693269
  721717
  724177
  785376
  798768
  807492
  826621
]
18.44 ms
(9.69%)
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
  80777
  396023
  469070
  482605
  448801
  653523
  664954
  421357
  499889
  383211
  439203
  425835
  448552
  551184
  586468
  598786
  612442
  724177
  397366
  401842
  429978
  672469
  396907
  428269
  459544
  470676
  459907
  554511
  653876
  684283
  721717
  624853
  425046
  406041
  419483
  432823
  514715
  454191
  445608
  495905
  693269
  601161
  387905
  480772
  505012
  562838
  431765
  403243
  387113
  425033
  472544
  785376
  118472
  581112
  545080
  395392
  474147
  126104
  395955
  233547
  161528
  826621
  339474
  765461
  81637
  395860
  389823
  391049
  193342
  546861
  395132
  468671
  473184
  404598
  459807
  406299
  404773
  407124
  525946
  393590
  596192
  131615
  433139
  342206
  447481
  466490
  541336
  571445
  807492
  419113
  466572
  414973
  396542
  798768
  385296
  425945
  421070
  425131
  442691
  449953
  535358
  692887
  597813
  598038
  404483
  433343
  471586
  415105
  458394
  472750
  451796
  582480
  437815
  471629
  385321
  366267
  285846
  514717
  417064
  420768
]
2.64 ms
(1.39%)
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
  80777
  81637
  118472
  126104
  131615
  161528
  193342
  233547
  285846
  339474
  342206
  366267
  383211
  385296
  385321
  387113
  387905
  389823
  391049
  393590
  395132
  395392
  395860
  395955
  396023
  396542
  396907
  397366
  401842
  403243
  404483
  404598
  404773
  406041
  406299
  407124
  414973
  415105
  417064
  419113
  419483
  420768
  421070
  421357
  425033
  425046
  425131
  425835
  425945
  428269
  429978
  431765
  432823
  433139
  433343
  437815
  439203
  442691
  445608
  447481
  448552
  448801
  449953
  451796
  454191
  458394
  459544
  459807
  459907
  466490
  466572
  468671
  469070
  470676
  471586
  471629
  472544
  472750
  473184
  474147
  480772
  482605
  495905
  499889
  505012
  514715
  514717
  525946
  535358
  541336
  545080
  546861
  551184
  554511
  562838
  571445
  581112
  582480
  586468
  596192
  597813
  598038
  598786
  601161
  612442
  624853
  653523
  653876
  664954
  672469
  684283
  692887
  693269
  721717
  724177
  785376
  798768
  807492
  826621
]
1.87 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро беловолосая"
]
1.86 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome blonde"
]
1.84 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.80%)
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.