GET https://search.jues.net/search/embeds/2?q=hairy%20amateur%20compilation

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.26 ms
(83.03%)
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
  389307
  390131
  398325
  398567
  418547
  421732
  423793
  427448
  431702
  442615
  442619
  442620
  442648
  446551
  446661
  448300
  451771
  457787
  461775
  464364
  466466
  466492
  466884
  466888
  470007
  471650
  472102
  472657
  472678
  472687
  475656
  475681
  475682
  475685
  475686
  475689
  477069
  479926
  484981
  487057
  490595
  490603
  491631
  495286
  495730
  496841
  499568
  499842
  505970
  506156
  508773
  509113
  509664
  522702
  537175
  539349
  546059
  555479
  555594
  555607
  564751
  570941
  572172
  573196
  574049
  579376
  579377
  581992
  583083
  585050
  588017
  590730
  592948
  596961
  597730
  599577
  602218
  603554
  604059
  610154
  614834
  616359
  629554
  629602
  629647
  630414
  648710
  649429
  652890
  654935
  673528
  694366
  696108
  708583
  710866
  712053
  722168
  735132
  735622
  735798
  742067
  752603
  757176
  764420
  765668
  768157
  782481
  789616
  793671
  800611
  801351
  803819
  803960
  807855
  812745
  819309
  823968
  824555
  825711
  826455
]
15.65 ms
(10.37%)
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
  696108
  446551
  505970
  629602
  807855
  457787
  819309
  602218
  812745
  466466
  710866
  629647
  475656
  461775
  496841
  803960
  555479
  506156
  472687
  592948
  499842
  803819
  490595
  825711
  472678
  581992
  648710
  712053
  610154
  793671
  768157
  442648
  537175
  782481
  599577
  649429
  475681
  824555
  475685
  390131
  446661
  448300
  431702
  442615
  475682
  427448
  442620
  471650
  801351
  490603
  596961
  451771
  826455
  673528
  466492
  694366
  800611
  590730
  477069
  495730
  764420
  765668
  742067
  579376
  752603
  470007
  475686
  570941
  735622
  472102
  539349
  614834
  421732
  442619
  579377
  574049
  555607
  583083
  479926
  484981
  472657
  508773
  652890
  735798
  757176
  522702
  495286
  708583
  616359
  466888
  823968
  722168
  418547
  466884
  509113
  398567
  597730
  585050
  564751
  573196
  555594
  630414
  735132
  398325
  389307
  572172
  603554
  789616
  475689
  491631
  654935
  629554
  423793
  487057
  604059
  499568
  588017
  509664
  464364
  546059
]
2.68 ms
(1.78%)
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
  389307
  390131
  398325
  398567
  418547
  421732
  423793
  427448
  431702
  442615
  442619
  442620
  442648
  446551
  446661
  448300
  451771
  457787
  461775
  464364
  466466
  466492
  466884
  466888
  470007
  471650
  472102
  472657
  472678
  472687
  475656
  475681
  475682
  475685
  475686
  475689
  477069
  479926
  484981
  487057
  490595
  490603
  491631
  495286
  495730
  496841
  499568
  499842
  505970
  506156
  508773
  509113
  509664
  522702
  537175
  539349
  546059
  555479
  555594
  555607
  564751
  570941
  572172
  573196
  574049
  579376
  579377
  581992
  583083
  585050
  588017
  590730
  592948
  596961
  597730
  599577
  602218
  603554
  604059
  610154
  614834
  616359
  629554
  629602
  629647
  630414
  648710
  649429
  652890
  654935
  673528
  694366
  696108
  708583
  710866
  712053
  722168
  735132
  735622
  735798
  742067
  752603
  757176
  764420
  765668
  768157
  782481
  789616
  793671
  800611
  801351
  803819
  803960
  807855
  812745
  819309
  823968
  824555
  825711
  826455
]
1.99 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая любительск подборк"
]
1.89 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая любительск подборк"
]
1.71 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy amateur compilation"
]

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.