Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.51 ms
(84.24%)
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
  402083
  403582
  411516
  441118
  464648
  474721
  478288
  479839
  532616
  533400
  538469
  556447
  557640
  558590
  572921
  577128
  580934
  583727
  586891
  588363
  589593
  589652
  592325
  593196
  600590
  603125
  609555
  610065
  611285
  614072
  617504
  622750
  629557
  638187
  638916
  639981
  640366
  642314
  643706
  678850
  680455
  680597
  680615
  684501
  684874
  693360
  695549
  699066
  701235
  706413
  708536
  710068
  710802
  719422
  728464
  731766
  732162
  739482
  742066
  742346
  742822
  742972
  744205
  745470
  746791
  747482
  749041
  750276
  750529
  750655
  760158
  760503
  763966
  765546
  769089
  772454
  773029
  773198
  773855
  775611
  775653
  777800
  777867
  777869
  777875
  777884
  782520
  782949
  783169
  784106
  784710
  787536
  787812
  788210
  788987
  789538
  791223
  791552
  793128
  796193
  796397
  796404
  797083
  800528
  801833
  801999
  803479
  803732
  803980
  804246
  806009
  809911
  810082
  812282
  814186
  817685
  820088
  820171
  826804
  827077
]
18.34 ms
(9.68%)
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
  611285
  622750
  589652
  643706
  614072
  777867
  801833
  777884
  788987
  804246
  742972
  769089
  772454
  742822
  728464
  760503
  701235
  402083
  593196
  538469
  695549
  782949
  750529
  411516
  817685
  820088
  826804
  556447
  693360
  638187
  642314
  603125
  777800
  791223
  803980
  806009
  773029
  749041
  773198
  706413
  787536
  788210
  812282
  441118
  814186
  464648
  678850
  710068
  719422
  638916
  609555
  629557
  640366
  600590
  777875
  791552
  742066
  746791
  793128
  796397
  750655
  617504
  787812
  820171
  533400
  588363
  610065
  796193
  801999
  810082
  777869
  731766
  732162
  747482
  782520
  577128
  745470
  783169
  403582
  827077
  474721
  532616
  558590
  580934
  680455
  680597
  680615
  699066
  684874
  684501
  708536
  710802
  583727
  589593
  586891
  639981
  592325
  775653
  789538
  800528
  775611
  784106
  796404
  797083
  803479
  760158
  742346
  750276
  773855
  739482
  744205
  765546
  763966
  784710
  803732
  809911
  478288
  479839
  557640
  572921
]
4.20 ms
(2.22%)
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
  402083
  403582
  411516
  441118
  464648
  474721
  478288
  479839
  532616
  533400
  538469
  556447
  557640
  558590
  572921
  577128
  580934
  583727
  586891
  588363
  589593
  589652
  592325
  593196
  600590
  603125
  609555
  610065
  611285
  614072
  617504
  622750
  629557
  638187
  638916
  639981
  640366
  642314
  643706
  678850
  680455
  680597
  680615
  684501
  684874
  693360
  695549
  699066
  701235
  706413
  708536
  710068
  710802
  719422
  728464
  731766
  732162
  739482
  742066
  742346
  742822
  742972
  744205
  745470
  746791
  747482
  749041
  750276
  750529
  750655
  760158
  760503
  763966
  765546
  769089
  772454
  773029
  773198
  773855
  775611
  775653
  777800
  777867
  777869
  777875
  777884
  782520
  782949
  783169
  784106
  784710
  787536
  787812
  788210
  788987
  789538
  791223
  791552
  793128
  796193
  796397
  796404
  797083
  800528
  801833
  801999
  803479
  803732
  803980
  804246
  806009
  809911
  810082
  812282
  814186
  817685
  820088
  820171
  826804
  827077
]
2.09 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl fingering"
]
1.81 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк fingering"
]
1.37 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк fingering"
]

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.