Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.17 ms
(85.88%)
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
  145646
  145922
  397207
  398979
  409316
  415594
  424407
  424423
  426840
  429211
  429879
  430244
  430430
  435376
  440641
  442442
  443709
  443824
  445599
  454187
  454193
  454561
  465068
  465134
  466389
  466402
  466405
  468500
  470979
  471030
  471032
  475590
  475656
  475682
  475688
  484277
  485363
  485423
  488993
  490446
  490595
  490598
  496056
  498873
  499568
  505388
  505970
  506061
  506836
  510779
  513001
  514250
  515883
  523031
  527258
  529650
  530429
  537577
  541422
  544263
  546016
  546433
  546634
  546921
  550357
  550367
  555330
  555438
  557706
  559416
  560828
  563900
  566770
  572186
  577692
  578780
  583164
  583875
  591743
  592214
  592975
  593052
  599239
  604612
  605080
  606254
  619472
  661906
  665822
  675541
  714597
  714605
  716975
  722063
  723950
  725422
  730190
  732971
  743019
  743932
  745335
  746885
  787756
  794965
  795716
  798772
  802997
  811155
  818252
  819988
  820365
  824595
  825162
  825170
  825259
  825711
  825959
  826203
  826695
  828650
]
15.47 ms
(8.56%)
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
  505388
  505970
  468500
  485423
  488993
  546921
  546634
  566770
  555330
  572186
  578780
  606254
  409316
  424423
  435376
  445599
  454193
  475688
  397207
  424407
  440641
  454187
  465134
  470979
  471032
  475590
  475656
  426840
  429879
  430430
  442442
  443824
  454561
  145922
  415594
  429211
  465068
  471030
  443709
  466402
  515883
  490446
  523031
  485363
  496056
  506061
  484277
  498873
  506836
  541422
  430244
  490598
  514250
  530429
  499568
  546016
  557706
  583164
  665822
  675541
  550357
  560828
  577692
  592975
  599239
  787756
  466405
  398979
  527258
  490595
  475682
  818252
  819988
  825170
  828650
  563900
  619472
  725422
  745335
  732971
  604612
  145646
  510779
  550367
  466389
  513001
  820365
  825959
  824595
  826695
  825162
  826203
  825711
  825259
  529650
  537577
  559416
  544263
  661906
  714605
  716975
  714597
  722063
  546433
  555438
  583875
  605080
  591743
  593052
  592214
  811155
  794965
  795716
  798772
  730190
  802997
  746885
  723950
  743019
  743932
]
2.70 ms
(1.49%)
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
  145646
  145922
  397207
  398979
  409316
  415594
  424407
  424423
  426840
  429211
  429879
  430244
  430430
  435376
  440641
  442442
  443709
  443824
  445599
  454187
  454193
  454561
  465068
  465134
  466389
  466402
  466405
  468500
  470979
  471030
  471032
  475590
  475656
  475682
  475688
  484277
  485363
  485423
  488993
  490446
  490595
  490598
  496056
  498873
  499568
  505388
  505970
  506061
  506836
  510779
  513001
  514250
  515883
  523031
  527258
  529650
  530429
  537577
  541422
  544263
  546016
  546433
  546634
  546921
  550357
  550367
  555330
  555438
  557706
  559416
  560828
  563900
  566770
  572186
  577692
  578780
  583164
  583875
  591743
  592214
  592975
  593052
  599239
  604612
  605080
  606254
  619472
  661906
  665822
  675541
  714597
  714605
  716975
  722063
  723950
  725422
  730190
  732971
  743019
  743932
  745335
  746885
  787756
  794965
  795716
  798772
  802997
  811155
  818252
  819988
  820365
  824595
  825162
  825170
  825259
  825711
  825959
  826203
  826695
  828650
]
2.08 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf hairy"
]
1.92 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf волосатая"
]
1.67 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf волосатая"
]

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.