Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.73 ms
(81.91%)
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
  48235
  68710
  79355
  81656
  95986
  129857
  130089
  143026
  209335
  209726
  210072
  280674
  310758
  317166
  325910
  382793
  382954
  383103
  383389
  383501
  384490
  384532
  384786
  384808
  384900
  385081
  385683
  387195
  387391
  388219
  388366
  389176
  390601
  392957
  394238
  394646
  395580
  395754
  396341
  396571
  397232
  397505
  397740
  398022
  398236
  398492
  399090
  399387
  399628
  399848
  400944
  401167
  401251
  402015
  402967
  403966
  405406
  409532
  410163
  411291
  411416
  414058
  421352
  426368
  426872
  428979
  444778
  450539
  451561
  451985
  455234
  459162
  460259
  460731
  461260
  462541
  463102
  463112
  464301
  466733
  467053
  467604
  468834
  469477
  471363
  474011
  474289
  474473
  476753
  477864
  487116
  494363
  497535
  504481
  517788
  517844
  525393
  531235
  538815
  545382
  568315
  580107
  580262
  583948
  590362
  590411
  598024
  606537
  612430
  615900
  624239
  659042
  663458
  681054
  698597
  721949
  723714
  730107
  809493
  816576
]
15.93 ms
(11.28%)
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
  460731
  385081
  384786
  384900
  143026
  394238
  392957
  280674
  397232
  397740
  402967
  401167
  405406
  444778
  816576
  463112
  469477
  477864
  583948
  698597
  615900
  612430
  723714
  721949
  401251
  396571
  129857
  399848
  68710
  403966
  462541
  317166
  411416
  426872
  388219
  426368
  421352
  451985
  476753
  474473
  468834
  531235
  464301
  568315
  545382
  580262
  590362
  590411
  517844
  81656
  382793
  384808
  383103
  209726
  394646
  395580
  395754
  310758
  325910
  48235
  388366
  390601
  398022
  398492
  399628
  402015
  400944
  414058
  411291
  410163
  455234
  487116
  450539
  459162
  460259
  494363
  461260
  659042
  681054
  606537
  624239
  809493
  730107
  79355
  385683
  396341
  399090
  399387
  428979
  463102
  210072
  389176
  398236
  451561
  209335
  397505
  474011
  130089
  387195
  387391
  409532
  471363
  497535
  474289
  466733
  538815
  504481
  517788
  525393
  467053
  663458
  580107
  598024
  467604
  382954
  383501
  95986
  383389
  384532
  384490
]
3.24 ms
(2.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
  48235
  68710
  79355
  81656
  95986
  129857
  130089
  143026
  209335
  209726
  210072
  280674
  310758
  317166
  325910
  382793
  382954
  383103
  383389
  383501
  384490
  384532
  384786
  384808
  384900
  385081
  385683
  387195
  387391
  388219
  388366
  389176
  390601
  392957
  394238
  394646
  395580
  395754
  396341
  396571
  397232
  397505
  397740
  398022
  398236
  398492
  399090
  399387
  399628
  399848
  400944
  401167
  401251
  402015
  402967
  403966
  405406
  409532
  410163
  411291
  411416
  414058
  421352
  426368
  426872
  428979
  444778
  450539
  451561
  451985
  455234
  459162
  460259
  460731
  461260
  462541
  463102
  463112
  464301
  466733
  467053
  467604
  468834
  469477
  471363
  474011
  474289
  474473
  476753
  477864
  487116
  494363
  497535
  504481
  517788
  517844
  525393
  531235
  538815
  545382
  568315
  580107
  580262
  583948
  590362
  590411
  598024
  606537
  612430
  615900
  624239
  659042
  663458
  681054
  698597
  721949
  723714
  730107
  809493
  816576
]
1.97 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde group"
]
1.63 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая group"
]
1.30 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая group"
]

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.