Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.69 ms
(87.16%)
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
  4311
  382606
  391764
  391768
  392104
  423972
  425475
  427020
  459665
  463255
  469696
  470690
  471576
  473962
  485854
  486118
  505587
  506424
  539660
  540935
  543625
  545875
  545922
  545980
  547604
  547681
  547984
  559467
  590522
  609194
  617673
  618242
  618934
  619908
  623745
  627668
  630152
  650292
  687691
  690755
  704152
  708152
  709970
  713325
  713758
  713993
  722085
  725204
  725431
  725489
  725768
  726890
  728054
  730826
  731146
  731217
  731219
  731575
  734709
  735266
  735658
  735887
  735954
  735984
  738328
  739553
  742263
  742601
  742665
  742776
  754531
  755875
  759105
  759489
  761948
  761956
  765495
  766142
  767755
  768470
  771025
  778292
  779861
  783115
  788126
  788401
  789482
  793168
  793998
  794554
  795288
  796262
  796459
  797131
  797316
  797380
  798692
  800547
  801432
  801496
  802096
  804409
  804838
  805340
  805615
  807236
  810328
  810819
  823647
  824137
  824260
  824852
  825064
  825838
  826219
  826357
  826481
  826581
  827619
]
11.16 ms
(6.50%)
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
  627668
  797316
  730826
  505587
  826581
  824852
  826219
  827619
  824137
  485854
  795288
  798692
  805340
  778292
  779861
  810819
  731575
  734709
  742263
  742776
  759105
  807236
  728054
  735887
  735984
  738328
  735658
  742601
  742665
  754531
  755875
  759489
  767755
  768470
  731217
  739553
  725768
  731146
  731219
  735954
  761956
  771025
  793998
  810328
  427020
  823647
  650292
  609194
  392104
  825064
  826357
  825838
  547604
  545875
  797131
  802096
  805615
  788126
  789482
  794554
  796262
  800547
  801422
  801496
  783115
  788401
  793168
  796459
  804838
  725204
  726890
  725489
  765495
  722085
  797380
  801432
  382606
  471576
  543625
  619908
  713758
  4311
  391764
  473962
  469696
  539660
  618934
  423972
  459665
  425475
  506424
  486118
  540935
  545922
  547681
  547984
  713993
  687691
  690755
  708152
  709970
  545980
  590522
  617673
  804409
  735266
  761948
  766142
  630152
  713325
  463255
  559467
  470690
  704152
  618242
  725431
  623745
  391768
  826481
  824260
]
2.98 ms
(1.74%)
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
  4311
  382606
  391764
  391768
  392104
  423972
  425475
  427020
  459665
  463255
  469696
  470690
  471576
  473962
  485854
  486118
  505587
  506424
  539660
  540935
  543625
  545875
  545922
  545980
  547604
  547681
  547984
  559467
  590522
  609194
  617673
  618242
  618934
  619908
  623745
  627668
  630152
  650292
  687691
  690755
  704152
  708152
  709970
  713325
  713758
  713993
  722085
  725204
  725431
  725489
  725768
  726890
  728054
  730826
  731146
  731217
  731219
  731575
  734709
  735266
  735658
  735887
  735954
  735984
  738328
  739553
  742263
  742601
  742665
  742776
  754531
  755875
  759105
  759489
  761948
  761956
  765495
  766142
  767755
  768470
  771025
  778292
  779861
  783115
  788126
  788401
  789482
  793168
  793998
  794554
  795288
  796262
  796459
  797131
  797316
  797380
  798692
  800547
  801432
  801496
  802096
  804409
  804838
  805340
  805615
  807236
  810328
  810819
  823647
  824137
  824260
  824852
  825064
  825838
  826219
  826357
  826481
  826581
  827619
]
2.55 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск русск"
]
2.01 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur rus"
]
1.79 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск русск"
]
1.55 ms
(0.90%)
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.