GET https://search.jues.net/search/embeds/2?q=ride%20on%20cock

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.94 ms
(87.61%)
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
  385751
  395709
  396070
  399994
  405488
  405501
  408213
  408581
  409174
  411958
  417172
  418669
  433820
  436578
  438004
  441656
  451780
  453533
  456040
  456948
  457036
  463716
  464975
  466874
  468991
  479518
  479752
  487729
  498854
  501451
  505548
  511378
  512733
  512745
  515125
  520320
  533091
  533924
  540587
  540808
  546505
  551525
  553126
  557729
  558545
  560369
  564207
  570109
  580802
  581442
  584849
  585729
  587301
  589607
  590163
  596260
  600510
  600912
  601574
  602634
  616879
  634312
  636026
  658193
  665939
  667270
  676987
  681776
  684660
  684980
  692682
  696493
  709082
  716819
  730678
  731071
  732096
  736985
  738053
  739042
  740116
  744367
  744556
  747625
  747819
  756252
  757274
  758763
  764815
  766616
  775681
  775999
  779191
  788763
  791134
  793482
  794869
  795489
  798700
  800181
  801148
  801676
  802313
  803757
  804554
  806019
  807432
  808786
  809153
  812704
  813206
  813765
  820597
  821322
  821405
  823320
  824368
  824576
  828809
]
14.66 ms
(7.30%)
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
  505548
  558545
  676987
  585729
  596260
  636026
  600510
  812704
  501451
  828809
  684660
  441656
  512745
  801676
  456040
  479752
  634312
  766616
  570109
  809153
  515125
  793482
  601574
  824368
  463716
  487729
  512733
  692682
  551525
  731071
  824576
  520320
  546505
  681776
  764815
  788763
  408581
  667270
  730678
  409174
  798700
  740116
  795489
  823320
  665939
  590163
  747625
  385751
  399994
  533924
  802313
  732096
  744556
  580802
  757274
  395709
  533091
  560369
  587301
  600912
  794869
  800181
  807432
  821322
  821405
  553126
  584849
  739042
  736985
  540808
  658193
  772018
  813206
  758763
  775681
  779191
  803757
  716819
  808786
  744367
  405488
  820597
  457036
  511378
  616879
  791134
  738053
  433820
  438004
  396070
  498854
  540587
  468991
  696493
  602634
  747819
  479518
  411958
  813765
  557729
  684980
  775999
  801148
  436578
  417172
  453533
  456948
  564207
  589607
  709082
  464975
  466874
  804554
  756252
  581442
  408213
  418669
  405501
  806019
  451780
]
2.70 ms
(1.35%)
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
  385751
  395709
  396070
  399994
  405488
  405501
  408213
  408581
  409174
  411958
  417172
  418669
  433820
  436578
  438004
  441656
  451780
  453533
  456040
  456948
  457036
  463716
  464975
  466874
  468991
  479518
  479752
  487729
  498854
  501451
  505548
  511378
  512733
  512745
  515125
  520320
  533091
  533924
  540587
  540808
  546505
  551525
  553126
  557729
  558545
  560369
  564207
  570109
  580802
  581442
  584849
  585729
  587301
  589607
  590163
  596260
  600510
  600912
  601574
  602634
  616879
  634312
  636026
  658193
  665939
  667270
  676987
  681776
  684660
  684980
  692682
  696493
  709082
  716819
  730678
  731071
  732096
  736985
  738053
  739042
  740116
  744367
  744556
  747625
  747819
  756252
  757274
  758763
  764815
  766616
  775681
  775999
  779191
  788763
  791134
  793482
  794869
  795489
  798700
  800181
  801148
  801676
  802313
  803757
  804554
  806019
  807432
  808786
  809153
  812704
  813206
  813765
  820597
  821322
  821405
  823320
  824368
  824576
  828809
]
2.13 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ride on cock"
]
1.93 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ride cock"
]
1.84 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ride cock"
]
1.64 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.