GET https://search.jues.net/search/embeds/5?q=hidden%20public%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.81 ms
(83.62%)
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
  78786
  420235
  420310
  425223
  440977
  444615
  446551
  446553
  447908
  448319
  453925
  454416
  455800
  457049
  457057
  457112
  457668
  457723
  457726
  457730
  457767
  457776
  457778
  457787
  458528
  459160
  459470
  461274
  462297
  466530
  467174
  467999
  468928
  468942
  469229
  469230
  469234
  469248
  469249
  469254
  472038
  472131
  473206
  473649
  483757
  484250
  485483
  486197
  486842
  488214
  488221
  488233
  488716
  489796
  494661
  494866
  494975
  495499
  498111
  499565
  499720
  501235
  503449
  503907
  504415
  505430
  506520
  507216
  508588
  509492
  510570
  510734
  519101
  519366
  519811
  519815
  522416
  523137
  534347
  534354
  534946
  543016
  544454
  544610
  545352
  548403
  552716
  553178
  553774
  558113
  559110
  559584
  559609
  560901
  567591
  571479
  572851
  572862
  578101
  579661
  579896
  596131
  596463
  600875
  601826
  613320
  614417
  615426
  619785
  634448
  651678
  670208
  671886
  680210
  683300
  699044
  721908
  744924
  748464
  795913
]
15.83 ms
(10.12%)
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
  469254
  558113
  495499
  559609
  454416
  634448
  469234
  494866
  457057
  613320
  523137
  503907
  457049
  472038
  501235
  467174
  680210
  670208
  457787
  579896
  519366
  651678
  744924
  459470
  671886
  683300
  473206
  559110
  467999
  544610
  486197
  457726
  721908
  489796
  484250
  448319
  440977
  505430
  78786
  615426
  488221
  455800
  560901
  462297
  457112
  614417
  508588
  469248
  483757
  425223
  486842
  488214
  519815
  795913
  472131
  494975
  572862
  596131
  453925
  468928
  619785
  420310
  469230
  469249
  468942
  469229
  458528
  499565
  488716
  447908
  457730
  457776
  506520
  548403
  578101
  601826
  498111
  543016
  559584
  600875
  572851
  494661
  420235
  446551
  534946
  545352
  552716
  553774
  579661
  457778
  509492
  553178
  504415
  699044
  519101
  485483
  503449
  567591
  571479
  510734
  473649
  596463
  466530
  444615
  748464
  507216
  522416
  499720
  459160
  534347
  457723
  534354
  488233
  457767
  446553
  457668
  510570
  519811
  544454
  461274
]
2.90 ms
(1.85%)
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
  78786
  420235
  420310
  425223
  440977
  444615
  446551
  446553
  447908
  448319
  453925
  454416
  455800
  457049
  457057
  457112
  457668
  457723
  457726
  457730
  457767
  457776
  457778
  457787
  458528
  459160
  459470
  461274
  462297
  466530
  467174
  467999
  468928
  468942
  469229
  469230
  469234
  469248
  469249
  469254
  472038
  472131
  473206
  473649
  483757
  484250
  485483
  486197
  486842
  488214
  488221
  488233
  488716
  489796
  494661
  494866
  494975
  495499
  498111
  499565
  499720
  501235
  503449
  503907
  504415
  505430
  506520
  507216
  508588
  509492
  510570
  510734
  519101
  519366
  519811
  519815
  522416
  523137
  534347
  534354
  534946
  543016
  544454
  544610
  545352
  548403
  552716
  553178
  553774
  558113
  559110
  559584
  559609
  560901
  567591
  571479
  572851
  572862
  578101
  579661
  579896
  596131
  596463
  600875
  601826
  613320
  614417
  615426
  619785
  634448
  651678
  670208
  671886
  680210
  683300
  699044
  721908
  744924
  748464
  795913
]
1.84 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт на улиц секс"
]
1.83 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden public sex"
]
1.65 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скрыт на улиц секс"
]
1.58 ms
(1.01%)
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.