Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.95 ms
(80.51%)
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
  410957
  458352
  462620
  474063
  476881
  480327
  481558
  481808
  483970
  485228
  488445
  489945
  496510
  498988
  499154
  501970
  502272
  502365
  510003
  510500
  512434
  512686
  516150
  520507
  525299
  528267
  529623
  529926
  530622
  531618
  532177
  533050
  533653
  534495
  535186
  535629
  535858
  535922
  535996
  536176
  538179
  538371
  539345
  539396
  540058
  540169
  540401
  541157
  542776
  543533
  544875
  548155
  554457
  554882
  555762
  557936
  558484
  558965
  560556
  561431
  562210
  565291
  576142
  578325
  578357
  580034
  584915
  592802
  596176
  599176
  600098
  602372
  617655
  621615
  627581
  628817
  629170
  632867
  633838
  633932
  643683
  643855
  653162
  653322
  653754
  656252
  663824
  668585
  670255
  674290
  678209
  685233
  691614
  692032
  696099
  698352
  699902
  701026
  703702
  707734
  710599
  713363
  716502
  722356
  729607
  737813
  740707
  749995
  750409
  768169
  772292
  780646
  783804
  784321
  789732
  792498
  792516
  795797
  804968
  827109
]
19.53 ms
(12.48%)
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
  784321
  749995
  480327
  476881
  544875
  792498
  539345
  783804
  481808
  539396
  536176
  520507
  535858
  534495
  578357
  580034
  701026
  653754
  696099
  710599
  628817
  629170
  643855
  633838
  633932
  617655
  632867
  707734
  795797
  535996
  663824
  627581
  485228
  540058
  529926
  512686
  555762
  600098
  750409
  528267
  653322
  668585
  692032
  653162
  792516
  481558
  558484
  560556
  722356
  474063
  502272
  530622
  596176
  525299
  565291
  691614
  685233
  698352
  699902
  538179
  510003
  554457
  458352
  499154
  496510
  510500
  561431
  584915
  541157
  729607
  827109
  502365
  538371
  540169
  540401
  516150
  531618
  535922
  529623
  548155
  678209
  713363
  656252
  670255
  674290
  558965
  621615
  592802
  740707
  602372
  501970
  578325
  576142
  462620
  410957
  780646
  737813
  768169
  716502
  599176
  557936
  512434
  533653
  535629
  535186
  488445
  498988
  804968
  489945
  532177
  554882
  703702
  533050
  483970
  562210
  643683
  772292
  789732
  543533
  542776
]
2.93 ms
(1.87%)
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
  410957
  458352
  462620
  474063
  476881
  480327
  481558
  481808
  483970
  485228
  488445
  489945
  496510
  498988
  499154
  501970
  502272
  502365
  510003
  510500
  512434
  512686
  516150
  520507
  525299
  528267
  529623
  529926
  530622
  531618
  532177
  533050
  533653
  534495
  535186
  535629
  535858
  535922
  535996
  536176
  538179
  538371
  539345
  539396
  540058
  540169
  540401
  541157
  542776
  543533
  544875
  548155
  554457
  554882
  555762
  557936
  558484
  558965
  560556
  561431
  562210
  565291
  576142
  578325
  578357
  580034
  584915
  592802
  596176
  599176
  600098
  602372
  617655
  621615
  627581
  628817
  629170
  632867
  633838
  633932
  643683
  643855
  653162
  653322
  653754
  656252
  663824
  668585
  670255
  674290
  678209
  685233
  691614
  692032
  696099
  698352
  699902
  701026
  703702
  707734
  710599
  713363
  716502
  722356
  729607
  737813
  740707
  749995
  750409
  768169
  772292
  780646
  783804
  784321
  789732
  792498
  792516
  795797
  804968
  827109
]
2.67 ms
(1.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашне с членим девушка"
]
1.86 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск член девушк"
]
1.82 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.07%)
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.