GET https://search.jues.net/search/embeds/5?q=short%20hair%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.84 ms
(87.19%)
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
  388032
  397248
  401077
  402190
  420454
  421562
  421971
  434017
  443170
  447308
  448933
  457049
  459345
  461728
  463179
  464049
  465027
  468706
  470173
  475032
  475600
  476775
  477146
  478459
  480006
  486211
  486213
  493777
  496993
  502762
  511015
  511421
  513322
  522816
  528346
  531217
  531559
  532381
  533306
  535724
  536604
  541226
  550327
  553563
  568339
  573778
  575392
  576057
  581384
  590461
  590841
  595443
  597504
  597830
  598715
  603236
  633015
  633763
  635974
  637077
  643396
  644330
  649509
  649517
  650160
  650326
  654117
  656320
  659297
  664236
  664955
  665475
  672321
  673454
  675806
  677346
  684688
  694192
  696156
  697230
  697806
  699482
  699626
  705813
  708732
  709537
  711896
  719058
  719934
  720078
  720393
  720487
  720724
  720823
  722070
  722812
  724255
  724720
  725390
  725601
  728210
  732004
  740526
  741252
  741527
  742226
  744246
  747380
  752132
  756012
  758554
  758560
  758563
  769567
  769796
  793364
  797585
  800562
  807262
  811672
]
14.30 ms
(7.52%)
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
  459345
  461728
  486211
  464049
  468706
  475032
  476775
  493777
  496993
  511015
  531559
  531217
  532381
  535724
  536604
  533306
  528346
  465027
  568339
  541226
  576057
  581384
  650160
  654117
  656320
  664236
  665475
  672321
  699482
  699626
  709537
  719058
  719934
  720724
  722070
  649517
  675806
  677346
  694192
  697230
  705813
  711896
  673454
  684688
  696156
  720487
  553563
  575392
  590841
  595443
  643396
  590461
  633763
  597504
  598715
  637077
  800562
  793364
  797585
  725601
  740526
  741527
  752132
  758554
  758560
  807262
  724720
  725390
  728210
  732004
  724255
  741252
  747380
  758563
  769796
  742226
  744246
  769567
  756012
  633015
  644330
  697806
  708732
  720078
  722812
  811672
  397248
  402190
  447308
  470173
  401077
  421971
  448933
  457049
  480006
  388032
  463179
  420454
  434017
  443170
  477146
  475600
  522816
  511421
  502762
  486213
  478459
  649509
  421562
  513322
  573778
  659297
  664955
  720823
  650326
  720393
  550327
  597830
  635974
  603236
]
2.61 ms
(1.37%)
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
  388032
  397248
  401077
  402190
  420454
  421562
  421971
  434017
  443170
  447308
  448933
  457049
  459345
  461728
  463179
  464049
  465027
  468706
  470173
  475032
  475600
  476775
  477146
  478459
  480006
  486211
  486213
  493777
  496993
  502762
  511015
  511421
  513322
  522816
  528346
  531217
  531559
  532381
  533306
  535724
  536604
  541226
  550327
  553563
  568339
  573778
  575392
  576057
  581384
  590461
  590841
  595443
  597504
  597830
  598715
  603236
  633015
  633763
  635974
  637077
  643396
  644330
  649509
  649517
  650160
  650326
  654117
  656320
  659297
  664236
  664955
  665475
  672321
  673454
  675806
  677346
  684688
  694192
  696156
  697230
  697806
  699482
  699626
  705813
  708732
  709537
  711896
  719058
  719934
  720078
  720393
  720487
  720724
  720823
  722070
  722812
  724255
  724720
  725390
  725601
  728210
  732004
  740526
  741252
  741527
  742226
  744246
  747380
  752132
  756012
  758554
  758560
  758563
  769567
  769796
  793364
  797585
  800562
  807262
  811672
]
2.29 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "short hair teen"
]
1.96 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "short hair teen"
]
1.71 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "short hair 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.