GET https://search.jues.net/search/embeds/4?q=%D0%BD%D0%B0%20%D0%BA%D1%83%D1%85%D0%BD%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.07 ms
(84.47%)
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
  73947
  172541
  295874
  382018
  382443
  384241
  391092
  397366
  398655
  401226
  404342
  407146
  417292
  422203
  426515
  432834
  439720
  440713
  442814
  446173
  448195
  453155
  453453
  457562
  459744
  460750
  464459
  472063
  474401
  477625
  479916
  480639
  483022
  485180
  490804
  497957
  498984
  499010
  499339
  501030
  503976
  506273
  509351
  509353
  510705
  511132
  511799
  513832
  517077
  518976
  519659
  521412
  527131
  529378
  533887
  533910
  533919
  539786
  543762
  545895
  546390
  547964
  548024
  551110
  553214
  557129
  559067
  561512
  566128
  566887
  567502
  571057
  572736
  577364
  585395
  589634
  590946
  591016
  591022
  591023
  591035
  591057
  591543
  592092
  601102
  609604
  609753
  610544
  613815
  615979
  620430
  621034
  621782
  625000
  642405
  644338
  653252
  680904
  682234
  701208
  704345
  705223
  705425
  705491
  718854
  720630
  721604
  731048
  743247
  771365
  778175
  780083
  780839
  788399
  794286
  798269
  801432
  802058
  810296
  810393
]
14.78 ms
(9.24%)
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
  426515
  566128
  401226
  439720
  498984
  457562
  485180
  529378
  539786
  513832
  497957
  503976
  561512
  585395
  442814
  510705
  609753
  547964
  621034
  391092
  509353
  577364
  615979
  591016
  499339
  557129
  591057
  780839
  432834
  479916
  464459
  613815
  601102
  609604
  295874
  477625
  453453
  506273
  653252
  398655
  407146
  417292
  453155
  472063
  397366
  404342
  483022
  501030
  517077
  519659
  551110
  625000
  546390
  720630
  591023
  621782
  778175
  705425
  382443
  521412
  480639
  545895
  743247
  705491
  384241
  682234
  591022
  591035
  448195
  567502
  518976
  559067
  460750
  382018
  527131
  533910
  509351
  680904
  701208
  794286
  731048
  610544
  474401
  511132
  499010
  788399
  572736
  533887
  548024
  566887
  704345
  642405
  644338
  591543
  592092
  620430
  780083
  810296
  798269
  810393
  771365
  802058
  172541
  801432
  571057
  422203
  589634
  440713
  446173
  590946
  73947
  459744
  490804
  511799
  533919
  543762
  553214
  705223
  718854
  721604
]
2.99 ms
(1.87%)
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
  73947
  172541
  295874
  382018
  382443
  384241
  391092
  397366
  398655
  401226
  404342
  407146
  417292
  422203
  426515
  432834
  439720
  440713
  442814
  446173
  448195
  453155
  453453
  457562
  459744
  460750
  464459
  472063
  474401
  477625
  479916
  480639
  483022
  485180
  490804
  497957
  498984
  499010
  499339
  501030
  503976
  506273
  509351
  509353
  510705
  511132
  511799
  513832
  517077
  518976
  519659
  521412
  527131
  529378
  533887
  533910
  533919
  539786
  543762
  545895
  546390
  547964
  548024
  551110
  553214
  557129
  559067
  561512
  566128
  566887
  567502
  571057
  572736
  577364
  585395
  589634
  590946
  591016
  591022
  591023
  591035
  591057
  591543
  592092
  601102
  609604
  609753
  610544
  613815
  615979
  620430
  621034
  621782
  625000
  642405
  644338
  653252
  680904
  682234
  701208
  704345
  705223
  705425
  705491
  718854
  720630
  721604
  731048
  743247
  771365
  778175
  780083
  780839
  788399
  794286
  798269
  801432
  802058
  810296
  810393
]
2.14 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на кухня"
]
1.72 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на кухн"
]
1.62 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на кухн"
]
1.59 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.