Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.24 ms
(87.74%)
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
  12708
  64314
  80653
  81412
  81637
  87363
  107874
  223442
  311697
  327981
  337234
  343503
  382254
  382657
  382756
  384095
  385199
  387374
  401599
  401627
  401738
  402427
  403823
  406658
  424870
  426911
  456682
  458489
  469720
  480043
  482557
  494849
  515300
  523061
  534376
  542721
  545319
  548067
  554741
  555732
  560264
  567258
  567639
  571702
  574409
  577950
  585692
  592258
  593855
  594626
  602763
  603731
  616060
  628615
  630572
  634007
  636556
  636561
  637505
  654397
  661035
  706659
  710843
  713945
  714969
  720378
  723151
  726295
  726325
  726356
  726438
  727505
  733249
  733381
  736907
  740091
  740171
  740864
  743860
  744400
  745314
  746277
  747396
  747546
  748938
  749028
  757605
  761242
  767751
  769338
  777621
  777628
  779028
  779958
  782578
  785985
  787493
  789508
  791009
  791491
  791494
  792199
  793740
  794502
  795641
  798305
  798594
  799480
  800252
  800357
  801057
  803166
  806149
  807457
  811360
  812404
  812424
  813307
]
12.35 ms
(6.60%)
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
  713945
  654397
  661035
  710843
  714969
  723151
  567258
  567639
  583788
  628615
  630572
  594626
  616060
  634007
  636556
  637505
  787493
  798305
  800252
  811360
  812424
  777628
  779958
  791009
  793740
  795641
  803166
  806149
  812404
  733381
  749028
  761242
  798594
  800357
  807457
  746277
  767751
  726325
  726356
  726438
  744400
  745314
  747396
  763063
  769338
  726295
  727505
  733249
  740091
  740864
  748938
  736907
  740171
  743860
  757605
  636561
  706659
  720378
  777621
  779028
  782578
  785985
  789508
  813307
  382254
  87363
  382756
  387374
  337234
  382657
  311697
  343503
  574409
  555732
  327981
  80653
  571702
  592258
  792199
  107874
  12708
  402427
  401738
  401627
  424870
  456682
  494849
  482557
  585692
  603731
  794502
  801057
  799480
  64314
  385199
  401599
  81637
  403823
  384095
  469720
  545319
  602763
  593855
  577950
  560264
  542721
  548067
  534376
  791494
  791491
  223442
  406658
  458489
  747546
  426911
  81412
  480043
  523061
  515300
  554741
]
3.01 ms
(1.61%)
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
  12708
  64314
  80653
  81412
  81637
  87363
  107874
  223442
  311697
  327981
  337234
  343503
  382254
  382657
  382756
  384095
  385199
  387374
  401599
  401627
  401738
  402427
  403823
  406658
  424870
  426911
  456682
  458489
  469720
  480043
  482557
  494849
  515300
  523061
  534376
  542721
  545319
  548067
  554741
  555732
  560264
  567258
  567639
  571702
  574409
  577950
  585692
  592258
  593855
  594626
  602763
  603731
  616060
  628615
  630572
  634007
  636556
  636561
  637505
  654397
  661035
  706659
  710843
  713945
  714969
  720378
  723151
  726295
  726325
  726356
  726438
  727505
  733249
  733381
  736907
  740091
  740171
  740864
  743860
  744400
  745314
  746277
  747396
  747546
  748938
  749028
  757605
  761242
  767751
  769338
  777621
  777628
  779028
  779958
  782578
  785985
  787493
  789508
  791009
  791491
  791494
  792199
  793740
  794502
  795641
  798305
  798594
  799480
  800252
  800357
  801057
  803166
  806149
  807457
  811360
  812404
  812424
  813307
]
2.63 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на лиц"
]
1.97 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на лиц"
]
1.46 ms
(0.78%)
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.