Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
273.72 ms
(91.90%)
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
  6858
  34884
  60096
  233211
  381997
  387050
  390346
  397132
  401696
  402427
  403250
  411167
  421053
  427158
  429924
  431497
  444249
  446358
  453284
  459314
  461966
  462170
  463661
  470761
  472076
  473928
  478787
  486592
  491554
  491658
  492384
  492824
  499050
  500059
  501227
  507396
  512641
  520492
  522260
  523738
  523965
  527864
  535972
  538438
  538469
  541350
  541708
  544873
  545357
  545547
  552232
  552236
  554236
  556255
  556285
  557717
  559606
  563961
  568682
  569365
  569416
  574116
  574181
  574289
  575636
  577717
  577838
  577905
  577989
  585822
  590328
  593919
  594118
  594286
  595538
  596676
  597836
  598615
  614665
  618144
  622303
  629727
  630478
  645728
  652424
  657158
  660655
  669285
  670762
  671098
  673763
  676487
  676499
  676524
  676532
  676929
  677026
  677249
  677750
  679688
  691469
  693506
  708731
  709459
  717109
  720104
  721225
  723010
  774811
  776111
  777474
  778412
  778510
  778518
  780879
  783359
  785798
  790172
  799913
  810562
]
13.00 ms
(4.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
  776111
  780879
  783359
  785798
  790172
  799913
  810562
  390346
  411167
  6858
  233211
  429924
  401696
  461966
  381997
  403250
  427158
  492824
  512641
  486592
  559606
  463661
  473928
  472076
  462170
  478787
  523965
  491554
  491658
  520492
  522260
  523738
  492384
  499050
  500059
  501227
  60096
  34884
  387050
  397132
  402427
  421053
  431497
  444249
  459314
  446358
  453284
  470761
  538438
  507396
  538469
  527864
  535972
  544873
  554236
  563961
  574116
  575636
  577717
  577905
  545357
  552232
  556255
  556285
  557717
  577838
  541350
  541708
  568682
  569365
  569416
  669285
  671098
  673763
  676929
  677249
  691469
  717109
  723010
  645728
  657158
  670762
  676487
  676524
  693506
  708731
  709459
  720104
  652424
  660655
  676499
  676532
  677026
  677750
  679688
  721225
  545547
  552236
  574181
  574289
  577989
  585822
  590328
  593919
  596676
  598615
  630478
  594286
  622303
  629727
  595538
  597836
  614665
  594118
  618144
  774811
  777474
  778412
  778510
  778518
]
2.89 ms
(0.97%)
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
  6858
  34884
  60096
  233211
  381997
  387050
  390346
  397132
  401696
  402427
  403250
  411167
  421053
  427158
  429924
  431497
  444249
  446358
  453284
  459314
  461966
  462170
  463661
  470761
  472076
  473928
  478787
  486592
  491554
  491658
  492384
  492824
  499050
  500059
  501227
  507396
  512641
  520492
  522260
  523738
  523965
  527864
  535972
  538438
  538469
  541350
  541708
  544873
  545357
  545547
  552232
  552236
  554236
  556255
  556285
  557717
  559606
  563961
  568682
  569365
  569416
  574116
  574181
  574289
  575636
  577717
  577838
  577905
  577989
  585822
  590328
  593919
  594118
  594286
  595538
  596676
  597836
  598615
  614665
  618144
  622303
  629727
  630478
  645728
  652424
  657158
  660655
  669285
  670762
  671098
  673763
  676487
  676499
  676524
  676532
  676929
  677026
  677249
  677750
  679688
  691469
  693506
  708731
  709459
  717109
  720104
  721225
  723010
  774811
  776111
  777474
  778412
  778510
  778518
  780879
  783359
  785798
  790172
  799913
  810562
]
2.72 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лет"
]
1.94 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лет"
]
1.89 ms
(0.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.