GET https://search.jues.net/search/embeds/8?q=russian%20skinny%20bitch

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.19 ms
(87.68%)
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
  385129
  402242
  403349
  404263
  418133
  418665
  418673
  419018
  420718
  423930
  424181
  424493
  425954
  427142
  434328
  437176
  440736
  441820
  444198
  445013
  448337
  449000
  462591
  467758
  469899
  469900
  472334
  473550
  473833
  477612
  477919
  479033
  482095
  486368
  487241
  488725
  491472
  491653
  492061
  494108
  495171
  495528
  496848
  498877
  501523
  501782
  505865
  506489
  507366
  508881
  510465
  511848
  512302
  522282
  522809
  522836
  523745
  524722
  526510
  538199
  538415
  542105
  543703
  546377
  546476
  547888
  550236
  551161
  552471
  552796
  558824
  559020
  560481
  562235
  567193
  568807
  569846
  569850
  570021
  570041
  570256
  570500
  570591
  570669
  570670
  571515
  572154
  572165
  572445
  573107
  573115
  573695
  573715
  575091
  575106
  575265
  575727
  575750
  575789
  576026
  576836
  577932
  578958
  579181
  581935
  582354
  585910
  587055
  588252
  589377
  590554
  595872
  596577
  596618
  597023
  597060
  597136
  599605
  617260
  789090
]
13.11 ms
(7.09%)
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
  427142
  418665
  506489
  512302
  424181
  404263
  505865
  542105
  547888
  559020
  571515
  575727
  575750
  576026
  578958
  582354
  552471
  558824
  560481
  568807
  569846
  570500
  570591
  572445
  573107
  575106
  575789
  577932
  552796
  567193
  570669
  573715
  581935
  546476
  562235
  569850
  570021
  570670
  572154
  572165
  597136
  585910
  590554
  596618
  597023
  599605
  402242
  420718
  462591
  477919
  403349
  434328
  441820
  472334
  473833
  423930
  425954
  437176
  418673
  440736
  419018
  448337
  501523
  501782
  510465
  491472
  491653
  494108
  496848
  507366
  511848
  522282
  522809
  523745
  486368
  492061
  508881
  487241
  488725
  495171
  495528
  522836
  538199
  538415
  570256
  573115
  576836
  570041
  589377
  595872
  473550
  385129
  526510
  524722
  469899
  469900
  482095
  587055
  449000
  424493
  444198
  617260
  550236
  445013
  543703
  789090
  546377
  575265
  596577
  597060
  477612
  588252
  467758
  479033
  579181
  418133
  498877
  575091
  551161
  573695
]
2.41 ms
(1.30%)
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
  385129
  402242
  403349
  404263
  418133
  418665
  418673
  419018
  420718
  423930
  424181
  424493
  425954
  427142
  434328
  437176
  440736
  441820
  444198
  445013
  448337
  449000
  462591
  467758
  469899
  469900
  472334
  473550
  473833
  477612
  477919
  479033
  482095
  486368
  487241
  488725
  491472
  491653
  492061
  494108
  495171
  495528
  496848
  498877
  501523
  501782
  505865
  506489
  507366
  508881
  510465
  511848
  512302
  522282
  522809
  522836
  523745
  524722
  526510
  538199
  538415
  542105
  543703
  546377
  546476
  547888
  550236
  551161
  552471
  552796
  558824
  559020
  560481
  562235
  567193
  568807
  569846
  569850
  570021
  570041
  570256
  570500
  570591
  570669
  570670
  571515
  572154
  572165
  572445
  573107
  573115
  573695
  573715
  575091
  575106
  575265
  575727
  575750
  575789
  576026
  576836
  577932
  578958
  579181
  581935
  582354
  585910
  587055
  588252
  589377
  590554
  595872
  596577
  596618
  597023
  597060
  597136
  599605
  617260
  789090
]
2.08 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian skinny bitch"
]
1.78 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск худая девушк"
]
1.72 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск худая девушк"
]
1.68 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.