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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
111.00 ms
(82.85%)
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
  385479
  388005
  391985
  471004
  471039
  471049
  471063
  471066
  484255
  510917
  536192
  539658
  540782
  542479
  544580
  545155
  545157
  549640
  557607
  557822
  559414
  563779
  572682
  576450
  577308
  577987
  579496
  585806
  586906
  587205
  589868
  591576
  592648
  594426
  604461
  610128
  612621
  622159
  623696
  625298
  629930
  634961
  635028
  636644
  639480
  641789
  644172
  647096
  648193
  661523
  661902
  665592
  666053
  666058
  666101
  666670
  666673
  671519
  680300
  696131
  696144
  697306
  706013
  707443
  707481
  710280
  710446
  710901
  712784
  713416
  714352
  714373
  714407
  714569
  714739
  719146
  722125
  722158
  724505
  725199
  725435
  726629
  728952
  728955
  728984
  729036
  729045
  729880
  729932
  730189
  732184
  733724
  734207
  734318
  740326
  749487
  751256
  751954
  753580
  757166
  784174
  787238
  787285
  789477
  789568
  794410
  794535
  794580
  794583
  794597
  794626
  795113
  795353
  801395
  802248
  802292
  808254
  824479
  824594
  826651
]
12.91 ms
(9.64%)
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
  757166
  733724
  751954
  801395
  592648
  824479
  471039
  719146
  559414
  623696
  644172
  794535
  729932
  734207
  740326
  749487
  787285
  794580
  802292
  728952
  753580
  726629
  728984
  730189
  725435
  794410
  795113
  795353
  536192
  594426
  471066
  539658
  563779
  557607
  671519
  589868
  591576
  639480
  787238
  714407
  577308
  391985
  545157
  794626
  794583
  484255
  388005
  471063
  471004
  577987
  542479
  544580
  549640
  557822
  576450
  648193
  666053
  666058
  666670
  707481
  710446
  647096
  661523
  661902
  680300
  696131
  696144
  697306
  706013
  710280
  713416
  714352
  714373
  665592
  666101
  666673
  712784
  714739
  585806
  610128
  622159
  634961
  586906
  629930
  636644
  587205
  625298
  725199
  729036
  724505
  604461
  612621
  635028
  641789
  707443
  722125
  789477
  824594
  510917
  471049
  545155
  579496
  572682
  722158
  794597
  802248
  808254
  729880
  784174
  728955
  732184
  729045
  734318
  751256
  710901
  714569
  789568
  385479
  540782
  826651
]
2.76 ms
(2.06%)
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
  385479
  388005
  391985
  471004
  471039
  471049
  471063
  471066
  484255
  510917
  536192
  539658
  540782
  542479
  544580
  545155
  545157
  549640
  557607
  557822
  559414
  563779
  572682
  576450
  577308
  577987
  579496
  585806
  586906
  587205
  589868
  591576
  592648
  594426
  604461
  610128
  612621
  622159
  623696
  625298
  629930
  634961
  635028
  636644
  639480
  641789
  644172
  647096
  648193
  661523
  661902
  665592
  666053
  666058
  666101
  666670
  666673
  671519
  680300
  696131
  696144
  697306
  706013
  707443
  707481
  710280
  710446
  710901
  712784
  713416
  714352
  714373
  714407
  714569
  714739
  719146
  722125
  722158
  724505
  725199
  725435
  726629
  728952
  728955
  728984
  729036
  729045
  729880
  729932
  730189
  732184
  733724
  734207
  734318
  740326
  749487
  751256
  751954
  753580
  757166
  784174
  787238
  787285
  789477
  789568
  794410
  794535
  794580
  794583
  794597
  794626
  795113
  795353
  801395
  802248
  802292
  808254
  824479
  824594
  826651
]
2.13 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur hairy"
]
1.98 ms
(1.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск волосатая"
]
1.44 ms
(1.08%)
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.