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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.70 ms
(87.03%)
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
  404772
  415342
  417513
  426814
  426926
  427084
  430629
  433039
  437576
  437579
  439669
  442325
  442678
  442835
  442867
  444165
  445079
  449118
  451428
  451639
  454412
  454788
  455923
  456170
  456291
  458311
  460588
  463350
  463761
  463773
  464407
  465399
  466309
  467405
  467414
  467441
  468912
  470662
  476707
  482383
  482495
  486962
  489396
  489938
  493835
  502733
  503579
  503584
  506146
  511303
  511528
  511529
  511827
  512521
  512529
  512575
  512988
  515592
  515903
  518589
  518608
  519565
  520597
  520800
  521060
  522489
  524597
  525773
  526222
  526270
  527442
  528522
  531191
  531491
  532066
  533636
  539282
  542759
  548213
  549244
  552976
  553255
  559867
  561337
  561354
  562044
  563616
  564481
  566074
  566075
  569683
  569987
  570899
  577439
  577584
  588343
  589573
  591292
  595763
  602803
  602834
  615929
  619464
  621338
  627095
  627660
  635974
  643086
  648761
  654914
  663922
  665496
  678978
  719014
  728446
  756506
  778941
  806099
  807356
  813257
]
16.86 ms
(8.30%)
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
  561337
  602803
  489396
  539282
  569683
  552976
  464407
  404772
  426814
  449118
  521060
  559867
  511827
  454412
  476707
  526222
  531491
  502733
  548213
  562044
  566075
  577584
  561354
  566074
  569987
  663922
  719014
  654914
  665496
  648761
  595763
  619464
  635974
  602834
  627660
  778941
  806099
  728446
  756506
  627095
  415342
  437576
  437579
  466309
  458311
  465399
  433039
  456291
  442325
  515592
  533636
  511303
  511529
  518589
  520597
  524597
  512575
  439669
  444165
  463350
  570899
  489938
  525773
  493835
  426926
  519565
  553255
  455923
  451639
  417513
  445079
  442678
  463761
  468912
  456170
  470662
  486962
  531191
  532066
  482383
  563616
  577439
  678978
  588343
  591292
  643086
  807356
  813257
  621338
  430629
  467414
  467441
  442867
  451428
  467405
  503579
  506146
  512529
  512988
  518608
  522489
  526270
  528522
  512521
  515903
  549244
  527442
  454788
  542759
  564481
  427084
  442835
  482495
  460588
  463773
  503584
  520800
  511528
  589573
  615929
]
3.79 ms
(1.87%)
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
  404772
  415342
  417513
  426814
  426926
  427084
  430629
  433039
  437576
  437579
  439669
  442325
  442678
  442835
  442867
  444165
  445079
  449118
  451428
  451639
  454412
  454788
  455923
  456170
  456291
  458311
  460588
  463350
  463761
  463773
  464407
  465399
  466309
  467405
  467414
  467441
  468912
  470662
  476707
  482383
  482495
  486962
  489396
  489938
  493835
  502733
  503579
  503584
  506146
  511303
  511528
  511529
  511827
  512521
  512529
  512575
  512988
  515592
  515903
  518589
  518608
  519565
  520597
  520800
  521060
  522489
  524597
  525773
  526222
  526270
  527442
  528522
  531191
  531491
  532066
  533636
  539282
  542759
  548213
  549244
  552976
  553255
  559867
  561337
  561354
  562044
  563616
  564481
  566074
  566075
  569683
  569987
  570899
  577439
  577584
  588343
  589573
  591292
  595763
  602803
  602834
  615929
  619464
  621338
  627095
  627660
  635974
  643086
  648761
  654914
  663922
  665496
  678978
  719014
  728446
  756506
  778941
  806099
  807356
  813257
]
1.60 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teacher big ass"
]
1.38 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teacher большая большие жоп"
]
1.37 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teacher большая большие жоп"
]
1.33 ms
(0.65%)
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.