Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.24 ms
(84.18%)
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
  197443
  225591
  229077
  364620
  384126
  389264
  390252
  395252
  396064
  399062
  399912
  401190
  403257
  403283
  404095
  404117
  405924
  410177
  417266
  417388
  417455
  417547
  418253
  419895
  421619
  421940
  422096
  424011
  425150
  426788
  427818
  428041
  429242
  429930
  431403
  431765
  432464
  433679
  435366
  435559
  436691
  438748
  438962
  440963
  441748
  441800
  442988
  443994
  444234
  445428
  446238
  449514
  449712
  450446
  451610
  452211
  452381
  452967
  453088
  453321
  454305
  454701
  454907
  455085
  459012
  459824
  460408
  461208
  461411
  462232
  463469
  465918
  465971
  466734
  466756
  466786
  467050
  469180
  469364
  469502
  470007
  470027
  470449
  471412
  471770
  471975
  472183
  472814
  472894
  473542
  475452
  475605
  476439
  478517
  479378
  480624
  484939
  488235
  496054
  497324
  501623
  504781
  507332
  510785
  512331
  528465
  528945
  548304
  549136
  550237
  551242
  555967
  555983
  562292
  577382
  586645
  598331
  601511
  601717
  604541
]
15.81 ms
(9.84%)
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
  433679
  435559
  410177
  428041
  436691
  429242
  440963
  451610
  459012
  466786
  469364
  471770
  473542
  449514
  453088
  462232
  466734
  469502
  470027
  472183
  472894
  479378
  454701
  497324
  507332
  550237
  551242
  562292
  577382
  549136
  598331
  390252
  417266
  426788
  432464
  441748
  444234
  445428
  469180
  475605
  404117
  419895
  421619
  425150
  435366
  438962
  442988
  452211
  452381
  460408
  461208
  461411
  466756
  467050
  471975
  480624
  396064
  404095
  418253
  421940
  454305
  454907
  459824
  476439
  225591
  229077
  364620
  395252
  403257
  417455
  427818
  441800
  450446
  463469
  431403
  449712
  465918
  470007
  472814
  528945
  528465
  484939
  488235
  496054
  510785
  548304
  601511
  601717
  446238
  604541
  443994
  453321
  452967
  504781
  471412
  475452
  555967
  555983
  586645
  431765
  417388
  422096
  465971
  478517
  455085
  389264
  470449
  438748
  512331
  501623
  384126
  197443
  399912
  399062
  401190
  403283
  405924
  417547
  424011
  429930
]
2.66 ms
(1.66%)
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
  197443
  225591
  229077
  364620
  384126
  389264
  390252
  395252
  396064
  399062
  399912
  401190
  403257
  403283
  404095
  404117
  405924
  410177
  417266
  417388
  417455
  417547
  418253
  419895
  421619
  421940
  422096
  424011
  425150
  426788
  427818
  428041
  429242
  429930
  431403
  431765
  432464
  433679
  435366
  435559
  436691
  438748
  438962
  440963
  441748
  441800
  442988
  443994
  444234
  445428
  446238
  449514
  449712
  450446
  451610
  452211
  452381
  452967
  453088
  453321
  454305
  454701
  454907
  455085
  459012
  459824
  460408
  461208
  461411
  462232
  463469
  465918
  465971
  466734
  466756
  466786
  467050
  469180
  469364
  469502
  470007
  470027
  470449
  471412
  471770
  471975
  472183
  472814
  472894
  473542
  475452
  475605
  476439
  478517
  479378
  480624
  484939
  488235
  496054
  497324
  501623
  504781
  507332
  510785
  512331
  528465
  528945
  548304
  549136
  550237
  551242
  555967
  555983
  562292
  577382
  586645
  598331
  601511
  601717
  604541
]
2.21 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "телки голые"
]
1.59 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женскийрод голые"
]
1.58 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.97%)
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.