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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.38 ms
(81.48%)
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
  10171
  370039
  382750
  382941
  383247
  383791
  384082
  385388
  385728
  386269
  386923
  387566
  388450
  390134
  411884
  415518
  415523
  415527
  420082
  428115
  432796
  443715
  451718
  454806
  457159
  462372
  467608
  469357
  474771
  486438
  502247
  506787
  510562
  516004
  516957
  519184
  527282
  527502
  527519
  527525
  527536
  528997
  529040
  530489
  530643
  545607
  550410
  564214
  566018
  579318
  580214
  582778
  585431
  587511
  591357
  592478
  592724
  597951
  600013
  605300
  605317
  607954
  608430
  609864
  614993
  622049
  622398
  624784
  629359
  630030
  634522
  634550
  634560
  636987
  637016
  637134
  637426
  647626
  648595
  664235
  671101
  673125
  675480
  677296
  689592
  695316
  704526
  710197
  716143
  720711
  721695
  725310
  725342
  730077
  731814
  732277
  744016
  750727
  753072
  756544
  758476
  758540
  766723
  766756
  772721
  773654
  773986
  773989
  774410
  775755
  782425
  788166
  792184
  792534
  792564
  792772
  792807
  802478
  810218
  810220
]
19.19 ms
(12.28%)
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
  591357
  587511
  720711
  695316
  597951
  516004
  592724
  637426
  469357
  647626
  636987
  530643
  580214
  411884
  510562
  545607
  600013
  579318
  506787
  519184
  585431
  530489
  592478
  704526
  629359
  486438
  462372
  614993
  637016
  622398
  457159
  467608
  502247
  677296
  10171
  773986
  370039
  782425
  766756
  775755
  689592
  730077
  673125
  383791
  527525
  550410
  716143
  529040
  443715
  451718
  732277
  527502
  564214
  607954
  622049
  624784
  792564
  527282
  382941
  385388
  385728
  383247
  387566
  527536
  566018
  710197
  605300
  773654
  773989
  386923
  415527
  792534
  788166
  648595
  582778
  810220
  725310
  792772
  750727
  753072
  774410
  528997
  516957
  675480
  630030
  605317
  609864
  802478
  766723
  772721
  721695
  386269
  731814
  420082
  454806
  390134
  637134
  388450
  671101
  725342
  432796
  474771
  664235
  634550
  634560
  608430
  634522
  744016
  758476
  792184
  810218
  756544
  792807
  415518
  415523
  428115
  527519
  758540
  384082
  382750
]
2.34 ms
(1.49%)
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
  10171
  370039
  382750
  382941
  383247
  383791
  384082
  385388
  385728
  386269
  386923
  387566
  388450
  390134
  411884
  415518
  415523
  415527
  420082
  428115
  432796
  443715
  451718
  454806
  457159
  462372
  467608
  469357
  474771
  486438
  502247
  506787
  510562
  516004
  516957
  519184
  527282
  527502
  527519
  527525
  527536
  528997
  529040
  530489
  530643
  545607
  550410
  564214
  566018
  579318
  580214
  582778
  585431
  587511
  591357
  592478
  592724
  597951
  600013
  605300
  605317
  607954
  608430
  609864
  614993
  622049
  622398
  624784
  629359
  630030
  634522
  634550
  634560
  636987
  637016
  637134
  637426
  647626
  648595
  664235
  671101
  673125
  675480
  677296
  689592
  695316
  704526
  710197
  716143
  720711
  721695
  725310
  725342
  730077
  731814
  732277
  744016
  750727
  753072
  756544
  758476
  758540
  766723
  766756
  772721
  773654
  773986
  773989
  774410
  775755
  782425
  788166
  792184
  792534
  792564
  792772
  792807
  802478
  810218
  810220
]
2.14 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass casting"
]
1.66 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп кастинг"
]
1.66 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп кастинг"
]

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.