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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.23 ms
(53.65%)
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
  145516
  385655
  391270
  442649
  462680
  464095
  467180
  502810
  521213
  539570
  540197
  547520
  553876
  560089
  560910
  561860
  562554
  563731
  565148
  565993
  583853
  585644
  586068
  587189
  591043
  591503
  593184
  594804
  594973
  599250
  605392
  607584
  617364
  622980
  626889
  641341
  642243
  648209
  650524
  658943
  660436
  661029
  662877
  665881
  666683
  667615
  668155
  668538
  684251
  693036
  694505
  698431
  703140
  707479
  713087
  713188
  714377
  715264
  716487
  718460
  722152
  722168
  724220
  730628
  733389
  733406
  734370
  734614
  735976
  739298
  744188
  750647
  755414
  755956
  776639
  782403
  784013
  789059
  793632
  794546
  794559
  794565
  794566
  794593
  800419
  801004
  801616
  801855
  803490
  804359
  805385
  806226
  809338
  811112
  811893
  811989
  812171
  812548
  814747
  815715
  815874
  815913
  816036
  816934
  816980
  818197
  819244
  819773
  820940
  821604
  823410
  823538
  823549
  823576
  824632
  824663
  826620
  826705
  827176
  827397
]
161.45 ms
(41.80%)
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
  145516
  385655
  391270
  442649
  462680
  464095
  467180
  502810
  521213
  539570
  540197
  547520
  553876
  560089
  560910
  561860
  562554
  563731
  565148
  565993
  583853
  585644
  586068
  587189
  591043
  591503
  593184
  594804
  594973
  599250
  605392
  607584
  617364
  622980
  626889
  641341
  642243
  648209
  650524
  658943
  660436
  661029
  662877
  665881
  666683
  667615
  668155
  668538
  684251
  693036
  694505
  698431
  703140
  707479
  713087
  713188
  714377
  715264
  716487
  718460
  722152
  722168
  724220
  730628
  733389
  733406
  734370
  734614
  735976
  739298
  744188
  750647
  755414
  755956
  776639
  782403
  784013
  789059
  793632
  794546
  794559
  794565
  794566
  794593
  800419
  801004
  801616
  801855
  803490
  804359
  805385
  806226
  809338
  811112
  811893
  811989
  812171
  812548
  814747
  815715
  815874
  815913
  816036
  816934
  816980
  818197
  819244
  819773
  820940
  821604
  823410
  823538
  823549
  823576
  824632
  824663
  826620
  826705
  827176
  827397
]
10.83 ms
(2.80%)
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
  755414
  735976
  385655
  391270
  815715
  816980
  814747
  815913
  816934
  819244
  815874
  816036
  818197
  820940
  823410
  823538
  464095
  467180
  540197
  502810
  521213
  539570
  462680
  565148
  547520
  553876
  665881
  722152
  722168
  648209
  684251
  693036
  718460
  560089
  583853
  585644
  587189
  594804
  599250
  626889
  794546
  794593
  801616
  794559
  794565
  803490
  733406
  734370
  734614
  750647
  784013
  800419
  801855
  804359
  805385
  806226
  811112
  811893
  811989
  812548
  730628
  739298
  744188
  733389
  755956
  724220
  794566
  809338
  812171
  145516
  442649
  823576
  824632
  824663
  826620
  826705
  819773
  823549
  827176
  827397
  821604
  562554
  563731
  560910
  565993
  650524
  668155
  694505
  713188
  714377
  715264
  716487
  658943
  703140
  707479
  660436
  661029
  662877
  666683
  667615
  668538
  698431
  713087
  561860
  586068
  591503
  607584
  642243
  591043
  622980
  593184
  605392
  594973
  617364
  641341
  789059
  801004
  776639
  782403
  793632
]
2.05 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy tits"
]
1.66 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая сиськ"
]
1.41 ms
(0.36%)
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.