GET https://search.jues.net/search/embeds/6?q=teens%20black

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.35 ms
(86.66%)
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
  12573
  14599
  33401
  180923
  233298
  366283
  373981
  382362
  382788
  383154
  389315
  395504
  397958
  398388
  408508
  411118
  415714
  415875
  417469
  420501
  421408
  430380
  433516
  443237
  446351
  446352
  449573
  457494
  461755
  463845
  468475
  479703
  484054
  488931
  529330
  529664
  530304
  533559
  533681
  536718
  536725
  536740
  542614
  543035
  554834
  556250
  575197
  578778
  584576
  591684
  595194
  597678
  599006
  600933
  601101
  604464
  606956
  616989
  622582
  623960
  623965
  626357
  631394
  635236
  635932
  638988
  641075
  646893
  650263
  651872
  652548
  659057
  662047
  664260
  666850
  669054
  669564
  675008
  680030
  681511
  681692
  683404
  684970
  686776
  694116
  695939
  697130
  705702
  714830
  715920
  716088
  717162
  718803
  720388
  720806
  720889
  722489
  726154
  737470
  754162
  774524
  775607
  776041
  777761
  783896
  784618
  785857
  790985
  792587
  794009
  794560
  794769
  795413
  797029
  802601
  803757
  807541
  810709
  811100
  822286
]
14.39 ms
(8.08%)
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
  714830
  715920
  718803
  777761
  783896
  790985
  794009
  797029
  803757
  810709
  12573
  180923
  366283
  446352
  395504
  33401
  417469
  233298
  382788
  397958
  421408
  411118
  533559
  666850
  675008
  575197
  601101
  595194
  383154
  373981
  382362
  14599
  389315
  398388
  408508
  420501
  430380
  415714
  443237
  433516
  415875
  822286
  446351
  457494
  484054
  449573
  463845
  468475
  488931
  533681
  530304
  536718
  536725
  529330
  529664
  536740
  461755
  479703
  554834
  556250
  543035
  542614
  578778
  650263
  659057
  669564
  697130
  717162
  720806
  646893
  651872
  664260
  669054
  681692
  694116
  652548
  662047
  680030
  681511
  683404
  684970
  686776
  695939
  705702
  716088
  720388
  720889
  722489
  584576
  616989
  626357
  635236
  591684
  597678
  604464
  635932
  631394
  599006
  600933
  606956
  622582
  623960
  623965
  638988
  641075
  807541
  774524
  775607
  776041
  794560
  795413
  726154
  737470
  754162
  784618
  785857
  792587
  794769
  802601
  811100
]
2.54 ms
(1.43%)
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
  12573
  14599
  33401
  180923
  233298
  366283
  373981
  382362
  382788
  383154
  389315
  395504
  397958
  398388
  408508
  411118
  415714
  415875
  417469
  420501
  421408
  430380
  433516
  443237
  446351
  446352
  449573
  457494
  461755
  463845
  468475
  479703
  484054
  488931
  529330
  529664
  530304
  533559
  533681
  536718
  536725
  536740
  542614
  543035
  554834
  556250
  575197
  578778
  584576
  591684
  595194
  597678
  599006
  600933
  601101
  604464
  606956
  616989
  622582
  623960
  623965
  626357
  631394
  635236
  635932
  638988
  641075
  646893
  650263
  651872
  652548
  659057
  662047
  664260
  666850
  669054
  669564
  675008
  680030
  681511
  681692
  683404
  684970
  686776
  694116
  695939
  697130
  705702
  714830
  715920
  716088
  717162
  718803
  720388
  720806
  720889
  722489
  726154
  737470
  754162
  774524
  775607
  776041
  777761
  783896
  784618
  785857
  790985
  792587
  794009
  794560
  794769
  795413
  797029
  802601
  803757
  807541
  810709
  811100
  822286
]
1.83 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens black"
]
1.72 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens black"
]
1.47 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teens black"
]

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.