Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.67 ms
(82.78%)
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
  261088
  387545
  388995
  395839
  417173
  422453
  425529
  426823
  427001
  431740
  452258
  453514
  456993
  460038
  460715
  462116
  473649
  475541
  480053
  483175
  483844
  488730
  490773
  491588
  495131
  496510
  506696
  509797
  510725
  511182
  514691
  521179
  521939
  523716
  524118
  540187
  540724
  541713
  550342
  553788
  561310
  562257
  562262
  562288
  562395
  563653
  564300
  564806
  567523
  567828
  571370
  576216
  577831
  578958
  582713
  584685
  584958
  585930
  586607
  588568
  589898
  590478
  590807
  599472
  599481
  601218
  602874
  603792
  603969
  604137
  605494
  605928
  606668
  615466
  615625
  615936
  617706
  618528
  622465
  624941
  625259
  641649
  644057
  648762
  650075
  650280
  650669
  651794
  673260
  684672
  691578
  697400
  709148
  715395
  739905
  748158
  748632
  751725
  755796
  758699
  761273
  764179
  766342
  776248
  784110
  784564
  785369
  786420
  788007
  788144
  797817
  799414
  801386
  801772
  803142
  805254
  807359
  807464
  809979
]
14.73 ms
(10.27%)
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
  495131
  511182
  536850
  567523
  648762
  651794
  561310
  625259
  590807
  605928
  585930
  599481
  788007
  788144
  784110
  797817
  751725
  739905
  766342
  622465
  803142
  475541
  387545
  422453
  453514
  417173
  462116
  540724
  521179
  521939
  395839
  456993
  473649
  540187
  567828
  550342
  564300
  577831
  673260
  562395
  564806
  582713
  588568
  617706
  599472
  776248
  748632
  618528
  431740
  261088
  425529
  460038
  483844
  488730
  509797
  541713
  452258
  483175
  514691
  584958
  684672
  691578
  650669
  697400
  709148
  590478
  586607
  615466
  604137
  644057
  605494
  615625
  755796
  784564
  799414
  809979
  761273
  758699
  764179
  785369
  786420
  807464
  427001
  426823
  460715
  510725
  490773
  388995
  491588
  523716
  496510
  524118
  506696
  480053
  562257
  578958
  584685
  562262
  571370
  576216
  715395
  650075
  650280
  553788
  562288
  563653
  589898
  615936
  624941
  601218
  606668
  641649
  603969
  602874
  603792
  801386
  805254
  807359
  801772
  748158
]
2.67 ms
(1.86%)
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
  261088
  387545
  388995
  395839
  417173
  422453
  425529
  426823
  427001
  431740
  452258
  453514
  456993
  460038
  460715
  462116
  473649
  475541
  480053
  483175
  483844
  488730
  490773
  491588
  495131
  496510
  506696
  509797
  510725
  511182
  514691
  521179
  521939
  523716
  524118
  540187
  540724
  541713
  550342
  553788
  561310
  562257
  562262
  562288
  562395
  563653
  564300
  564806
  567523
  567828
  571370
  576216
  577831
  578958
  582713
  584685
  584958
  585930
  586607
  588568
  589898
  590478
  590807
  599472
  599481
  601218
  602874
  603792
  603969
  604137
  605494
  605928
  606668
  615466
  615625
  615936
  617706
  618528
  622465
  624941
  625259
  641649
  644057
  648762
  650075
  650280
  650669
  651794
  673260
  684672
  691578
  697400
  709148
  715395
  739905
  748158
  748632
  751725
  755796
  758699
  761273
  764179
  766342
  776248
  784110
  784564
  785369
  786420
  788007
  788144
  797817
  799414
  801386
  801772
  803142
  805254
  807359
  807464
  809979
]
2.10 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "student girl"
]
1.92 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "student девушк"
]
1.85 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "student девушк"
]
1.42 ms
(0.99%)
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.