GET https://search.jues.net/search/embeds/5?q=sex%20with%20boss

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.28 ms
(85.06%)
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
  66559
  212138
  237950
  305201
  393424
  396230
  396860
  401334
  403418
  412089
  418542
  428155
  438403
  442188
  449952
  455175
  455186
  466038
  466043
  467050
  469130
  471966
  501556
  505983
  509167
  515606
  515734
  520932
  528614
  534841
  538264
  539537
  541406
  543926
  545493
  552443
  554458
  556669
  556984
  557543
  559907
  566978
  567308
  569954
  578470
  585479
  589141
  596818
  596974
  600811
  600820
  600828
  606754
  609402
  615513
  618538
  619683
  621286
  621464
  621686
  623569
  623991
  637521
  643368
  644375
  650007
  663443
  664815
  665433
  667694
  669774
  671736
  680625
  680754
  695724
  697390
  702065
  709911
  710561
  717692
  718733
  718739
  726977
  727006
  742174
  746571
  750042
  750326
  752153
  755293
  760814
  771291
  772039
  774524
  777361
  780619
  782407
  783281
  786573
  789642
  790640
  792603
  794950
  796243
  798365
  800572
  800982
  805354
  809575
  810071
  810734
  813208
  813385
  813786
  814332
  815095
  815762
  818435
  823644
  823922
]
12.84 ms
(8.25%)
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
  621286
  396860
  455186
  396230
  818435
  815762
  515606
  538264
  539537
  528614
  543926
  585479
  606754
  621686
  805354
  774524
  792603
  796243
  742174
  810734
  237950
  471966
  466043
  823922
  823644
  814332
  665433
  671736
  663443
  717692
  589141
  809575
  813208
  783281
  810071
  755293
  777361
  412089
  467050
  438403
  515734
  212138
  428155
  442188
  505983
  541406
  556984
  718733
  650007
  664815
  697390
  702065
  709911
  596818
  600811
  800982
  771291
  727006
  637521
  813385
  403418
  520932
  534841
  554458
  559907
  578470
  667694
  680754
  556669
  596974
  623991
  789642
  794950
  726977
  752153
  750326
  772039
  623569
  393424
  449952
  305201
  615513
  800572
  66559
  545493
  669774
  600820
  619683
  643368
  790640
  750042
  746571
  401334
  813786
  455175
  501556
  718739
  680625
  557543
  644375
  609402
  786573
  760814
  710561
  782407
  469130
  418542
  466038
  815095
  509167
  566978
  567308
  569954
  695724
  552443
  600828
  621464
  618538
  798365
  780619
]
2.87 ms
(1.84%)
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
  66559
  212138
  237950
  305201
  393424
  396230
  396860
  401334
  403418
  412089
  418542
  428155
  438403
  442188
  449952
  455175
  455186
  466038
  466043
  467050
  469130
  471966
  501556
  505983
  509167
  515606
  515734
  520932
  528614
  534841
  538264
  539537
  541406
  543926
  545493
  552443
  554458
  556669
  556984
  557543
  559907
  566978
  567308
  569954
  578470
  585479
  589141
  596818
  596974
  600811
  600820
  600828
  606754
  609402
  615513
  618538
  619683
  621286
  621464
  621686
  623569
  623991
  637521
  643368
  644375
  650007
  663443
  664815
  665433
  667694
  669774
  671736
  680625
  680754
  695724
  697390
  702065
  709911
  710561
  717692
  718733
  718739
  726977
  727006
  742174
  746571
  750042
  750326
  752153
  755293
  760814
  771291
  772039
  774524
  777361
  780619
  782407
  783281
  786573
  789642
  790640
  792603
  794950
  796243
  798365
  800572
  800982
  805354
  809575
  810071
  810734
  813208
  813385
  813786
  814332
  815095
  815762
  818435
  823644
  823922
]
2.10 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex with boss"
]
1.79 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс boss"
]
1.74 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс boss"
]

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.