GET https://search.jues.net/search/embeds/6?q=teen%20close%20up

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.66 ms
(86.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
  459735
  478452
  493670
  517888
  530584
  531744
  531756
  533577
  534117
  535765
  538015
  540831
  542450
  543533
  544124
  545185
  546417
  549073
  564303
  565440
  566846
  575046
  575635
  585761
  586736
  587984
  590828
  590845
  593576
  594359
  594375
  604655
  605741
  606979
  610208
  616598
  616665
  616712
  622117
  629686
  631063
  633062
  635521
  636885
  640384
  641172
  642814
  645342
  653686
  655252
  655523
  657139
  657156
  660269
  661028
  662015
  662794
  664585
  670802
  675607
  677735
  680233
  683527
  686129
  688939
  690200
  691600
  691601
  691662
  691879
  693125
  693170
  693176
  693207
  693691
  694831
  699544
  702981
  713022
  713513
  715562
  717204
  718154
  718240
  720703
  724057
  776286
  776956
  777034
  777575
  778725
  779005
  779893
  781589
  782493
  783089
  784050
  784541
  785081
  785512
  792102
  792806
  793330
  793331
  794764
  795470
  796218
  796528
  820000
  820521
  820896
  821493
  821629
  823041
  826042
  826108
  826131
  827275
  827531
]
12.44 ms
(7.55%)
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
  823041
  540831
  820521
  821629
  827275
  827531
  820000
  820896
  821493
  826108
  826131
  826566
  826042
  459735
  478452
  493670
  517888
  534117
  535765
  530584
  531744
  531756
  533577
  538015
  543533
  546417
  565440
  542450
  544124
  545185
  549073
  564303
  566846
  575046
  662015
  675607
  677735
  683527
  688939
  693170
  693691
  699544
  702981
  713022
  715562
  718240
  720703
  655252
  655523
  657139
  660269
  661028
  662794
  670802
  686129
  690200
  691600
  691662
  693207
  694831
  645342
  653686
  657156
  664585
  680233
  691601
  691879
  693125
  693176
  713513
  717204
  718154
  575635
  585761
  586736
  604655
  605741
  606979
  610208
  622117
  635521
  640384
  594359
  594375
  616665
  629686
  633062
  590828
  590845
  616712
  636885
  641172
  587984
  593576
  616598
  631063
  642814
  779893
  782493
  783089
  792102
  793330
  793331
  794764
  795470
  796218
  776286
  776956
  777034
  777575
  778725
  779005
  781589
  784050
  784541
  785081
  785512
  792806
  796528
  724057
]
3.39 ms
(2.06%)
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
  459735
  478452
  493670
  517888
  530584
  531744
  531756
  533577
  534117
  535765
  538015
  540831
  542450
  543533
  544124
  545185
  546417
  549073
  564303
  565440
  566846
  575046
  575635
  585761
  586736
  587984
  590828
  590845
  593576
  594359
  594375
  604655
  605741
  606979
  610208
  616598
  616665
  616712
  622117
  629686
  631063
  633062
  635521
  636885
  640384
  641172
  642814
  645342
  653686
  655252
  655523
  657139
  657156
  660269
  661028
  662015
  662794
  664585
  670802
  675607
  677735
  680233
  683527
  686129
  688939
  690200
  691600
  691601
  691662
  691879
  693125
  693170
  693176
  693207
  693691
  694831
  699544
  702981
  713022
  713513
  715562
  717204
  718154
  718240
  720703
  724057
  776286
  776956
  777034
  777575
  778725
  779005
  779893
  781589
  782493
  783089
  784050
  784541
  785081
  785512
  792102
  792806
  793330
  793331
  794764
  795470
  796218
  796528
  820000
  820521
  820896
  821493
  821629
  823041
  826042
  826108
  826131
  827275
  827531
]
2.08 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen close up"
]
1.84 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen close up"
]
1.65 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen close up"
]
1.65 ms
(1.00%)
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.