Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.59 ms
(85.63%)
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
  397406
  417328
  418226
  431592
  431718
  441476
  450473
  450721
  451410
  473529
  480976
  483378
  493083
  493543
  495389
  499069
  505670
  508909
  509557
  511478
  518887
  518959
  531849
  542059
  542411
  543703
  549100
  549106
  549538
  553687
  556652
  577970
  578337
  584865
  585605
  586011
  590241
  594553
  607985
  616053
  616449
  616829
  619358
  623085
  623277
  626327
  632095
  632868
  641458
  648917
  651901
  670248
  676205
  698091
  706467
  712642
  715795
  718582
  726082
  726736
  731827
  738505
  738841
  739584
  739587
  741239
  743766
  747222
  750115
  750788
  750789
  751702
  757941
  759049
  761584
  764154
  764562
  767042
  767141
  767183
  777320
  778470
  784294
  784770
  785166
  785477
  787600
  789763
  793113
  793114
  793383
  793934
  794096
  794962
  794969
  794971
  794980
  794981
  795005
  795684
  796732
  796980
  797098
  797115
  797122
  800236
  801045
  804307
  805335
  809112
  809797
  809811
  809813
  809816
  810065
  817025
  817139
  817206
  817758
  820365
]
12.73 ms
(8.22%)
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
  418226
  417328
  778470
  797122
  809797
  796732
  809813
  817139
  616449
  718582
  651901
  767141
  801045
  549106
  739587
  577970
  804307
  789763
  698091
  759049
  578337
  585605
  616829
  809112
  757941
  495389
  796980
  623277
  590241
  793113
  738505
  820365
  794096
  676205
  793383
  739584
  518887
  809816
  743766
  787600
  670248
  810065
  741239
  777320
  556652
  793934
  531849
  761584
  784770
  731827
  794980
  797098
  553687
  623085
  632095
  431592
  480976
  706467
  751702
  794962
  607985
  797115
  800236
  616053
  750789
  431718
  817206
  632868
  726736
  795005
  626327
  805335
  794971
  499069
  817758
  794969
  397406
  549538
  795684
  518959
  794981
  543703
  586011
  764154
  726082
  785477
  549100
  483378
  809811
  750115
  750788
  505670
  542411
  619358
  793114
  784294
  450473
  493083
  747222
  817025
  542059
  450721
  509557
  493543
  441476
  785166
  508909
  712642
  738841
  767042
  764562
  473529
  584865
  511478
  594553
  641458
  715795
  767183
  451410
  648917
]
2.55 ms
(1.65%)
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
  397406
  417328
  418226
  431592
  431718
  441476
  450473
  450721
  451410
  473529
  480976
  483378
  493083
  493543
  495389
  499069
  505670
  508909
  509557
  511478
  518887
  518959
  531849
  542059
  542411
  543703
  549100
  549106
  549538
  553687
  556652
  577970
  578337
  584865
  585605
  586011
  590241
  594553
  607985
  616053
  616449
  616829
  619358
  623085
  623277
  626327
  632095
  632868
  641458
  648917
  651901
  670248
  676205
  698091
  706467
  712642
  715795
  718582
  726082
  726736
  731827
  738505
  738841
  739584
  739587
  741239
  743766
  747222
  750115
  750788
  750789
  751702
  757941
  759049
  761584
  764154
  764562
  767042
  767141
  767183
  777320
  778470
  784294
  784770
  785166
  785477
  787600
  789763
  793113
  793114
  793383
  793934
  794096
  794962
  794969
  794971
  794980
  794981
  795005
  795684
  796732
  796980
  797098
  797115
  797122
  800236
  801045
  804307
  805335
  809112
  809797
  809811
  809813
  809816
  810065
  817025
  817139
  817206
  817758
  820365
]
2.11 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "связала мужа и трахае%…"
]
1.76 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бдсм жен секс"
]
1.65 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "бдсм жен секс"
]
1.44 ms
(0.93%)
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.