GET https://search.jues.net/search/embeds/8?q=milf%20video

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.16 ms
(84.40%)
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
  381933
  389023
  413126
  415561
  415577
  415632
  415879
  421061
  428710
  440534
  442189
  452869
  454239
  454243
  454548
  454752
  458707
  459173
  459191
  459684
  464246
  467961
  470663
  470726
  476091
  476168
  479044
  479053
  479955
  486173
  486190
  488233
  489379
  490517
  491431
  494290
  494312
  495031
  495138
  498363
  499099
  500464
  500576
  500916
  506222
  509799
  510519
  511388
  511872
  513131
  514790
  514935
  516492
  519349
  519738
  519894
  521391
  522447
  522673
  523933
  525233
  525848
  528913
  528942
  529704
  532166
  532170
  532266
  532364
  539047
  542529
  542730
  544768
  546716
  547622
  552992
  555055
  556009
  557438
  557521
  559087
  562398
  564121
  565008
  565018
  566002
  566059
  566074
  567400
  570959
  575329
  580388
  580623
  581306
  582235
  583142
  591277
  592891
  595101
  596234
  601444
  605588
  612068
  623822
  631478
  637048
  641414
  646872
  668804
  690831
  694534
  696430
  700134
  700284
  707368
  786120
  791209
  796877
  799591
  810698
]
15.97 ms
(10.04%)
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
  459684
  479955
  415561
  440534
  454239
  470726
  479044
  442189
  467961
  511872
  514790
  523933
  525848
  488233
  494290
  495031
  510519
  511388
  486173
  486190
  498363
  506222
  516492
  519738
  521391
  522447
  525233
  491431
  556009
  786120
  494312
  522673
  489379
  381933
  389023
  413126
  421061
  428710
  415879
  415632
  605588
  454548
  458707
  459191
  490517
  476168
  452869
  459173
  479053
  495138
  500464
  500916
  513131
  532266
  519349
  519894
  529704
  539047
  499099
  500576
  509799
  514935
  528942
  532166
  532170
  532364
  528913
  464246
  470663
  566002
  580388
  581306
  582235
  583142
  542529
  542730
  544768
  546716
  555055
  564121
  565008
  566074
  567400
  570959
  580623
  547622
  557438
  565018
  566059
  690831
  694534
  707368
  646872
  668804
  696430
  552992
  557521
  559087
  562398
  575329
  591277
  596234
  595101
  623822
  631478
  592891
  601444
  637048
  641414
  791209
  799591
  810698
  612068
  700134
  700284
  796877
  415577
  454243
  454752
  476091
]
2.62 ms
(1.65%)
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
  381933
  389023
  413126
  415561
  415577
  415632
  415879
  421061
  428710
  440534
  442189
  452869
  454239
  454243
  454548
  454752
  458707
  459173
  459191
  459684
  464246
  467961
  470663
  470726
  476091
  476168
  479044
  479053
  479955
  486173
  486190
  488233
  489379
  490517
  491431
  494290
  494312
  495031
  495138
  498363
  499099
  500464
  500576
  500916
  506222
  509799
  510519
  511388
  511872
  513131
  514790
  514935
  516492
  519349
  519738
  519894
  521391
  522447
  522673
  523933
  525233
  525848
  528913
  528942
  529704
  532166
  532170
  532266
  532364
  539047
  542529
  542730
  544768
  546716
  547622
  552992
  555055
  556009
  557438
  557521
  559087
  562398
  564121
  565008
  565018
  566002
  566059
  566074
  567400
  570959
  575329
  580388
  580623
  581306
  582235
  583142
  591277
  592891
  595101
  596234
  601444
  605588
  612068
  623822
  631478
  637048
  641414
  646872
  668804
  690831
  694534
  696430
  700134
  700284
  707368
  786120
  791209
  796877
  799591
  810698
]
1.79 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf video"
]
1.49 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf video"
]
1.47 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf video"
]

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.