Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.99 ms
(88.00%)
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
  12573
  188610
  261656
  307633
  373842
  382190
  383162
  383539
  391602
  398360
  398981
  399737
  401081
  401139
  411451
  415766
  422922
  431381
  432854
  440261
  442626
  445868
  446061
  446753
  454278
  455822
  455855
  457728
  459651
  462285
  469203
  469736
  470212
  474956
  478532
  480687
  490007
  493260
  495459
  496702
  499578
  507092
  508276
  509064
  511867
  512826
  512878
  512918
  514721
  516062
  518223
  521317
  521425
  524601
  530045
  541783
  541926
  551909
  555215
  558717
  559212
  570462
  573188
  579841
  581188
  584709
  584714
  592617
  596198
  605725
  606798
  609797
  620645
  623165
  628709
  645341
  661280
  685818
  690896
  694153
  703070
  706589
  712789
  714050
  717849
  719107
  719129
  719132
  719315
  719903
  720015
  720418
  720421
  720481
  720699
  720712
  721976
  722029
  724169
  732869
  740832
  744099
  745568
  747497
  749575
  758983
  760227
  766956
  767166
  773917
  795139
  817890
  818554
  819147
  821062
  821445
  821553
  822806
  823295
  827830
]
13.51 ms
(7.16%)
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
  440261
  760227
  822806
  512878
  712789
  795139
  717849
  685818
  827830
  518223
  551909
  819147
  817890
  470212
  499578
  521317
  555215
  694153
  719132
  720015
  719129
  596198
  766956
  745568
  773917
  720418
  721976
  573188
  399737
  415766
  521425
  581188
  592617
  455822
  495459
  442626
  524601
  496702
  514721
  818554
  821445
  823295
  821062
  821553
  446753
  559212
  579841
  719107
  714050
  720699
  628709
  767166
  747497
  724169
  744099
  12573
  584709
  606798
  383539
  373842
  398360
  507092
  516062
  541926
  720712
  720481
  722029
  620645
  623165
  261656
  478532
  509064
  446061
  469203
  661280
  480687
  474956
  508276
  584714
  541783
  558717
  391602
  605725
  469736
  749575
  382190
  445868
  512918
  455855
  411451
  511867
  720421
  454278
  422922
  719903
  512826
  459651
  493260
  457728
  462285
  609797
  383162
  530045
  645341
  570462
  706589
  307633
  432854
  188610
  401081
  490007
  690896
  732869
  740832
  758983
  703070
  401139
  398981
  431381
  719315
]
2.53 ms
(1.34%)
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
  12573
  188610
  261656
  307633
  373842
  382190
  383162
  383539
  391602
  398360
  398981
  399737
  401081
  401139
  411451
  415766
  422922
  431381
  432854
  440261
  442626
  445868
  446061
  446753
  454278
  455822
  455855
  457728
  459651
  462285
  469203
  469736
  470212
  474956
  478532
  480687
  490007
  493260
  495459
  496702
  499578
  507092
  508276
  509064
  511867
  512826
  512878
  512918
  514721
  516062
  518223
  521317
  521425
  524601
  530045
  541783
  541926
  551909
  555215
  558717
  559212
  570462
  573188
  579841
  581188
  584709
  584714
  592617
  596198
  605725
  606798
  609797
  620645
  623165
  628709
  645341
  661280
  685818
  690896
  694153
  703070
  706589
  712789
  714050
  717849
  719107
  719129
  719132
  719315
  719903
  720015
  720418
  720421
  720481
  720699
  720712
  721976
  722029
  724169
  732869
  740832
  744099
  745568
  747497
  749575
  758983
  760227
  766956
  767166
  773917
  795139
  817890
  818554
  819147
  821062
  821445
  821553
  822806
  823295
  827830
]
1.79 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public solo anal"
]
1.71 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц соло анал"
]
1.68 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц соло анал"
]
1.42 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.