Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.72 ms
(85.16%)
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
  66540
  69842
  69883
  259942
  386339
  388897
  391880
  396916
  398369
  401119
  405832
  417554
  419175
  433072
  444808
  455525
  457321
  488565
  490482
  492592
  495517
  503029
  505917
  508974
  509963
  514013
  514022
  517414
  523021
  532137
  535790
  540606
  541034
  543153
  548692
  549202
  550358
  554122
  554875
  555936
  556704
  558358
  562412
  562966
  563962
  565471
  566701
  567619
  572222
  572242
  576768
  580031
  584574
  586614
  603967
  608695
  609827
  614893
  615590
  618147
  618206
  618489
  620309
  629740
  631125
  632783
  634599
  646359
  657787
  674266
  679578
  682618
  689020
  690281
  696127
  702926
  703762
  703828
  709574
  714359
  718224
  718400
  718533
  718626
  719215
  719284
  723156
  724810
  730717
  730754
  733040
  735841
  736154
  738560
  744517
  745336
  746930
  747684
  755605
  768300
  769194
  773845
  776191
  777122
  779783
  780202
  781007
  783217
  784056
  786206
  787269
  788015
  789362
  793049
  793338
  793932
  794401
  795894
  801622
  801672
]
10.56 ms
(7.57%)
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
  508974
  608695
  788015
  793049
  632783
  548692
  586614
  609827
  444808
  492592
  768300
  503029
  69883
  777122
  457321
  433072
  558358
  562966
  620309
  784056
  69842
  517414
  419175
  505917
  490482
  514013
  514022
  618206
  776191
  783217
  540606
  549202
  543153
  567619
  576768
  696127
  703828
  714359
  718400
  580031
  618147
  629740
  614893
  618489
  634599
  795894
  780202
  786206
  789362
  794401
  801672
  733040
  724810
  744517
  747684
  769194
  730754
  735841
  746930
  755605
  773845
  745336
  631125
  781007
  787269
  793932
  398369
  388897
  690281
  603967
  386339
  509963
  535790
  719215
  779783
  793338
  730717
  738560
  532137
  615590
  565471
  66540
  736154
  801622
  455525
  555936
  562412
  682618
  556704
  401119
  572242
  523021
  391880
  259942
  396916
  405832
  417554
  488565
  495517
  584574
  554122
  554875
  563962
  541034
  550358
  679578
  689020
  718224
  657787
  674266
  709574
  718533
  719284
  646359
  702926
  703762
  718626
  723156
  566701
  572222
]
2.62 ms
(1.88%)
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
  66540
  69842
  69883
  259942
  386339
  388897
  391880
  396916
  398369
  401119
  405832
  417554
  419175
  433072
  444808
  455525
  457321
  488565
  490482
  492592
  495517
  503029
  505917
  508974
  509963
  514013
  514022
  517414
  523021
  532137
  535790
  540606
  541034
  543153
  548692
  549202
  550358
  554122
  554875
  555936
  556704
  558358
  562412
  562966
  563962
  565471
  566701
  567619
  572222
  572242
  576768
  580031
  584574
  586614
  603967
  608695
  609827
  614893
  615590
  618147
  618206
  618489
  620309
  629740
  631125
  632783
  634599
  646359
  657787
  674266
  679578
  682618
  689020
  690281
  696127
  702926
  703762
  703828
  709574
  714359
  718224
  718400
  718533
  718626
  719215
  719284
  723156
  724810
  730717
  730754
  733040
  735841
  736154
  738560
  744517
  745336
  746930
  747684
  755605
  768300
  769194
  773845
  776191
  777122
  779783
  780202
  781007
  783217
  784056
  786206
  787269
  788015
  789362
  793049
  793338
  793932
  794401
  795894
  801622
  801672
]
2.13 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончил в тот"
]
1.94 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в"
]
1.56 ms
(1.12%)
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.