Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.62 ms
(84.54%)
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
  3512
  3599
  391749
  396789
  398639
  401774
  403147
  403266
  469358
  469770
  530176
  533898
  534583
  534621
  534628
  539751
  539752
  543385
  544981
  545071
  547004
  551875
  552985
  555471
  557506
  557805
  563088
  567542
  567874
  573153
  574455
  576537
  588185
  589822
  594552
  594626
  596641
  604664
  605700
  605786
  607072
  607703
  613920
  618638
  620468
  623415
  623951
  625107
  627951
  628826
  629884
  632232
  632949
  634444
  634691
  635414
  635527
  636160
  636179
  636324
  637462
  639231
  639578
  641641
  641903
  643949
  643972
  644127
  644907
  648474
  656813
  659990
  661340
  665048
  694112
  695417
  701947
  704097
  708513
  710105
  712705
  716713
  717430
  717437
  718346
  718847
  719530
  719538
  719864
  749898
  775002
  775701
  776100
  776221
  778324
  778457
  781073
  788053
  789604
  797363
  799831
  803717
  818082
  819277
  819324
  819412
  819929
  823348
  823588
  823616
  824373
  824547
  824623
  824772
  826811
  827319
  828764
]
13.05 ms
(8.93%)
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
  589822
  613920
  623951
  628826
  632949
  634691
  635414
  636160
  636179
  643949
  596641
  604664
  618638
  620468
  635527
  641641
  644127
  625107
  627951
  628493
  594552
  605786
  607703
  632232
  637462
  639578
  641903
  643972
  803717
  799831
  749898
  605700
  623415
  701947
  403147
  710105
  534628
  775002
  3512
  3599
  398639
  403266
  824547
  530176
  567542
  659990
  712705
  716713
  594626
  401774
  391749
  396789
  819277
  819412
  824373
  824772
  644907
  819929
  823348
  823588
  823616
  824623
  826811
  827319
  818082
  819324
  828764
  828652
  469358
  534583
  533898
  534621
  539752
  539751
  469770
  543385
  547004
  567874
  576537
  544981
  557805
  563088
  574455
  552985
  557506
  573153
  656813
  694112
  708513
  717437
  718847
  661340
  665048
  704097
  717430
  718346
  719538
  648474
  695417
  719530
  719864
  545071
  551875
  555471
  607072
  629884
  636324
  634444
  588185
  639231
  778324
  778457
  788053
  789604
  797363
  775701
  776100
  776183
  776221
  781073
]
2.96 ms
(2.03%)
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
  3512
  3599
  391749
  396789
  398639
  401774
  403147
  403266
  469358
  469770
  530176
  533898
  534583
  534621
  534628
  539751
  539752
  543385
  544981
  545071
  547004
  551875
  552985
  555471
  557506
  557805
  563088
  567542
  567874
  573153
  574455
  576537
  588185
  589822
  594552
  594626
  596641
  604664
  605700
  605786
  607072
  607703
  613920
  618638
  620468
  623415
  623951
  625107
  627951
  628826
  629884
  632232
  632949
  634444
  634691
  635414
  635527
  636160
  636179
  636324
  637462
  639231
  639578
  641641
  641903
  643949
  643972
  644127
  644907
  648474
  656813
  659990
  661340
  665048
  694112
  695417
  701947
  704097
  708513
  710105
  712705
  716713
  717430
  717437
  718346
  718847
  719530
  719538
  719864
  749898
  775002
  775701
  776100
  776221
  778324
  778457
  781073
  788053
  789604
  797363
  799831
  803717
  818082
  819277
  819324
  819412
  819929
  823348
  823588
  823616
  824373
  824547
  824623
  824772
  826811
  827319
  828764
]
1.86 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "настоящий любитель до…"
]
1.78 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральные любительск"
]
1.37 ms
(0.94%)
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.