GET https://search.jues.net/search/embeds/2?q=sex%20in%20hotel

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.90 ms
(88.75%)
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
  152129
  152762
  185247
  381887
  387868
  397349
  397633
  435244
  442611
  444296
  459735
  472856
  474421
  485069
  495434
  503739
  506564
  526330
  527679
  530287
  533162
  540934
  542813
  567454
  574223
  578690
  579752
  596986
  597429
  600855
  603368
  603633
  605378
  618069
  620410
  630672
  649776
  651393
  662903
  669328
  671901
  675926
  698220
  705418
  708855
  710294
  715468
  717833
  718240
  718453
  718972
  720666
  722426
  723831
  723878
  724227
  726755
  728653
  732491
  733481
  735917
  736167
  743926
  745883
  745889
  749537
  754871
  757629
  757651
  762063
  764388
  765838
  766210
  771778
  773782
  779130
  779875
  779897
  782897
  789348
  789611
  790161
  794747
  795197
  795429
  796000
  798793
  799089
  805018
  807784
  810151
  812133
  813475
  813655
  813700
  814101
  817429
  817686
  817691
  817701
  817710
  818043
  819020
  819201
  819206
  819266
  819527
  820781
  823055
  823352
  823476
  825023
  825070
  825302
  826735
  827167
  827481
  828053
  828123
]
11.44 ms
(6.01%)
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
  474421
  444296
  435244
  442611
  495434
  527679
  675926
  605378
  503739
  397349
  526330
  798793
  817429
  649776
  387868
  819266
  825302
  618069
  567454
  828123
  698220
  717833
  814101
  723831
  749537
  720666
  779130
  779897
  823476
  826735
  542813
  812133
  820781
  603368
  795197
  152129
  819201
  506564
  540934
  708855
  671901
  620410
  764388
  732491
  828053
  579752
  796000
  754871
  813475
  813655
  827481
  817691
  669328
  597429
  765838
  766210
  794747
  818043
  819206
  819527
  718240
  710294
  728653
  762131
  743926
  762063
  705418
  789611
  807784
  718972
  745889
  745883
  771778
  459735
  472856
  574223
  715468
  596986
  600855
  805018
  810151
  779875
  789348
  723878
  757651
  630672
  825023
  485069
  381887
  823055
  827167
  823352
  718453
  782897
  736167
  733481
  724227
  152762
  817710
  825070
  533162
  757629
  735917
  773782
  726755
  603633
  799089
  722426
  185247
  817701
  530287
  790161
  651393
  795429
  397633
  817686
  819020
  813700
  578690
  662903
]
3.39 ms
(1.78%)
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
  152129
  152762
  185247
  381887
  387868
  397349
  397633
  435244
  442611
  444296
  459735
  472856
  474421
  485069
  495434
  503739
  506564
  526330
  527679
  530287
  533162
  540934
  542813
  567454
  574223
  578690
  579752
  596986
  597429
  600855
  603368
  603633
  605378
  618069
  620410
  630672
  649776
  651393
  662903
  669328
  671901
  675926
  698220
  705418
  708855
  710294
  715468
  717833
  718240
  718453
  718972
  720666
  722426
  723831
  723878
  724227
  726755
  728653
  732491
  733481
  735917
  736167
  743926
  745883
  745889
  749537
  754871
  757629
  757651
  762063
  764388
  765838
  766210
  771778
  773782
  779130
  779875
  779897
  782897
  789348
  789611
  790161
  794747
  795197
  795429
  796000
  798793
  799089
  805018
  807784
  810151
  812133
  813475
  813655
  813700
  814101
  817429
  817686
  817691
  817701
  817710
  818043
  819020
  819201
  819206
  819266
  819527
  820781
  823055
  823352
  823476
  825023
  825070
  825302
  826735
  827167
  827481
  828053
  828123
]
1.87 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex in hotel"
]
1.73 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс hotel"
]
1.66 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс hotel"
]

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.