GET https://search.jues.net/search/embeds/10?q=18-19-let%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.91 ms
(85.73%)
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
  388857
  393550
  398848
  410299
  410321
  462450
  489286
  505829
  517288
  523354
  531655
  541718
  545990
  547404
  548973
  548994
  552621
  554186
  554827
  557462
  558082
  560637
  560937
  563947
  565552
  568944
  572705
  581248
  583528
  594074
  595423
  597560
  598474
  604216
  620044
  622965
  623195
  623716
  624161
  625992
  627122
  631938
  639950
  641714
  643462
  647084
  648512
  648560
  652188
  652614
  652904
  653533
  653544
  654430
  655069
  656085
  656090
  656322
  657142
  657291
  659419
  666819
  668449
  672797
  675041
  678415
  690251
  691351
  691611
  696297
  701486
  703193
  713300
  720748
  720793
  721322
  722617
  725167
  728404
  728676
  730623
  739794
  740710
  743849
  744689
  748535
  751665
  753485
  754195
  754228
  764835
  766802
  766806
  766863
  766883
  769833
  770287
  770435
  774652
  775453
  776937
  776945
  777082
  777211
  777318
  778900
  781105
  786761
  787550
  788552
  791181
  793335
  793440
  795119
  804320
  805722
  812362
  813635
  814490
  814998
]
13.90 ms
(8.46%)
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
  489286
  517288
  652614
  721322
  560937
  583528
  793440
  730623
  751665
  805722
  739794
  744689
  766802
  770287
  769833
  778900
  781105
  393550
  410321
  701486
  766883
  753485
  623716
  648560
  653544
  659419
  594074
  620044
  622965
  523354
  398848
  554186
  653533
  656085
  657291
  675041
  690251
  696297
  655069
  656090
  720748
  563947
  631938
  623195
  624161
  643462
  597560
  787550
  804320
  754195
  728404
  764835
  728676
  748535
  766806
  770435
  754228
  766863
  777082
  793335
  795119
  656322
  505829
  666819
  462450
  703193
  388857
  410299
  814490
  813635
  814998
  531655
  541718
  547404
  548973
  548994
  558082
  565552
  572705
  581248
  552621
  557462
  568944
  647084
  648512
  668449
  691611
  652904
  691351
  713300
  720793
  652188
  654430
  657142
  672797
  678415
  722617
  545990
  554827
  560637
  598474
  604216
  641714
  625992
  639950
  595423
  627122
  774652
  776937
  777211
  777318
  786761
  788552
  775453
  776945
  791181
  812362
  725167
  740710
  743849
]
2.48 ms
(1.51%)
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
  388857
  393550
  398848
  410299
  410321
  462450
  489286
  505829
  517288
  523354
  531655
  541718
  545990
  547404
  548973
  548994
  552621
  554186
  554827
  557462
  558082
  560637
  560937
  563947
  565552
  568944
  572705
  581248
  583528
  594074
  595423
  597560
  598474
  604216
  620044
  622965
  623195
  623716
  624161
  625992
  627122
  631938
  639950
  641714
  643462
  647084
  648512
  648560
  652188
  652614
  652904
  653533
  653544
  654430
  655069
  656085
  656090
  656322
  657142
  657291
  659419
  666819
  668449
  672797
  675041
  678415
  690251
  691351
  691611
  696297
  701486
  703193
  713300
  720748
  720793
  721322
  722617
  725167
  728404
  728676
  730623
  739794
  740710
  743849
  744689
  748535
  751665
  753485
  754195
  754228
  764835
  766802
  766806
  766863
  766883
  769833
  770287
  770435
  774652
  775453
  776937
  776945
  777082
  777211
  777318
  778900
  781105
  786761
  787550
  788552
  791181
  793335
  793440
  795119
  804320
  805722
  812362
  813635
  814490
  814998
]
2.06 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18-19-let anal"
]
1.79 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 19 let лет анал"
]
1.68 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 19 let лет анал"
]

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.