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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.16 ms
(82.62%)
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
  388962
  391984
  391992
  391994
  416599
  418126
  418144
  421838
  428924
  429861
  429885
  430365
  432363
  434309
  435398
  435547
  435592
  439029
  439078
  439130
  439156
  439274
  439317
  444194
  444917
  445103
  446562
  446641
  446709
  448587
  452574
  454504
  454517
  455132
  456226
  456238
  460384
  462840
  463687
  464264
  466455
  467696
  469615
  470022
  470458
  471107
  477246
  482751
  483691
  487428
  489615
  495470
  498294
  499383
  499836
  504781
  506105
  507951
  509964
  513568
  513654
  517810
  519368
  519699
  519700
  520904
  521677
  522260
  522288
  523355
  526567
  542701
  542706
  544401
  547492
  548150
  548157
  554949
  556445
  569359
  571194
  571235
  571726
  581058
  583085
  595483
  599478
  602782
  605725
  605828
  620647
  627049
  652249
  661424
  674177
  674204
  677240
  685506
  691808
  696871
  700257
  705809
  714562
  718775
  722384
  742286
  742320
  745100
  745104
  745672
  751563
  751609
  755878
  757566
  761608
  782321
  782515
  782854
  790459
  791930
]
16.12 ms
(10.64%)
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
  444917
  477246
  605828
  782321
  745672
  696871
  718775
  439156
  446562
  498294
  507951
  571726
  454517
  519700
  571194
  542701
  674177
  674204
  677240
  652249
  685506
  691808
  700257
  705809
  569359
  581058
  602782
  620647
  790459
  782854
  742286
  742320
  782515
  751563
  757566
  745100
  755878
  745104
  751609
  761608
  714562
  791930
  391994
  460384
  463687
  464264
  520904
  605725
  454504
  526567
  599478
  388962
  513568
  523355
  482751
  544401
  542706
  548157
  547492
  722384
  554949
  556445
  627049
  391984
  416599
  446641
  421838
  439130
  466455
  471107
  456238
  439274
  487428
  521677
  499836
  571235
  428924
  435398
  455132
  522260
  499383
  504781
  548150
  583085
  432363
  429885
  429861
  435592
  439029
  444194
  470022
  489615
  495470
  522288
  506105
  519699
  439078
  661424
  439317
  434309
  452574
  456226
  467696
  391992
  446709
  418126
  430365
  445103
  448587
  469615
  519368
  509964
  483691
  513654
  517810
  595483
  462840
  470458
  418144
  435547
]
3.01 ms
(1.98%)
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
  388962
  391984
  391992
  391994
  416599
  418126
  418144
  421838
  428924
  429861
  429885
  430365
  432363
  434309
  435398
  435547
  435592
  439029
  439078
  439130
  439156
  439274
  439317
  444194
  444917
  445103
  446562
  446641
  446709
  448587
  452574
  454504
  454517
  455132
  456226
  456238
  460384
  462840
  463687
  464264
  466455
  467696
  469615
  470022
  470458
  471107
  477246
  482751
  483691
  487428
  489615
  495470
  498294
  499383
  499836
  504781
  506105
  507951
  509964
  513568
  513654
  517810
  519368
  519699
  519700
  520904
  521677
  522260
  522288
  523355
  526567
  542701
  542706
  544401
  547492
  548150
  548157
  554949
  556445
  569359
  571194
  571235
  571726
  581058
  583085
  595483
  599478
  602782
  605725
  605828
  620647
  627049
  652249
  661424
  674177
  674204
  677240
  685506
  691808
  696871
  700257
  705809
  714562
  718775
  722384
  742286
  742320
  745100
  745104
  745672
  751563
  751609
  755878
  757566
  761608
  782321
  782515
  782854
  790459
  791930
]
1.89 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian anal solo"
]
1.81 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск анал соло"
]
1.70 ms
(1.12%)
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.