GET https://search.jues.net/search/embeds/10?q=extreme%20double%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.79 ms
(86.96%)
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
  15129
  85792
  96636
  96690
  96952
  159370
  326134
  358596
  361993
  383075
  383531
  386460
  386596
  386935
  388474
  389243
  391537
  395446
  395706
  396330
  396562
  396708
  398492
  399926
  400270
  400912
  400943
  401629
  405045
  405178
  405182
  405848
  406290
  408439
  409652
  411745
  413711
  414364
  414448
  419517
  421107
  423708
  426403
  426511
  441081
  445941
  446330
  458115
  467882
  476671
  483730
  493839
  495126
  497692
  510402
  514220
  530484
  531129
  531134
  531179
  531209
  531211
  531233
  531248
  533043
  533911
  533931
  534201
  534553
  534999
  535005
  535505
  536178
  536283
  537899
  537902
  537922
  542213
  581098
  583693
  583707
  583960
  595249
  600270
  600338
  601575
  631202
  632623
  634786
  634791
  637004
  639048
  639729
  640733
  641375
  649583
  650322
  660375
  666536
  666553
  666871
  666877
  666912
  677781
  678125
  678127
  679744
  699627
  705817
  721103
  724330
  726315
  730461
  733843
  748961
  788794
  805601
  806688
  808655
  817430
]
14.81 ms
(8.21%)
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
  533911
  534201
  535005
  537899
  510402
  530484
  531209
  531211
  533043
  536283
  537902
  583707
  542213
  583693
  666877
  679744
  650322
  666553
  660375
  678125
  600270
  748961
  632623
  639729
  640733
  396330
  467882
  358596
  388474
  401629
  413711
  419517
  426511
  383075
  383531
  326134
  96636
  96690
  389243
  386935
  396708
  405848
  405178
  409652
  411745
  426403
  414364
  414448
  423708
  817430
  446330
  458115
  476671
  483730
  495126
  534553
  536178
  537922
  531134
  531248
  533931
  531179
  531233
  514220
  534999
  699627
  705817
  721103
  649583
  666912
  666536
  639048
  641375
  595249
  600338
  601575
  805601
  808655
  788794
  806688
  726315
  724330
  730461
  733843
  634786
  634791
  386460
  400912
  400943
  408439
  421107
  441081
  395706
  405045
  445941
  386596
  395446
  396562
  399926
  405182
  406290
  361993
  391537
  400270
  493839
  497692
  535505
  583960
  677781
  666871
  678127
  581098
  637004
  631202
  531129
  85792
  96952
  159370
  15129
  398492
]
2.56 ms
(1.42%)
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
  15129
  85792
  96636
  96690
  96952
  159370
  326134
  358596
  361993
  383075
  383531
  386460
  386596
  386935
  388474
  389243
  391537
  395446
  395706
  396330
  396562
  396708
  398492
  399926
  400270
  400912
  400943
  401629
  405045
  405178
  405182
  405848
  406290
  408439
  409652
  411745
  413711
  414364
  414448
  419517
  421107
  423708
  426403
  426511
  441081
  445941
  446330
  458115
  467882
  476671
  483730
  493839
  495126
  497692
  510402
  514220
  530484
  531129
  531134
  531179
  531209
  531211
  531233
  531248
  533043
  533911
  533931
  534201
  534553
  534999
  535005
  535505
  536178
  536283
  537899
  537902
  537922
  542213
  581098
  583693
  583707
  583960
  595249
  600270
  600338
  601575
  631202
  632623
  634786
  634791
  637004
  639048
  639729
  640733
  641375
  649583
  650322
  660375
  666536
  666553
  666871
  666877
  666912
  677781
  678125
  678127
  679744
  699627
  705817
  721103
  724330
  726315
  730461
  733843
  748961
  788794
  805601
  806688
  808655
  817430
]
2.11 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme double anal"
]
1.50 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.27 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор double анал"
]
1.26 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор double анал"
]

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.