Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.86 ms
(88.83%)
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
  391893
  396903
  405423
  454492
  456168
  474014
  474029
  504228
  530289
  533523
  535585
  535602
  536305
  536544
  538043
  543421
  544661
  545080
  545085
  547946
  548756
  554811
  554816
  561046
  563644
  575667
  578656
  582772
  582864
  587537
  587689
  593884
  593885
  601361
  601368
  602986
  603620
  603798
  604987
  605583
  605701
  606064
  606471
  606497
  606521
  607511
  610814
  616688
  621777
  622086
  622089
  622119
  622154
  624985
  624998
  625307
  630264
  630578
  632250
  633179
  635384
  635787
  635789
  635791
  635831
  635877
  642524
  645493
  648984
  649276
  650700
  650978
  651287
  651317
  651420
  653175
  653593
  653620
  653712
  653889
  653915
  654217
  654276
  659007
  662019
  667075
  671243
  673533
  676554
  677584
  681530
  682291
  692457
  693789
  694027
  694310
  694346
  696794
  697153
  705398
  707297
  711013
  712892
  714279
  716416
  717385
  719858
  723476
  723691
  727722
  731157
  732850
  733031
  736727
  747760
  749817
  750741
  753690
  755121
  762269
]
10.71 ms
(5.54%)
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
  707297
  650700
  653915
  662019
  676554
  694310
  714279
  545080
  587537
  587689
  603798
  607511
  610814
  622154
  635789
  635791
  593884
  604987
  606521
  635877
  602986
  603620
  630578
  582772
  716416
  723476
  719858
  723691
  731157
  747760
  749817
  750741
  727722
  753690
  755121
  530289
  456168
  543421
  535602
  732850
  575667
  651287
  693789
  653620
  538043
  547946
  545085
  554816
  548756
  474014
  474029
  504228
  622089
  454492
  396903
  717385
  733031
  391893
  762269
  533523
  535585
  536544
  544661
  554811
  563644
  561046
  582864
  651420
  653712
  653889
  671243
  692457
  694027
  694346
  645493
  648984
  649276
  650978
  651317
  653175
  654217
  667075
  677584
  682291
  697153
  705398
  712892
  653593
  654276
  659007
  681530
  696794
  578656
  593885
  601368
  606064
  616688
  621777
  622086
  624998
  625307
  633179
  635384
  642524
  601361
  622119
  632250
  635831
  605583
  606471
  624985
  630264
  635787
  605701
  606497
  736727
  711013
  673533
  405423
  536305
]
3.81 ms
(1.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur homemade swinger"
]
2.58 ms
(1.33%)
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
  391893
  396903
  405423
  454492
  456168
  474014
  474029
  504228
  530289
  533523
  535585
  535602
  536305
  536544
  538043
  543421
  544661
  545080
  545085
  547946
  548756
  554811
  554816
  561046
  563644
  575667
  578656
  582772
  582864
  587537
  587689
  593884
  593885
  601361
  601368
  602986
  603620
  603798
  604987
  605583
  605701
  606064
  606471
  606497
  606521
  607511
  610814
  616688
  621777
  622086
  622089
  622119
  622154
  624985
  624998
  625307
  630264
  630578
  632250
  633179
  635384
  635787
  635789
  635791
  635831
  635877
  642524
  645493
  648984
  649276
  650700
  650978
  651287
  651317
  651420
  653175
  653593
  653620
  653712
  653889
  653915
  654217
  654276
  659007
  662019
  667075
  671243
  673533
  676554
  677584
  681530
  682291
  692457
  693789
  694027
  694310
  694346
  696794
  697153
  705398
  707297
  711013
  712892
  714279
  716416
  717385
  719858
  723476
  723691
  727722
  731157
  732850
  733031
  736727
  747760
  749817
  750741
  753690
  755121
  762269
]
1.56 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск домашн любительск свингер"
]
1.50 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.75%)
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.