GET https://search.jues.net/search/embeds/3?q=handjob%20facial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.05 ms
(86.47%)
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
  446310
  447289
  453022
  457012
  460107
  460112
  465409
  469308
  469706
  473542
  488520
  497389
  505248
  509399
  536937
  544879
  550209
  555161
  555945
  557726
  560891
  571993
  573922
  575695
  577718
  584970
  585391
  585790
  588072
  606511
  606575
  607866
  626434
  630846
  633109
  633671
  636557
  638067
  638963
  648563
  652665
  661921
  664222
  668554
  668613
  668988
  670003
  670032
  670257
  671419
  674124
  674825
  697327
  703211
  709764
  710891
  727610
  728115
  729781
  730450
  732669
  733074
  733346
  738022
  740508
  741832
  741854
  744675
  747135
  754253
  756526
  762476
  763166
  763579
  763717
  764956
  767365
  769344
  769354
  770065
  772968
  775054
  775130
  776629
  777217
  777477
  777568
  778068
  779030
  779085
  779614
  781405
  783768
  783838
  786570
  786705
  786713
  786831
  786980
  788979
  789012
  789891
  790761
  793311
  794992
  795669
  795673
  796024
  797013
  797267
  798849
  799528
  801397
  805354
  807273
  807275
  812822
  813308
  820662
]
13.40 ms
(7.82%)
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
  509399
  744675
  754253
  638963
  460107
  638067
  777568
  794992
  795673
  796024
  807275
  813308
  779030
  789891
  795669
  756526
  772968
  728115
  763717
  766254
  775130
  779085
  788979
  797013
  661921
  571993
  607866
  790761
  801397
  807273
  741854
  763166
  573922
  446310
  560891
  465409
  575695
  550209
  652665
  668554
  668613
  670003
  671419
  703211
  648563
  710891
  585790
  630846
  797267
  729781
  733346
  781405
  783768
  762476
  764956
  727610
  633109
  633671
  636557
  777477
  786713
  460112
  626434
  584970
  555161
  730450
  544879
  670032
  668988
  674825
  606511
  775054
  779614
  786705
  786980
  776629
  777217
  786570
  789012
  793311
  769354
  770065
  783838
  799528
  767365
  763579
  798849
  557726
  664222
  585391
  588072
  805354
  769344
  741832
  488520
  820662
  473542
  577718
  697327
  709764
  670257
  674124
  555945
  606575
  778068
  786831
  812822
  738022
  747135
  733074
  732669
  740508
  469706
  497389
  505248
  457012
  469308
  536937
  453022
  447289
]
2.65 ms
(1.55%)
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
  446310
  447289
  453022
  457012
  460107
  460112
  465409
  469308
  469706
  473542
  488520
  497389
  505248
  509399
  536937
  544879
  550209
  555161
  555945
  557726
  560891
  571993
  573922
  575695
  577718
  584970
  585391
  585790
  588072
  606511
  606575
  607866
  626434
  630846
  633109
  633671
  636557
  638067
  638963
  648563
  652665
  661921
  664222
  668554
  668613
  668988
  670003
  670032
  670257
  671419
  674124
  674825
  697327
  703211
  709764
  710891
  727610
  728115
  729781
  730450
  732669
  733074
  733346
  738022
  740508
  741832
  741854
  744675
  747135
  754253
  756526
  762476
  763166
  763579
  763717
  764956
  767365
  769344
  769354
  770065
  772968
  775054
  775130
  776629
  777217
  777477
  777568
  778068
  779030
  779085
  779614
  781405
  783768
  783838
  786570
  786705
  786713
  786831
  786980
  788979
  789012
  789891
  790761
  793311
  794992
  795669
  795673
  796024
  797013
  797267
  798849
  799528
  801397
  805354
  807273
  807275
  812822
  813308
  820662
]
1.88 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "handjob facial"
]
1.76 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член facial"
]
1.75 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дрочк член facial"
]

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.