Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.68 ms
(87.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
  33077
  51524
  388583
  420748
  452687
  474721
  479481
  482867
  483989
  485736
  491653
  492695
  495529
  499578
  503011
  519267
  522682
  523956
  525288
  526150
  527693
  534345
  541959
  542698
  544072
  551104
  562821
  562911
  585785
  599813
  608270
  610704
  612494
  616709
  622615
  623071
  629727
  629751
  638968
  640826
  640844
  640863
  647114
  650293
  653848
  659313
  659482
  663463
  664696
  667443
  682671
  689094
  690364
  690468
  691235
  692412
  692842
  698386
  698775
  699235
  699870
  703795
  705538
  705746
  706121
  706543
  712065
  713460
  718971
  720418
  720676
  725426
  731412
  731440
  731539
  732664
  734061
  738922
  739607
  740048
  741931
  743579
  744501
  745763
  746982
  749571
  753929
  761160
  762640
  763429
  763977
  764597
  766494
  772503
  773855
  774033
  776359
  777691
  778633
  779848
  780857
  783729
  785506
  786047
  789059
  790152
  790225
  790251
  792392
  793306
  794970
  796619
  798865
  798904
  798975
  805426
  806960
  809345
  813901
  817746
]
9.67 ms
(5.97%)
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
  452687
  479481
  420748
  491653
  492695
  522682
  482867
  483989
  519267
  525288
  485736
  495529
  503011
  523956
  527693
  33077
  51524
  388583
  817746
  813901
  474721
  526150
  534345
  499578
  541959
  542698
  562821
  544072
  551104
  647114
  663463
  664696
  667443
  689094
  705746
  706121
  706543
  720676
  653848
  659313
  659482
  691235
  692842
  713460
  650293
  682671
  690364
  690468
  692412
  699235
  703795
  712065
  562911
  608270
  623071
  629727
  629751
  638968
  640826
  640863
  585785
  612494
  599813
  610704
  616709
  622615
  640844
  779848
  785506
  789059
  793306
  794970
  798865
  798904
  798975
  776359
  777691
  780857
  783729
  786047
  790225
  790251
  796619
  805426
  806960
  725426
  731440
  739607
  740048
  744501
  753929
  766494
  792392
  809345
  732664
  745763
  749571
  763429
  763977
  764597
  772503
  773855
  741931
  762640
  774033
  731412
  731539
  734061
  738922
  743579
  746982
  761160
  698386
  698775
  699870
  705538
  718971
  720418
  778633
  790152
]
3.35 ms
(2.07%)
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
  33077
  51524
  388583
  420748
  452687
  474721
  479481
  482867
  483989
  485736
  491653
  492695
  495529
  499578
  503011
  519267
  522682
  523956
  525288
  526150
  527693
  534345
  541959
  542698
  544072
  551104
  562821
  562911
  585785
  599813
  608270
  610704
  612494
  616709
  622615
  623071
  629727
  629751
  638968
  640826
  640844
  640863
  647114
  650293
  653848
  659313
  659482
  663463
  664696
  667443
  682671
  689094
  690364
  690468
  691235
  692412
  692842
  698386
  698775
  699235
  699870
  703795
  705538
  705746
  706121
  706543
  712065
  713460
  718971
  720418
  720676
  725426
  731412
  731440
  731539
  732664
  734061
  738922
  739607
  740048
  741931
  743579
  744501
  745763
  746982
  749571
  753929
  761160
  762640
  763429
  763977
  764597
  766494
  772503
  773855
  774033
  776359
  777691
  778633
  779848
  780857
  783729
  785506
  786047
  789059
  790152
  790225
  790251
  792392
  793306
  794970
  796619
  798865
  798904
  798975
  805426
  806960
  809345
  813901
  817746
]
2.10 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вмашин"
]
1.76 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в машина"
]
1.52 ms
(0.94%)
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.