Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.37 ms
(81.62%)
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
  79942
  104130
  213316
  381860
  381983
  382420
  391439
  397856
  410308
  422819
  424001
  424427
  426771
  427660
  432425
  432431
  432436
  432467
  432504
  432534
  432540
  433045
  433385
  433594
  433707
  433751
  433768
  433822
  433829
  436393
  441188
  445187
  448781
  461620
  465887
  470120
  483855
  490543
  498169
  500890
  504014
  505992
  514996
  519055
  524089
  524136
  526880
  527983
  546890
  546970
  561916
  568643
  568655
  572889
  580027
  583538
  584483
  585939
  588373
  599487
  601446
  603406
  607304
  626642
  627182
  657831
  677860
  686862
  689388
  695759
  699533
  699908
  704281
  710093
  710854
  711990
  723655
  723668
  725139
  725466
  730742
  732166
  735834
  735864
  735959
  740716
  742110
  742713
  749461
  750890
  750922
  751244
  753500
  753506
  755138
  758693
  759951
  760881
  761834
  767634
  767639
  767984
  768691
  768695
  779177
  782969
  791750
  791753
  791758
  792127
  794730
  795528
  797034
  799021
  812446
  812461
  812464
  812728
]
18.61 ms
(11.56%)
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
  740716
  750922
  753506
  792127
  797034
  750890
  755138
  767634
  749461
  760878
  730742
  732166
  753500
  758693
  699533
  779177
  397856
  382420
  601446
  761834
  432534
  422819
  483855
  514996
  568655
  448781
  527983
  519055
  441188
  432425
  677860
  657831
  695759
  627182
  812446
  723668
  759951
  699908
  812461
  433594
  599487
  588373
  742110
  607304
  213316
  104130
  427660
  461620
  490543
  470120
  546970
  572889
  568643
  436393
  433829
  424001
  424427
  432436
  445187
  410308
  524136
  381860
  381983
  391439
  432467
  433045
  723655
  504014
  465887
  711990
  710854
  689388
  791753
  799021
  791750
  794730
  795528
  812728
  725466
  751244
  735864
  742713
  768695
  767639
  757577
  704281
  812464
  505992
  580027
  583538
  626642
  433385
  500890
  498169
  584483
  433768
  546890
  603406
  725139
  561916
  710093
  782969
  791758
  735959
  760881
  768691
  735834
  767984
  79942
  433751
  433822
  432431
  432504
  432540
  426771
  433707
  526880
  686862
  585939
  524089
]
3.71 ms
(2.31%)
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
  79942
  104130
  213316
  381860
  381983
  382420
  391439
  397856
  410308
  422819
  424001
  424427
  426771
  427660
  432425
  432431
  432436
  432467
  432504
  432534
  432540
  433045
  433385
  433594
  433707
  433751
  433768
  433822
  433829
  436393
  441188
  445187
  448781
  461620
  465887
  470120
  483855
  490543
  498169
  500890
  504014
  505992
  514996
  519055
  524089
  524136
  526880
  527983
  546890
  546970
  561916
  568643
  568655
  572889
  580027
  583538
  584483
  585939
  588373
  599487
  601446
  603406
  607304
  626642
  627182
  657831
  677860
  686862
  689388
  695759
  699533
  699908
  704281
  710093
  710854
  711990
  723655
  723668
  725139
  725466
  730742
  732166
  735834
  735864
  735959
  740716
  742110
  742713
  749461
  750890
  750922
  751244
  753500
  753506
  755138
  758693
  759951
  760881
  761834
  767634
  767639
  767984
  768691
  768695
  779177
  782969
  791750
  791753
  791758
  792127
  794730
  795528
  797034
  799021
  812446
  812461
  812464
  812728
]
2.10 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в колготках сперма"
]
1.78 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "колготк сперм"
]
1.38 ms
(0.86%)
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.