GET https://search.jues.net/search/embeds/8?q=threesome%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
201.24 ms
(90.77%)
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
  391893
  393384
  397895
  403938
  410855
  417844
  419176
  429025
  453512
  453852
  461884
  462685
  466317
  469494
  481591
  502021
  517301
  530289
  532367
  532681
  532717
  533689
  534133
  535789
  536202
  539018
  540122
  543688
  543982
  544252
  545091
  553241
  554876
  556050
  557942
  566394
  579305
  592708
  593859
  593893
  597183
  600058
  603515
  603608
  603646
  603649
  606535
  610780
  617692
  622116
  622179
  625363
  632048
  632251
  633045
  633049
  633965
  635780
  635863
  641852
  648996
  649169
  649627
  650642
  651313
  651318
  651423
  653603
  653628
  653634
  653880
  654293
  669637
  679549
  692470
  693816
  694128
  696167
  702954
  703207
  711258
  718059
  723074
  724449
  731358
  732704
  737893
  744856
  748446
  749548
  755134
  758035
  761453
  762269
  767857
  767861
  770837
  775794
  779170
  779794
  783112
  789011
  790413
  793200
  793231
  801467
  804508
  805368
  806376
  809184
  809399
  812998
  817434
  817663
  825628
  825949
  825998
  827830
  827873
  827896
]
10.47 ms
(4.72%)
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
  453852
  553241
  597183
  556050
  466317
  453512
  481591
  653634
  651313
  653628
  711258
  653603
  593893
  622116
  635780
  633965
  825949
  809399
  737893
  429025
  461884
  603608
  633045
  502021
  761453
  693816
  610780
  793200
  557942
  603649
  417844
  817434
  649169
  724449
  393384
  462685
  517301
  593859
  748446
  827873
  827896
  530289
  532717
  540122
  534133
  566394
  554876
  648996
  651423
  679549
  692470
  694128
  649627
  651318
  653880
  654293
  696167
  592708
  600058
  622179
  632251
  603646
  633049
  635863
  617692
  603515
  755134
  793231
  779170
  806376
  732704
  758035
  801467
  702954
  805368
  703207
  783112
  632048
  410855
  625363
  535789
  543688
  650642
  825998
  579305
  545091
  779794
  536202
  419176
  718059
  790413
  804508
  809184
  744856
  812998
  397895
  391893
  817663
  825628
  532681
  544252
  770837
  749548
  762269
  767857
  767861
  731358
  789011
  403938
  827830
  532367
  669637
  469494
  543982
  723074
  641852
  775794
  533689
  539018
  606535
]
2.57 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome amateur"
]
2.32 ms
(1.05%)
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
  391893
  393384
  397895
  403938
  410855
  417844
  419176
  429025
  453512
  453852
  461884
  462685
  466317
  469494
  481591
  502021
  517301
  530289
  532367
  532681
  532717
  533689
  534133
  535789
  536202
  539018
  540122
  543688
  543982
  544252
  545091
  553241
  554876
  556050
  557942
  566394
  579305
  592708
  593859
  593893
  597183
  600058
  603515
  603608
  603646
  603649
  606535
  610780
  617692
  622116
  622179
  625363
  632048
  632251
  633045
  633049
  633965
  635780
  635863
  641852
  648996
  649169
  649627
  650642
  651313
  651318
  651423
  653603
  653628
  653634
  653880
  654293
  669637
  679549
  692470
  693816
  694128
  696167
  702954
  703207
  711258
  718059
  723074
  724449
  731358
  732704
  737893
  744856
  748446
  749548
  755134
  758035
  761453
  762269
  767857
  767861
  770837
  775794
  779170
  779794
  783112
  789011
  790413
  793200
  793231
  801467
  804508
  805368
  806376
  809184
  809399
  812998
  817434
  817663
  825628
  825949
  825998
  827830
  827873
  827896
]
1.81 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро любительск"
]
1.62 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.