GET https://search.jues.net/search/embeds/10?q=homemade%20asshole

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.59 ms
(83.74%)
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
  391945
  410734
  416501
  416522
  416561
  416571
  416600
  418111
  418121
  418133
  422273
  426290
  427971
  428700
  429905
  432274
  433002
  434286
  434309
  438013
  439052
  439156
  439924
  441442
  441454
  442524
  443236
  443255
  445661
  446063
  451316
  453332
  453582
  456208
  456478
  457821
  459237
  461704
  463493
  464262
  464804
  465548
  467936
  469027
  473745
  478423
  480857
  483210
  483564
  483711
  483715
  492165
  504810
  511673
  511973
  512931
  513016
  513992
  520786
  520789
  524254
  526556
  526570
  528143
  528474
  529338
  532727
  534553
  541212
  542266
  549739
  552991
  555582
  555847
  556680
  563692
  576920
  584228
  585454
  586838
  590802
  592402
  598668
  600642
  601333
  602165
  602409
  603947
  604286
  604357
  604790
  605015
  606816
  609841
  609885
  612699
  613851
  614966
  624755
  625864
  627361
  634108
  639208
  642022
  646872
  666355
  675110
  680267
  696598
  708517
  709693
  752704
  758779
  760649
  779840
  806668
  814971
  824791
]
16.49 ms
(10.34%)
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
  680267
  675110
  590802
  600642
  602409
  613851
  625864
  604357
  627361
  524254
  708517
  612699
  666355
  603947
  604790
  639208
  709693
  806668
  418111
  441454
  426290
  433002
  439156
  442524
  410734
  534553
  520789
  513992
  542266
  555582
  541212
  549739
  555847
  556680
  584228
  586838
  598668
  605015
  609841
  609885
  592402
  614966
  634108
  601333
  606816
  604286
  624755
  758779
  752704
  602165
  422273
  480857
  416501
  416600
  418133
  429905
  434309
  439924
  434286
  528143
  483715
  483210
  529338
  441442
  416561
  428700
  432274
  443236
  416522
  439052
  416571
  418121
  427971
  824791
  814971
  446063
  453582
  467936
  473745
  451316
  457821
  464804
  483564
  453332
  469027
  504810
  511673
  513372
  465548
  478423
  492165
  563692
  576920
  646872
  696598
  585454
  779840
  760649
  461704
  464262
  391945
  456208
  456478
  456520
  511973
  512931
  526556
  483711
  520786
  526570
  513016
  528474
  438013
  642022
  463493
  532727
  552991
  443255
  459237
  445661
]
2.39 ms
(1.50%)
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
  391945
  410734
  416501
  416522
  416561
  416571
  416600
  418111
  418121
  418133
  422273
  426290
  427971
  428700
  429905
  432274
  433002
  434286
  434309
  438013
  439052
  439156
  439924
  441442
  441454
  442524
  443236
  443255
  445661
  446063
  451316
  453332
  453582
  456208
  456478
  457821
  459237
  461704
  463493
  464262
  464804
  465548
  467936
  469027
  473745
  478423
  480857
  483210
  483564
  483711
  483715
  492165
  504810
  511673
  511973
  512931
  513016
  513992
  520786
  520789
  524254
  526556
  526570
  528143
  528474
  529338
  532727
  534553
  541212
  542266
  549739
  552991
  555582
  555847
  556680
  563692
  576920
  584228
  585454
  586838
  590802
  592402
  598668
  600642
  601333
  602165
  602409
  603947
  604286
  604357
  604790
  605015
  606816
  609841
  609885
  612699
  613851
  614966
  624755
  625864
  627361
  634108
  639208
  642022
  646872
  666355
  675110
  680267
  696598
  708517
  709693
  752704
  758779
  760649
  779840
  806668
  814971
  824791
]
2.06 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade asshole"
]
1.82 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск asshole"
]
1.38 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск asshole"
]

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.