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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.74 ms
(85.68%)
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
  383547
  383842
  384411
  385438
  418337
  419574
  420050
  420818
  422609
  428659
  429949
  445730
  447386
  460501
  468471
  468561
  473087
  477552
  479080
  482550
  490597
  494959
  507151
  527499
  530465
  532389
  536216
  542461
  542982
  543045
  550208
  550417
  550712
  551948
  551952
  552019
  552854
  559912
  561726
  565062
  565483
  566605
  570274
  572417
  581315
  581374
  581382
  583453
  583625
  584620
  586619
  586627
  591720
  591904
  592419
  592451
  592531
  593830
  593921
  595690
  597494
  604440
  606894
  609208
  619450
  620611
  623276
  638381
  644330
  649356
  653066
  675409
  676518
  679048
  680934
  682134
  690438
  691521
  692744
  694079
  694193
  701790
  702862
  704772
  720333
  722142
  724750
  724896
  725610
  729038
  729814
  730319
  732855
  733419
  734771
  735518
  738505
  743275
  748679
  749541
  759168
  760082
  764204
  768834
  789704
  802573
  806281
  807144
  808754
  811055
  812062
  814219
  817671
  820019
  821299
  821599
  821692
  823978
  824783
]
14.79 ms
(8.46%)
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
  550417
  561726
  679048
  552854
  570274
  572417
  595690
  620611
  591720
  586627
  592451
  808754
  724896
  749541
  606894
  644330
  592531
  591904
  823978
  383547
  429949
  824783
  482550
  447386
  445730
  477552
  490597
  581382
  551948
  551952
  422609
  420818
  566605
  419574
  385438
  384411
  814219
  820019
  821299
  821692
  817671
  821599
  507151
  536216
  532389
  527499
  530465
  565483
  583625
  542982
  552019
  581374
  584620
  542461
  543045
  583453
  649356
  653066
  680934
  694079
  694193
  704772
  675409
  692744
  702862
  722142
  676518
  682134
  691521
  720333
  609208
  623276
  638381
  593830
  802573
  725610
  733419
  743275
  811055
  729038
  730319
  759168
  768834
  724750
  729814
  732855
  734771
  735518
  760082
  764204
  772838
  738505
  748679
  604440
  701790
  812062
  383842
  460501
  468561
  494959
  565062
  418337
  420050
  428659
  468471
  473087
  559912
  581315
  593921
  619450
  597494
  479080
  586619
  550208
  550712
  690438
  806281
  592419
  807144
  789704
]
3.17 ms
(1.81%)
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
  383547
  383842
  384411
  385438
  418337
  419574
  420050
  420818
  422609
  428659
  429949
  445730
  447386
  460501
  468471
  468561
  473087
  477552
  479080
  482550
  490597
  494959
  507151
  527499
  530465
  532389
  536216
  542461
  542982
  543045
  550208
  550417
  550712
  551948
  551952
  552019
  552854
  559912
  561726
  565062
  565483
  566605
  570274
  572417
  581315
  581374
  581382
  583453
  583625
  584620
  586619
  586627
  591720
  591904
  592419
  592451
  592531
  593830
  593921
  595690
  597494
  604440
  606894
  609208
  619450
  620611
  623276
  638381
  644330
  649356
  653066
  675409
  676518
  679048
  680934
  682134
  690438
  691521
  692744
  694079
  694193
  701790
  702862
  704772
  720333
  722142
  724750
  724896
  725610
  729038
  729814
  730319
  732855
  733419
  734771
  735518
  738505
  743275
  748679
  749541
  759168
  760082
  764204
  768834
  789704
  802573
  806281
  807144
  808754
  811055
  812062
  814219
  817671
  820019
  821299
  821599
  821692
  823978
  824783
]
1.95 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small tits hairy"
]
1.91 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая сиськ волосатая"
]
1.62 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.90%)
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.