GET https://search.jues.net/search/embeds/5?q=natural%20milf%20creampie

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.44 ms
(82.30%)
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
  390573
  407903
  411975
  414893
  417095
  418047
  418956
  420757
  422170
  423571
  426658
  427770
  427971
  428090
  430644
  437679
  440744
  442775
  452633
  455373
  458985
  460864
  467663
  467960
  477597
  477888
  484296
  490797
  490825
  491461
  495143
  496973
  498811
  501676
  507909
  511061
  511287
  511315
  511319
  511328
  512875
  513964
  514488
  515056
  515575
  517469
  520437
  520680
  525307
  527962
  528562
  528570
  529331
  531417
  533278
  534642
  538624
  540073
  545139
  546107
  549686
  549708
  552994
  560435
  562975
  569632
  578762
  580930
  584111
  584365
  587821
  589070
  591315
  591877
  599010
  603420
  604677
  612232
  615919
  618272
  618735
  620208
  622366
  630092
  630664
  635973
  636579
  637247
  656495
  666188
  691201
  702881
  714779
  716972
  719851
  720965
  727032
  728229
  733236
  735910
  748218
  756321
  758210
  761047
  761293
  764909
  765463
  768758
  771442
  783992
  784754
  785386
  794247
  795807
  797012
  797133
  803208
  805772
  813029
  814995
]
23.23 ms
(12.07%)
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
  490797
  490825
  498811
  511315
  520680
  515575
  520437
  531417
  534642
  538624
  540073
  511061
  529331
  533278
  467663
  546107
  549686
  549708
  560435
  545139
  569632
  580930
  552994
  656495
  720965
  666188
  691201
  702881
  714779
  719851
  562975
  578762
  584111
  604677
  637247
  599010
  620208
  591315
  612232
  615919
  589070
  591877
  630092
  794247
  795807
  803208
  805772
  813029
  733236
  761293
  765463
  784754
  785386
  748218
  728229
  756321
  764909
  735910
  727032
  758210
  761047
  618735
  622366
  630664
  635973
  783992
  797133
  428090
  420757
  442775
  455373
  390573
  407903
  426658
  427770
  460864
  507909
  514488
  528570
  477597
  512875
  618272
  603420
  491461
  584365
  716972
  797012
  771442
  768758
  527962
  418956
  477888
  587821
  636579
  430644
  440744
  501676
  418047
  422170
  423571
  437679
  411975
  414893
  417095
  427971
  814995
  458985
  467960
  484296
  452633
  515056
  496973
  511319
  511328
  513964
  525307
  511287
  517469
  528562
  495143
]
2.83 ms
(1.47%)
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
  390573
  407903
  411975
  414893
  417095
  418047
  418956
  420757
  422170
  423571
  426658
  427770
  427971
  428090
  430644
  437679
  440744
  442775
  452633
  455373
  458985
  460864
  467663
  467960
  477597
  477888
  484296
  490797
  490825
  491461
  495143
  496973
  498811
  501676
  507909
  511061
  511287
  511315
  511319
  511328
  512875
  513964
  514488
  515056
  515575
  517469
  520437
  520680
  525307
  527962
  528562
  528570
  529331
  531417
  533278
  534642
  538624
  540073
  545139
  546107
  549686
  549708
  552994
  560435
  562975
  569632
  578762
  580930
  584111
  584365
  587821
  589070
  591315
  591877
  599010
  603420
  604677
  612232
  615919
  618272
  618735
  620208
  622366
  630092
  630664
  635973
  636579
  637247
  656495
  666188
  691201
  702881
  714779
  716972
  719851
  720965
  727032
  728229
  733236
  735910
  748218
  756321
  758210
  761047
  761293
  764909
  765463
  768758
  771442
  783992
  784754
  785386
  794247
  795807
  797012
  797133
  803208
  805772
  813029
  814995
]
2.53 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "natural milf creampie"
]
1.93 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "натуральная натуральные milf creampie"
]
1.89 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "натуральная натуральные milf creampie"
]

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.