GET https://search.jues.net/search/embeds/2?q=body%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.43 ms
(85.18%)
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
  398414
  425392
  445743
  529772
  529822
  529879
  530652
  532435
  532823
  533115
  536091
  539198
  540028
  540281
  540284
  540285
  540287
  546477
  547334
  549610
  552109
  555883
  559171
  559983
  570677
  577238
  577240
  589976
  589983
  590196
  596172
  604035
  605736
  607572
  616092
  622644
  635021
  636515
  643784
  645401
  645508
  650573
  652221
  652291
  661788
  662824
  673567
  674873
  675464
  676503
  687379
  690239
  697647
  700524
  701202
  704979
  708986
  709046
  709076
  709079
  709102
  709124
  709185
  709301
  711712
  719512
  723180
  731094
  735622
  736708
  736812
  738104
  738880
  743275
  747641
  749006
  751485
  753599
  754342
  757197
  757719
  759817
  762201
  766315
  769093
  770282
  773151
  773188
  775314
  778016
  778708
  779741
  780624
  780824
  785556
  789787
  791334
  792401
  797489
  800221
  801308
  802749
  803572
  804686
  805253
  807040
  814171
  815682
  816863
  817250
  819691
  821374
  823063
  824753
  825903
  826301
  827165
  827543
]
11.93 ms
(8.44%)
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
  652291
  815682
  690239
  708986
  636515
  780624
  643784
  819691
  824753
  539198
  532435
  645401
  675464
  778016
  749006
  622644
  709076
  823063
  826301
  547334
  589983
  607572
  780824
  736708
  738880
  751485
  559983
  555883
  769093
  529822
  652221
  676503
  792401
  821374
  673567
  704979
  635021
  804686
  757719
  823492
  540281
  540284
  697647
  719512
  661788
  577238
  596172
  791334
  753599
  700524
  779741
  827543
  816863
  530652
  687379
  604035
  801308
  773188
  735622
  747641
  736812
  754342
  773151
  757197
  616092
  701202
  825903
  827165
  817250
  445743
  532823
  546477
  662824
  709185
  650573
  785556
  763376
  803572
  762201
  766315
  709102
  778708
  398414
  533115
  536091
  540028
  559171
  674873
  709079
  723180
  590196
  589976
  789787
  775314
  800221
  805253
  731094
  738104
  759817
  770282
  709301
  797489
  802749
  807040
  605736
  425392
  814171
  549610
  570677
  552109
  743275
  709124
  529879
  540285
  540287
  529772
  577240
  645508
  709046
  711712
]
2.31 ms
(1.63%)
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
  398414
  425392
  445743
  529772
  529822
  529879
  530652
  532435
  532823
  533115
  536091
  539198
  540028
  540281
  540284
  540285
  540287
  546477
  547334
  549610
  552109
  555883
  559171
  559983
  570677
  577238
  577240
  589976
  589983
  590196
  596172
  604035
  605736
  607572
  616092
  622644
  635021
  636515
  643784
  645401
  645508
  650573
  652221
  652291
  661788
  662824
  673567
  674873
  675464
  676503
  687379
  690239
  697647
  700524
  701202
  704979
  708986
  709046
  709076
  709079
  709102
  709124
  709185
  709301
  711712
  719512
  723180
  731094
  735622
  736708
  736812
  738104
  738880
  743275
  747641
  749006
  751485
  753599
  754342
  757197
  757719
  759817
  762201
  766315
  769093
  770282
  773151
  773188
  775314
  778016
  778708
  779741
  780624
  780824
  785556
  789787
  791334
  792401
  797489
  800221
  801308
  802749
  803572
  804686
  805253
  807040
  814171
  815682
  816863
  817250
  819691
  821374
  823063
  824753
  825903
  826301
  827165
  827543
]
1.83 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "body девушк"
]
1.81 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "body girl"
]
1.31 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "body девушк"
]

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.