GET https://search.jues.net/search/embeds/5?q=mom%20anal%20double

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.39 ms
(85.02%)
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
  402649
  443387
  443726
  464959
  468667
  495562
  515089
  515370
  522898
  530015
  531232
  532679
  532790
  533364
  533592
  534023
  536337
  537886
  543478
  551579
  556016
  561132
  561134
  562838
  576685
  580258
  590241
  592463
  593359
  599851
  599994
  600002
  600008
  600173
  600338
  600340
  600962
  604310
  604378
  604558
  605590
  606467
  615748
  619082
  619407
  619466
  619467
  619468
  620160
  621692
  628707
  630553
  631199
  631919
  632700
  633079
  633097
  634475
  637680
  637746
  638552
  640525
  640795
  641395
  641642
  643127
  643935
  644277
  644998
  646175
  646451
  646904
  647600
  647875
  647954
  648838
  649498
  649583
  660148
  660696
  662604
  663346
  664212
  666585
  668518
  672158
  673633
  675006
  677703
  681031
  681982
  683529
  688617
  695117
  717836
  718732
  720291
  721103
  726654
  742428
  747012
  755850
  756398
  770291
  770672
  775476
  775477
  775741
  775963
  775976
  784242
  784907
  788566
  788789
  799743
  801968
  805554
  807958
  808655
  810835
]
14.22 ms
(8.49%)
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
  537886
  464959
  576685
  647600
  672158
  681031
  683529
  721103
  649583
  660148
  663346
  666585
  673633
  647875
  662604
  664212
  677703
  681982
  695117
  717836
  556016
  590241
  600173
  600962
  621692
  637680
  637746
  640795
  643935
  604558
  619467
  620160
  605590
  632700
  633097
  634475
  640525
  644277
  599851
  600338
  604310
  619466
  628707
  631199
  638552
  643127
  775741
  784907
  799743
  801968
  805554
  808655
  775476
  784242
  788566
  810835
  756398
  770672
  742428
  755850
  770291
  726654
  747012
  633079
  641395
  641642
  718732
  720291
  775477
  775976
  788789
  807958
  443387
  533592
  675006
  534023
  600340
  619407
  515089
  522898
  561132
  543478
  580258
  649498
  660696
  668518
  561134
  562838
  592463
  606467
  619082
  631919
  600008
  604378
  593359
  619468
  615748
  775963
  402649
  443726
  468667
  495562
  515370
  599994
  600002
  688617
  630553
  644998
  531232
  532790
  533364
  536337
  530015
  532679
  551579
  646175
  647954
  646451
  646904
  648838
]
3.51 ms
(2.10%)
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
  402649
  443387
  443726
  464959
  468667
  495562
  515089
  515370
  522898
  530015
  531232
  532679
  532790
  533364
  533592
  534023
  536337
  537886
  543478
  551579
  556016
  561132
  561134
  562838
  576685
  580258
  590241
  592463
  593359
  599851
  599994
  600002
  600008
  600173
  600338
  600340
  600962
  604310
  604378
  604558
  605590
  606467
  615748
  619082
  619407
  619466
  619467
  619468
  620160
  621692
  628707
  630553
  631199
  631919
  632700
  633079
  633097
  634475
  637680
  637746
  638552
  640525
  640795
  641395
  641642
  643127
  643935
  644277
  644998
  646175
  646451
  646904
  647600
  647875
  647954
  648838
  649498
  649583
  660148
  660696
  662604
  663346
  664212
  666585
  668518
  672158
  673633
  675006
  677703
  681031
  681982
  683529
  688617
  695117
  717836
  718732
  720291
  721103
  726654
  742428
  747012
  755850
  756398
  770291
  770672
  775476
  775477
  775741
  775963
  775976
  784242
  784907
  788566
  788789
  799743
  801968
  805554
  807958
  808655
  810835
]
2.33 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom anal double"
]
1.75 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom анал double"
]
1.68 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom анал double"
]

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.