Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.91 ms
(88.42%)
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
  391644
  391693
  396056
  398670
  398678
  400029
  402063
  403834
  409685
  417318
  418159
  418774
  422495
  423484
  423670
  424247
  424830
  426499
  432320
  441258
  442611
  442879
  444779
  445444
  446762
  447073
  447183
  448737
  451981
  461090
  476599
  477794
  478131
  478207
  479303
  492708
  492718
  497459
  499441
  503825
  505659
  506544
  513561
  515499
  521568
  526158
  527804
  533649
  538420
  548908
  550403
  552726
  554722
  555693
  555796
  555878
  557405
  557658
  558615
  560783
  565718
  567708
  567733
  570361
  570371
  571254
  571600
  572116
  574571
  580144
  582289
  583426
  585436
  588252
  588266
  590480
  592643
  594608
  598399
  600709
  601237
  602618
  602783
  611299
  615665
  621387
  622308
  623465
  625948
  626209
  634159
  646246
  648288
  661462
  676169
  696225
  705715
  731884
  738260
  739038
  742010
  742011
  743103
  744683
  749723
  760252
  775834
  779010
  780374
  788101
  788247
  789229
  790998
  791359
  791704
  792765
  792789
  797592
  803183
  807681
]
15.09 ms
(7.18%)
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
  461090
  418159
  515499
  565718
  423484
  499441
  398670
  570371
  550403
  557658
  570361
  572116
  594608
  779010
  742011
  402063
  391693
  441258
  583426
  598399
  626209
  477794
  422495
  448737
  476599
  424247
  555796
  426499
  391644
  661462
  775834
  739038
  615665
  478207
  497459
  788247
  797592
  792765
  743103
  601237
  571600
  409685
  451981
  648288
  696225
  600709
  621387
  634159
  588252
  742010
  400029
  418774
  398678
  548908
  585436
  611299
  592643
  442611
  423670
  492708
  506544
  505659
  424830
  442879
  445444
  446762
  479303
  513561
  571254
  580144
  567708
  554722
  557405
  558615
  567733
  588266
  602618
  602783
  791704
  749723
  731884
  744683
  417318
  447073
  432320
  478131
  521568
  526158
  403834
  533649
  503825
  538420
  552726
  555693
  582289
  676169
  705715
  555878
  622308
  625948
  780374
  791359
  807681
  738260
  760252
  623465
  789229
  574571
  790998
  560783
  492718
  788101
  646246
  590480
  792789
  527804
  803183
  447183
  444779
  396056
]
2.30 ms
(1.09%)
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
  391644
  391693
  396056
  398670
  398678
  400029
  402063
  403834
  409685
  417318
  418159
  418774
  422495
  423484
  423670
  424247
  424830
  426499
  432320
  441258
  442611
  442879
  444779
  445444
  446762
  447073
  447183
  448737
  451981
  461090
  476599
  477794
  478131
  478207
  479303
  492708
  492718
  497459
  499441
  503825
  505659
  506544
  513561
  515499
  521568
  526158
  527804
  533649
  538420
  548908
  550403
  552726
  554722
  555693
  555796
  555878
  557405
  557658
  558615
  560783
  565718
  567708
  567733
  570361
  570371
  571254
  571600
  572116
  574571
  580144
  582289
  583426
  585436
  588252
  588266
  590480
  592643
  594608
  598399
  600709
  601237
  602618
  602783
  611299
  615665
  621387
  622308
  623465
  625948
  626209
  634159
  646246
  648288
  661462
  676169
  696225
  705715
  731884
  738260
  739038
  742010
  742011
  743103
  744683
  749723
  760252
  775834
  779010
  780374
  788101
  788247
  789229
  790998
  791359
  791704
  792765
  792789
  797592
  803183
  807681
]
1.95 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые минет оральн секс cum"
]
1.84 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые минет оральн секс cum"
]
1.59 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny blowjob cum"
]

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.