GET https://search.jues.net/search/embeds/8?q=girls%20hot

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.40 ms
(85.86%)
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
  30515
  383646
  399061
  422350
  448081
  464803
  467268
  476662
  488912
  529594
  529610
  535780
  540706
  553675
  554919
  559171
  572388
  577550
  589525
  590489
  600096
  600469
  600831
  620431
  620995
  625231
  627961
  628597
  631917
  639089
  643918
  645354
  650317
  652528
  663249
  664993
  668842
  670815
  674873
  689567
  694147
  696065
  698233
  700860
  706228
  715004
  717806
  727627
  731094
  734453
  734801
  737370
  738147
  738517
  740082
  740182
  742275
  742951
  744713
  747055
  749145
  749526
  750671
  752112
  752221
  752912
  754605
  754654
  756396
  758604
  758630
  762945
  764262
  766370
  767899
  769046
  769073
  771785
  777873
  778084
  778478
  778600
  779123
  780061
  780452
  781172
  781184
  781491
  784290
  785486
  785735
  787167
  787436
  789454
  789825
  791676
  792327
  794889
  794912
  797408
  799468
  801690
  804131
  805682
  808479
  812319
  819437
  819634
  819978
  820534
  821124
  822435
  822677
  822686
  822720
  825335
  827167
  827241
  827559
  828847
]
11.32 ms
(7.07%)
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
  30515
  399061
  825335
  819634
  819978
  820534
  821124
  822677
  827167
  827241
  822435
  819437
  822686
  822720
  828847
  827559
  476662
  448081
  529594
  540706
  529610
  535780
  464803
  559171
  554919
  572388
  664993
  696065
  706228
  652528
  668842
  674873
  694147
  650317
  663249
  670815
  689567
  698233
  700860
  715004
  553675
  577550
  589525
  620431
  628597
  643918
  600831
  627961
  600096
  600469
  631917
  639089
  778084
  778600
  781172
  785486
  787167
  794912
  797408
  801690
  779123
  780061
  780452
  781184
  785735
  791676
  794889
  812319
  727627
  734801
  737370
  738147
  747055
  749145
  750671
  752221
  762945
  769073
  781491
  784290
  787436
  789825
  792327
  808479
  731094
  734453
  740182
  742951
  749526
  766370
  767899
  769046
  738517
  742275
  752112
  754654
  758604
  758630
  771785
  754605
  740082
  744713
  752912
  756396
  764262
  625231
  717806
  777873
  778478
  789454
  799468
  804131
  805682
  422350
  467268
  488912
  590489
  620995
  383646
  645354
]
3.28 ms
(2.05%)
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
  30515
  383646
  399061
  422350
  448081
  464803
  467268
  476662
  488912
  529594
  529610
  535780
  540706
  553675
  554919
  559171
  572388
  577550
  589525
  590489
  600096
  600469
  600831
  620431
  620995
  625231
  627961
  628597
  631917
  639089
  643918
  645354
  650317
  652528
  663249
  664993
  668842
  670815
  674873
  689567
  694147
  696065
  698233
  700860
  706228
  715004
  717806
  727627
  731094
  734453
  734801
  737370
  738147
  738517
  740082
  740182
  742275
  742951
  744713
  747055
  749145
  749526
  750671
  752112
  752221
  752912
  754605
  754654
  756396
  758604
  758630
  762945
  764262
  766370
  767899
  769046
  769073
  771785
  777873
  778084
  778478
  778600
  779123
  780061
  780452
  781172
  781184
  781491
  784290
  785486
  785735
  787167
  787436
  789454
  789825
  791676
  792327
  794889
  794912
  797408
  799468
  801690
  804131
  805682
  808479
  812319
  819437
  819634
  819978
  820534
  821124
  822435
  822677
  822686
  822720
  825335
  827167
  827241
  827559
  828847
]
2.19 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.17 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls hot"
]
1.91 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк hot"
]
1.76 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.