Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.26 ms
(86.70%)
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
  79479
  96452
  123002
  381950
  382567
  384878
  384963
  385077
  385359
  387012
  388687
  389124
  391904
  392109
  392675
  394579
  396732
  397899
  398803
  401579
  401583
  411333
  419623
  420478
  422252
  424213
  424654
  425913
  425952
  425954
  426872
  427515
  429446
  439365
  440898
  443045
  444123
  451566
  453653
  453865
  454555
  461941
  462181
  462713
  464962
  467772
  468004
  469101
  469874
  470562
  470603
  470618
  470691
  471541
  471771
  472399
  475564
  476274
  478353
  479117
  479995
  483883
  490648
  496065
  499266
  501992
  506216
  509518
  510641
  516143
  516360
  520860
  523302
  524438
  524710
  526577
  533648
  534132
  535246
  543623
  543677
  545901
  548740
  551821
  552308
  557109
  563203
  563209
  568679
  568717
  579083
  585524
  587107
  591180
  593858
  597195
  601425
  621977
  649087
  678569
  689949
  694533
  696865
  712346
  722655
  724678
  731950
  739012
  755741
  761141
  762169
  767399
  777913
  784732
  792493
  806754
  808577
  809779
  813260
  825644
]
19.93 ms
(9.08%)
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
  731950
  767399
  429446
  462713
  79479
  382567
  401579
  461941
  451566
  524438
  389124
  678569
  475564
  543623
  552308
  563209
  579083
  587107
  593858
  621977
  469101
  123002
  391904
  392675
  453865
  468004
  471541
  384878
  385359
  424654
  425913
  425954
  439365
  422252
  453653
  479117
  470691
  516360
  499266
  509518
  496065
  523302
  526577
  470603
  476274
  388687
  381950
  479995
  396732
  443045
  427515
  454555
  470618
  471771
  470562
  392109
  387012
  398803
  825644
  483883
  534132
  535246
  543677
  649087
  689949
  712346
  545901
  585524
  755741
  724678
  762169
  739012
  761141
  784732
  792493
  806754
  808577
  401583
  419623
  462181
  464962
  524710
  516143
  501992
  520860
  424213
  533648
  506216
  548740
  694533
  696865
  722655
  551821
  591180
  777913
  809779
  813260
  397899
  478353
  440898
  467772
  384963
  394579
  425952
  426872
  469874
  490648
  510641
  385077
  444123
  472399
  557109
  568679
  568717
  563203
  601425
  597195
  96452
  411333
  420478
]
2.83 ms
(1.29%)
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
  79479
  96452
  123002
  381950
  382567
  384878
  384963
  385077
  385359
  387012
  388687
  389124
  391904
  392109
  392675
  394579
  396732
  397899
  398803
  401579
  401583
  411333
  419623
  420478
  422252
  424213
  424654
  425913
  425952
  425954
  426872
  427515
  429446
  439365
  440898
  443045
  444123
  451566
  453653
  453865
  454555
  461941
  462181
  462713
  464962
  467772
  468004
  469101
  469874
  470562
  470603
  470618
  470691
  471541
  471771
  472399
  475564
  476274
  478353
  479117
  479995
  483883
  490648
  496065
  499266
  501992
  506216
  509518
  510641
  516143
  516360
  520860
  523302
  524438
  524710
  526577
  533648
  534132
  535246
  543623
  543677
  545901
  548740
  551821
  552308
  557109
  563203
  563209
  568679
  568717
  579083
  585524
  587107
  591180
  593858
  597195
  601425
  621977
  649087
  678569
  689949
  694533
  696865
  712346
  722655
  724678
  731950
  739012
  755741
  761141
  762169
  767399
  777913
  784732
  792493
  806754
  808577
  809779
  813260
  825644
]
1.88 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "двоих русских"
]
1.54 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "два русск"
]
1.47 ms
(0.67%)
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.