GET https://search.jues.net/search/embeds/7?q=video%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.15 ms
(89.60%)
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
  256162
  417077
  458948
  478348
  490591
  529785
  532235
  533796
  537078
  537095
  537283
  541563
  542479
  543702
  551481
  551713
  551837
  563572
  564698
  565129
  567458
  568312
  575299
  577308
  583405
  585303
  589857
  594547
  596284
  603567
  608000
  610421
  612228
  615256
  616535
  619393
  622275
  627595
  630345
  633477
  634263
  636556
  637170
  637785
  639715
  641501
  644456
  646639
  650048
  650269
  650881
  652286
  660622
  661701
  665827
  665954
  668331
  681710
  681719
  685432
  688252
  692214
  692437
  693040
  695551
  699431
  708908
  709504
  710015
  712144
  712582
  713285
  713768
  716502
  716994
  730920
  739263
  740565
  742325
  742332
  744030
  745314
  745639
  745792
  748853
  749394
  749754
  751313
  752458
  764826
  765404
  765627
  770381
  771909
  773110
  778132
  778610
  780274
  783880
  784125
  784130
  787737
  788464
  788637
  788938
  791169
  792104
  792438
  801713
  802043
  803683
  803857
  804297
  804489
  811324
  820206
  821789
  823409
  823996
  826354
]
12.28 ms
(6.04%)
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
  417077
  821789
  823409
  820206
  490591
  533796
  537078
  537095
  532235
  537283
  478348
  565129
  577308
  542479
  551837
  564698
  543702
  551713
  665954
  681719
  692437
  699431
  713285
  646639
  650269
  650881
  708908
  716994
  650048
  660622
  665827
  692214
  693040
  710015
  585303
  596284
  616535
  641501
  619393
  636556
  644456
  594547
  637170
  639715
  788464
  788938
  787737
  739263
  764826
  803683
  803857
  749754
  745314
  745639
  745792
  765404
  748853
  749394
  615256
  778132
  788637
  801713
  804297
  458948
  826354
  529785
  563572
  695551
  652286
  622275
  630345
  783880
  791169
  802043
  740565
  770381
  778610
  256162
  823996
  541563
  551481
  568312
  575299
  583405
  661701
  712582
  668331
  681710
  709504
  685432
  688252
  712144
  716502
  567458
  589857
  610421
  627595
  633477
  603567
  608000
  612228
  634263
  780274
  792104
  804489
  811324
  792438
  744030
  773110
  784130
  742332
  730920
  742325
  752458
  751313
  765627
  771909
  637785
  713768
  784125
]
2.26 ms
(1.11%)
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
  256162
  417077
  458948
  478348
  490591
  529785
  532235
  533796
  537078
  537095
  537283
  541563
  542479
  543702
  551481
  551713
  551837
  563572
  564698
  565129
  567458
  568312
  575299
  577308
  583405
  585303
  589857
  594547
  596284
  603567
  608000
  610421
  612228
  615256
  616535
  619393
  622275
  627595
  630345
  633477
  634263
  636556
  637170
  637785
  639715
  641501
  644456
  646639
  650048
  650269
  650881
  652286
  660622
  661701
  665827
  665954
  668331
  681710
  681719
  685432
  688252
  692214
  692437
  693040
  695551
  699431
  708908
  709504
  710015
  712144
  712582
  713285
  713768
  716502
  716994
  730920
  739263
  740565
  742325
  742332
  744030
  745314
  745639
  745792
  748853
  749394
  749754
  751313
  752458
  764826
  765404
  765627
  770381
  771909
  773110
  778132
  778610
  780274
  783880
  784125
  784130
  787737
  788464
  788637
  788938
  791169
  792104
  792438
  801713
  802043
  803683
  803857
  804297
  804489
  811324
  820206
  821789
  823409
  823996
  826354
]
1.78 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "video девушк"
]
1.60 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "video девушк"
]
1.54 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "video girl"
]

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.