GET https://search.jues.net/search/embeds/10?q=amateur%20stranger

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.12 ms
(79.01%)
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
  420880
  424237
  426979
  431963
  432962
  436481
  437585
  438776
  438879
  440655
  442196
  442234
  442747
  443029
  447275
  447709
  447909
  448434
  450461
  450534
  450635
  451149
  451850
  455343
  455470
  455514
  461634
  461861
  463151
  463195
  466992
  469137
  469637
  471517
  474247
  475232
  476937
  477014
  478337
  482190
  482257
  482997
  484022
  484252
  488196
  488201
  488286
  489614
  489798
  494298
  495302
  495324
  497236
  499333
  504116
  506258
  506517
  507948
  510572
  511639
  511772
  515651
  517261
  517600
  517602
  517881
  519768
  521172
  521916
  522293
  522392
  522453
  522526
  524274
  526154
  526356
  535416
  536154
  536664
  539300
  541101
  544016
  546419
  548704
  551109
  551450
  551640
  555667
  559367
  560041
  560412
  561306
  566100
  568392
  571656
  572211
  572214
  572323
  574592
  576742
  580997
  584290
  588745
  591287
  593769
  595029
  601988
  604746
  612092
  613599
  617402
  618952
  630472
  643939
  667417
  668005
  680944
  681209
  697026
  788806
]
17.85 ms
(10.06%)
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
  584290
  517881
  469637
  517600
  495324
  536154
  539300
  524274
  535416
  463151
  572211
  680944
  681209
  555667
  572214
  630472
  617402
  612092
  788806
  437585
  431963
  466992
  455343
  450461
  450635
  521172
  484022
  506517
  510572
  522526
  420880
  484252
  451850
  461861
  482190
  499333
  522293
  526154
  494298
  511772
  526356
  507948
  541101
  546419
  560041
  571656
  572323
  551450
  566100
  568392
  576742
  580997
  551109
  551640
  559367
  560412
  561306
  697026
  668005
  593769
  613599
  618952
  595029
  591287
  601988
  475232
  438879
  442234
  447909
  463195
  476937
  482257
  436481
  448434
  455470
  455514
  515651
  522453
  488286
  511639
  482997
  489798
  506258
  519768
  521916
  442747
  447275
  548704
  574592
  478337
  488201
  489614
  488196
  604746
  474247
  497236
  426979
  438776
  443029
  440655
  471517
  477014
  461634
  517602
  495302
  504116
  517261
  522392
  544016
  667417
  588745
  643939
  432962
  447709
  424237
  450534
  451149
  442196
  536664
  469137
]
10.98 ms
(6.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
3.36 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
  420880
  424237
  426979
  431963
  432962
  436481
  437585
  438776
  438879
  440655
  442196
  442234
  442747
  443029
  447275
  447709
  447909
  448434
  450461
  450534
  450635
  451149
  451850
  455343
  455470
  455514
  461634
  461861
  463151
  463195
  466992
  469137
  469637
  471517
  474247
  475232
  476937
  477014
  478337
  482190
  482257
  482997
  484022
  484252
  488196
  488201
  488286
  489614
  489798
  494298
  495302
  495324
  497236
  499333
  504116
  506258
  506517
  507948
  510572
  511639
  511772
  515651
  517261
  517600
  517602
  517881
  519768
  521172
  521916
  522293
  522392
  522453
  522526
  524274
  526154
  526356
  535416
  536154
  536664
  539300
  541101
  544016
  546419
  548704
  551109
  551450
  551640
  555667
  559367
  560041
  560412
  561306
  566100
  568392
  571656
  572211
  572214
  572323
  574592
  576742
  580997
  584290
  588745
  591287
  593769
  595029
  601988
  604746
  612092
  613599
  617402
  618952
  630472
  643939
  667417
  668005
  680944
  681209
  697026
  788806
]
1.85 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur stranger"
]
1.67 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск stranger"
]
1.50 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск stranger"
]

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.