Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.96 ms
(87.10%)
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
  419267
  432690
  454470
  461302
  465630
  469496
  470411
  475242
  482277
  525545
  529237
  530029
  545984
  554795
  565629
  592241
  598102
  618859
  625026
  626285
  635313
  668542
  670850
  677265
  678370
  690717
  700636
  703395
  703632
  704429
  706067
  706415
  707786
  708532
  708680
  713116
  716956
  717285
  717949
  719861
  720100
  720750
  721930
  722448
  724627
  725367
  727024
  727539
  729540
  730112
  730312
  731057
  731102
  732433
  732655
  733130
  734229
  735437
  738070
  738985
  742560
  743003
  746280
  747555
  747731
  749741
  750484
  750937
  757522
  759018
  759910
  761009
  761222
  761754
  763599
  768054
  770087
  770342
  770367
  770378
  770500
  770681
  770718
  770965
  771579
  772496
  773246
  777102
  778491
  780388
  785359
  785454
  786745
  787706
  792777
  793669
  794336
  794994
  796142
  797228
  799451
  800956
  801224
  801724
  802213
  806705
  807740
  809859
  810592
  812644
  813464
  815478
  816995
  817200
  820345
  820722
  825310
  825449
]
12.94 ms
(6.96%)
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
  530029
  545984
  703395
  706067
  708532
  716956
  717285
  720750
  677265
  690717
  706415
  713116
  720100
  722448
  626285
  796142
  801224
  810592
  812644
  785359
  809859
  725367
  727024
  734229
  743003
  746280
  750484
  793669
  801724
  813464
  761009
  770681
  738985
  747731
  732655
  750937
  763599
  770087
  770965
  710923
  719861
  778491
  785454
  797228
  800956
  802213
  806705
  432690
  465630
  454470
  470411
  668542
  482277
  419267
  475242
  820722
  815478
  820345
  825310
  816995
  817200
  825449
  469496
  461302
  525545
  529237
  554795
  700636
  703632
  670850
  708680
  678370
  707786
  717949
  565629
  592241
  618859
  598102
  777102
  780388
  787706
  792777
  794336
  799451
  807740
  730112
  759910
  761222
  761754
  772496
  773246
  786745
  794994
  730312
  731057
  731102
  732433
  744533
  757522
  770718
  724627
  733130
  735437
  742560
  759018
  768054
  770500
  771579
  729540
  738070
  727539
  747555
  749741
  770342
  770367
  770378
  625026
  635313
  704429
  721930
]
2.86 ms
(1.54%)
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
  419267
  432690
  454470
  461302
  465630
  469496
  470411
  475242
  482277
  525545
  529237
  530029
  545984
  554795
  565629
  592241
  598102
  618859
  625026
  626285
  635313
  668542
  670850
  677265
  678370
  690717
  700636
  703395
  703632
  704429
  706067
  706415
  707786
  708532
  708680
  713116
  716956
  717285
  717949
  719861
  720100
  720750
  721930
  722448
  724627
  725367
  727024
  727539
  729540
  730112
  730312
  731057
  731102
  732433
  732655
  733130
  734229
  735437
  738070
  738985
  742560
  743003
  746280
  747555
  747731
  749741
  750484
  750937
  757522
  759018
  759910
  761009
  761222
  761754
  763599
  768054
  770087
  770342
  770367
  770378
  770500
  770681
  770718
  770965
  771579
  772496
  773246
  777102
  778491
  780388
  785359
  785454
  786745
  787706
  792777
  793669
  794336
  794994
  796142
  797228
  799451
  800956
  801224
  801724
  802213
  806705
  807740
  809859
  810592
  812644
  813464
  815478
  816995
  817200
  820345
  820722
  825310
  825449
]
2.37 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum latina"
]
2.11 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum латинская"
]
1.95 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum латинская"
]

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.