GET https://search.jues.net/search/embeds/6?q=girl%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.54 ms
(87.57%)
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
  401636
  489880
  490491
  493783
  496385
  505571
  510335
  514189
  525473
  531017
  533075
  533215
  533302
  533787
  535562
  536006
  536260
  537039
  537690
  540934
  541918
  542402
  543588
  543634
  544794
  546031
  546672
  547542
  557919
  558929
  566492
  572353
  572680
  577296
  579080
  579298
  579472
  579699
  582832
  593028
  604407
  611494
  622813
  626100
  627560
  627562
  633692
  639204
  645226
  645721
  650032
  651499
  651518
  670729
  676741
  685275
  686121
  688773
  691982
  692154
  694038
  696149
  696157
  704238
  711117
  712202
  717279
  717447
  721642
  723208
  733198
  734618
  735206
  736638
  737234
  737352
  737825
  739105
  739654
  740184
  740703
  743925
  744730
  745168
  746924
  749533
  752017
  752042
  752046
  752462
  753714
  754980
  755205
  755482
  757943
  758616
  760399
  760606
  764192
  767343
  769083
  769336
  773649
  777325
  777481
  777532
  778325
  778557
  783158
  790267
  790434
  791609
  792198
  806617
  811809
  816190
  826999
  827244
  827457
  828290
]
11.50 ms
(6.51%)
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
  692154
  622813
  755482
  493783
  696157
  828290
  778557
  769336
  790434
  734618
  577296
  670729
  760399
  696149
  542402
  531017
  537690
  401636
  826999
  827457
  496385
  533075
  543634
  717447
  723208
  712202
  593028
  790267
  777325
  778325
  791609
  792198
  740703
  767343
  737825
  752046
  757943
  773649
  743925
  752462
  777532
  783158
  544794
  827244
  572353
  566492
  579080
  579699
  806617
  764192
  769083
  752017
  754980
  739105
  745168
  749533
  737234
  721642
  490491
  547542
  717279
  753714
  816190
  489880
  514189
  525473
  533787
  533302
  533215
  535562
  505571
  582832
  543588
  546031
  546672
  558929
  645226
  645721
  676741
  685275
  711117
  651518
  686121
  694038
  704238
  650032
  651499
  688773
  691982
  572680
  579298
  579472
  604407
  626100
  611494
  639204
  627560
  777481
  737352
  739654
  752042
  811809
  736638
  746924
  733198
  735206
  744730
  758616
  755205
  740184
  760606
  627562
  633692
  510335
  536260
  537039
  536006
  540934
  557919
  541918
]
3.02 ms
(1.71%)
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
  401636
  489880
  490491
  493783
  496385
  505571
  510335
  514189
  525473
  531017
  533075
  533215
  533302
  533787
  535562
  536006
  536260
  537039
  537690
  540934
  541918
  542402
  543588
  543634
  544794
  546031
  546672
  547542
  557919
  558929
  566492
  572353
  572680
  577296
  579080
  579298
  579472
  579699
  582832
  593028
  604407
  611494
  622813
  626100
  627560
  627562
  633692
  639204
  645226
  645721
  650032
  651499
  651518
  670729
  676741
  685275
  686121
  688773
  691982
  692154
  694038
  696149
  696157
  704238
  711117
  712202
  717279
  717447
  721642
  723208
  733198
  734618
  735206
  736638
  737234
  737352
  737825
  739105
  739654
  740184
  740703
  743925
  744730
  745168
  746924
  749533
  752017
  752042
  752046
  752462
  753714
  754980
  755205
  755482
  757943
  758616
  760399
  760606
  764192
  767343
  769083
  769336
  773649
  777325
  777481
  777532
  778325
  778557
  783158
  790267
  790434
  791609
  792198
  806617
  811809
  816190
  826999
  827244
  827457
  828290
]
2.18 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl amateur"
]
1.94 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк любительск"
]
1.68 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.92%)
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.