GET https://search.jues.net/search/embeds/5?q=fuck%20in%20mouth

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.36 ms
(85.26%)
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
  70646
  230986
  336884
  382638
  393164
  396436
  396850
  397672
  398679
  489258
  494312
  503388
  511013
  511495
  517739
  520364
  523522
  526853
  529608
  530185
  537174
  542662
  543153
  545310
  551018
  551090
  555162
  590565
  614893
  633742
  642041
  642154
  652533
  660352
  661922
  666001
  675167
  684379
  692731
  706018
  718400
  718533
  719215
  720272
  729853
  733190
  734338
  739253
  756268
  764805
  766366
  766399
  767801
  767816
  767824
  769840
  772339
  777459
  777535
  778786
  779936
  780250
  781090
  787222
  787258
  787421
  788733
  791605
  794959
  799711
  803400
  808251
  811356
  814050
  817001
  817106
  818222
  819174
  819316
  821429
  823875
  823897
  823981
  824113
  824118
  824973
  824978
  825006
  825045
  825108
  825179
  825180
  825208
  825224
  825347
  825356
  825389
  825425
  825434
  825460
  825464
  825705
  825898
  825968
  826478
  826585
  826586
  826982
  827082
  827401
  828193
  828264
  828565
]
12.71 ms
(8.12%)
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
  551018
  828565
  825045
  520364
  523522
  396436
  397672
  537174
  503388
  494312
  489258
  825968
  823761
  825932
  828264
  825898
  823981
  642041
  511495
  817106
  825421
  825434
  780250
  794959
  517739
  827401
  825347
  551090
  814050
  825179
  825464
  825356
  529608
  799711
  767816
  642154
  822849
  826524
  823875
  824973
  825389
  824118
  825180
  828193
  766399
  633742
  706018
  336884
  396850
  819174
  824978
  817001
  823897
  821429
  824404
  825108
  530185
  652533
  777459
  766366
  767824
  808251
  756268
  769840
  764805
  777535
  778786
  825006
  826137
  824113
  543153
  660352
  811356
  826982
  827082
  675167
  526853
  788733
  511013
  230986
  382638
  825224
  818222
  555162
  545310
  542662
  666001
  684379
  719215
  692731
  718533
  661922
  781090
  729853
  739253
  787258
  787421
  791605
  803400
  734338
  772339
  733190
  767801
  787222
  70646
  393164
  398679
  825460
  825705
  826478
  826586
  825425
  819316
  825208
  826585
  720272
  718400
  590565
  614893
  779936
]
2.83 ms
(1.81%)
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
  70646
  230986
  336884
  382638
  393164
  396436
  396850
  397672
  398679
  489258
  494312
  503388
  511013
  511495
  517739
  520364
  523522
  526853
  529608
  530185
  537174
  542662
  543153
  545310
  551018
  551090
  555162
  590565
  614893
  633742
  642041
  642154
  652533
  660352
  661922
  666001
  675167
  684379
  692731
  706018
  718400
  718533
  719215
  720272
  729853
  733190
  734338
  739253
  756268
  764805
  766366
  766399
  767801
  767816
  767824
  769840
  772339
  777459
  777535
  778786
  779936
  780250
  781090
  787222
  787258
  787421
  788733
  791605
  794959
  799711
  803400
  808251
  811356
  814050
  817001
  817106
  818222
  819174
  819316
  821429
  823875
  823897
  823981
  824113
  824118
  824973
  824978
  825006
  825045
  825108
  825179
  825180
  825208
  825224
  825347
  825356
  825389
  825425
  825434
  825460
  825464
  825705
  825898
  825968
  826478
  826585
  826586
  826982
  827082
  827401
  828193
  828264
  828565
]
2.15 ms
(1.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс mouth"
]
1.94 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck in mouth"
]
1.73 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс mouth"
]
1.71 ms
(1.10%)
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.