Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.63 ms
(53.11%)
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
  28720
  61498
  143302
  226286
  282652
  285233
  378046
  382251
  382781
  383565
  384269
  386959
  389814
  391601
  394535
  395218
  398225
  398622
  401510
  413534
  417707
  417734
  417737
  417740
  419496
  420068
  421243
  421586
  423352
  423845
  427470
  428388
  428392
  429239
  429254
  429276
  429288
  445733
  445766
  447451
  450648
  451582
  451585
  453156
  453235
  455836
  459222
  460162
  462713
  467289
  467303
  472094
  473977
  477464
  478241
  480293
  480304
  480707
  482360
  487475
  489187
  491717
  497146
  501883
  502249
  502722
  509454
  512765
  512904
  513894
  513910
  523330
  524187
  525637
  527053
  528963
  529079
  533729
  546340
  552089
  552684
  553632
  559586
  561339
  565394
  570271
  570288
  570910
  571544
  571894
  571904
  572272
  573597
  573874
  574459
  574785
  584631
  584704
  594838
  594908
  599222
  599758
  601907
  602774
  607303
  611900
  617814
  619132
  624152
  624843
  626428
  636178
  636264
  645096
  648521
  664312
  684048
  687751
  725405
  730621
]
164.45 ms
(41.47%)
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
  28720
  61498
  143302
  226286
  282652
  285233
  378046
  382251
  382781
  383565
  384269
  386959
  389814
  391601
  394535
  395218
  398225
  398622
  401510
  413534
  417707
  417734
  417737
  417740
  419496
  420068
  421243
  421586
  423352
  423845
  427470
  428388
  428392
  429239
  429254
  429276
  429288
  445733
  445766
  447451
  450648
  451582
  451585
  453156
  453235
  455836
  459222
  460162
  462713
  467289
  467303
  472094
  473977
  477464
  478241
  480293
  480304
  480707
  482360
  487475
  489187
  491717
  497146
  501883
  502249
  502722
  509454
  512765
  512904
  513894
  513910
  523330
  524187
  525637
  527053
  528963
  529079
  533729
  546340
  552089
  552684
  553632
  559586
  561339
  565394
  570271
  570288
  570910
  571544
  571894
  571904
  572272
  573597
  573874
  574459
  574785
  584631
  584704
  594838
  594908
  599222
  599758
  601907
  602774
  607303
  611900
  617814
  619132
  624152
  624843
  626428
  636178
  636264
  645096
  648521
  664312
  684048
  687751
  725405
  730621
]
14.54 ms
(3.67%)
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
  664312
  559586
  561339
  601907
  636178
  607303
  599758
  602774
  617814
  384269
  391601
  459222
  143302
  480304
  394535
  429288
  451582
  472094
  497146
  502722
  491717
  28720
  428392
  453235
  480293
  513910
  513894
  482360
  546340
  570910
  572272
  552089
  684048
  645096
  594908
  619132
  636264
  428388
  528963
  529079
  489187
  502249
  573597
  413534
  445733
  477464
  525637
  527053
  574459
  599222
  624152
  626428
  378046
  420068
  285233
  509454
  624843
  417737
  594838
  512904
  574785
  480707
  584631
  611900
  524187
  584704
  462713
  687751
  571544
  730621
  523330
  398225
  401510
  460162
  571894
  725405
  226286
  450648
  533729
  512765
  455836
  61498
  487475
  386959
  423845
  421586
  282652
  417740
  421243
  429254
  417734
  427470
  447451
  553632
  571904
  570271
  570288
  565394
  552684
  573874
  453156
  467303
  382251
  389814
  429239
  451585
  423352
  478241
  501883
  382781
  648521
  473977
  383565
  395218
  398622
  417707
  429276
  419496
  445766
  467289
]
2.12 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пикап ххх"
]
1.70 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пикап ххх"
]
1.54 ms
(0.39%)
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.