GET https://search.jues.net/search/embeds/10?q=teen%20beautiful

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.05 ms
(83.87%)
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
  388078
  397348
  398869
  400019
  400021
  401757
  404696
  411033
  414194
  414256
  414498
  416898
  417986
  419432
  420793
  426024
  429877
  436849
  441468
  443489
  461586
  463922
  464903
  465986
  472353
  478490
  480260
  543637
  543829
  548723
  552514
  552998
  558959
  565964
  568157
  568485
  572028
  573780
  574523
  574896
  575060
  575106
  575127
  575214
  575475
  575740
  576283
  595403
  596619
  597057
  597584
  597815
  598493
  598571
  598580
  598584
  598674
  598679
  598700
  600050
  600159
  603432
  605331
  605333
  605334
  620901
  632302
  633737
  637128
  644291
  649920
  652192
  652831
  652923
  654086
  659414
  663232
  668437
  668545
  671578
  671640
  672686
  680161
  680172
  683454
  684189
  684690
  686712
  690439
  698033
  702162
  717708
  717834
  717902
  718668
  720079
  720332
  720754
  721307
  722864
  722883
  727807
  728384
  730692
  733905
  741548
  743341
  744723
  744842
  745075
  745353
  757367
  758956
  772728
  777080
  780608
  784742
  794702
  795690
  807525
]
15.80 ms
(9.60%)
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
  464903
  543637
  543829
  568157
  572028
  575127
  575740
  576283
  558959
  565964
  575060
  575106
  552514
  552998
  568485
  574523
  575214
  575475
  654086
  659414
  663232
  668437
  668545
  671578
  721307
  649920
  652831
  671640
  680161
  680172
  683454
  684189
  684690
  686712
  690439
  702162
  717902
  720754
  652192
  652923
  672686
  698033
  720079
  720332
  722883
  548723
  573780
  574896
  595403
  597057
  597584
  598493
  598571
  598674
  598700
  600159
  633737
  637128
  644291
  596619
  598580
  598679
  603432
  597815
  605331
  620901
  598584
  600050
  605334
  777080
  784742
  807525
  795690
  727807
  730692
  743341
  757367
  772728
  794702
  728384
  741548
  744723
  745353
  733905
  744842
  745075
  758956
  605333
  632302
  717708
  717834
  718668
  722864
  780608
  388078
  401757
  414194
  414498
  436849
  478490
  397348
  411033
  414256
  429877
  443489
  404696
  426024
  461586
  398869
  400019
  400021
  416898
  417986
  419432
  463922
  480260
  420793
  441468
  465986
  472353
]
3.21 ms
(1.95%)
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
  388078
  397348
  398869
  400019
  400021
  401757
  404696
  411033
  414194
  414256
  414498
  416898
  417986
  419432
  420793
  426024
  429877
  436849
  441468
  443489
  461586
  463922
  464903
  465986
  472353
  478490
  480260
  543637
  543829
  548723
  552514
  552998
  558959
  565964
  568157
  568485
  572028
  573780
  574523
  574896
  575060
  575106
  575127
  575214
  575475
  575740
  576283
  595403
  596619
  597057
  597584
  597815
  598493
  598571
  598580
  598584
  598674
  598679
  598700
  600050
  600159
  603432
  605331
  605333
  605334
  620901
  632302
  633737
  637128
  644291
  649920
  652192
  652831
  652923
  654086
  659414
  663232
  668437
  668545
  671578
  671640
  672686
  680161
  680172
  683454
  684189
  684690
  686712
  690439
  698033
  702162
  717708
  717834
  717902
  718668
  720079
  720332
  720754
  721307
  722864
  722883
  727807
  728384
  730692
  733905
  741548
  743341
  744723
  744842
  745075
  745353
  757367
  758956
  772728
  777080
  780608
  784742
  794702
  795690
  807525
]
2.10 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen beautiful"
]
1.92 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen красивая"
]
1.81 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.