GET https://search.jues.net/search/embeds/6?q=casting%20small%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.31 ms
(84.07%)
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
  383842
  397128
  401738
  406105
  406172
  413393
  414783
  415735
  416090
  417745
  420206
  436358
  447955
  450111
  456639
  457213
  461438
  462091
  462785
  466610
  472755
  475734
  484134
  491516
  492681
  503220
  506387
  508823
  515471
  523066
  528875
  529854
  532249
  532625
  538460
  539938
  550417
  550523
  552899
  556312
  557265
  558040
  558861
  561635
  561702
  562327
  564077
  564114
  564795
  566064
  566067
  567759
  569210
  574867
  576068
  576071
  578420
  583666
  587231
  589796
  593975
  594118
  595427
  596347
  597242
  597251
  597260
  597268
  597269
  597791
  598553
  600246
  600378
  600564
  601512
  601643
  601922
  605105
  605311
  606124
  612022
  615514
  618379
  626185
  634159
  634556
  636272
  636794
  651879
  662407
  672975
  673976
  702939
  703101
  714494
  718647
  720439
  721538
  724659
  725640
  727357
  730579
  730728
  743075
  744917
  747451
  748327
  751220
  751770
  756518
  758961
  759534
  777289
  779234
  782184
  782676
  796436
  810211
  810265
  811951
]
14.18 ms
(9.22%)
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
  744917
  758961
  751220
  727357
  810211
  724659
  720439
  576071
  515471
  605105
  550417
  672975
  600378
  401738
  550523
  606124
  594118
  777289
  730579
  779234
  782184
  529854
  539938
  447955
  567759
  673976
  491516
  558040
  558861
  596347
  492681
  506387
  810265
  576068
  583666
  598553
  703101
  523066
  472755
  538460
  557265
  662407
  600564
  615514
  595427
  618379
  782676
  748327
  756518
  759534
  406105
  415735
  461438
  462091
  532249
  561635
  714494
  466610
  420206
  561702
  597268
  597269
  636272
  601643
  730728
  796436
  508823
  593975
  413393
  601922
  605311
  612022
  564077
  562327
  578420
  556312
  566067
  651879
  702939
  718647
  721538
  552899
  564114
  589796
  597260
  600246
  626185
  634159
  597242
  597251
  747451
  725640
  601512
  462785
  634556
  597791
  406172
  414783
  566064
  574867
  417745
  503220
  484134
  436358
  383842
  587231
  456639
  475734
  636794
  743075
  751770
  811951
  450111
  416090
  397128
  457213
  532625
  528875
  564795
  569210
]
3.02 ms
(1.96%)
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
  383842
  397128
  401738
  406105
  406172
  413393
  414783
  415735
  416090
  417745
  420206
  436358
  447955
  450111
  456639
  457213
  461438
  462091
  462785
  466610
  472755
  475734
  484134
  491516
  492681
  503220
  506387
  508823
  515471
  523066
  528875
  529854
  532249
  532625
  538460
  539938
  550417
  550523
  552899
  556312
  557265
  558040
  558861
  561635
  561702
  562327
  564077
  564114
  564795
  566064
  566067
  567759
  569210
  574867
  576068
  576071
  578420
  583666
  587231
  589796
  593975
  594118
  595427
  596347
  597242
  597251
  597260
  597268
  597269
  597791
  598553
  600246
  600378
  600564
  601512
  601643
  601922
  605105
  605311
  606124
  612022
  615514
  618379
  626185
  634159
  634556
  636272
  636794
  651879
  662407
  672975
  673976
  702939
  703101
  714494
  718647
  720439
  721538
  724659
  725640
  727357
  730579
  730728
  743075
  744917
  747451
  748327
  751220
  751770
  756518
  758961
  759534
  777289
  779234
  782184
  782676
  796436
  810211
  810265
  811951
]
2.09 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting small girls"
]
1.83 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг маленькая девушк"
]
1.74 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.