Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.23 ms
(82.47%)
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
  387125
  387874
  390934
  393476
  403725
  421845
  421865
  424121
  426703
  426865
  427585
  432737
  434067
  436138
  441288
  446179
  447588
  448511
  452772
  454623
  455787
  456573
  456591
  457441
  459134
  461843
  463848
  465324
  465773
  465807
  466284
  470572
  479583
  490235
  490529
  493670
  508569
  511811
  512010
  512613
  523743
  524070
  529597
  534432
  537960
  538011
  544988
  545183
  545936
  546310
  552294
  556474
  563025
  565496
  566843
  568960
  571415
  579821
  587908
  590775
  599002
  612718
  614915
  617683
  623699
  633935
  639222
  640060
  644106
  649244
  650262
  650722
  652760
  655241
  655293
  657466
  662509
  663738
  672291
  673934
  683357
  710687
  717241
  720410
  720952
  723662
  728762
  739164
  742852
  751120
  760962
  764240
  765366
  765743
  765819
  767055
  772661
  775543
  777737
  778628
  782674
  788838
  791426
  793196
  794873
  798801
  800336
  800380
  800407
  800592
  800785
  801101
  801634
  804325
  804905
  806838
  807032
  815131
  817155
  819705
]
15.69 ms
(10.50%)
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
  728762
  739164
  804325
  544988
  650722
  655293
  683357
  720952
  672291
  650262
  662509
  673934
  546310
  571415
  644106
  587908
  590775
  614915
  623699
  633935
  777737
  778628
  793196
  798801
  775543
  782674
  794873
  800336
  800407
  764240
  765366
  765819
  767055
  772661
  640060
  717241
  791426
  800785
  817155
  493670
  807032
  760962
  390934
  448511
  490529
  470572
  511811
  568960
  545183
  579821
  751120
  447588
  463848
  466284
  479583
  436138
  456591
  446179
  454623
  441288
  512010
  537960
  523743
  534432
  556474
  465324
  508569
  742852
  801101
  815131
  545936
  804905
  403725
  599002
  421865
  426865
  465807
  512613
  387125
  387874
  652760
  617683
  806838
  723662
  720410
  639222
  612718
  800592
  765743
  710687
  788838
  393476
  819705
  529597
  649244
  655241
  663738
  801634
  800380
  457441
  657466
  434067
  432737
  563025
  552294
  565496
  566843
  426703
  455787
  459134
  465773
  424121
  452772
  456573
  427585
  421845
  461843
  490235
  538011
  524070
]
3.10 ms
(2.07%)
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
  387125
  387874
  390934
  393476
  403725
  421845
  421865
  424121
  426703
  426865
  427585
  432737
  434067
  436138
  441288
  446179
  447588
  448511
  452772
  454623
  455787
  456573
  456591
  457441
  459134
  461843
  463848
  465324
  465773
  465807
  466284
  470572
  479583
  490235
  490529
  493670
  508569
  511811
  512010
  512613
  523743
  524070
  529597
  534432
  537960
  538011
  544988
  545183
  545936
  546310
  552294
  556474
  563025
  565496
  566843
  568960
  571415
  579821
  587908
  590775
  599002
  612718
  614915
  617683
  623699
  633935
  639222
  640060
  644106
  649244
  650262
  650722
  652760
  655241
  655293
  657466
  662509
  663738
  672291
  673934
  683357
  710687
  717241
  720410
  720952
  723662
  728762
  739164
  742852
  751120
  760962
  764240
  765366
  765743
  765819
  767055
  772661
  775543
  777737
  778628
  782674
  788838
  791426
  793196
  794873
  798801
  800336
  800380
  800407
  800592
  800785
  801101
  801634
  804325
  804905
  806838
  807032
  815131
  817155
  819705
]
2.16 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal doggy pov"
]
1.85 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал рак пов"
]
1.77 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.09%)
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.