GET https://search.jues.net/search/embeds/5?q=skinny%20hot

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.23 ms
(88.72%)
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
  6840
  233364
  359723
  383244
  393701
  395372
  396762
  397307
  398604
  402036
  412207
  417673
  420086
  421518
  424757
  437809
  465936
  466930
  475317
  477202
  478545
  483093
  485466
  489088
  492234
  498332
  500891
  504720
  505867
  506290
  525988
  530661
  532493
  538420
  539218
  544058
  546049
  550589
  550677
  558272
  559388
  559721
  559889
  560299
  560753
  561124
  567305
  570296
  570383
  570874
  574864
  586562
  589577
  591276
  592708
  593082
  594515
  595424
  598135
  599602
  600307
  600805
  603005
  607149
  608233
  617319
  618061
  621081
  622510
  624665
  626928
  627656
  630313
  653497
  667562
  681203
  683303
  689310
  689758
  695775
  696563
  720168
  725111
  727890
  728166
  729065
  737828
  741083
  741167
  742942
  743937
  744242
  747637
  750448
  755352
  757201
  763447
  763869
  765196
  768831
  769868
  770419
  777110
  785595
  790047
  791681
  792460
  799153
  799260
  806331
  806474
  810349
  810478
  814295
  815094
  815127
  818523
  820938
  826972
]
9.70 ms
(5.34%)
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
  683303
  695775
  696563
  720168
  653497
  667562
  681203
  689310
  689758
  546049
  559388
  559721
  559889
  561124
  570296
  570383
  570874
  594515
  600805
  608233
  617319
  589577
  592708
  595424
  600307
  618061
  624665
  586562
  591276
  593082
  603005
  621081
  622510
  626928
  630313
  598135
  599602
  627656
  777110
  792460
  791681
  810478
  725111
  729065
  750448
  757201
  799260
  806331
  810349
  727890
  737828
  741167
  744242
  747637
  769868
  728166
  763447
  765196
  768831
  742942
  743937
  755352
  763869
  741083
  770419
  607149
  785595
  790047
  799153
  806474
  383244
  395372
  396762
  6840
  359723
  420086
  465936
  233364
  397307
  398604
  417673
  437809
  500891
  532493
  505867
  485466
  530661
  466930
  574864
  492234
  393701
  402036
  421518
  412207
  424757
  815094
  815127
  814295
  818523
  820938
  826972
  483093
  489088
  475317
  477202
  478545
  506290
  525988
  539218
  538420
  498332
  504720
  558272
  560299
  560753
  567305
  569904
  544058
  550589
  550677
]
3.90 ms
(2.15%)
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
  6840
  233364
  359723
  383244
  393701
  395372
  396762
  397307
  398604
  402036
  412207
  417673
  420086
  421518
  424757
  437809
  465936
  466930
  475317
  477202
  478545
  483093
  485466
  489088
  492234
  498332
  500891
  504720
  505867
  506290
  525988
  530661
  532493
  538420
  539218
  544058
  546049
  550589
  550677
  558272
  559388
  559721
  559889
  560299
  560753
  561124
  567305
  570296
  570383
  570874
  574864
  586562
  589577
  591276
  592708
  593082
  594515
  595424
  598135
  599602
  600307
  600805
  603005
  607149
  608233
  617319
  618061
  621081
  622510
  624665
  626928
  627656
  630313
  653497
  667562
  681203
  683303
  689310
  689758
  695775
  696563
  720168
  725111
  727890
  728166
  729065
  737828
  741083
  741167
  742942
  743937
  744242
  747637
  750448
  755352
  757201
  763447
  763869
  765196
  768831
  769868
  770419
  777110
  785595
  790047
  791681
  792460
  799153
  799260
  806331
  806474
  810349
  810478
  814295
  815094
  815127
  818523
  820938
  826972
]
1.79 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny hot"
]
1.72 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые hot"
]
1.65 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые hot"
]

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.