GET https://search.jues.net/search/embeds/8?q=%D0%B1%D0%B0%D1%81%D1%81%D0%B5%D0%B9%D0%BD%D0%B0

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
194.53 ms
(86.54%)
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
  13703
  34087
  38068
  96048
  385751
  391247
  393338
  395895
  396994
  408998
  419492
  419854
  426406
  435497
  445182
  446222
  446344
  447004
  449809
  451950
  454558
  454727
  454925
  462908
  465490
  468049
  468705
  471836
  472481
  474495
  474563
  475272
  477342
  478043
  479792
  481332
  482605
  483005
  484553
  496553
  502530
  513778
  515096
  518554
  520229
  524062
  529105
  531539
  533511
  534355
  536523
  536540
  543499
  544345
  545403
  549129
  554338
  554975
  557274
  564519
  565149
  566620
  589779
  591708
  598847
  599953
  603516
  604064
  610643
  640534
  642399
  643415
  648118
  661312
  662910
  663550
  671729
  674891
  676759
  682144
  690394
  696511
  699670
  710949
  718329
  718926
  720405
  727414
  730556
  733709
  742246
  745590
  749695
  760673
  788505
  808034
  814815
  815059
  815519
  815938
  816038
  817815
  818942
  819060
  819098
  819120
  819122
  819271
  819637
  819646
  821123
  821489
  821577
  821956
  822203
  822229
  822768
  823139
  823383
  825537
]
18.09 ms
(8.05%)
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
  733709
  742246
  727414
  730556
  745590
  749695
  760673
  710949
  788505
  808034
  13703
  393338
  395895
  96048
  435497
  426406
  419854
  465490
  472481
  482605
  484553
  446344
  447004
  454925
  475272
  483005
  449809
  454727
  462908
  481332
  518554
  496553
  520229
  524062
  536523
  529105
  531539
  536540
  564519
  565149
  543499
  554338
  557274
  566620
  598847
  642399
  599953
  640534
  643415
  408998
  445182
  446222
  471836
  474563
  391247
  468049
  474495
  478043
  419492
  451950
  454558
  468705
  477342
  479792
  502530
  385751
  34087
  38068
  396994
  815938
  816038
  819637
  819646
  823139
  825537
  815059
  821956
  822768
  814815
  818942
  819060
  819098
  819120
  819122
  819271
  821123
  822203
  815519
  817815
  821489
  821577
  822229
  823383
  515096
  513778
  534355
  533511
  544345
  554975
  545403
  549129
  671729
  676759
  682144
  699670
  648118
  662910
  674891
  690394
  696511
  718329
  661312
  663550
  718926
  720405
  589779
  591708
  603516
  604064
  610643
]
4.43 ms
(1.97%)
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
  13703
  34087
  38068
  96048
  385751
  391247
  393338
  395895
  396994
  408998
  419492
  419854
  426406
  435497
  445182
  446222
  446344
  447004
  449809
  451950
  454558
  454727
  454925
  462908
  465490
  468049
  468705
  471836
  472481
  474495
  474563
  475272
  477342
  478043
  479792
  481332
  482605
  483005
  484553
  496553
  502530
  513778
  515096
  518554
  520229
  524062
  529105
  531539
  533511
  534355
  536523
  536540
  543499
  544345
  545403
  549129
  554338
  554975
  557274
  564519
  565149
  566620
  589779
  591708
  598847
  599953
  603516
  604064
  610643
  640534
  642399
  643415
  648118
  661312
  662910
  663550
  671729
  674891
  676759
  682144
  690394
  696511
  699670
  710949
  718329
  718926
  720405
  727414
  730556
  733709
  742246
  745590
  749695
  760673
  788505
  808034
  814815
  815059
  815519
  815938
  816038
  817815
  818942
  819060
  819098
  819120
  819122
  819271
  819637
  819646
  821123
  821489
  821577
  821956
  822203
  822229
  822768
  823139
  823383
  825537
]
3.18 ms
(1.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "бассейна"
]
1.53 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "бассейн"
]
1.44 ms
(0.64%)
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.