GET https://search.jues.net/search/embeds/5?q=%D1%85%D1%83%D0%B4%D1%8B%D0%B5%20%D0%B4%D0%B5%D0%B2%D0%BA%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.09 ms
(84.43%)
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
  6666
  89346
  256431
  382456
  383238
  383523
  393900
  395739
  418851
  420544
  424333
  428016
  433582
  437427
  441069
  441812
  443845
  445057
  446049
  446620
  447418
  448208
  449992
  450015
  455633
  464461
  468021
  469246
  472080
  472560
  473532
  473804
  475352
  476610
  476818
  478442
  478788
  479225
  480134
  482766
  485857
  486620
  491059
  494534
  494545
  497551
  497835
  500580
  501615
  504584
  504904
  507194
  511209
  512074
  542105
  542640
  542923
  543767
  546407
  547303
  548607
  548628
  548678
  548748
  549400
  551366
  551973
  552115
  552237
  552388
  552402
  552640
  552655
  552681
  552705
  553915
  554201
  557231
  559002
  559391
  559469
  560481
  560566
  561263
  561330
  562250
  562275
  562293
  562484
  563800
  567102
  567741
  568348
  568631
  569859
  569899
  570494
  570614
  571188
  571921
  571932
  572159
  572339
  572427
  572521
  572818
  572999
  573852
  575064
  575127
  575219
  575423
  575485
  575516
  576280
  576283
  577401
  578015
  578371
  584134
]
15.97 ms
(9.04%)
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
  383523
  383238
  256431
  393900
  395739
  382456
  89346
  6666
  424333
  437427
  420544
  428016
  445057
  433582
  441069
  443845
  418851
  441812
  469246
  480134
  446049
  447418
  455633
  468021
  472080
  485857
  486620
  446620
  448208
  449992
  450015
  472560
  473532
  476818
  478442
  482766
  497835
  500580
  504584
  511209
  494534
  494545
  507194
  512074
  497551
  501615
  504904
  464461
  473804
  475352
  476610
  478788
  479225
  491059
  542105
  543767
  546407
  548607
  551366
  551973
  552115
  552388
  552402
  552705
  553915
  557231
  561330
  567102
  567741
  569859
  569899
  570494
  571921
  571932
  572159
  572339
  572427
  572521
  572818
  572999
  573852
  575064
  575127
  575219
  575423
  575485
  575516
  576280
  576283
  577401
  578015
  578371
  584134
  542640
  542923
  547303
  548628
  548678
  548748
  549400
  552237
  552640
  552655
  552681
  554201
  559002
  559391
  559469
  560481
  560566
  561263
  562250
  562275
  562293
  562484
  563800
  568348
  568631
  570614
  571188
]
3.28 ms
(1.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худые девки"
]
2.77 ms
(1.57%)
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
  6666
  89346
  256431
  382456
  383238
  383523
  393900
  395739
  418851
  420544
  424333
  428016
  433582
  437427
  441069
  441812
  443845
  445057
  446049
  446620
  447418
  448208
  449992
  450015
  455633
  464461
  468021
  469246
  472080
  472560
  473532
  473804
  475352
  476610
  476818
  478442
  478788
  479225
  480134
  482766
  485857
  486620
  491059
  494534
  494545
  497551
  497835
  500580
  501615
  504584
  504904
  507194
  511209
  512074
  542105
  542640
  542923
  543767
  546407
  547303
  548607
  548628
  548678
  548748
  549400
  551366
  551973
  552115
  552237
  552388
  552402
  552640
  552655
  552681
  552705
  553915
  554201
  557231
  559002
  559391
  559469
  560481
  560566
  561263
  561330
  562250
  562275
  562293
  562484
  563800
  567102
  567741
  568348
  568631
  569859
  569899
  570494
  570614
  571188
  571921
  571932
  572159
  572339
  572427
  572521
  572818
  572999
  573852
  575064
  575127
  575219
  575423
  575485
  575516
  576280
  576283
  577401
  578015
  578371
  584134
]
1.93 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые девк"
]
1.79 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые девк"
]
1.75 ms
(0.99%)
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.