Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.87 ms
(85.38%)
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
  391317
  398302
  418718
  444516
  448998
  454597
  454761
  456245
  470315
  476150
  484934
  493715
  500320
  505331
  513758
  515270
  515524
  527504
  528062
  528985
  529638
  529639
  530968
  530969
  531369
  531655
  531767
  532884
  533405
  533428
  536100
  537774
  538395
  538469
  539500
  541306
  541750
  542704
  548945
  548969
  549097
  550800
  553547
  554827
  556252
  558402
  560345
  565610
  573977
  576534
  582836
  583619
  585845
  585869
  586127
  587241
  587452
  588583
  589847
  589894
  590295
  591089
  594303
  594312
  594601
  595438
  596039
  600423
  604110
  604659
  613503
  614559
  619242
  626751
  627875
  628205
  634037
  635724
  639112
  650495
  653954
  655011
  658845
  661676
  666858
  671098
  671773
  671808
  671977
  680797
  680801
  681358
  683296
  686139
  691790
  692691
  701313
  701962
  702357
  703235
  704065
  704698
  707819
  708697
  710068
  739804
  765251
  765256
  776057
  782436
  783567
  783711
  785855
  788321
  792067
  793266
  796686
  803092
  803378
  823020
]
11.87 ms
(8.12%)
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
  691790
  553547
  556252
  585845
  639112
  591089
  604659
  776057
  796686
  765251
  765256
  739804
  613503
  702357
  703235
  803092
  803378
  454597
  476150
  391317
  398302
  470315
  515524
  456245
  628205
  513758
  505331
  484934
  527504
  594601
  594312
  448998
  418718
  444516
  530969
  536100
  558402
  594303
  823020
  454761
  493715
  529638
  529639
  530968
  531369
  532884
  538395
  515270
  528985
  531767
  538469
  539500
  500320
  528062
  531655
  533428
  533405
  537774
  541750
  542704
  548945
  565610
  541306
  549097
  560345
  582836
  583619
  650495
  658845
  661676
  666858
  671098
  671773
  671808
  692691
  701962
  704698
  653954
  680797
  683296
  686139
  704065
  655011
  671977
  680801
  681358
  701313
  707819
  708697
  710068
  548969
  550800
  554827
  573977
  576534
  586127
  587241
  600423
  604110
  614559
  634037
  590295
  595438
  619242
  635724
  585869
  588583
  589894
  627875
  587452
  589847
  596039
  626751
  783567
  783711
  785855
  788321
  792067
  793266
  782436
]
2.48 ms
(1.70%)
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
  391317
  398302
  418718
  444516
  448998
  454597
  454761
  456245
  470315
  476150
  484934
  493715
  500320
  505331
  513758
  515270
  515524
  527504
  528062
  528985
  529638
  529639
  530968
  530969
  531369
  531655
  531767
  532884
  533405
  533428
  536100
  537774
  538395
  538469
  539500
  541306
  541750
  542704
  548945
  548969
  549097
  550800
  553547
  554827
  556252
  558402
  560345
  565610
  573977
  576534
  582836
  583619
  585845
  585869
  586127
  587241
  587452
  588583
  589847
  589894
  590295
  591089
  594303
  594312
  594601
  595438
  596039
  600423
  604110
  604659
  613503
  614559
  619242
  626751
  627875
  628205
  634037
  635724
  639112
  650495
  653954
  655011
  658845
  661676
  666858
  671098
  671773
  671808
  671977
  680797
  680801
  681358
  683296
  686139
  691790
  692691
  701313
  701962
  702357
  703235
  704065
  704698
  707819
  708697
  710068
  739804
  765251
  765256
  776057
  782436
  783567
  783711
  785855
  788321
  792067
  793266
  796686
  803092
  803378
  823020
]
2.00 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло teen вагин"
]
1.76 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo teen vagina"
]
1.71 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло teen вагин"
]
1.55 ms
(1.06%)
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.