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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.44 ms
(52.08%)
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
  6609
  6656
  24944
  385225
  387160
  398811
  400834
  401456
  406210
  406361
  406372
  406641
  406688
  410651
  411307
  411804
  412991
  415591
  420308
  423505
  426434
  426475
  428220
  428583
  431504
  432675
  433002
  433132
  433507
  439822
  440032
  441057
  441063
  441841
  444022
  445103
  446022
  446079
  448845
  450791
  452832
  454420
  454777
  457429
  457943
  458001
  458965
  460330
  463840
  464042
  464617
  464951
  465062
  465528
  467946
  468148
  469260
  470434
  473450
  475837
  476117
  476136
  476166
  483561
  487711
  503256
  519071
  524798
  526449
  531279
  533733
  534552
  545250
  545461
  547471
  555056
  555337
  568060
  592587
  595309
  596886
  602602
  604497
  619652
  624753
  635450
  716897
  720357
  722442
  723573
  726877
  729280
  731312
  733677
  737554
  744975
  752589
  759401
  761754
  765567
  765729
  767194
  778139
  780799
  788450
  791419
  800360
  802925
  814754
  815142
  815542
  815751
  815927
  816529
  817242
  817786
  820559
  820641
  822002
  825304
]
164.08 ms
(41.20%)
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
  6609
  6656
  24944
  385225
  387160
  398811
  400834
  401456
  406210
  406361
  406372
  406641
  406688
  410651
  411307
  411804
  412991
  415591
  420308
  423505
  426434
  426475
  428220
  428583
  431504
  432675
  433002
  433132
  433507
  439822
  440032
  441057
  441063
  441841
  444022
  445103
  446022
  446079
  448845
  450791
  452832
  454420
  454777
  457429
  457943
  458001
  458965
  460330
  463840
  464042
  464617
  464951
  465062
  465528
  467946
  468148
  469260
  470434
  473450
  475837
  476117
  476136
  476166
  483561
  487711
  503256
  519071
  524798
  526449
  531279
  533733
  534552
  545250
  545461
  547471
  555056
  555337
  568060
  592587
  595309
  596886
  602602
  604497
  619652
  624753
  635450
  716897
  720357
  722442
  723573
  726877
  729280
  731312
  733677
  737554
  744975
  752589
  759401
  761754
  765567
  765729
  767194
  778139
  780799
  788450
  791419
  800360
  802925
  814754
  815142
  815542
  815751
  815927
  816529
  817242
  817786
  820559
  820641
  822002
  825304
]
18.65 ms
(4.68%)
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
  716897
  780799
  788450
  802925
  24944
  433132
  6656
  448845
  604497
  454777
  476117
  439822
  454420
  6609
  398811
  816529
  817786
  820559
  815542
  815751
  815142
  722442
  635450
  778139
  761754
  767194
  791419
  800360
  731312
  737554
  729280
  733677
  765729
  720357
  387160
  406361
  441841
  460330
  473450
  531279
  533733
  503256
  534552
  464951
  476166
  568060
  545250
  555337
  547471
  624753
  592587
  744975
  465062
  423505
  519071
  765567
  428583
  433002
  433507
  411804
  420308
  431504
  467946
  595309
  465528
  415591
  814754
  468148
  555056
  446022
  445103
  545461
  483561
  444022
  411307
  426434
  440032
  458001
  463840
  401456
  476136
  457429
  487711
  406210
  464042
  602602
  406688
  410651
  426475
  825304
  723573
  817242
  820641
  822002
  815927
  469260
  446079
  526449
  524798
  619652
  596886
  759401
  752589
  726877
  385225
  400834
  406641
  406372
  412991
  432675
  441057
  428220
  441063
  452832
  457943
  470434
  450791
  475837
  458965
  464617
]
2.19 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf oil anal"
]
2.14 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf масл анал"
]
2.00 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf масл анал"
]
1.78 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.