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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.63 ms
(87.21%)
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
  382207
  382934
  384271
  385690
  388795
  391371
  409016
  420140
  420299
  421257
  425786
  429881
  432884
  440641
  452363
  453390
  458504
  459388
  459472
  460196
  472606
  475296
  475636
  479148
  483522
  483745
  485661
  487008
  497792
  499568
  513010
  523058
  536524
  550125
  554405
  562159
  562536
  564475
  564480
  569315
  577692
  578323
  581130
  587451
  588811
  589120
  592681
  594136
  596792
  598814
  599239
  599354
  601071
  602222
  607683
  607686
  607692
  607716
  607755
  608650
  611280
  617045
  618799
  626807
  630254
  637363
  641807
  642022
  649372
  660383
  666160
  666704
  668628
  672754
  685526
  691558
  696584
  700468
  705349
  705999
  710847
  710878
  711624
  714203
  715420
  716241
  725742
  733549
  738292
  743231
  744805
  744985
  748431
  758780
  760485
  768650
  776148
  780418
  781792
  782057
  782093
  782094
  788753
  797053
  800657
  804241
  804432
  806995
  807590
  807827
  811125
  812467
  812480
  813793
  824531
  824632
  824633
  824733
  824837
  827395
]
14.25 ms
(7.41%)
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
  425786
  459388
  744805
  780418
  705349
  760485
  641807
  811125
  607692
  536524
  472606
  523058
  384271
  812480
  714203
  598814
  806995
  758780
  705999
  710878
  691558
  607755
  804241
  601071
  716241
  637363
  788753
  800657
  812467
  483522
  630254
  685526
  577692
  596792
  781792
  459472
  475636
  672754
  660383
  807827
  824531
  432884
  391371
  440641
  649372
  420299
  385690
  666160
  409016
  738292
  485661
  782057
  711624
  562536
  587451
  607683
  768650
  550125
  513010
  382207
  824632
  827395
  483745
  479148
  421257
  710847
  602222
  776148
  797053
  743231
  388795
  813793
  564480
  696584
  589120
  499568
  668628
  611280
  599239
  554405
  607686
  608650
  618799
  569315
  592681
  807590
  382934
  824733
  715420
  588811
  804432
  733549
  748431
  562159
  564475
  700468
  594136
  782093
  782094
  824633
  497792
  626807
  725742
  452363
  475296
  487008
  824837
  642022
  666704
  599354
  607716
  581130
  744985
  578323
  420140
  617045
  453390
  429881
  458504
  460196
]
3.33 ms
(1.73%)
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
  382207
  382934
  384271
  385690
  388795
  391371
  409016
  420140
  420299
  421257
  425786
  429881
  432884
  440641
  452363
  453390
  458504
  459388
  459472
  460196
  472606
  475296
  475636
  479148
  483522
  483745
  485661
  487008
  497792
  499568
  513010
  523058
  536524
  550125
  554405
  562159
  562536
  564475
  564480
  569315
  577692
  578323
  581130
  587451
  588811
  589120
  592681
  594136
  596792
  598814
  599239
  599354
  601071
  602222
  607683
  607686
  607692
  607716
  607755
  608650
  611280
  617045
  618799
  626807
  630254
  637363
  641807
  642022
  649372
  660383
  666160
  666704
  668628
  672754
  685526
  691558
  696584
  700468
  705349
  705999
  710847
  710878
  711624
  714203
  715420
  716241
  725742
  733549
  738292
  743231
  744805
  744985
  748431
  758780
  760485
  768650
  776148
  780418
  781792
  782057
  782093
  782094
  788753
  797053
  800657
  804241
  804432
  806995
  807590
  807827
  811125
  812467
  812480
  813793
  824531
  824632
  824633
  824733
  824837
  827395
]
1.95 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy dildo solo"
]
1.72 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая дилд соло"
]
1.69 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.86%)
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.