GET https://search.jues.net/search/embeds/6?q=webcam%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.55 ms
(83.06%)
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
  84837
  88505
  384046
  386569
  388773
  389719
  392959
  412616
  418464
  419201
  419354
  420320
  443481
  452482
  455017
  459248
  462000
  468232
  477463
  479477
  489115
  506306
  511127
  512751
  514661
  517372
  520032
  520994
  523590
  529866
  533572
  540127
  543678
  546617
  553155
  554698
  554708
  555301
  563977
  565834
  571828
  574025
  580666
  585229
  588494
  592118
  600668
  602221
  602993
  603121
  610552
  614578
  617471
  635183
  635328
  662790
  668733
  686410
  687778
  691535
  692944
  693264
  696287
  697204
  697682
  708320
  713423
  716148
  722368
  724040
  725649
  730528
  732178
  732685
  734709
  735472
  737998
  740326
  746016
  748959
  751386
  753619
  759222
  760479
  761445
  764731
  766929
  768343
  768649
  768702
  769434
  776544
  780543
  787261
  787266
  787392
  793895
  794011
  794102
  795108
  795109
  798409
  798727
  799915
  801049
  803874
  810029
  813856
  814464
  816666
  817880
  818750
  818813
  818877
  819940
  824479
  825698
  825904
  825925
  827989
]
14.58 ms
(9.88%)
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
  546617
  574025
  543678
  668733
  697682
  799915
  737998
  766929
  768343
  746016
  751386
  84837
  814464
  565834
  686410
  602221
  602993
  392959
  88505
  388773
  389719
  419354
  506306
  512751
  412616
  825698
  825925
  825904
  816666
  818813
  818877
  819940
  813856
  817880
  824479
  818750
  827989
  529866
  540127
  533572
  554698
  553155
  554708
  563977
  693264
  662790
  687778
  691535
  716148
  692944
  696287
  708320
  713423
  555301
  600668
  592118
  614578
  635183
  617471
  780543
  787392
  793895
  810029
  795108
  801049
  725649
  734709
  740326
  760479
  761445
  768702
  769434
  787266
  795109
  798727
  803874
  732685
  735472
  753619
  724040
  768649
  730528
  732178
  748959
  759222
  764731
  635328
  697204
  722368
  787261
  794011
  794102
  798409
  420320
  459248
  468232
  479477
  455017
  520032
  520994
  514661
  523590
  462000
  477463
  571828
  580666
  585229
  588494
  610552
  603121
  776544
  452482
  443481
  517372
  511127
  384046
  419201
  489115
  418464
  386569
]
2.78 ms
(1.88%)
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
  84837
  88505
  384046
  386569
  388773
  389719
  392959
  412616
  418464
  419201
  419354
  420320
  443481
  452482
  455017
  459248
  462000
  468232
  477463
  479477
  489115
  506306
  511127
  512751
  514661
  517372
  520032
  520994
  523590
  529866
  533572
  540127
  543678
  546617
  553155
  554698
  554708
  555301
  563977
  565834
  571828
  574025
  580666
  585229
  588494
  592118
  600668
  602221
  602993
  603121
  610552
  614578
  617471
  635183
  635328
  662790
  668733
  686410
  687778
  691535
  692944
  693264
  696287
  697204
  697682
  708320
  713423
  716148
  722368
  724040
  725649
  730528
  732178
  732685
  734709
  735472
  737998
  740326
  746016
  748959
  751386
  753619
  759222
  760479
  761445
  764731
  766929
  768343
  768649
  768702
  769434
  776544
  780543
  787261
  787266
  787392
  793895
  794011
  794102
  795108
  795109
  798409
  798727
  799915
  801049
  803874
  810029
  813856
  814464
  816666
  817880
  818750
  818813
  818877
  819940
  824479
  825698
  825904
  825925
  827989
]
2.13 ms
(1.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam shower"
]
1.90 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер shower"
]
1.55 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер shower"
]

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.