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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.16 ms
(88.60%)
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
  384104
  409727
  417304
  423862
  449166
  460545
  482126
  482130
  489549
  490245
  493080
  501920
  502916
  503747
  507084
  507434
  516016
  520039
  527727
  535071
  536959
  543465
  546400
  547702
  549136
  551665
  558911
  560693
  569433
  572219
  575637
  576248
  578716
  579500
  579853
  583467
  584688
  590309
  598091
  600847
  605005
  605494
  605664
  614388
  617311
  618753
  624819
  625369
  626328
  628718
  631826
  632401
  633917
  636066
  638912
  639366
  648630
  650282
  651294
  660649
  666466
  666504
  677918
  680650
  685070
  685072
  689061
  697608
  697735
  699937
  702275
  704704
  704722
  705116
  705322
  711341
  712959
  713004
  716915
  718699
  720168
  721156
  725096
  727230
  732154
  732486
  735252
  736120
  740160
  740966
  746065
  746232
  748334
  749623
  755918
  757297
  761670
  762911
  764668
  766300
  766462
  766890
  769248
  780283
  785679
  788332
  789272
  793718
  793792
  793807
  793869
  795906
  796464
  798045
  799874
  801095
  808492
  812724
  818825
  821809
]
13.14 ms
(6.54%)
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
  535071
  520039
  503747
  543465
  572219
  578716
  546400
  705322
  677918
  716915
  718699
  720168
  551665
  624819
  631826
  785679
  793792
  796464
  788332
  789272
  793869
  808492
  740160
  740966
  746232
  793807
  735252
  732154
  736120
  727230
  746065
  761670
  766300
  614388
  721156
  812724
  423862
  449166
  384104
  409727
  417304
  493080
  651294
  605005
  762911
  583467
  685070
  685072
  590309
  711341
  482130
  502916
  489549
  547702
  575637
  569433
  576248
  549136
  560693
  666504
  697608
  697735
  702275
  648630
  650282
  666466
  689061
  699937
  705116
  680650
  704704
  712959
  713004
  579853
  605664
  639366
  633917
  600847
  625369
  628718
  632401
  598091
  605494
  617311
  618753
  626328
  636066
  638912
  732486
  501920
  818825
  821809
  460545
  482126
  490245
  507084
  527727
  516016
  579500
  660649
  558911
  801095
  793718
  798045
  749623
  757297
  795906
  725096
  766462
  766890
  769248
  764668
  748334
  755918
  780283
  799874
  507434
  584688
  704722
  536959
]
3.12 ms
(1.55%)
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
  384104
  409727
  417304
  423862
  449166
  460545
  482126
  482130
  489549
  490245
  493080
  501920
  502916
  503747
  507084
  507434
  516016
  520039
  527727
  535071
  536959
  543465
  546400
  547702
  549136
  551665
  558911
  560693
  569433
  572219
  575637
  576248
  578716
  579500
  579853
  583467
  584688
  590309
  598091
  600847
  605005
  605494
  605664
  614388
  617311
  618753
  624819
  625369
  626328
  628718
  631826
  632401
  633917
  636066
  638912
  639366
  648630
  650282
  651294
  660649
  666466
  666504
  677918
  680650
  685070
  685072
  689061
  697608
  697735
  699937
  702275
  704704
  704722
  705116
  705322
  711341
  712959
  713004
  716915
  718699
  720168
  721156
  725096
  727230
  732154
  732486
  735252
  736120
  740160
  740966
  746065
  746232
  748334
  749623
  755918
  757297
  761670
  762911
  764668
  766300
  766462
  766890
  769248
  780283
  785679
  788332
  789272
  793718
  793792
  793807
  793869
  795906
  796464
  798045
  799874
  801095
  808492
  812724
  818825
  821809
]
1.87 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "husband teens amateur"
]
1.85 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "husband teens любительск"
]
1.68 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.26 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "husband teens любительск"
]

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.