GET https://search.jues.net/search/embeds/3?q=small%20tits%20redhead

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.43 ms
(79.30%)
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
  64934
  381807
  396684
  397059
  397917
  402212
  410770
  411756
  415793
  419407
  420548
  426138
  428523
  429097
  444115
  447323
  448924
  456906
  456961
  463945
  467792
  468695
  469274
  469736
  473322
  475614
  477015
  477082
  478911
  480434
  482913
  485367
  487072
  490714
  494196
  495497
  499788
  500873
  503748
  503946
  507175
  508695
  511299
  511713
  513103
  513198
  515604
  516902
  519502
  520464
  522938
  523279
  526093
  532900
  532926
  532945
  533005
  533012
  533039
  535918
  535920
  536201
  546385
  548730
  550430
  557542
  557790
  558563
  559539
  559766
  559777
  560507
  563776
  564676
  564822
  566034
  568602
  569128
  570721
  574912
  579684
  581743
  584688
  590413
  590702
  591273
  593381
  597828
  604227
  609052
  610350
  623555
  676976
  680115
  703553
  718688
  721381
  721551
  722629
  722821
  722851
  727125
  730374
  753477
  754223
  758606
  783452
  786771
  789747
  791731
  792056
  792181
  800001
  800593
  804820
  805675
  814110
  824755
  827477
  828028
]
26.05 ms
(14.92%)
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
  477015
  519502
  507175
  559777
  447323
  495497
  428523
  419407
  523279
  532900
  533005
  590413
  415793
  448924
  480434
  513198
  508695
  511299
  482913
  574912
  557790
  570721
  548730
  564822
  680115
  604227
  722851
  824755
  559766
  397059
  397917
  503748
  564676
  591273
  494196
  814110
  722629
  800593
  792056
  753477
  467792
  381807
  532926
  805675
  444115
  64934
  499788
  429097
  478911
  402212
  463945
  536201
  563776
  532945
  533012
  535918
  535920
  721551
  513103
  516902
  515604
  520464
  827477
  456961
  676976
  579684
  789747
  786771
  800001
  721381
  426138
  420548
  526093
  503946
  560507
  569128
  581743
  558563
  722821
  557542
  550430
  584688
  792181
  487072
  828028
  623555
  568602
  469736
  597828
  804820
  590702
  396684
  411756
  410770
  473322
  477082
  456906
  533039
  559539
  566034
  718688
  703553
  546385
  593381
  610350
  609052
  791731
  727125
  730374
  754223
  758606
  475614
  468695
  511713
  485367
  490714
  500873
  522938
  469274
  783452
]
2.75 ms
(1.58%)
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
  64934
  381807
  396684
  397059
  397917
  402212
  410770
  411756
  415793
  419407
  420548
  426138
  428523
  429097
  444115
  447323
  448924
  456906
  456961
  463945
  467792
  468695
  469274
  469736
  473322
  475614
  477015
  477082
  478911
  480434
  482913
  485367
  487072
  490714
  494196
  495497
  499788
  500873
  503748
  503946
  507175
  508695
  511299
  511713
  513103
  513198
  515604
  516902
  519502
  520464
  522938
  523279
  526093
  532900
  532926
  532945
  533005
  533012
  533039
  535918
  535920
  536201
  546385
  548730
  550430
  557542
  557790
  558563
  559539
  559766
  559777
  560507
  563776
  564676
  564822
  566034
  568602
  569128
  570721
  574912
  579684
  581743
  584688
  590413
  590702
  591273
  593381
  597828
  604227
  609052
  610350
  623555
  676976
  680115
  703553
  718688
  721381
  721551
  722629
  722821
  722851
  727125
  730374
  753477
  754223
  758606
  783452
  786771
  789747
  791731
  792056
  792181
  800001
  800593
  804820
  805675
  814110
  824755
  827477
  828028
]
2.10 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small tits redhead"
]
1.91 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая сиськ рыжая"
]
1.81 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.86%)
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.