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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.04 ms
(85.40%)
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
  6651
  282542
  324183
  383020
  386567
  389900
  391561
  391715
  392721
  392817
  396554
  397739
  398302
  400662
  400730
  400941
  400954
  402032
  403134
  404443
  404968
  406513
  409995
  412725
  413641
  414061
  414070
  415761
  418534
  421369
  426026
  430366
  432927
  436132
  440016
  447444
  452875
  485527
  495747
  497690
  506371
  510393
  510402
  515572
  521588
  523205
  524183
  524193
  524793
  529574
  530012
  530478
  531085
  531209
  532727
  532799
  533012
  533090
  535423
  536227
  536271
  540685
  544147
  545465
  547852
  563943
  565575
  568518
  575601
  594208
  604105
  609804
  618769
  623204
  635900
  641562
  641569
  641761
  644066
  648679
  651666
  656919
  656936
  656944
  660713
  661973
  663317
  675762
  677671
  680248
  687204
  696598
  711291
  713113
  717553
  720756
  723094
  740269
  745101
  745123
  748530
  750123
  750145
  752592
  752706
  757061
  757868
  761430
  766945
  770267
  786872
  787514
  794310
  799786
  800282
  800318
  801313
  805301
  814443
]
16.41 ms
(9.10%)
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
  506371
  529574
  533090
  540685
  544147
  565575
  656936
  656944
  661973
  717553
  648679
  656919
  713113
  663317
  720756
  547852
  609804
  641569
  641761
  618769
  641562
  799786
  805301
  801313
  761430
  786872
  794310
  800318
  762121
  745123
  766945
  770267
  745101
  740269
  750123
  750145
  752592
  757061
  604105
  723094
  787514
  800282
  324183
  402032
  406513
  398302
  282542
  396554
  403134
  391561
  392721
  392817
  397739
  523205
  524183
  651666
  635900
  426026
  391715
  400662
  400941
  400954
  414070
  418534
  432927
  413641
  440016
  485527
  497690
  532799
  495747
  533012
  510402
  530012
  531209
  532727
  535423
  677671
  594208
  644066
  623204
  748530
  415761
  436132
  404443
  421369
  430366
  452875
  404968
  409995
  447444
  524793
  510393
  521588
  524193
  530478
  814443
  536227
  531085
  515572
  545465
  563943
  568518
  575601
  680248
  696598
  752706
  711291
  675762
  757868
  536271
  660713
  687204
  386567
  383020
  6651
  389900
  400730
  412725
  414061
]
2.41 ms
(1.34%)
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
  6651
  282542
  324183
  383020
  386567
  389900
  391561
  391715
  392721
  392817
  396554
  397739
  398302
  400662
  400730
  400941
  400954
  402032
  403134
  404443
  404968
  406513
  409995
  412725
  413641
  414061
  414070
  415761
  418534
  421369
  426026
  430366
  432927
  436132
  440016
  447444
  452875
  485527
  495747
  497690
  506371
  510393
  510402
  515572
  521588
  523205
  524183
  524193
  524793
  529574
  530012
  530478
  531085
  531209
  532727
  532799
  533012
  533090
  535423
  536227
  536271
  540685
  544147
  545465
  547852
  563943
  565575
  568518
  575601
  594208
  604105
  609804
  618769
  623204
  635900
  641562
  641569
  641761
  644066
  648679
  651666
  656919
  656936
  656944
  660713
  661973
  663317
  675762
  677671
  680248
  687204
  696598
  711291
  713113
  717553
  720756
  723094
  740269
  745101
  745123
  748530
  750123
  750145
  752592
  752706
  757061
  757868
  761430
  766945
  770267
  786872
  787514
  794310
  799786
  800282
  800318
  801313
  805301
  814443
]
2.29 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme teen"
]
1.87 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор teen"
]
1.72 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.91%)
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.