Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.74 ms
(82.50%)
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
  102147
  361993
  395233
  401073
  410724
  411289
  414098
  417095
  419429
  424324
  426159
  428681
  429086
  429313
  431372
  441049
  444283
  444842
  445035
  445211
  445373
  446108
  447631
  449687
  450434
  452760
  455258
  456638
  457751
  458125
  460710
  461673
  465171
  465185
  470313
  470842
  472447
  473080
  474383
  474712
  482081
  482793
  483551
  488152
  489486
  489618
  489627
  489630
  490694
  491650
  492511
  495820
  497096
  498518
  504553
  505103
  506189
  508457
  508502
  511044
  515590
  519886
  523066
  524533
  525019
  525213
  525556
  526356
  529120
  529204
  530385
  531198
  532252
  533877
  533937
  534787
  536673
  537966
  547823
  548034
  558568
  558645
  558840
  565188
  567272
  569457
  569926
  573298
  576036
  576065
  578409
  594503
  595687
  596160
  597793
  599711
  614605
  618883
  624834
  624933
  630018
  633085
  637520
  638327
  653726
  674507
  679821
  691221
  721780
  741605
  756345
  757157
  759639
  770404
  774009
  788315
  788604
  802117
  814506
  814825
]
18.20 ms
(11.23%)
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
  741605
  756345
  757157
  770404
  630018
  638327
  721780
  429313
  445035
  102147
  449687
  473080
  455258
  515590
  498518
  504553
  523066
  525213
  488152
  489630
  511044
  788604
  759639
  624834
  419429
  429086
  411289
  428681
  444283
  417095
  814506
  814825
  482793
  447631
  474712
  450434
  505103
  533877
  533937
  526356
  534787
  548034
  565188
  578409
  558568
  576036
  653726
  674507
  558645
  567272
  595687
  624933
  637520
  594503
  596160
  614605
  597793
  618883
  633085
  802117
  774009
  788315
  465185
  401073
  452760
  470313
  474383
  482081
  456638
  361993
  395233
  444842
  431372
  445211
  446108
  489627
  506189
  525019
  489486
  489618
  491650
  508502
  529204
  483551
  490694
  495820
  497096
  508457
  426159
  424324
  410724
  441049
  414098
  445373
  472447
  458125
  465171
  470842
  492511
  457751
  460710
  461673
  525556
  529120
  530385
  537966
  536673
  524533
  532252
  519886
  531198
  558840
  573298
  576065
  547823
  691221
  679821
  569457
  569926
  599711
]
2.55 ms
(1.57%)
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
  102147
  361993
  395233
  401073
  410724
  411289
  414098
  417095
  419429
  424324
  426159
  428681
  429086
  429313
  431372
  441049
  444283
  444842
  445035
  445211
  445373
  446108
  447631
  449687
  450434
  452760
  455258
  456638
  457751
  458125
  460710
  461673
  465171
  465185
  470313
  470842
  472447
  473080
  474383
  474712
  482081
  482793
  483551
  488152
  489486
  489618
  489627
  489630
  490694
  491650
  492511
  495820
  497096
  498518
  504553
  505103
  506189
  508457
  508502
  511044
  515590
  519886
  523066
  524533
  525019
  525213
  525556
  526356
  529120
  529204
  530385
  531198
  532252
  533877
  533937
  534787
  536673
  537966
  547823
  548034
  558568
  558645
  558840
  565188
  567272
  569457
  569926
  573298
  576036
  576065
  578409
  594503
  595687
  596160
  597793
  599711
  614605
  618883
  624834
  624933
  630018
  633085
  637520
  638327
  653726
  674507
  679821
  691221
  721780
  741605
  756345
  757157
  759639
  770404
  774009
  788315
  788604
  802117
  814506
  814825
]
2.20 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "petite pussy"
]
1.89 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "petite pussy"
]
1.86 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "petite 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.