GET https://search.jues.net/search/embeds/8?q=hairy%20saggy%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.37 ms
(85.57%)
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
  271496
  388791
  398522
  416131
  423958
  428816
  434091
  442100
  449908
  450147
  453541
  453989
  453993
  454028
  456030
  457600
  458293
  458987
  460855
  462807
  463781
  466459
  466863
  474849
  477548
  490641
  490648
  492406
  492412
  502023
  502497
  506855
  507616
  508602
  512518
  518860
  519235
  521210
  528362
  529340
  535345
  535706
  541479
  544475
  544585
  545744
  549389
  550356
  555175
  555623
  570891
  578866
  585434
  591161
  594067
  596041
  598341
  599084
  601182
  601449
  612237
  626948
  629977
  630254
  632949
  637538
  648587
  649955
  674493
  687512
  688299
  690084
  704097
  704542
  705796
  715472
  715965
  718806
  718985
  724457
  729075
  733396
  734269
  740368
  740442
  742283
  742897
  753057
  754317
  756909
  760171
  772877
  776635
  776641
  792539
  793539
  794409
  801390
  802381
  804224
  804391
  807840
  808034
  808494
  810030
  810369
  813613
  815398
  815957
  816826
  817964
  818510
  818787
  819350
  820085
  820493
  824833
  824857
  825183
  826599
]
15.45 ms
(8.73%)
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
  734269
  742897
  793539
  807840
  724457
  754317
  740368
  804391
  544585
  776635
  792539
  801390
  740442
  398522
  824833
  454028
  718806
  601449
  630254
  388791
  416131
  449908
  490648
  490641
  434091
  458987
  466459
  453993
  492406
  492412
  466863
  544475
  598341
  599084
  462807
  502497
  502023
  477548
  535345
  506855
  512518
  529340
  541479
  591161
  612237
  456030
  507616
  555623
  817964
  820493
  813613
  826599
  818510
  818787
  820085
  824857
  815398
  815957
  819350
  825183
  519235
  521210
  518860
  535706
  508602
  550356
  545744
  549389
  648587
  649955
  674493
  705796
  715472
  715965
  690084
  704097
  687512
  688299
  718985
  555175
  570891
  578866
  632949
  596041
  637538
  585434
  594067
  601182
  629977
  794409
  733396
  756909
  760171
  810369
  729075
  753057
  742283
  772877
  626948
  704542
  776641
  802381
  804224
  808034
  808494
  810030
  271496
  423958
  428816
  442100
  816826
  450147
  453989
  457600
  460855
  474849
  458293
  463781
  453541
  528362
]
2.69 ms
(1.52%)
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
  271496
  388791
  398522
  416131
  423958
  428816
  434091
  442100
  449908
  450147
  453541
  453989
  453993
  454028
  456030
  457600
  458293
  458987
  460855
  462807
  463781
  466459
  466863
  474849
  477548
  490641
  490648
  492406
  492412
  502023
  502497
  506855
  507616
  508602
  512518
  518860
  519235
  521210
  528362
  529340
  535345
  535706
  541479
  544475
  544585
  545744
  549389
  550356
  555175
  555623
  570891
  578866
  585434
  591161
  594067
  596041
  598341
  599084
  601182
  601449
  612237
  626948
  629977
  630254
  632949
  637538
  648587
  649955
  674493
  687512
  688299
  690084
  704097
  704542
  705796
  715472
  715965
  718806
  718985
  724457
  729075
  733396
  734269
  740368
  740442
  742283
  742897
  753057
  754317
  756909
  760171
  772877
  776635
  776641
  792539
  793539
  794409
  801390
  802381
  804224
  804391
  807840
  808034
  808494
  810030
  810369
  813613
  815398
  815957
  816826
  817964
  818510
  818787
  819350
  820085
  820493
  824833
  824857
  825183
  826599
]
1.99 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая saggy сиськ"
]
1.94 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy saggy tits"
]
1.80 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая saggy сиськ"
]

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.