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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.45 ms
(84.85%)
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
  91891
  233364
  391607
  392623
  393701
  400014
  407389
  411447
  423983
  428966
  433352
  434848
  435888
  436644
  446117
  446170
  448227
  450671
  451518
  454098
  454906
  454907
  458689
  462334
  467792
  473228
  491125
  492283
  494399
  502551
  504711
  512650
  526870
  538535
  541662
  544058
  548049
  549780
  552192
  562232
  562492
  563291
  567058
  567072
  567190
  570571
  592656
  594048
  595480
  596507
  596648
  598592
  598943
  626793
  652904
  668978
  672885
  683278
  685180
  689908
  692060
  698226
  702062
  702695
  705461
  708149
  711378
  715055
  717675
  717726
  718537
  722195
  723196
  727668
  741713
  746391
  751228
  752718
  753878
  757795
  758988
  763412
  763524
  763870
  765027
  765997
  768634
  774919
  777210
  779142
  779177
  781037
  781125
  781212
  781316
  782111
  784086
  787161
  787592
  791678
  792535
  792720
  792728
  793952
  795243
  795475
  795905
  799253
  802588
  804840
  806133
  809971
  811819
  812215
  813314
  823650
  825804
  827952
]
13.71 ms
(8.65%)
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
  435888
  6840
  233364
  454907
  423983
  434848
  407389
  598943
  91891
  752718
  494399
  391607
  567058
  448227
  562492
  596507
  462334
  433352
  502551
  411447
  504711
  570571
  549780
  400014
  458689
  450671
  526870
  492283
  598592
  594048
  467792
  538535
  685180
  702062
  717726
  705461
  698226
  722195
  777210
  781037
  781212
  791678
  792720
  795905
  799253
  809971
  812215
  753878
  765997
  792535
  802588
  757795
  751228
  763870
  779177
  795475
  806133
  813314
  652904
  692060
  718537
  702695
  567072
  596648
  823650
  541662
  563291
  683278
  708149
  711378
  668978
  715055
  672885
  689908
  717675
  626793
  779142
  804840
  774919
  781125
  781316
  782111
  787592
  811819
  784086
  792728
  793952
  795243
  746391
  765027
  768634
  763412
  763524
  758988
  723196
  787161
  491125
  595480
  446117
  473228
  393701
  446170
  544058
  552192
  592656
  392623
  454906
  548049
  741713
  567190
  727668
  569904
  428966
  436644
  454098
  451518
  512650
  825804
  827952
  562232
]
3.66 ms
(2.31%)
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
  91891
  233364
  391607
  392623
  393701
  400014
  407389
  411447
  423983
  428966
  433352
  434848
  435888
  436644
  446117
  446170
  448227
  450671
  451518
  454098
  454906
  454907
  458689
  462334
  467792
  473228
  491125
  492283
  494399
  502551
  504711
  512650
  526870
  538535
  541662
  544058
  548049
  549780
  552192
  562232
  562492
  563291
  567058
  567072
  567190
  570571
  592656
  594048
  595480
  596507
  596648
  598592
  598943
  626793
  652904
  668978
  672885
  683278
  685180
  689908
  692060
  698226
  702062
  702695
  705461
  708149
  711378
  715055
  717675
  717726
  718537
  722195
  723196
  727668
  741713
  746391
  751228
  752718
  753878
  757795
  758988
  763412
  763524
  763870
  765027
  765997
  768634
  774919
  777210
  779142
  779177
  781037
  781125
  781212
  781316
  782111
  784086
  787161
  787592
  791678
  792535
  792720
  792728
  793952
  795243
  795475
  795905
  799253
  802588
  804840
  806133
  809971
  811819
  812215
  813314
  823650
  825804
  827952
]
2.15 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian hot girls"
]
1.87 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск hot девушк"
]
1.19 ms
(0.75%)
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.