GET https://search.jues.net/search/embeds/6?q=anal%20compilation%20stockings

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.31 ms
(81.81%)
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
  47707
  97377
  386798
  391202
  414337
  415112
  416529
  416751
  424682
  427174
  428116
  429805
  433147
  436230
  443090
  445641
  448414
  449115
  451866
  452311
  452773
  453623
  460209
  463098
  463825
  464372
  465604
  466294
  466801
  467763
  469520
  469766
  470015
  471439
  471881
  474663
  475684
  476098
  477073
  477076
  477587
  477744
  478517
  478575
  480296
  480457
  483544
  484809
  484899
  486589
  487632
  492701
  495397
  495401
  496794
  498551
  502102
  505069
  508692
  516656
  517308
  519209
  520216
  527568
  532817
  532876
  535621
  536712
  540167
  541650
  549086
  553480
  558012
  564646
  568190
  568423
  568457
  569132
  569176
  569197
  571235
  574384
  586569
  597170
  602519
  605521
  607091
  610616
  616036
  620163
  625783
  629893
  629951
  630542
  637002
  647322
  647663
  650315
  651607
  652544
  674082
  674863
  677707
  680271
  681691
  709645
  711283
  729344
  770225
  778607
  784146
  788608
  790219
  792557
  799785
  801259
  811102
  815600
  819557
  824263
]
18.23 ms
(12.19%)
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
  517308
  429805
  449115
  681691
  811102
  451866
  443090
  452311
  770225
  569176
  505069
  647663
  647322
  498551
  484809
  471439
  470015
  47707
  819557
  508692
  586569
  391202
  484899
  520216
  97377
  452773
  553480
  453623
  414337
  477076
  652544
  463825
  478575
  571235
  466294
  478517
  448414
  527568
  799785
  574384
  424682
  477587
  483544
  427174
  428116
  416529
  558012
  540167
  625783
  616036
  476098
  465604
  467763
  516656
  477073
  464372
  568423
  568457
  463098
  535621
  541650
  486589
  496794
  495397
  629893
  610616
  445641
  474663
  480457
  532817
  502102
  568190
  674082
  677707
  674863
  709645
  607091
  620163
  778607
  801259
  788608
  729344
  790219
  477744
  711283
  475684
  436230
  386798
  466801
  519209
  630542
  784146
  792557
  824263
  650315
  564646
  569132
  651607
  602519
  629951
  597170
  469520
  415112
  433147
  536712
  637002
  605521
  416751
  815600
  471881
  680271
  487632
  495401
  492701
  469766
  480296
  532876
  460209
  549086
  569197
]
2.37 ms
(1.58%)
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
  47707
  97377
  386798
  391202
  414337
  415112
  416529
  416751
  424682
  427174
  428116
  429805
  433147
  436230
  443090
  445641
  448414
  449115
  451866
  452311
  452773
  453623
  460209
  463098
  463825
  464372
  465604
  466294
  466801
  467763
  469520
  469766
  470015
  471439
  471881
  474663
  475684
  476098
  477073
  477076
  477587
  477744
  478517
  478575
  480296
  480457
  483544
  484809
  484899
  486589
  487632
  492701
  495397
  495401
  496794
  498551
  502102
  505069
  508692
  516656
  517308
  519209
  520216
  527568
  532817
  532876
  535621
  536712
  540167
  541650
  549086
  553480
  558012
  564646
  568190
  568423
  568457
  569132
  569176
  569197
  571235
  574384
  586569
  597170
  602519
  605521
  607091
  610616
  616036
  620163
  625783
  629893
  629951
  630542
  637002
  647322
  647663
  650315
  651607
  652544
  674082
  674863
  677707
  680271
  681691
  709645
  711283
  729344
  770225
  778607
  784146
  788608
  790219
  792557
  799785
  801259
  811102
  815600
  819557
  824263
]
1.92 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal compilation stockings"
]
1.61 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал подборк чулк нижн бел"
]
1.59 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.