GET https://search.jues.net/search/embeds/4?q=handjob%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.73 ms
(82.91%)
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
  350951
  366017
  424102
  432379
  432395
  432413
  432526
  432533
  432571
  433218
  433415
  433552
  433775
  434220
  434412
  436149
  438062
  438514
  438604
  440741
  444780
  453618
  456144
  456463
  456716
  458809
  459742
  460288
  461670
  462041
  465020
  466342
  470571
  470706
  470708
  472106
  472609
  473328
  473905
  477067
  477630
  477949
  478350
  483855
  488040
  497857
  498116
  499418
  505705
  506649
  508300
  512757
  513579
  514018
  514066
  514313
  517960
  518797
  523414
  533710
  534122
  535604
  535605
  536155
  553258
  561838
  561917
  568730
  569986
  578348
  596176
  609765
  612602
  638174
  658431
  658464
  660910
  692650
  696199
  703702
  707744
  715068
  715071
  716135
  716182
  716232
  719977
  730311
  731122
  732875
  736010
  736847
  738421
  741768
  744101
  744431
  744738
  747010
  753734
  759997
  761399
  763463
  764711
  767615
  781344
  785049
  787990
  789160
  790186
  790189
  791139
  800741
  801432
  803165
  804904
  811330
  814685
  828431
  828548
]
15.25 ms
(10.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
  553258
  432413
  434220
  456144
  433775
  456716
  438062
  456463
  473905
  523414
  781344
  801432
  561838
  438604
  459742
  466342
  514313
  477067
  483855
  512757
  350951
  477949
  440741
  508300
  753734
  787990
  828652
  715071
  800741
  803165
  767615
  811330
  736010
  741768
  731122
  761399
  703702
  472609
  444780
  473328
  461670
  462041
  460288
  568730
  561917
  432395
  424102
  497857
  533710
  534122
  535605
  535604
  478350
  715068
  470706
  432379
  696199
  791139
  747010
  804904
  814685
  638174
  764711
  744101
  470571
  514018
  472106
  433552
  596176
  434412
  505705
  514066
  498116
  518797
  707744
  716182
  719977
  658464
  612602
  744431
  738421
  759997
  438514
  433415
  513579
  785049
  790189
  732875
  763463
  730311
  744738
  432526
  433218
  436149
  465020
  477630
  453618
  458809
  470708
  488040
  499418
  517960
  506649
  578348
  736847
  789160
  790186
  432533
  432571
  536155
  366017
  828431
  828548
  569986
  692650
  658431
  716135
  660910
  716232
  609765
]
2.87 ms
(1.94%)
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
  350951
  366017
  424102
  432379
  432395
  432413
  432526
  432533
  432571
  433218
  433415
  433552
  433775
  434220
  434412
  436149
  438062
  438514
  438604
  440741
  444780
  453618
  456144
  456463
  456716
  458809
  459742
  460288
  461670
  462041
  465020
  466342
  470571
  470706
  470708
  472106
  472609
  473328
  473905
  477067
  477630
  477949
  478350
  483855
  488040
  497857
  498116
  499418
  505705
  506649
  508300
  512757
  513579
  514018
  514066
  514313
  517960
  518797
  523414
  533710
  534122
  535604
  535605
  536155
  553258
  561838
  561917
  568730
  569986
  578348
  596176
  609765
  612602
  638174
  658431
  658464
  660910
  692650
  696199
  703702
  707744
  715068
  715071
  716135
  716182
  716232
  719977
  730311
  731122
  732875
  736010
  736847
  738421
  741768
  744101
  744431
  744738
  747010
  753734
  759997
  761399
  763463
  764711
  767615
  781344
  785049
  787990
  789160
  790186
  790189
  791139
  800741
  801432
  803165
  804904
  811330
  814685
  828431
  828548
]
1.91 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член русск"
]
1.87 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "handjob russian"
]
1.73 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.13%)
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.