GET https://search.jues.net/search/embeds/6?q=hairy%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.67 ms
(86.12%)
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
  390625
  453169
  471004
  471011
  484255
  485673
  486475
  490437
  490595
  496466
  507441
  530568
  536120
  539241
  543734
  544988
  559419
  559423
  562998
  567615
  567618
  576475
  577270
  577987
  582494
  585806
  587205
  588890
  589467
  589589
  589631
  592567
  592648
  592655
  595910
  597210
  600455
  604552
  604563
  607755
  610128
  612621
  612636
  615260
  628022
  628529
  629558
  633716
  634640
  635001
  635028
  636644
  641789
  644199
  647096
  659476
  660061
  661514
  661902
  665592
  666011
  666053
  666101
  666670
  666673
  666698
  680300
  680664
  694637
  696129
  696131
  697301
  697306
  707443
  707481
  708035
  709367
  710182
  710280
  710446
  712784
  713416
  713973
  714352
  714373
  714739
  720182
  722125
  724667
  724861
  727985
  728948
  729036
  729079
  730309
  730318
  735448
  736376
  736671
  744891
  745294
  751507
  752473
  754057
  758913
  762186
  790201
  793821
  794417
  794570
  794577
  795344
  796704
  800616
  807193
  808125
  808480
  810383
  812032
  824225
]
13.34 ms
(7.89%)
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
  666053
  666670
  707481
  710446
  647096
  661902
  680300
  696131
  697306
  710280
  713416
  714352
  714373
  665592
  666101
  666673
  712784
  714739
  585806
  610128
  636644
  587205
  729036
  612621
  635028
  641789
  707443
  722125
  592648
  453169
  471004
  530568
  567615
  697301
  607755
  794570
  710182
  810383
  793821
  604563
  490595
  484255
  751507
  485673
  490437
  577270
  713973
  794577
  795344
  796704
  808125
  762186
  745294
  790201
  812032
  486475
  808480
  724861
  612636
  390625
  582494
  544988
  559419
  727985
  736671
  758913
  800616
  724667
  730309
  729079
  735448
  744891
  752473
  728948
  730318
  736376
  754057
  794417
  807193
  539241
  536120
  496466
  507441
  576475
  543734
  559423
  562998
  660061
  680664
  659476
  661514
  720182
  666011
  666698
  694637
  696129
  708035
  709367
  567618
  589467
  589589
  604552
  635001
  589631
  628529
  644199
  592567
  595910
  600455
  588890
  592655
  597210
  628022
  634640
  615260
  629558
  633716
  577987
  824225
  471011
]
3.10 ms
(1.83%)
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
  390625
  453169
  471004
  471011
  484255
  485673
  486475
  490437
  490595
  496466
  507441
  530568
  536120
  539241
  543734
  544988
  559419
  559423
  562998
  567615
  567618
  576475
  577270
  577987
  582494
  585806
  587205
  588890
  589467
  589589
  589631
  592567
  592648
  592655
  595910
  597210
  600455
  604552
  604563
  607755
  610128
  612621
  612636
  615260
  628022
  628529
  629558
  633716
  634640
  635001
  635028
  636644
  641789
  644199
  647096
  659476
  660061
  661514
  661902
  665592
  666011
  666053
  666101
  666670
  666673
  666698
  680300
  680664
  694637
  696129
  696131
  697301
  697306
  707443
  707481
  708035
  709367
  710182
  710280
  710446
  712784
  713416
  713973
  714352
  714373
  714739
  720182
  722125
  724667
  724861
  727985
  728948
  729036
  729079
  730309
  730318
  735448
  736376
  736671
  744891
  745294
  751507
  752473
  754057
  758913
  762186
  790201
  793821
  794417
  794570
  794577
  795344
  796704
  800616
  807193
  808125
  808480
  810383
  812032
  824225
]
1.97 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy homemade"
]
1.78 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая домашн любительск"
]
1.77 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.89%)
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.