GET https://search.jues.net/search/embeds/8?q=amateur%20bathroom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.02 ms
(83.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
  8900
  328286
  389935
  395769
  405761
  412078
  423468
  424141
  427057
  427148
  427771
  433904
  436452
  441762
  447642
  453210
  457686
  459109
  459887
  469308
  472381
  472772
  474199
  480314
  502350
  503648
  506833
  507637
  514034
  519804
  521663
  523979
  530937
  530980
  539316
  552844
  554123
  563296
  577188
  577897
  581994
  586279
  591803
  593195
  593741
  599653
  600936
  601343
  606796
  611347
  611402
  611474
  616108
  618000
  618533
  625022
  625038
  626477
  627961
  627962
  629309
  637463
  639657
  646154
  653824
  660818
  666358
  668467
  670825
  670942
  676679
  680675
  683260
  686331
  687957
  692718
  694870
  698723
  701938
  701976
  703689
  706545
  706666
  707388
  718338
  718908
  719817
  732142
  736385
  743640
  744094
  744131
  745360
  745954
  751170
  752619
  758386
  762892
  763496
  765980
  768978
  769197
  786545
  789635
  790399
  793011
  794011
  796971
  800134
  802244
  803915
  807070
  811541
  811816
  811864
  811900
  820134
  825904
  826544
]
13.26 ms
(9.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
  328286
  8900
  405761
  427771
  427148
  427057
  441762
  459109
  514034
  523979
  530937
  719817
  707388
  790399
  744094
  758386
  800134
  807070
  751170
  762892
  763496
  768978
  745954
  752619
  718338
  793011
  802244
  803915
  811816
  412078
  472772
  472381
  459887
  474199
  507637
  457686
  506833
  519804
  563296
  577897
  436452
  447642
  433904
  424141
  521663
  503648
  826544
  825904
  453210
  581994
  718908
  775142
  811541
  796971
  736385
  765980
  743640
  786545
  794011
  811864
  554123
  552844
  577188
  680675
  668467
  599653
  625038
  606796
  745360
  469308
  480314
  539316
  646154
  683260
  701938
  701976
  703689
  653824
  670942
  694870
  706545
  687957
  698723
  616108
  591803
  601343
  611402
  639657
  627962
  629309
  706666
  820134
  789635
  744131
  769197
  686331
  666358
  692718
  593741
  611474
  586279
  600936
  611347
  593195
  618533
  637463
  732142
  625022
  626477
  502350
  811900
  530980
  660818
  670825
  676679
  627961
  618000
  395769
  389935
  423468
]
2.59 ms
(1.86%)
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
  8900
  328286
  389935
  395769
  405761
  412078
  423468
  424141
  427057
  427148
  427771
  433904
  436452
  441762
  447642
  453210
  457686
  459109
  459887
  469308
  472381
  472772
  474199
  480314
  502350
  503648
  506833
  507637
  514034
  519804
  521663
  523979
  530937
  530980
  539316
  552844
  554123
  563296
  577188
  577897
  581994
  586279
  591803
  593195
  593741
  599653
  600936
  601343
  606796
  611347
  611402
  611474
  616108
  618000
  618533
  625022
  625038
  626477
  627961
  627962
  629309
  637463
  639657
  646154
  653824
  660818
  666358
  668467
  670825
  670942
  676679
  680675
  683260
  686331
  687957
  692718
  694870
  698723
  701938
  701976
  703689
  706545
  706666
  707388
  718338
  718908
  719817
  732142
  736385
  743640
  744094
  744131
  745360
  745954
  751170
  752619
  758386
  762892
  763496
  765980
  768978
  769197
  786545
  789635
  790399
  793011
  794011
  796971
  800134
  802244
  803915
  807070
  811541
  811816
  811864
  811900
  820134
  825904
  826544
]
1.83 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur bathroom"
]
1.68 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск ван"
]
1.67 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск ван"
]
1.53 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.