GET https://search.jues.net/search/embeds/9?q=%D0%BF%D1%8B%D1%88%D0%BA%D0%B0%20%D1%87%D1%83%D0%BB%D0%BA%D0%B0%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.87 ms
(86.71%)
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
  12887
  44900
  187450
  193462
  205715
  381956
  382280
  385779
  389639
  391954
  393705
  394212
  396287
  400361
  407703
  409032
  413709
  417438
  419530
  420652
  422347
  424003
  424474
  425981
  426877
  428723
  429886
  429899
  444104
  445630
  453072
  453415
  462565
  467052
  468377
  468858
  468934
  468965
  472007
  474865
  475660
  476321
  479979
  481956
  485681
  488812
  490996
  491431
  503476
  506057
  509244
  510107
  513339
  518846
  526201
  536426
  545004
  549222
  557989
  559346
  564795
  577290
  578298
  581251
  589694
  592636
  593063
  597099
  607599
  607632
  609071
  610626
  614361
  621404
  629781
  640687
  644000
  644382
  651029
  663881
  664217
  666480
  689689
  694505
  697185
  698617
  704907
  728231
  728469
  732385
  735886
  735901
  744087
  744992
  747052
  769463
  770203
  772106
  776745
  780691
  781765
  788753
  795478
  797014
  798607
  799077
  801030
  802352
  804400
  807996
  808055
  808070
  809215
  817333
  817343
  819959
  820141
  823441
  824285
  825973
]
13.10 ms
(7.43%)
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
  728469
  607599
  704907
  799077
  809215
  382280
  420652
  506057
  513339
  518846
  413709
  193462
  44900
  820141
  824285
  817343
  819959
  817333
  823441
  825973
  564795
  581251
  578298
  545004
  694505
  663881
  697185
  651029
  664217
  666480
  698617
  614361
  644000
  597099
  776745
  780691
  795478
  801030
  802352
  807996
  808055
  781765
  788753
  798607
  772106
  747052
  769463
  732385
  735886
  735901
  744087
  770203
  728231
  744992
  621404
  644382
  797014
  804400
  808070
  385779
  187450
  424474
  488812
  629781
  640687
  429899
  419530
  445630
  490996
  577290
  468965
  491431
  417438
  468934
  476321
  510107
  526201
  475660
  549222
  381956
  422347
  503476
  205715
  393705
  12887
  396287
  407703
  409032
  425981
  444104
  453415
  462565
  474865
  453072
  468377
  472007
  485681
  509244
  536426
  557989
  559346
  689689
  609071
  589694
  592636
  593063
  607632
  610626
  391954
  467052
  481956
  389639
  394212
  400361
  424003
  429886
  468858
  426877
  428723
  479979
]
3.35 ms
(1.90%)
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
  12887
  44900
  187450
  193462
  205715
  381956
  382280
  385779
  389639
  391954
  393705
  394212
  396287
  400361
  407703
  409032
  413709
  417438
  419530
  420652
  422347
  424003
  424474
  425981
  426877
  428723
  429886
  429899
  444104
  445630
  453072
  453415
  462565
  467052
  468377
  468858
  468934
  468965
  472007
  474865
  475660
  476321
  479979
  481956
  485681
  488812
  490996
  491431
  503476
  506057
  509244
  510107
  513339
  518846
  526201
  536426
  545004
  549222
  557989
  559346
  564795
  577290
  578298
  581251
  589694
  592636
  593063
  597099
  607599
  607632
  609071
  610626
  614361
  621404
  629781
  640687
  644000
  644382
  651029
  663881
  664217
  666480
  689689
  694505
  697185
  698617
  704907
  728231
  728469
  732385
  735886
  735901
  744087
  744992
  747052
  769463
  770203
  772106
  776745
  780691
  781765
  788753
  795478
  797014
  798607
  799077
  801030
  802352
  804400
  807996
  808055
  808070
  809215
  817333
  817343
  819959
  820141
  823441
  824285
  825973
]
1.95 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пышка чулках"
]
1.81 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная чулк нижн бел"
]
1.75 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "полная чулк нижн бел"
]
1.46 ms
(0.83%)
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.