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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.20 ms
(82.13%)
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
  14602
  341889
  387915
  395162
  395919
  396725
  397192
  398132
  398477
  401615
  402386
  404940
  411804
  414360
  417723
  417967
  418487
  421740
  422469
  427585
  439463
  444437
  447558
  452931
  454623
  456048
  457310
  458699
  460769
  461644
  464211
  464256
  466027
  466883
  468100
  468395
  472337
  487338
  493849
  494327
  501755
  512010
  517999
  518250
  519555
  519726
  523563
  525748
  526162
  530371
  531113
  531143
  531200
  531212
  531844
  533696
  533783
  534432
  535051
  535057
  535643
  536598
  537881
  537887
  537936
  541706
  541867
  544810
  545183
  553122
  555098
  559018
  560636
  564293
  564377
  564555
  569149
  580597
  581188
  581242
  583541
  590078
  599946
  604257
  604669
  610728
  618850
  620224
  620240
  623003
  630544
  631245
  634157
  634533
  634546
  635968
  637439
  638191
  646900
  650160
  660310
  667760
  674936
  690786
  696226
  706058
  712558
  714613
  715373
  717701
  727751
  728465
  756078
  757331
  777580
  777905
  786532
  792088
  817608
  818569
]
16.20 ms
(10.46%)
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
  454623
  458699
  519726
  512010
  402386
  464211
  536598
  533696
  631245
  14602
  817608
  456048
  531844
  564293
  560636
  712558
  674936
  706058
  590078
  623003
  620240
  620224
  777580
  638191
  396725
  421740
  444437
  466883
  650160
  756078
  786532
  341889
  395162
  397192
  555098
  714613
  690786
  518250
  717701
  777905
  395919
  583541
  696226
  660310
  604669
  610728
  472337
  541706
  414360
  818569
  452931
  523563
  544810
  757331
  533783
  531212
  534432
  535051
  634533
  537881
  581188
  581242
  494327
  411804
  457310
  461644
  580597
  564555
  401615
  531113
  667760
  387915
  398132
  417723
  417967
  468100
  466027
  526162
  541867
  727751
  404940
  460769
  398477
  517999
  519555
  531200
  537936
  545183
  559018
  553122
  569149
  646900
  599946
  618850
  635968
  604257
  634157
  630544
  637439
  792088
  728465
  715373
  493849
  439463
  537887
  531143
  464256
  468395
  418487
  447558
  422469
  427585
  487338
  501755
  525748
  634546
  564377
  535057
  530371
  535643
]
3.24 ms
(2.09%)
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
  14602
  341889
  387915
  395162
  395919
  396725
  397192
  398132
  398477
  401615
  402386
  404940
  411804
  414360
  417723
  417967
  418487
  421740
  422469
  427585
  439463
  444437
  447558
  452931
  454623
  456048
  457310
  458699
  460769
  461644
  464211
  464256
  466027
  466883
  468100
  468395
  472337
  487338
  493849
  494327
  501755
  512010
  517999
  518250
  519555
  519726
  523563
  525748
  526162
  530371
  531113
  531143
  531200
  531212
  531844
  533696
  533783
  534432
  535051
  535057
  535643
  536598
  537881
  537887
  537936
  541706
  541867
  544810
  545183
  553122
  555098
  559018
  560636
  564293
  564377
  564555
  569149
  580597
  581188
  581242
  583541
  590078
  599946
  604257
  604669
  610728
  618850
  620224
  620240
  623003
  630544
  631245
  634157
  634533
  634546
  635968
  637439
  638191
  646900
  650160
  660310
  667760
  674936
  690786
  696226
  706058
  712558
  714613
  715373
  717701
  727751
  728465
  756078
  757331
  777580
  777905
  786532
  792088
  817608
  818569
]
2.27 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deep anal big"
]
2.16 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "deep анал большие"
]
2.13 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "deep анал большие"
]

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.