Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.29 ms
(79.47%)
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
  101056
  315513
  384368
  398966
  400892
  403357
  403496
  406918
  408411
  411844
  413097
  415753
  415805
  417232
  421976
  422172
  427218
  428132
  428728
  428805
  429568
  429595
  432348
  432421
  440691
  440917
  441733
  441839
  442010
  442482
  443403
  443581
  444419
  444423
  445089
  445096
  445843
  447882
  448578
  449093
  452377
  452620
  454387
  454459
  454965
  454966
  455068
  456219
  457372
  457551
  458760
  459195
  459657
  462876
  464987
  465005
  465589
  465727
  466510
  466924
  473334
  473476
  473771
  474778
  475293
  475311
  476300
  476715
  476911
  479032
  482951
  483885
  484016
  484019
  485737
  485745
  485949
  486553
  488782
  490420
  491767
  491792
  492288
  492989
  495016
  496831
  498768
  499467
  500574
  501003
  502023
  503993
  504774
  505725
  507280
  507858
  509244
  509494
  510838
  510888
  511022
  511118
  511515
  513340
  515654
  515964
  517298
  517436
  517458
  517494
  518465
  518536
  520295
  520680
  524813
  526191
  526924
  531483
  539075
  540500
]
18.03 ms
(12.11%)
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
  483885
  490420
  492989
  496831
  499467
  502023
  504774
  505725
  511022
  517494
  520295
  498768
  507280
  511118
  513340
  517298
  517436
  518536
  526924
  384368
  101056
  315513
  400892
  398966
  403357
  403496
  406918
  413097
  417232
  429568
  429595
  432348
  443581
  445096
  411844
  428728
  428805
  432421
  440691
  444419
  408411
  422172
  427218
  428132
  440917
  442010
  445089
  415805
  421976
  443403
  444423
  415753
  441733
  441839
  442482
  449093
  454459
  454965
  454966
  457372
  464987
  465005
  465727
  466924
  475293
  484019
  485949
  492288
  445843
  448578
  452377
  452620
  456219
  458760
  459195
  462876
  465589
  473334
  473771
  479032
  482951
  485737
  485745
  491767
  491792
  447882
  454387
  455068
  457551
  459657
  466510
  473476
  474778
  475311
  476300
  476715
  476911
  484016
  486553
  488782
  495016
  500574
  503993
  509244
  510888
  511515
  517458
  518465
  539075
  501003
  515654
  515964
  520680
  524813
  531483
  510838
  526191
  540500
  507858
  509494
]
3.78 ms
(2.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вес"
]
3.07 ms
(2.06%)
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
  101056
  315513
  384368
  398966
  400892
  403357
  403496
  406918
  408411
  411844
  413097
  415753
  415805
  417232
  421976
  422172
  427218
  428132
  428728
  428805
  429568
  429595
  432348
  432421
  440691
  440917
  441733
  441839
  442010
  442482
  443403
  443581
  444419
  444423
  445089
  445096
  445843
  447882
  448578
  449093
  452377
  452620
  454387
  454459
  454965
  454966
  455068
  456219
  457372
  457551
  458760
  459195
  459657
  462876
  464987
  465005
  465589
  465727
  466510
  466924
  473334
  473476
  473771
  474778
  475293
  475311
  476300
  476715
  476911
  479032
  482951
  483885
  484016
  484019
  485737
  485745
  485949
  486553
  488782
  490420
  491767
  491792
  492288
  492989
  495016
  496831
  498768
  499467
  500574
  501003
  502023
  503993
  504774
  505725
  507280
  507858
  509244
  509494
  510838
  510888
  511022
  511118
  511515
  513340
  515654
  515964
  517298
  517436
  517458
  517494
  518465
  518536
  520295
  520680
  524813
  526191
  526924
  531483
  539075
  540500
]
1.98 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вес"
]
1.95 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "весу"
]
1.76 ms
(1.18%)
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.