GET https://search.jues.net/search/embeds/3?q=2022%20teen%20casting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.08 ms
(85.00%)
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
  53515
  53805
  134210
  341691
  383360
  386924
  391059
  391182
  396350
  396799
  396844
  398270
  401979
  402541
  403187
  403289
  406469
  415517
  415520
  417733
  417739
  417744
  428470
  432797
  447539
  451755
  461437
  468711
  468712
  468749
  512881
  521240
  526583
  528901
  528959
  529018
  529058
  531140
  533747
  541913
  552397
  566022
  571209
  571214
  571215
  571219
  575727
  590360
  590413
  593116
  594613
  596255
  597241
  598135
  598478
  598565
  598754
  600146
  600358
  605325
  605326
  605342
  605353
  609878
  613181
  615005
  619375
  619376
  619780
  632593
  633733
  633811
  634504
  634536
  634541
  640466
  644288
  644330
  650230
  666458
  671102
  671523
  687431
  688377
  689315
  689616
  692047
  702624
  702756
  709837
  714526
  715710
  717890
  718687
  718719
  719926
  720397
  722597
  725132
  725151
  727773
  727824
  729894
  735951
  741885
  742833
  743057
  746157
  746802
  746979
  747138
  747519
  756073
  756510
  758557
  775939
  779737
  792180
  817626
]
15.10 ms
(8.91%)
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
  619376
  590360
  596255
  597241
  634504
  605326
  605353
  634541
  743057
  719926
  53515
  391182
  468711
  529058
  53805
  396844
  428470
  417733
  692047
  715710
  722597
  666458
  598478
  779737
  775939
  746157
  725132
  725151
  746979
  735951
  727824
  615005
  709837
  718719
  773672
  633733
  134210
  402541
  401979
  468712
  468749
  512881
  528901
  528959
  531140
  529018
  521240
  541913
  575727
  571209
  571215
  671523
  689616
  687431
  689315
  571214
  571219
  609878
  644288
  605325
  605342
  593116
  598565
  600358
  634536
  792180
  729894
  758557
  619375
  644330
  702624
  714526
  403289
  406469
  391059
  415517
  417739
  432797
  415520
  417744
  451755
  566022
  590413
  447539
  461437
  526583
  633811
  702756
  741885
  386924
  341691
  817626
  594613
  756510
  398270
  403187
  383360
  552397
  650230
  720397
  717890
  640466
  600146
  619780
  598135
  598754
  742833
  746802
  747519
  747138
  727773
  756073
  718687
  396799
  688377
  671102
  613181
  396350
  533747
  632593
]
2.95 ms
(1.74%)
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
  53515
  53805
  134210
  341691
  383360
  386924
  391059
  391182
  396350
  396799
  396844
  398270
  401979
  402541
  403187
  403289
  406469
  415517
  415520
  417733
  417739
  417744
  428470
  432797
  447539
  451755
  461437
  468711
  468712
  468749
  512881
  521240
  526583
  528901
  528959
  529018
  529058
  531140
  533747
  541913
  552397
  566022
  571209
  571214
  571215
  571219
  575727
  590360
  590413
  593116
  594613
  596255
  597241
  598135
  598478
  598565
  598754
  600146
  600358
  605325
  605326
  605342
  605353
  609878
  613181
  615005
  619375
  619376
  619780
  632593
  633733
  633811
  634504
  634536
  634541
  640466
  644288
  644330
  650230
  666458
  671102
  671523
  687431
  688377
  689315
  689616
  692047
  702624
  702756
  709837
  714526
  715710
  717890
  718687
  718719
  719926
  720397
  722597
  725132
  725151
  727773
  727824
  729894
  735951
  741885
  742833
  743057
  746157
  746802
  746979
  747138
  747519
  756073
  756510
  758557
  775939
  779737
  792180
  817626
]
2.30 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "2022 teen casting"
]
1.77 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen кастинг"
]
1.68 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.95%)
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.