Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.22 ms
(79.21%)
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
  4252
  12680
  30791
  71071
  150488
  188335
  233941
  235816
  308583
  381952
  384589
  385379
  385386
  385638
  387407
  389819
  394109
  396001
  396379
  397190
  398965
  400691
  402340
  407187
  407409
  411069
  411249
  416116
  416120
  419549
  424102
  425510
  425526
  426870
  427001
  427208
  428580
  430566
  435366
  440942
  441780
  443081
  443135
  443419
  444233
  444707
  448925
  449411
  453397
  457558
  458193
  459325
  459418
  460171
  463204
  465579
  465653
  466465
  466756
  466923
  468284
  468376
  468518
  470035
  471570
  472373
  472772
  473319
  475097
  475887
  476312
  478079
  478611
  478803
  478937
  479123
  480892
  480931
  481101
  481750
  483723
  485610
  485986
  488843
  489172
  490574
  490708
  491158
  493087
  495206
  495726
  495814
  496019
  498210
  500095
  503515
  503877
  505342
  507955
  508304
  509199
  509202
  514887
  521439
  522163
  534191
  543856
  565872
  567750
  577097
  588435
  619774
  622127
  626580
  636450
  655088
  677132
  690438
  697704
  710191
]
17.70 ms
(11.76%)
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
  459325
  485610
  509199
  503515
  495206
  514887
  488843
  543856
  567750
  577097
  677132
  588435
  308583
  385379
  396001
  411249
  425526
  471570
  472772
  233941
  394109
  448925
  465579
  466923
  71071
  384589
  400691
  426870
  235816
  385386
  416116
  458193
  478611
  509202
  485986
  489172
  498210
  495814
  521439
  505342
  385638
  150488
  381952
  30791
  4252
  12680
  389819
  397190
  416120
  430566
  411069
  443135
  443419
  444707
  407187
  443081
  444233
  427208
  428580
  440942
  441780
  457558
  459418
  465653
  468284
  475097
  476312
  483723
  490574
  490708
  449411
  468376
  470035
  480931
  491158
  495726
  522163
  534191
  496019
  503877
  507955
  475887
  481101
  493087
  565872
  690438
  655088
  697704
  710191
  626580
  636450
  619774
  622127
  188335
  396379
  419549
  460171
  473319
  398965
  402340
  424102
  427001
  435366
  463204
  466756
  479123
  407409
  425510
  453397
  478937
  387407
  468518
  478803
  480892
  466465
  472373
  478079
  481750
  508304
  500095
]
4.45 ms
(2.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вес"
]
3.06 ms
(2.04%)
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
  4252
  12680
  30791
  71071
  150488
  188335
  233941
  235816
  308583
  381952
  384589
  385379
  385386
  385638
  387407
  389819
  394109
  396001
  396379
  397190
  398965
  400691
  402340
  407187
  407409
  411069
  411249
  416116
  416120
  419549
  424102
  425510
  425526
  426870
  427001
  427208
  428580
  430566
  435366
  440942
  441780
  443081
  443135
  443419
  444233
  444707
  448925
  449411
  453397
  457558
  458193
  459325
  459418
  460171
  463204
  465579
  465653
  466465
  466756
  466923
  468284
  468376
  468518
  470035
  471570
  472373
  472772
  473319
  475097
  475887
  476312
  478079
  478611
  478803
  478937
  479123
  480892
  480931
  481101
  481750
  483723
  485610
  485986
  488843
  489172
  490574
  490708
  491158
  493087
  495206
  495726
  495814
  496019
  498210
  500095
  503515
  503877
  505342
  507955
  508304
  509199
  509202
  514887
  521439
  522163
  534191
  543856
  565872
  567750
  577097
  588435
  619774
  622127
  626580
  636450
  655088
  677132
  690438
  697704
  710191
]
2.27 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "весу"
]
1.94 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.