Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.46 ms
(81.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
  13118
  188338
  391926
  394630
  394648
  396723
  401617
  407683
  410955
  413637
  417015
  429603
  429879
  430810
  432939
  441094
  441849
  445397
  451514
  452818
  452880
  459513
  460378
  461612
  464975
  466967
  467064
  468559
  468687
  470851
  471664
  471669
  473462
  477055
  478073
  478415
  479054
  485095
  491056
  495507
  498454
  500787
  502462
  508985
  510945
  511014
  513973
  517636
  523761
  530005
  532886
  534560
  534576
  537861
  538879
  541277
  541392
  544848
  555400
  561113
  564508
  564558
  568481
  568756
  576607
  579512
  580631
  584025
  586668
  587951
  589673
  592536
  605129
  605218
  606338
  610961
  628105
  628107
  634849
  641683
  651613
  657543
  661915
  664166
  666016
  675405
  678950
  680423
  696415
  713508
  714028
  724604
  733700
  737870
  744952
  757393
  761532
  765733
  769311
  777017
  784812
  786115
  794371
  800955
  801299
  801742
  811709
  813783
  815149
  815616
  815649
  815674
  815773
  815798
  817729
  817733
  818824
  819270
  821734
  827489
]
17.35 ms
(11.36%)
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
  555400
  584025
  561113
  568481
  680423
  661915
  666016
  605218
  587951
  786115
  800955
  765733
  429603
  445397
  464975
  391926
  466967
  407683
  441849
  394630
  495507
  523761
  498454
  579512
  394648
  413637
  432939
  815149
  817729
  452818
  468687
  491056
  508985
  537861
  511014
  500787
  517636
  460378
  477055
  485095
  541277
  544848
  541392
  564558
  576607
  696415
  714028
  651613
  657543
  664166
  678950
  713508
  589673
  610961
  605129
  628105
  634849
  606338
  586668
  592536
  794371
  784812
  733700
  737870
  769311
  801742
  811709
  724604
  757393
  777017
  801299
  467064
  473462
  188338
  451514
  471664
  401617
  410955
  429879
  452880
  471669
  13118
  461612
  478415
  478073
  502462
  641683
  468559
  530005
  628107
  430810
  744952
  761532
  459513
  441094
  513973
  564508
  568756
  675405
  580631
  479054
  396723
  417015
  815798
  817733
  821734
  813783
  815616
  815773
  815649
  815674
  818824
  819270
  827489
  470851
  534576
  510945
  532886
  534560
  538879
]
3.24 ms
(2.12%)
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
  13118
  188338
  391926
  394630
  394648
  396723
  401617
  407683
  410955
  413637
  417015
  429603
  429879
  430810
  432939
  441094
  441849
  445397
  451514
  452818
  452880
  459513
  460378
  461612
  464975
  466967
  467064
  468559
  468687
  470851
  471664
  471669
  473462
  477055
  478073
  478415
  479054
  485095
  491056
  495507
  498454
  500787
  502462
  508985
  510945
  511014
  513973
  517636
  523761
  530005
  532886
  534560
  534576
  537861
  538879
  541277
  541392
  544848
  555400
  561113
  564508
  564558
  568481
  568756
  576607
  579512
  580631
  584025
  586668
  587951
  589673
  592536
  605129
  605218
  606338
  610961
  628105
  628107
  634849
  641683
  651613
  657543
  661915
  664166
  666016
  675405
  678950
  680423
  696415
  713508
  714028
  724604
  733700
  737870
  744952
  757393
  761532
  765733
  769311
  777017
  784812
  786115
  794371
  800955
  801299
  801742
  811709
  813783
  815149
  815616
  815649
  815674
  815773
  815798
  817729
  817733
  818824
  819270
  821734
  827489
]
2.17 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal toys milf"
]
1.95 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал toys milf"
]
1.70 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал toys milf"
]

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.