GET https://search.jues.net/search/embeds/8?q=sex%20rus

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
181.81 ms
(84.23%)
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
  150336
  194687
  271234
  385359
  385928
  388078
  393330
  400696
  410791
  411257
  411757
  419739
  419998
  420718
  422357
  423837
  424011
  424483
  427192
  432181
  435378
  437758
  437761
  439920
  441420
  441595
  443248
  443874
  444001
  447068
  448214
  452683
  453480
  453514
  455913
  456741
  457580
  458253
  458755
  459087
  459503
  461443
  461553
  462050
  462284
  462597
  466880
  467549
  468179
  468399
  469277
  469757
  472400
  472609
  473284
  478721
  483528
  484403
  494106
  495529
  497201
  502350
  503943
  504206
  506185
  507541
  509192
  509975
  510794
  512458
  512645
  513865
  516312
  517548
  519394
  521422
  521991
  526774
  538415
  552248
  558270
  561895
  566354
  567830
  568079
  568847
  570260
  570307
  571420
  578385
  579893
  590633
  591196
  595367
  595388
  595459
  597049
  598010
  654812
  656072
  660905
  683293
  683304
  719555
  722964
  724238
  732160
  741604
  742234
  753896
  760394
  788356
  789287
  806789
  816599
  825540
  825593
  826527
]
26.36 ms
(12.21%)
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
  561895
  719555
  595459
  788356
  790440
  791935
  722964
  194687
  472609
  469277
  472400
  568847
  567830
  552248
  400696
  461553
  467549
  484403
  510794
  517548
  521422
  566354
  579893
  385928
  516312
  512645
  826527
  654812
  656072
  724238
  760394
  424011
  427192
  457580
  473284
  462284
  570260
  570307
  443248
  453514
  448214
  483528
  595367
  806789
  468399
  432181
  509192
  495529
  683304
  683293
  741604
  271234
  441595
  393330
  441420
  435378
  461443
  411257
  447068
  595388
  452683
  444001
  590633
  453480
  455913
  660905
  789287
  732160
  150336
  410791
  507541
  388078
  494106
  816599
  825540
  753896
  558270
  526774
  504206
  509975
  597049
  742234
  437758
  456741
  439920
  385359
  469757
  571420
  591196
  468179
  411757
  437761
  506185
  513865
  538415
  568079
  423837
  443874
  598010
  419998
  462050
  458755
  512458
  578385
  420718
  458253
  459503
  459087
  462597
  466880
  478721
  419739
  422357
  424483
  503943
  521991
  502350
  497201
  519394
  825593
]
2.07 ms
(0.96%)
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
  150336
  194687
  271234
  385359
  385928
  388078
  393330
  400696
  410791
  411257
  411757
  419739
  419998
  420718
  422357
  423837
  424011
  424483
  427192
  432181
  435378
  437758
  437761
  439920
  441420
  441595
  443248
  443874
  444001
  447068
  448214
  452683
  453480
  453514
  455913
  456741
  457580
  458253
  458755
  459087
  459503
  461443
  461553
  462050
  462284
  462597
  466880
  467549
  468179
  468399
  469277
  469757
  472400
  472609
  473284
  478721
  483528
  484403
  494106
  495529
  497201
  502350
  503943
  504206
  506185
  507541
  509192
  509975
  510794
  512458
  512645
  513865
  516312
  517548
  519394
  521422
  521991
  526774
  538415
  552248
  558270
  561895
  566354
  567830
  568079
  568847
  570260
  570307
  571420
  578385
  579893
  590633
  591196
  595367
  595388
  595459
  597049
  598010
  654812
  656072
  660905
  683293
  683304
  719555
  722964
  724238
  732160
  741604
  742234
  753896
  760394
  788356
  789287
  806789
  816599
  825540
  825593
  826527
]
1.61 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex rus"
]
1.56 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс русск"
]
1.18 ms
(0.55%)
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.