GET https://search.jues.net/search/embeds/5?q=%D0%B2%20%D0%B7%D0%B0%D0%B3%D0%BB%D0%BE%D1%82

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.22 ms
(86.78%)
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
  86926
  387230
  396021
  397423
  401794
  425535
  436845
  456890
  466728
  470420
  472635
  472876
  473564
  481840
  487062
  491092
  494278
  496430
  496808
  500701
  501977
  502376
  504609
  505176
  506068
  506563
  507158
  507757
  508219
  508279
  509501
  509565
  511038
  512618
  512675
  513855
  515303
  515322
  517835
  520075
  521496
  521577
  521714
  522505
  522602
  527535
  527819
  528225
  528667
  530120
  530247
  530252
  531395
  532018
  533997
  534052
  534800
  535532
  535847
  537954
  538576
  539338
  539524
  540429
  546010
  546833
  554479
  554740
  555938
  557085
  561600
  562499
  564533
  566895
  568096
  571069
  571993
  573447
  574186
  576558
  577082
  579575
  580402
  585104
  586636
  586763
  588896
  588949
  589648
  590917
  591128
  593087
  594976
  595115
  599135
  599805
  600487
  600767
  601960
  602480
  603072
  605289
  605638
  606839
  607238
  610074
  615510
  617710
  619845
  625283
  626287
  631107
  635697
  645922
  651244
  655728
  655983
  658692
  661921
  662476
]
11.59 ms
(6.36%)
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
  573447
  662476
  651244
  546833
  555938
  561600
  568096
  600767
  610074
  588896
  594976
  602480
  590917
  600487
  626287
  635697
  595115
  599135
  607238
  425535
  562499
  625283
  86926
  396021
  401794
  466728
  456890
  507158
  515303
  515322
  511038
  513855
  535847
  502376
  506563
  530120
  507757
  508279
  512618
  530252
  532018
  491092
  564533
  566895
  574186
  580402
  557085
  571069
  577082
  546010
  579575
  655728
  655983
  661921
  658692
  645922
  554479
  554740
  571993
  576558
  589648
  605638
  588949
  605289
  586636
  593087
  586763
  591128
  599805
  603072
  619845
  601960
  606839
  615510
  617710
  631107
  397423
  436845
  387230
  585104
  473564
  481840
  470420
  472876
  472635
  487062
  496808
  506068
  509501
  512675
  521577
  522602
  535532
  537954
  539338
  539524
  540429
  500701
  504609
  508219
  517835
  521714
  527535
  528225
  528667
  531395
  533997
  496430
  505176
  509565
  520075
  521496
  522505
  527819
  530247
  534052
  534800
  538576
  494278
  501977
]
4.79 ms
(2.63%)
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
  86926
  387230
  396021
  397423
  401794
  425535
  436845
  456890
  466728
  470420
  472635
  472876
  473564
  481840
  487062
  491092
  494278
  496430
  496808
  500701
  501977
  502376
  504609
  505176
  506068
  506563
  507158
  507757
  508219
  508279
  509501
  509565
  511038
  512618
  512675
  513855
  515303
  515322
  517835
  520075
  521496
  521577
  521714
  522505
  522602
  527535
  527819
  528225
  528667
  530120
  530247
  530252
  531395
  532018
  533997
  534052
  534800
  535532
  535847
  537954
  538576
  539338
  539524
  540429
  546010
  546833
  554479
  554740
  555938
  557085
  561600
  562499
  564533
  566895
  568096
  571069
  571993
  573447
  574186
  576558
  577082
  579575
  580402
  585104
  586636
  586763
  588896
  588949
  589648
  590917
  591128
  593087
  594976
  595115
  599135
  599805
  600487
  600767
  601960
  602480
  603072
  605289
  605638
  606839
  607238
  610074
  615510
  617710
  619845
  625283
  626287
  631107
  635697
  645922
  651244
  655728
  655983
  658692
  661921
  662476
]
2.44 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в заглот"
]
1.83 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в заглот"
]
1.59 ms
(0.87%)
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.