GET https://search.jues.net/search/embeds/7?q=old%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.30 ms
(82.50%)
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
  7286
  282006
  382405
  393531
  395706
  397130
  399853
  399922
  400982
  401343
  401989
  402676
  402680
  404633
  407617
  416172
  416185
  417135
  443729
  448930
  451749
  510687
  512879
  519725
  525778
  530632
  530697
  533049
  543720
  544749
  556033
  556334
  566516
  574870
  574960
  580241
  581661
  595458
  596586
  596991
  597518
  598444
  598471
  598675
  605335
  620300
  624282
  630266
  630490
  633474
  649569
  657070
  657336
  657536
  659392
  664808
  671316
  671340
  671626
  671810
  673817
  678726
  682494
  682918
  683880
  684197
  684812
  685617
  686059
  687490
  687927
  688668
  688677
  691250
  693528
  696219
  697289
  699772
  701118
  701526
  702439
  702633
  706311
  707276
  708457
  711273
  712971
  713617
  715209
  716027
  717892
  720009
  721298
  721325
  722443
  722492
  722751
  725112
  725409
  740596
  741539
  742422
  758496
  760963
  775962
  808266
  810316
  810701
  811669
  812361
  813599
  814133
  814364
  817623
  817688
  821628
  822172
  822718
  824920
]
16.42 ms
(10.47%)
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
  808266
  810316
  393531
  399853
  400982
  401989
  416172
  443729
  417135
  814364
  451749
  530697
  512879
  530632
  510687
  533049
  566516
  556334
  543720
  671626
  685617
  696219
  649569
  659392
  722751
  716027
  574870
  598675
  630490
  633474
  595458
  598444
  597518
  596991
  598471
  605335
  620300
  624282
  810701
  775962
  811669
  725409
  758496
  725112
  741539
  760963
  740596
  742422
  630266
  721298
  721325
  812361
  402676
  282006
  395706
  402680
  416185
  448930
  399922
  401343
  519725
  596586
  382405
  7286
  397130
  404633
  407617
  821628
  813599
  822172
  814133
  817623
  817688
  824920
  822718
  525778
  531288
  580241
  574960
  556033
  664808
  671340
  673817
  678726
  682494
  682918
  684812
  686059
  691250
  699772
  701118
  702439
  702633
  707276
  708457
  713617
  657070
  671810
  687490
  687927
  688668
  697289
  701526
  711273
  715209
  717892
  657336
  657536
  671316
  683880
  684197
  688677
  693528
  706311
  712971
  720009
  722443
  722492
  544749
  581661
]
2.81 ms
(1.79%)
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
  7286
  282006
  382405
  393531
  395706
  397130
  399853
  399922
  400982
  401343
  401989
  402676
  402680
  404633
  407617
  416172
  416185
  417135
  443729
  448930
  451749
  510687
  512879
  519725
  525778
  530632
  530697
  533049
  543720
  544749
  556033
  556334
  566516
  574870
  574960
  580241
  581661
  595458
  596586
  596991
  597518
  598444
  598471
  598675
  605335
  620300
  624282
  630266
  630490
  633474
  649569
  657070
  657336
  657536
  659392
  664808
  671316
  671340
  671626
  671810
  673817
  678726
  682494
  682918
  683880
  684197
  684812
  685617
  686059
  687490
  687927
  688668
  688677
  691250
  693528
  696219
  697289
  699772
  701118
  701526
  702439
  702633
  706311
  707276
  708457
  711273
  712971
  713617
  715209
  716027
  717892
  720009
  721298
  721325
  722443
  722492
  722751
  725112
  725409
  740596
  741539
  742422
  758496
  760963
  775962
  808266
  810316
  810701
  811669
  812361
  813599
  814133
  814364
  817623
  817688
  821628
  822172
  822718
  824920
]
2.54 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old teen"
]
2.01 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old teen"
]
2.00 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old teen"
]
1.64 ms
(1.04%)
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.