GET https://search.jues.net/search/embeds/6?q=big%20ass%20babe

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.92 ms
(87.86%)
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
  27635
  31493
  377241
  383434
  384158
  387295
  388392
  391437
  398374
  398674
  408402
  421801
  424099
  435507
  441430
  457056
  463338
  463604
  467379
  471646
  477573
  484072
  505630
  510317
  511696
  521014
  522156
  524622
  524653
  528405
  528442
  531887
  533562
  536739
  538696
  542268
  546025
  552709
  556956
  560537
  562920
  569162
  585499
  593262
  596400
  598929
  599746
  612932
  614905
  619674
  623265
  624688
  624827
  634853
  635883
  642220
  645370
  661769
  664230
  665777
  668784
  671389
  672091
  672506
  672554
  673286
  688097
  692503
  692549
  711327
  712253
  714712
  717863
  720942
  721364
  722532
  740259
  742305
  748588
  750349
  752198
  753621
  755334
  755580
  756454
  757487
  758940
  766491
  768691
  773452
  774291
  774447
  777667
  779116
  779628
  782456
  783868
  787221
  788853
  803615
  804167
  804758
  805431
  807037
  807906
  809104
  810180
  810347
  811347
  811510
  813053
  813789
  815433
  815446
  816250
  818087
  820123
  822127
  824864
  827976
]
14.63 ms
(7.31%)
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
  810347
  804758
  441430
  524622
  377241
  398374
  542268
  805431
  391437
  435507
  471646
  511696
  531887
  552709
  556956
  742305
  528442
  31493
  424099
  815433
  467379
  484072
  672506
  779116
  748588
  755334
  717863
  720942
  782456
  383434
  398674
  421801
  524653
  521014
  809104
  384158
  27635
  388392
  387295
  408402
  813789
  815446
  816250
  818087
  820123
  774447
  822127
  824864
  827976
  477573
  457056
  463338
  522156
  536739
  528405
  533562
  505630
  510317
  538696
  463604
  569162
  546025
  562920
  560537
  661769
  668784
  671389
  673286
  711327
  712253
  721364
  722532
  645370
  672091
  688097
  692503
  692549
  664230
  665777
  672554
  714712
  585499
  598929
  619674
  624688
  624827
  642220
  593262
  599746
  614905
  635883
  596400
  612932
  623265
  634853
  779628
  783868
  804167
  777667
  788853
  803615
  810180
  752198
  787221
  807037
  807906
  811347
  811510
  813053
  740259
  768691
  773452
  774291
  750349
  755580
  756454
  757487
  758940
  753621
  766491
]
3.24 ms
(1.62%)
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
  27635
  31493
  377241
  383434
  384158
  387295
  388392
  391437
  398374
  398674
  408402
  421801
  424099
  435507
  441430
  457056
  463338
  463604
  467379
  471646
  477573
  484072
  505630
  510317
  511696
  521014
  522156
  524622
  524653
  528405
  528442
  531887
  533562
  536739
  538696
  542268
  546025
  552709
  556956
  560537
  562920
  569162
  585499
  593262
  596400
  598929
  599746
  612932
  614905
  619674
  623265
  624688
  624827
  634853
  635883
  642220
  645370
  661769
  664230
  665777
  668784
  671389
  672091
  672506
  672554
  673286
  688097
  692503
  692549
  711327
  712253
  714712
  717863
  720942
  721364
  722532
  740259
  742305
  748588
  750349
  752198
  753621
  755334
  755580
  756454
  757487
  758940
  766491
  768691
  773452
  774291
  774447
  777667
  779116
  779628
  782456
  783868
  787221
  788853
  803615
  804167
  804758
  805431
  807037
  807906
  809104
  810180
  810347
  811347
  811510
  813053
  813789
  815433
  815446
  816250
  818087
  820123
  822127
  824864
  827976
]
1.76 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass babe"
]
1.63 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп babe"
]
1.56 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп babe"
]

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.