GET https://search.jues.net/search/embeds/2?q=dildo%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
250.35 ms
(91.26%)
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
  182213
  394590
  417348
  444064
  444485
  462225
  494529
  514117
  531852
  532639
  539898
  550262
  569391
  569633
  582076
  587559
  592519
  595229
  607107
  607755
  607891
  619026
  621827
  623275
  624379
  634027
  636716
  637364
  640131
  641982
  642085
  656812
  659234
  663234
  663317
  701313
  703339
  704100
  705007
  707710
  709824
  712496
  713186
  722398
  728904
  734214
  735297
  736014
  739818
  740578
  745201
  745907
  745921
  745931
  746085
  748290
  752657
  753202
  753918
  754425
  754532
  756843
  759418
  760545
  760594
  764087
  764724
  765164
  770465
  772243
  772261
  774774
  774881
  777767
  777982
  778120
  779291
  780189
  780263
  780360
  781251
  781420
  782046
  782080
  782141
  782334
  782952
  783034
  783715
  785079
  788530
  788531
  790091
  791122
  791184
  791503
  792067
  792697
  792723
  792729
  793017
  793133
  794312
  796689
  796709
  796716
  796965
  796994
  803613
  805046
  806139
  806694
  806764
  810177
  811331
  811733
  812031
  813195
  813796
  814671
]
12.99 ms
(4.73%)
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
  796709
  806139
  621827
  734214
  705007
  587559
  792729
  752657
  641982
  794312
  745921
  811733
  569633
  753918
  607891
  494529
  805046
  777982
  782141
  782080
  780189
  813195
  182213
  656812
  703339
  704100
  701313
  637364
  592519
  636716
  707710
  659234
  709824
  634027
  745907
  514117
  722398
  642085
  623275
  774774
  792067
  810177
  811331
  780263
  791184
  792723
  806694
  754532
  772261
  783034
  783715
  785079
  793133
  759418
  764087
  728904
  739818
  740578
  746085
  770465
  735297
  736014
  748290
  753202
  756843
  772243
  640131
  778120
  780360
  813796
  814671
  539898
  532639
  619026
  782952
  788530
  790091
  774881
  782046
  788531
  791122
  796965
  781420
  793017
  765164
  754425
  760545
  764724
  777767
  779291
  781251
  782334
  791503
  796689
  796994
  803613
  806764
  812031
  462225
  394590
  712496
  531852
  582076
  663234
  550262
  745201
  760594
  569391
  663317
  796716
  745931
  792697
  417348
  624379
  444485
  713186
  595229
  607107
  444064
  607755
]
3.09 ms
(1.13%)
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
  182213
  394590
  417348
  444064
  444485
  462225
  494529
  514117
  531852
  532639
  539898
  550262
  569391
  569633
  582076
  587559
  592519
  595229
  607107
  607755
  607891
  619026
  621827
  623275
  624379
  634027
  636716
  637364
  640131
  641982
  642085
  656812
  659234
  663234
  663317
  701313
  703339
  704100
  705007
  707710
  709824
  712496
  713186
  722398
  728904
  734214
  735297
  736014
  739818
  740578
  745201
  745907
  745921
  745931
  746085
  748290
  752657
  753202
  753918
  754425
  754532
  756843
  759418
  760545
  760594
  764087
  764724
  765164
  770465
  772243
  772261
  774774
  774881
  777767
  777982
  778120
  779291
  780189
  780263
  780360
  781251
  781420
  782046
  782080
  782141
  782334
  782952
  783034
  783715
  785079
  788530
  788531
  790091
  791122
  791184
  791503
  792067
  792697
  792723
  792729
  793017
  793133
  794312
  796689
  796709
  796716
  796965
  796994
  803613
  805046
  806139
  806694
  806764
  810177
  811331
  811733
  812031
  813195
  813796
  814671
]
2.14 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд домашн любительск"
]
2.08 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo homemade"
]
1.93 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд домашн любительск"
]
1.74 ms
(0.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.