Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.60 ms
(54.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "в форм"
]
155.52 ms
(40.14%)
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
  13118
  191235
  382942
  385165
  404859
  409346
  413786
  419051
  421760
  423765
  424847
  425505
  428517
  432520
  434230
  434667
  435924
  440935
  442101
  442966
  443081
  444157
  444183
  445793
  446208
  448070
  448622
  452030
  452216
  452557
  452991
  452997
  453420
  453576
  453896
  454130
  454403
  456321
  457180
  457826
  458385
  459359
  460420
  460704
  461406
  461717
  462126
  463989
  464214
  464962
  465302
  465599
  466886
  467063
  468184
  468339
  472604
  473449
  473650
  473786
  474056
  475539
  476051
  476101
  482554
  484776
  485955
  487223
  488213
  489296
  489800
  490475
  490522
  493852
  494242
  494541
  494569
  495106
  496165
  497025
  498416
  498616
  499690
  501441
  502010
  505779
  507469
  507829
  508230
  510035
  511205
  511298
  511315
  511550
  513208
  513997
  515403
  515615
  516010
  517458
  517484
  518450
  519335
  520372
  524653
  525790
  527071
  541870
  568164
  599371
  599457
  612247
  674087
  737162
  755348
  769501
  778714
  791060
  810000
  813920
]
13.86 ms
(3.58%)
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
  515615
  489296
  517458
  442966
  498416
  505779
  507829
  404859
  442101
  454130
  472604
  473449
  452991
  466886
  468339
  490475
  515403
  516010
  502010
  507469
  510035
  467063
  473650
  568164
  612247
  460704
  462126
  409346
  460420
  465599
  476051
  474056
  475539
  13118
  434230
  453420
  435924
  453896
  476101
  508230
  511205
  518450
  487223
  494569
  499690
  519335
  520372
  525790
  527071
  484776
  494242
  423765
  443081
  452997
  473786
  482554
  498616
  495106
  488213
  541870
  778714
  810000
  737162
  769501
  458385
  464962
  461717
  493852
  494541
  524653
  485955
  513208
  517484
  385165
  419051
  444157
  445793
  446208
  448070
  452030
  454403
  456321
  457826
  452216
  496165
  511315
  465302
  599371
  599457
  413786
  452557
  444183
  461406
  448622
  453576
  513997
  490522
  497025
  382942
  191235
  434667
  440935
  424847
  428517
  813920
  459359
  463989
  457180
  468184
  489800
  464214
  501441
  511298
  511550
  674087
  791060
  755348
  421760
  425505
  432520
]
2.64 ms
(0.68%)
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
  13118
  191235
  382942
  385165
  404859
  409346
  413786
  419051
  421760
  423765
  424847
  425505
  428517
  432520
  434230
  434667
  435924
  440935
  442101
  442966
  443081
  444157
  444183
  445793
  446208
  448070
  448622
  452030
  452216
  452557
  452991
  452997
  453420
  453576
  453896
  454130
  454403
  456321
  457180
  457826
  458385
  459359
  460420
  460704
  461406
  461717
  462126
  463989
  464214
  464962
  465302
  465599
  466886
  467063
  468184
  468339
  472604
  473449
  473650
  473786
  474056
  475539
  476051
  476101
  482554
  484776
  485955
  487223
  488213
  489296
  489800
  490475
  490522
  493852
  494242
  494541
  494569
  495106
  496165
  497025
  498416
  498616
  499690
  501441
  502010
  505779
  507469
  507829
  508230
  510035
  511205
  511298
  511315
  511550
  513208
  513997
  515403
  515615
  516010
  517458
  517484
  518450
  519335
  520372
  524653
  525790
  527071
  541870
  568164
  599371
  599457
  612247
  674087
  737162
  755348
  769501
  778714
  791060
  810000
  813920
]
1.68 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в форм"
]
1.64 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в форм"
]
1.50 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.