Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.00 ms
(87.03%)
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
  392277
  397068
  397255
  400143
  402999
  403600
  407154
  408293
  411310
  417662
  422807
  426183
  428454
  430835
  432834
  437583
  442426
  443553
  448362
  450830
  453151
  455281
  460189
  464661
  467838
  469952
  476909
  478107
  486023
  486251
  494209
  510287
  515047
  518858
  523256
  525551
  531979
  532064
  532120
  532825
  534845
  535944
  536330
  537116
  545874
  545908
  547912
  548320
  551035
  554525
  559008
  562600
  563157
  563443
  563920
  563925
  571508
  579371
  583201
  585155
  586150
  590533
  592856
  601234
  602959
  603834
  604561
  609238
  612977
  620780
  622668
  622710
  632549
  640403
  661991
  663274
  674249
  680854
  688100
  688646
  695707
  698312
  698834
  705450
  709540
  710146
  710310
  710575
  711354
  714156
  715423
  718920
  720545
  721233
  724502
  726588
  726606
  728352
  728443
  728447
  742321
  748892
  760875
  783485
  784304
  786453
  799936
  800097
  803595
  804620
  804675
  807407
  807515
  809061
  810718
  815353
  820096
  823976
  824434
  825102
]
14.45 ms
(7.48%)
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
  397255
  403600
  432834
  622710
  408293
  478107
  437583
  407154
  486023
  518858
  453151
  532064
  783485
  523256
  422807
  442426
  815353
  460189
  486251
  531979
  525551
  545874
  545908
  563920
  563925
  562600
  710146
  674249
  698834
  714156
  715423
  620780
  585155
  804675
  724502
  726588
  728443
  632549
  705450
  476909
  534845
  455281
  579371
  559008
  563443
  571508
  602959
  784304
  430835
  825102
  448362
  535944
  532120
  551035
  554525
  612977
  803595
  748892
  726606
  810718
  402999
  622668
  698312
  799936
  609238
  392277
  823976
  824434
  820096
  532825
  536330
  537116
  547912
  688100
  710575
  711354
  710310
  721233
  592856
  604561
  590533
  586150
  603834
  800097
  807515
  728352
  742321
  760875
  601234
  807407
  400143
  510287
  494209
  583201
  548320
  411310
  450830
  515047
  680854
  718920
  720545
  663274
  688646
  695707
  661991
  563157
  804620
  728447
  709540
  786453
  809061
  397068
  428454
  417662
  443553
  426183
  469952
  467838
  640403
  464661
]
3.29 ms
(1.70%)
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
  392277
  397068
  397255
  400143
  402999
  403600
  407154
  408293
  411310
  417662
  422807
  426183
  428454
  430835
  432834
  437583
  442426
  443553
  448362
  450830
  453151
  455281
  460189
  464661
  467838
  469952
  476909
  478107
  486023
  486251
  494209
  510287
  515047
  518858
  523256
  525551
  531979
  532064
  532120
  532825
  534845
  535944
  536330
  537116
  545874
  545908
  547912
  548320
  551035
  554525
  559008
  562600
  563157
  563443
  563920
  563925
  571508
  579371
  583201
  585155
  586150
  590533
  592856
  601234
  602959
  603834
  604561
  609238
  612977
  620780
  622668
  622710
  632549
  640403
  661991
  663274
  674249
  680854
  688100
  688646
  695707
  698312
  698834
  705450
  709540
  710146
  710310
  710575
  711354
  714156
  715423
  718920
  720545
  721233
  724502
  726588
  726606
  728352
  728443
  728447
  742321
  748892
  760875
  783485
  784304
  786453
  799936
  800097
  803595
  804620
  804675
  807407
  807515
  809061
  810718
  815353
  820096
  823976
  824434
  825102
]
2.12 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step big mom"
]
1.85 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step большие mom"
]
1.74 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step большие mom"
]
1.58 ms
(0.82%)
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.