GET https://search.jues.net/search/embeds/4?q=hairy%20ass%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.53 ms
(84.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
  386734
  402905
  407592
  416284
  417847
  425719
  426535
  429416
  430424
  433635
  434259
  437488
  442661
  447276
  451010
  451086
  454875
  458370
  458534
  458987
  460305
  463209
  465259
  466392
  477109
  479422
  479493
  483175
  492294
  513143
  520830
  523281
  524423
  526590
  526997
  529419
  530872
  530878
  539828
  540862
  546199
  553030
  557844
  560672
  561602
  563005
  563736
  566743
  575948
  581255
  584339
  585308
  585364
  592686
  593988
  595117
  595362
  596409
  598455
  601831
  606237
  606734
  610275
  611210
  620292
  620371
  625776
  634315
  642950
  645317
  648057
  649068
  650211
  664739
  671891
  682065
  695164
  696128
  701185
  716985
  730361
  738250
  761677
  769071
  771816
  773226
  788830
  790849
  792172
  793638
  797018
  802652
  804751
  809693
  813210
  814336
  816062
  816960
  818539
  820451
  820577
  820586
  820671
  820981
  821317
  821405
  821476
  821562
  821691
  821716
  822026
  822181
  822654
  822721
  823217
  823231
  823426
  824434
  826560
  827888
]
13.03 ms
(9.16%)
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
  595117
  771816
  696128
  585308
  802652
  695164
  451010
  458987
  560672
  477109
  407592
  821476
  826560
  816960
  820586
  822026
  824434
  820451
  821405
  822721
  823231
  823426
  818539
  827888
  465259
  479493
  526590
  530872
  530878
  563005
  575948
  581255
  553030
  584339
  650211
  671891
  664739
  682065
  648057
  649068
  701185
  585364
  601831
  606237
  610275
  620292
  792172
  797018
  761677
  790849
  773226
  730361
  738250
  634315
  642950
  716985
  793638
  813210
  479422
  523281
  645317
  593988
  769071
  429416
  526997
  520830
  546199
  566743
  386734
  416284
  442661
  611210
  563736
  822181
  814336
  598455
  823217
  458370
  460305
  620371
  606734
  804751
  788830
  417847
  463209
  524423
  625776
  540862
  561602
  592686
  595362
  596409
  809693
  447276
  426535
  451086
  492294
  454875
  402905
  425719
  557844
  437488
  466392
  430424
  434259
  433635
  822654
  816062
  820577
  820671
  821562
  820981
  821691
  821317
  821716
  458534
  483175
  529419
  539828
  513143
]
2.56 ms
(1.80%)
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
  386734
  402905
  407592
  416284
  417847
  425719
  426535
  429416
  430424
  433635
  434259
  437488
  442661
  447276
  451010
  451086
  454875
  458370
  458534
  458987
  460305
  463209
  465259
  466392
  477109
  479422
  479493
  483175
  492294
  513143
  520830
  523281
  524423
  526590
  526997
  529419
  530872
  530878
  539828
  540862
  546199
  553030
  557844
  560672
  561602
  563005
  563736
  566743
  575948
  581255
  584339
  585308
  585364
  592686
  593988
  595117
  595362
  596409
  598455
  601831
  606237
  606734
  610275
  611210
  620292
  620371
  625776
  634315
  642950
  645317
  648057
  649068
  650211
  664739
  671891
  682065
  695164
  696128
  701185
  716985
  730361
  738250
  761677
  769071
  771816
  773226
  788830
  790849
  792172
  793638
  797018
  802652
  804751
  809693
  813210
  814336
  816062
  816960
  818539
  820451
  820577
  820586
  820671
  820981
  821317
  821405
  821476
  821562
  821691
  821716
  822026
  822181
  822654
  822721
  823217
  823231
  823426
  824434
  826560
  827888
]
2.22 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy ass pov"
]
1.72 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая жоп пов"
]
1.47 ms
(1.03%)
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.