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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.95 ms
(81.94%)
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
  341622
  400936
  403141
  415503
  417212
  417801
  420291
  422049
  422926
  423572
  427263
  428126
  430314
  430404
  433312
  436178
  443323
  444069
  446030
  447500
  452456
  452953
  453337
  455941
  456518
  456705
  460289
  461765
  463094
  463777
  463780
  465299
  466404
  466982
  467960
  468076
  468955
  469198
  469552
  472567
  473539
  474529
  475830
  476123
  477210
  478051
  481904
  481907
  484410
  484724
  485147
  491717
  493192
  494006
  496756
  503119
  504399
  508673
  517836
  522877
  526223
  526693
  527923
  533232
  535282
  540217
  540535
  541588
  541639
  541673
  541821
  541830
  541864
  541879
  541884
  549093
  550277
  550315
  552272
  559453
  560440
  566908
  569204
  573212
  578411
  583690
  583960
  583989
  599854
  599905
  599977
  600022
  600030
  601046
  601324
  605345
  607355
  612343
  613508
  614023
  616205
  622693
  629888
  632595
  632616
  632646
  632680
  637092
  639790
  649619
  651634
  652539
  656183
  665776
  686843
  695123
  699397
  749234
  789878
  803455
]
21.60 ms
(11.96%)
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
  522877
  549093
  629888
  460289
  461765
  622693
  540535
  686843
  436178
  475830
  472567
  616205
  508673
  600030
  433312
  477210
  430404
  415503
  400936
  422049
  468955
  526223
  494006
  541884
  552272
  583960
  517836
  467960
  789878
  465299
  533232
  474529
  541879
  649619
  614023
  605345
  612343
  613508
  607355
  447500
  455941
  541639
  656183
  566908
  527923
  422926
  463780
  476123
  481907
  569204
  550277
  504399
  496756
  341622
  573212
  446030
  469552
  503119
  469198
  749234
  456705
  463094
  473539
  540217
  493192
  417801
  466404
  601324
  481904
  535282
  559453
  665776
  599977
  601046
  599854
  639790
  632646
  468076
  430314
  484410
  444069
  541673
  491717
  526693
  478051
  699397
  560440
  632680
  417212
  420291
  428126
  485147
  541588
  452456
  443323
  541830
  578411
  541821
  550315
  632595
  803455
  632616
  652539
  403141
  423572
  695123
  453337
  466982
  583989
  651634
  637092
  599905
  600022
  484724
  452953
  456518
  427263
  463777
  583690
  541864
]
3.03 ms
(1.68%)
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
  341622
  400936
  403141
  415503
  417212
  417801
  420291
  422049
  422926
  423572
  427263
  428126
  430314
  430404
  433312
  436178
  443323
  444069
  446030
  447500
  452456
  452953
  453337
  455941
  456518
  456705
  460289
  461765
  463094
  463777
  463780
  465299
  466404
  466982
  467960
  468076
  468955
  469198
  469552
  472567
  473539
  474529
  475830
  476123
  477210
  478051
  481904
  481907
  484410
  484724
  485147
  491717
  493192
  494006
  496756
  503119
  504399
  508673
  517836
  522877
  526223
  526693
  527923
  533232
  535282
  540217
  540535
  541588
  541639
  541673
  541821
  541830
  541864
  541879
  541884
  549093
  550277
  550315
  552272
  559453
  560440
  566908
  569204
  573212
  578411
  583690
  583960
  583989
  599854
  599905
  599977
  600022
  600030
  601046
  601324
  605345
  607355
  612343
  613508
  614023
  616205
  622693
  629888
  632595
  632616
  632646
  632680
  637092
  639790
  649619
  651634
  652539
  656183
  665776
  686843
  695123
  699397
  749234
  789878
  803455
]
2.21 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal compilation stockings"
]
2.06 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал подборк чулк нижн бел"
]
1.94 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.98%)
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.