Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
255.30 ms
(87.70%)
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
  389195
  390567
  395818
  396012
  401318
  404353
  412261
  413901
  416303
  417344
  418521
  419619
  420291
  422354
  425523
  425945
  426409
  428372
  430314
  433669
  434000
  442494
  442994
  443796
  445436
  445471
  445543
  447978
  448821
  448845
  451832
  451951
  452161
  454658
  464162
  468630
  469595
  471881
  472319
  475828
  476244
  480059
  483152
  484727
  486182
  486589
  486788
  487343
  487632
  488536
  488734
  491392
  493222
  495401
  496794
  497866
  500694
  504399
  504481
  508180
  510578
  512094
  512355
  514820
  515420
  516040
  516291
  517008
  518996
  519013
  519231
  519942
  522870
  522884
  524982
  524992
  525393
  527428
  529213
  535019
  535023
  535025
  535282
  541698
  541699
  541738
  541886
  556797
  559453
  565172
  573764
  574258
  583533
  586673
  592369
  593441
  597494
  599844
  600506
  607355
  614023
  614401
  619483
  624227
  625342
  628327
  631163
  639760
  639796
  647885
  649953
  666899
  668549
  688624
  689702
  717318
  722373
  809930
  815017
  815600
]
25.71 ms
(8.83%)
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
  497866
  504399
  522870
  389195
  425945
  442494
  442994
  815600
  454658
  471881
  486788
  519231
  527428
  464162
  486182
  666899
  647885
  688624
  573764
  614023
  593441
  586673
  607355
  614401
  717318
  422354
  433669
  452161
  416303
  396012
  417344
  476244
  512355
  522884
  524982
  487632
  495401
  515420
  488536
  500694
  448821
  516291
  541698
  809930
  516040
  541699
  510578
  592369
  597494
  624227
  404353
  445436
  512094
  420291
  451951
  469595
  556797
  395818
  448845
  413901
  517008
  390567
  418521
  419619
  447978
  486589
  514820
  535019
  535025
  504481
  508180
  496794
  525393
  541738
  689702
  565172
  583533
  625342
  599844
  445543
  480059
  425523
  488734
  412261
  434000
  815017
  483152
  491392
  535023
  535282
  493222
  559453
  668549
  722373
  600506
  628327
  619483
  631163
  443796
  426409
  430314
  472319
  519942
  487343
  524992
  428372
  519013
  529213
  541886
  639796
  639760
  475828
  484727
  468630
  649953
  574258
  401318
  451832
  445471
  518996
]
3.04 ms
(1.05%)
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
  389195
  390567
  395818
  396012
  401318
  404353
  412261
  413901
  416303
  417344
  418521
  419619
  420291
  422354
  425523
  425945
  426409
  428372
  430314
  433669
  434000
  442494
  442994
  443796
  445436
  445471
  445543
  447978
  448821
  448845
  451832
  451951
  452161
  454658
  464162
  468630
  469595
  471881
  472319
  475828
  476244
  480059
  483152
  484727
  486182
  486589
  486788
  487343
  487632
  488536
  488734
  491392
  493222
  495401
  496794
  497866
  500694
  504399
  504481
  508180
  510578
  512094
  512355
  514820
  515420
  516040
  516291
  517008
  518996
  519013
  519231
  519942
  522870
  522884
  524982
  524992
  525393
  527428
  529213
  535019
  535023
  535025
  535282
  541698
  541699
  541738
  541886
  556797
  559453
  565172
  573764
  574258
  583533
  586673
  592369
  593441
  597494
  599844
  600506
  607355
  614023
  614401
  619483
  624227
  625342
  628327
  631163
  639760
  639796
  647885
  649953
  666899
  668549
  688624
  689702
  717318
  722373
  809930
  815017
  815600
]
2.00 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy anal pussy"
]
1.69 ms
(0.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая анал pussy"
]
1.49 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая анал pussy"
]

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.