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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.12 ms
(53.82%)
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
  17066
  389770
  392104
  394103
  401724
  406059
  417368
  422237
  423459
  429362
  447909
  451488
  451620
  452567
  455657
  465103
  471801
  473057
  473778
  477953
  477981
  482174
  483369
  484587
  485301
  485899
  487156
  489691
  489714
  491503
  497958
  503621
  507241
  508809
  508852
  508874
  510950
  511058
  515170
  515175
  516837
  518581
  519588
  525821
  525918
  525919
  532912
  535729
  538054
  542951
  544493
  550067
  550418
  552273
  553173
  553516
  556839
  557940
  567372
  568061
  569233
  570873
  574210
  574833
  575603
  578082
  579362
  590549
  590796
  591612
  591819
  592645
  596230
  601569
  613465
  615928
  620900
  631768
  631965
  641095
  645381
  645934
  646846
  651941
  660531
  667309
  676951
  699678
  729436
  742878
  744261
  751970
  753142
  765726
  768940
  783452
  784393
  791362
  800988
  804719
  806097
  807037
  807391
  811028
  811073
  813553
  814220
  814558
  817335
  818245
  818784
  819107
  822292
  822979
  825231
  826736
  827163
  828365
]
155.64 ms
(40.06%)
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
  17066
  389770
  392104
  394103
  401724
  406059
  417368
  422237
  423459
  429362
  447909
  451488
  451620
  452567
  455657
  465103
  471801
  473057
  473778
  477953
  477981
  482174
  483369
  484587
  485301
  485899
  487156
  489691
  489714
  491503
  497958
  503621
  507241
  508809
  508852
  508874
  510950
  511058
  515170
  515175
  516837
  518581
  519588
  525821
  525918
  525919
  532912
  535729
  538054
  542951
  544493
  550067
  550418
  552273
  553173
  553516
  556839
  557940
  567372
  568061
  569233
  570873
  574210
  574833
  575603
  578082
  579362
  590549
  590796
  591612
  591819
  592645
  596230
  601569
  613465
  615928
  620900
  631768
  631965
  641095
  645381
  645934
  646846
  651941
  660531
  667309
  676951
  699678
  729436
  742878
  744261
  751970
  753142
  765726
  768940
  783452
  784393
  791362
  800988
  804719
  806097
  807037
  807391
  811028
  811073
  813553
  814220
  814558
  817335
  818245
  818784
  819107
  822292
  822979
  825231
  826736
  827163
  828365
]
16.33 ms
(4.20%)
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
  783452
  807037
  477981
  484587
  511058
  489691
  508809
  818245
  645381
  667309
  800988
  814220
  451620
  532912
  544493
  592645
  491503
  515170
  574833
  817335
  553173
  651941
  553516
  596230
  538054
  569233
  422237
  17066
  556839
  601569
  620900
  818784
  784393
  765726
  465103
  615928
  569904
  477953
  392104
  590796
  575603
  660531
  744261
  806097
  822530
  827163
  535729
  518581
  401724
  429362
  455657
  471801
  473057
  567372
  676951
  646846
  557940
  590549
  641095
  791362
  804719
  742878
  417368
  473778
  394103
  452567
  508852
  508874
  516837
  525821
  483369
  503621
  510950
  485301
  525918
  525919
  507241
  515175
  497958
  485899
  579362
  406059
  487156
  550067
  552273
  631965
  570873
  489714
  751970
  591612
  826736
  819107
  825231
  814558
  822292
  822979
  828365
  574210
  811073
  753142
  729436
  768940
  447909
  451488
  811028
  807391
  813553
  550418
  645934
  699678
  631768
  423459
  389770
  613465
  542951
  578082
  591819
  568061
  519588
  482174
]
2.15 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "redhead small tits"
]
1.86 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рыжая маленькая сиськ"
]
1.78 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рыжая маленькая сиськ"
]
1.66 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.