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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.07 ms
(83.32%)
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
  415342
  426814
  426926
  430629
  432376
  432393
  432426
  432452
  432472
  432486
  432517
  432527
  433039
  433042
  433061
  433452
  433561
  433596
  437561
  437576
  437577
  437579
  439721
  442325
  442553
  442835
  449118
  455515
  455531
  456291
  458311
  462995
  463761
  463773
  464407
  466309
  466560
  466755
  467459
  467551
  468912
  469014
  469343
  470408
  470442
  470662
  472800
  476707
  478978
  482495
  482533
  489396
  489768
  489938
  492519
  493835
  499261
  502733
  503579
  503584
  506146
  509620
  511303
  512521
  513531
  515592
  515736
  516156
  516748
  517356
  519515
  522489
  524673
  525773
  526222
  526270
  531191
  531491
  532066
  539561
  550299
  562951
  564696
  565107
  566074
  566075
  569793
  570899
  571776
  577439
  577584
  586136
  586535
  588343
  591292
  595763
  606880
  608815
  619464
  619832
  621338
  626216
  627660
  635974
  644095
  644847
  648761
  654914
  663922
  665496
  678978
  719014
  728446
  730688
  732905
  756506
  778941
  797785
  806099
  813257
]
18.17 ms
(10.81%)
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
  608815
  619832
  626216
  586535
  606880
  730688
  432486
  432517
  433452
  432426
  432472
  433561
  432376
  432527
  433042
  432452
  433061
  513531
  489768
  469343
  499261
  797785
  433596
  466560
  482533
  566074
  469014
  517356
  531491
  539561
  569793
  564696
  719014
  665496
  437576
  466309
  426814
  462995
  470408
  442325
  524673
  509620
  437577
  644847
  489396
  526222
  502733
  492519
  565107
  562951
  663922
  654914
  595763
  635974
  627660
  732905
  756506
  415342
  437579
  464407
  449118
  458311
  466755
  511303
  516156
  519515
  566075
  577584
  550299
  648761
  571776
  619464
  806099
  728446
  455531
  439721
  433039
  442553
  476707
  586136
  778941
  456291
  515592
  515736
  470442
  516748
  455515
  478978
  467551
  470662
  525773
  532066
  678978
  430629
  426926
  472800
  503579
  522489
  463761
  489938
  531191
  493835
  570899
  577439
  588343
  591292
  437561
  432393
  526270
  813257
  621338
  506146
  512521
  468912
  644095
  442835
  482495
  463773
  467459
  503584
]
3.01 ms
(1.79%)
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
  415342
  426814
  426926
  430629
  432376
  432393
  432426
  432452
  432472
  432486
  432517
  432527
  433039
  433042
  433061
  433452
  433561
  433596
  437561
  437576
  437577
  437579
  439721
  442325
  442553
  442835
  449118
  455515
  455531
  456291
  458311
  462995
  463761
  463773
  464407
  466309
  466560
  466755
  467459
  467551
  468912
  469014
  469343
  470408
  470442
  470662
  472800
  476707
  478978
  482495
  482533
  489396
  489768
  489938
  492519
  493835
  499261
  502733
  503579
  503584
  506146
  509620
  511303
  512521
  513531
  515592
  515736
  516156
  516748
  517356
  519515
  522489
  524673
  525773
  526222
  526270
  531191
  531491
  532066
  539561
  550299
  562951
  564696
  565107
  566074
  566075
  569793
  570899
  571776
  577439
  577584
  586136
  586535
  588343
  591292
  595763
  606880
  608815
  619464
  619832
  621338
  626216
  627660
  635974
  644095
  644847
  648761
  654914
  663922
  665496
  678978
  719014
  728446
  730688
  732905
  756506
  778941
  797785
  806099
  813257
]
1.83 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teacher big boobs"
]
1.69 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teacher большие boobs"
]
1.58 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teacher большие boobs"
]

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.