GET https://search.jues.net/search/embeds/3?q=public%20teen%20webcam

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.50 ms
(82.88%)
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
  439260
  452829
  458380
  472357
  516692
  520602
  530710
  541152
  541795
  543691
  544378
  547109
  550470
  550474
  552717
  554717
  555661
  564242
  566794
  575357
  579127
  581040
  581557
  588285
  589580
  592646
  592833
  595982
  604090
  609507
  614384
  614391
  615953
  618245
  619814
  626351
  626415
  632942
  634453
  636390
  639053
  639635
  651030
  661339
  668749
  685466
  695524
  697682
  705779
  714456
  719277
  720662
  721868
  721908
  721938
  722972
  723940
  727036
  727045
  728188
  728906
  729567
  733215
  734429
  735827
  735830
  736507
  736921
  738236
  738414
  739618
  740762
  746104
  746164
  746172
  748509
  749107
  749563
  751408
  752145
  752477
  754880
  765922
  766084
  766323
  768295
  776918
  785083
  785414
  785420
  786757
  788097
  789676
  790112
  793061
  795892
  795924
  798753
  799875
  800505
  801782
  802865
  803693
  804271
  804437
  811091
  816817
  818621
  818820
  818838
  819374
  819523
  823443
  827248
  827550
  828004
  828141
  828202
  828621
]
13.71 ms
(9.59%)
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
  786757
  736921
  685466
  592646
  604090
  727036
  738414
  752477
  458380
  588285
  579127
  555661
  734429
  566794
  520602
  721908
  827248
  816817
  819374
  819523
  823443
  828141
  828004
  543691
  541152
  547109
  609507
  618245
  626415
  614391
  790112
  740762
  785414
  795892
  728906
  746164
  721868
  530710
  550470
  552717
  695524
  634453
  595982
  614384
  639053
  789676
  801782
  803693
  800505
  811091
  766084
  768295
  739618
  754880
  733215
  766323
  765922
  615953
  720662
  785420
  802865
  661339
  626351
  575357
  516692
  728188
  751408
  752145
  736507
  632942
  592833
  721938
  439260
  472357
  581557
  541795
  714456
  636390
  639635
  788097
  798753
  799875
  785083
  793061
  795924
  735830
  738236
  748509
  749563
  735827
  765077
  727045
  746104
  746172
  749107
  619814
  722972
  776918
  804437
  719277
  554717
  564242
  452829
  818621
  818838
  818820
  827550
  828202
  828621
  550474
  544378
  651030
  668749
  697682
  581040
  723940
  705779
  589580
  729567
  804271
]
3.03 ms
(2.12%)
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
  439260
  452829
  458380
  472357
  516692
  520602
  530710
  541152
  541795
  543691
  544378
  547109
  550470
  550474
  552717
  554717
  555661
  564242
  566794
  575357
  579127
  581040
  581557
  588285
  589580
  592646
  592833
  595982
  604090
  609507
  614384
  614391
  615953
  618245
  619814
  626351
  626415
  632942
  634453
  636390
  639053
  639635
  651030
  661339
  668749
  685466
  695524
  697682
  705779
  714456
  719277
  720662
  721868
  721908
  721938
  722972
  723940
  727036
  727045
  728188
  728906
  729567
  733215
  734429
  735827
  735830
  736507
  736921
  738236
  738414
  739618
  740762
  746104
  746164
  746172
  748509
  749107
  749563
  751408
  752145
  752477
  754880
  765922
  766084
  766323
  768295
  776918
  785083
  785414
  785420
  786757
  788097
  789676
  790112
  793061
  795892
  795924
  798753
  799875
  800505
  801782
  802865
  803693
  804271
  804437
  811091
  816817
  818621
  818820
  818838
  819374
  819523
  823443
  827248
  827550
  828004
  828141
  828202
  828621
]
2.37 ms
(1.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public teen webcam"
]
1.86 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на teen улиц вебкамер"
]
1.84 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на teen улиц вебкамер"
]

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.