Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
177.93 ms
(86.88%)
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
  402673
  409021
  412517
  413895
  415392
  416155
  416901
  420028
  420078
  420594
  420597
  420677
  421801
  422747
  424809
  426014
  426944
  427620
  428242
  431727
  436246
  443351
  443440
  445567
  452980
  453293
  453517
  453882
  455322
  455409
  458256
  461230
  467645
  470060
  470218
  471363
  471865
  476632
  478841
  478850
  487046
  495771
  500862
  505359
  508836
  512581
  515611
  517278
  517934
  519427
  519871
  520825
  522409
  522522
  523668
  524280
  524532
  525049
  525267
  525420
  526635
  531909
  533729
  542832
  547650
  551236
  552404
  555807
  555836
  569445
  569623
  571779
  580711
  588336
  599111
  600158
  604643
  619762
  659984
  678188
  679653
  683839
  688680
  721045
  726954
  757719
  768357
  768889
  771249
  771822
  771948
  771976
  772157
  772765
  773235
  774447
  774796
  778766
  778784
  780562
  782113
  783162
  784599
  786381
  787197
  788795
  789352
  790938
  791281
  792196
  804070
  804154
  815067
  815105
  815122
  818818
  820443
  820591
  823124
  827879
]
17.04 ms
(8.32%)
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
  453293
  461230
  427620
  470060
  757719
  555836
  409021
  413895
  420028
  523668
  424809
  774447
  815067
  659984
  571779
  588336
  790938
  791281
  772765
  771249
  768889
  782113
  773235
  416901
  522522
  533729
  599111
  788795
  792196
  778784
  771948
  804070
  787197
  412517
  402673
  421801
  524280
  815122
  768357
  815105
  721045
  683839
  778766
  772157
  771976
  771822
  774796
  784599
  804154
  453882
  455409
  542832
  467645
  827879
  555807
  455322
  436246
  520825
  524532
  526635
  517934
  517278
  512581
  415392
  452980
  458256
  470218
  525420
  547650
  569445
  569623
  688680
  551236
  580711
  619762
  726954
  604643
  445567
  416155
  426014
  428242
  420597
  420078
  471865
  478841
  453517
  487046
  476632
  495771
  679653
  552404
  426944
  443351
  443440
  478850
  519871
  525049
  515611
  500862
  508836
  519427
  525267
  422747
  431727
  678188
  600158
  783162
  786381
  420677
  420594
  471363
  522409
  505359
  820591
  823124
  820443
  818818
  780562
  789352
  531909
]
2.37 ms
(1.16%)
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
  402673
  409021
  412517
  413895
  415392
  416155
  416901
  420028
  420078
  420594
  420597
  420677
  421801
  422747
  424809
  426014
  426944
  427620
  428242
  431727
  436246
  443351
  443440
  445567
  452980
  453293
  453517
  453882
  455322
  455409
  458256
  461230
  467645
  470060
  470218
  471363
  471865
  476632
  478841
  478850
  487046
  495771
  500862
  505359
  508836
  512581
  515611
  517278
  517934
  519427
  519871
  520825
  522409
  522522
  523668
  524280
  524532
  525049
  525267
  525420
  526635
  531909
  533729
  542832
  547650
  551236
  552404
  555807
  555836
  569445
  569623
  571779
  580711
  588336
  599111
  600158
  604643
  619762
  659984
  678188
  679653
  683839
  688680
  721045
  726954
  757719
  768357
  768889
  771249
  771822
  771948
  771976
  772157
  772765
  773235
  774447
  774796
  778766
  778784
  780562
  782113
  783162
  784599
  786381
  787197
  788795
  789352
  790938
  791281
  792196
  804070
  804154
  815067
  815105
  815122
  818818
  820443
  820591
  823124
  827879
]
2.08 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex pov beautiful"
]
1.98 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс пов красивая"
]
1.79 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.79%)
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.