GET https://search.jues.net/search/embeds/5?q=russian%20teens%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.88 ms
(87.16%)
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
  233335
  381959
  390707
  391880
  392554
  397950
  403780
  420577
  420702
  423946
  426785
  431608
  433822
  444119
  444129
  444246
  453647
  454136
  457018
  459599
  459679
  461997
  462738
  465784
  466304
  466974
  470090
  470542
  470687
  471554
  471571
  473975
  475343
  478403
  488070
  494030
  494575
  495047
  498123
  500019
  504169
  525714
  533761
  533785
  534497
  534499
  535618
  537085
  539366
  543719
  544053
  558343
  562492
  566866
  567058
  571454
  574018
  578013
  578825
  588822
  595355
  597031
  599355
  600197
  600208
  600477
  602868
  620091
  628206
  641029
  645895
  650290
  663166
  663828
  673163
  675355
  685127
  687859
  688768
  692440
  692445
  694660
  695097
  705856
  708182
  734189
  741931
  752708
  761782
  762166
  762277
  764101
  764122
  766011
  768042
  778154
  778613
  779124
  782776
  783609
  784696
  786093
  786597
  790260
  790401
  792242
  796537
  799680
  803230
  803842
  804853
  811209
  817987
  818105
  819786
  824946
  825752
]
12.08 ms
(6.80%)
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
  805512
  734189
  764122
  433822
  462738
  431608
  495047
  471554
  381959
  470542
  470687
  539366
  544053
  695097
  578825
  600208
  461997
  534497
  663166
  692445
  470090
  471571
  533785
  543719
  779124
  782776
  784696
  786093
  786597
  803842
  766011
  768042
  741931
  778154
  804853
  444246
  459599
  459679
  233335
  390707
  420577
  500019
  535618
  504169
  494030
  566866
  562492
  645895
  650290
  675355
  692440
  687859
  694660
  571454
  588822
  595355
  600197
  783609
  791973
  752708
  762277
  761782
  708182
  444119
  465784
  453647
  466304
  498123
  525714
  494575
  803230
  778613
  817987
  457018
  790401
  762166
  423946
  426785
  403780
  391880
  818105
  825752
  819786
  790260
  397950
  558343
  392554
  444129
  420702
  475343
  705856
  578013
  790440
  764101
  824946
  533761
  534499
  537085
  574018
  673163
  688768
  663828
  641029
  600477
  628206
  599355
  602868
  792242
  796537
  799680
  811209
  685127
  620091
  597031
  567058
  488070
  478403
  466974
  454136
  473975
]
3.32 ms
(1.87%)
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
  233335
  381959
  390707
  391880
  392554
  397950
  403780
  420577
  420702
  423946
  426785
  431608
  433822
  444119
  444129
  444246
  453647
  454136
  457018
  459599
  459679
  461997
  462738
  465784
  466304
  466974
  470090
  470542
  470687
  471554
  471571
  473975
  475343
  478403
  488070
  494030
  494575
  495047
  498123
  500019
  504169
  525714
  533761
  533785
  534497
  534499
  535618
  537085
  539366
  543719
  544053
  558343
  562492
  566866
  567058
  571454
  574018
  578013
  578825
  588822
  595355
  597031
  599355
  600197
  600208
  600477
  602868
  620091
  628206
  641029
  645895
  650290
  663166
  663828
  673163
  675355
  685127
  687859
  688768
  692440
  692445
  694660
  695097
  705856
  708182
  734189
  741931
  752708
  761782
  762166
  762277
  764101
  764122
  766011
  768042
  778154
  778613
  779124
  782776
  783609
  784696
  786093
  786597
  790260
  790401
  792242
  796537
  799680
  803230
  803842
  804853
  811209
  817987
  818105
  819786
  824946
  825752
]
2.07 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian teens amateur"
]
1.89 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск teens любительск"
]
1.66 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск teens любительск"
]

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.