GET https://search.jues.net/search/embeds/2?q=kissing%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.18 ms
(86.52%)
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
  12068
  148176
  181441
  307342
  382426
  382606
  383442
  401525
  402254
  446954
  468475
  480826
  544568
  549952
  570207
  581869
  586542
  592992
  624964
  628997
  652551
  654465
  663430
  663863
  671127
  673457
  675760
  679115
  679125
  679131
  679399
  682510
  684414
  694568
  701864
  702236
  705352
  714637
  715469
  715703
  717436
  718495
  720784
  721219
  722221
  722816
  722899
  723975
  725365
  726476
  726646
  726811
  728337
  730634
  732247
  733329
  736285
  737203
  740211
  740252
  741974
  742472
  743047
  743058
  743408
  745012
  746473
  751756
  753300
  753351
  753912
  753926
  755289
  759051
  759600
  759815
  760387
  768286
  770820
  773433
  773546
  781971
  784356
  788302
  793557
  793574
  793607
  795159
  795500
  796424
  799468
  799517
  800192
  801334
  801881
  802398
  802834
  803453
  803999
  804579
  808127
  808518
  810047
  810342
  813910
  815782
  818417
  818441
  818790
  818858
  819975
  819978
  819995
  820142
  823167
  823257
  823605
  824219
  826238
  826438
]
13.42 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
  795159
  796424
  740211
  728337
  755289
  759051
  733329
  751756
  760387
  759600
  702236
  715703
  781971
  793557
  12068
  382606
  401525
  402254
  815782
  446954
  722816
  586542
  624964
  802834
  737203
  788302
  726476
  743047
  743058
  753926
  784356
  181441
  148176
  813910
  818417
  818441
  824219
  818790
  819978
  823257
  819975
  820142
  823167
  826438
  818858
  823605
  480826
  544568
  549952
  652551
  663430
  663863
  671127
  679115
  717436
  718495
  673457
  675760
  701864
  715469
  721219
  679125
  679131
  679399
  684414
  694568
  705352
  722221
  592992
  628997
  793607
  795500
  800192
  803999
  804579
  723975
  741974
  753300
  753351
  773546
  793574
  801334
  810047
  810342
  725365
  768286
  726646
  746473
  753912
  726811
  732247
  740252
  742472
  759815
  773433
  730634
  743408
  770820
  714637
  720784
  799468
  799517
  802398
  803453
  808127
  382426
  383442
  307342
  826238
  819995
  468475
  570207
  581869
  654465
  722899
  682510
  801881
  736285
  745012
  808518
]
3.04 ms
(1.78%)
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
  12068
  148176
  181441
  307342
  382426
  382606
  383442
  401525
  402254
  446954
  468475
  480826
  544568
  549952
  570207
  581869
  586542
  592992
  624964
  628997
  652551
  654465
  663430
  663863
  671127
  673457
  675760
  679115
  679125
  679131
  679399
  682510
  684414
  694568
  701864
  702236
  705352
  714637
  715469
  715703
  717436
  718495
  720784
  721219
  722221
  722816
  722899
  723975
  725365
  726476
  726646
  726811
  728337
  730634
  732247
  733329
  736285
  737203
  740211
  740252
  741974
  742472
  743047
  743058
  743408
  745012
  746473
  751756
  753300
  753351
  753912
  753926
  755289
  759051
  759600
  759815
  760387
  768286
  770820
  773433
  773546
  781971
  784356
  788302
  793557
  793574
  793607
  795159
  795500
  796424
  799468
  799517
  800192
  801334
  801881
  802398
  802834
  803453
  803999
  804579
  808127
  808518
  810047
  810342
  813910
  815782
  818417
  818441
  818790
  818858
  819975
  819978
  819995
  820142
  823167
  823257
  823605
  824219
  826238
  826438
]
1.85 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "kissing pussy"
]
1.65 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kissing pussy"
]
1.27 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "kissing pussy"
]

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.