GET https://search.jues.net/search/embeds/5?q=amateur%20hairy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.30 ms
(85.20%)
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
  70636
  400884
  413123
  453152
  471025
  475682
  483995
  485016
  485673
  486475
  489119
  490437
  490592
  490594
  496845
  502544
  504028
  531595
  532414
  541017
  541116
  543317
  544877
  545743
  546146
  547573
  549031
  554170
  555486
  558674
  559313
  559334
  563685
  567629
  574143
  576597
  576791
  577270
  578171
  578510
  583403
  597663
  599238
  612169
  614222
  614802
  616381
  616569
  617568
  619620
  621382
  623071
  625209
  626176
  631457
  631459
  634934
  640361
  641571
  644218
  650531
  652163
  660383
  661534
  662424
  666067
  666078
  666094
  666122
  666680
  666713
  666722
  670263
  684183
  687103
  697219
  698916
  700804
  705349
  706895
  708578
  708706
  708743
  709611
  710229
  710439
  710856
  712140
  713973
  714418
  721938
  722167
  722681
  734661
  739895
  742280
  745294
  762186
  771424
  778481
  781771
  790201
  793565
  794577
  795344
  796490
  796704
  802219
  802303
  802307
  803136
  804257
  804738
  807193
  808125
  809555
  811443
  812032
  825250
]
15.45 ms
(8.31%)
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
  807193
  485673
  490437
  496845
  577270
  713973
  722167
  794577
  795344
  802303
  796704
  808125
  809555
  762186
  739895
  745294
  721938
  790201
  812032
  413123
  453152
  475682
  490592
  70636
  825250
  471025
  559334
  541116
  708578
  652163
  661534
  666067
  666094
  709611
  708706
  641571
  700804
  543317
  490594
  400884
  502544
  531595
  541017
  574143
  583403
  545743
  547573
  567629
  666122
  666680
  687103
  698916
  666722
  705349
  710229
  650531
  666078
  670263
  706895
  710856
  712140
  555486
  597663
  614222
  614802
  625209
  626176
  631457
  640361
  616381
  619620
  621382
  616512
  616569
  631459
  617568
  634934
  697219
  710439
  504028
  489119
  684183
  714418
  486475
  742280
  483995
  532414
  485016
  546146
  558674
  576791
  578171
  549031
  578510
  544877
  559313
  563685
  662424
  708743
  660383
  666713
  722681
  554170
  576597
  623071
  644218
  599238
  612169
  778481
  793565
  811443
  802307
  803136
  804257
  804738
  734661
  771424
  781771
  796490
  802219
]
3.96 ms
(2.13%)
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
  70636
  400884
  413123
  453152
  471025
  475682
  483995
  485016
  485673
  486475
  489119
  490437
  490592
  490594
  496845
  502544
  504028
  531595
  532414
  541017
  541116
  543317
  544877
  545743
  546146
  547573
  549031
  554170
  555486
  558674
  559313
  559334
  563685
  567629
  574143
  576597
  576791
  577270
  578171
  578510
  583403
  597663
  599238
  612169
  614222
  614802
  616381
  616569
  617568
  619620
  621382
  623071
  625209
  626176
  631457
  631459
  634934
  640361
  641571
  644218
  650531
  652163
  660383
  661534
  662424
  666067
  666078
  666094
  666122
  666680
  666713
  666722
  670263
  684183
  687103
  697219
  698916
  700804
  705349
  706895
  708578
  708706
  708743
  709611
  710229
  710439
  710856
  712140
  713973
  714418
  721938
  722167
  722681
  734661
  739895
  742280
  745294
  762186
  771424
  778481
  781771
  790201
  793565
  794577
  795344
  796490
  796704
  802219
  802303
  802307
  803136
  804257
  804738
  807193
  808125
  809555
  811443
  812032
  825250
]
2.41 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur hairy"
]
2.20 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск волосатая"
]
1.76 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.93%)
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.