GET https://search.jues.net/search/embeds/5?q=cum%20pantyhose

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.65 ms
(81.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
  396408
  420226
  428517
  432386
  432488
  432520
  432544
  433385
  433550
  433834
  444819
  450682
  453870
  456685
  460868
  465921
  471460
  473465
  477186
  479942
  489841
  495062
  503485
  505196
  510010
  515710
  515734
  521387
  531412
  535314
  539208
  540703
  545490
  545696
  546890
  548634
  555101
  560269
  564569
  565711
  569444
  579354
  581418
  585380
  590639
  597881
  600820
  601945
  603406
  610091
  612465
  617211
  618128
  619996
  620211
  621485
  623461
  624879
  625863
  626945
  634968
  636666
  663151
  665678
  682861
  686862
  693658
  694953
  695737
  700724
  707196
  708292
  710253
  712053
  724888
  725231
  725442
  725448
  725467
  725476
  725477
  725513
  727491
  728243
  728523
  730902
  731073
  731083
  731276
  735924
  736797
  739767
  740115
  741073
  745374
  745495
  746594
  750430
  758097
  758307
  760973
  763182
  765554
  775042
  780030
  784731
  786098
  789229
  796011
  796343
  797132
  801026
  801148
  802222
  803719
  804982
  810781
  810970
  813260
  820187
]
16.50 ms
(11.27%)
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
  803719
  725448
  745374
  746594
  786098
  796343
  739767
  728243
  731276
  735924
  741073
  789229
  444819
  465921
  396408
  432386
  433385
  473465
  515734
  505196
  618128
  432488
  428517
  820187
  450682
  460868
  479942
  521387
  539208
  555101
  707196
  663151
  665678
  682861
  695737
  546890
  590639
  634968
  600820
  612465
  636666
  620211
  810781
  775042
  802222
  725477
  725513
  727491
  797132
  813260
  725467
  763182
  725476
  745495
  758097
  758307
  603406
  624879
  433550
  477186
  432520
  432544
  433834
  515710
  510010
  420226
  471460
  489841
  453870
  456685
  495062
  503485
  540703
  531412
  535314
  560269
  579354
  581418
  545696
  564569
  569444
  708292
  693658
  694953
  700724
  686862
  710253
  712053
  545490
  548634
  565711
  585380
  621485
  625863
  619996
  610091
  597881
  617211
  626945
  796011
  801148
  804982
  780030
  801026
  810970
  725231
  725442
  731083
  740115
  784731
  730902
  728523
  736797
  760973
  731073
  765554
  724888
  750430
  601945
  623461
]
3.42 ms
(2.34%)
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
  396408
  420226
  428517
  432386
  432488
  432520
  432544
  433385
  433550
  433834
  444819
  450682
  453870
  456685
  460868
  465921
  471460
  473465
  477186
  479942
  489841
  495062
  503485
  505196
  510010
  515710
  515734
  521387
  531412
  535314
  539208
  540703
  545490
  545696
  546890
  548634
  555101
  560269
  564569
  565711
  569444
  579354
  581418
  585380
  590639
  597881
  600820
  601945
  603406
  610091
  612465
  617211
  618128
  619996
  620211
  621485
  623461
  624879
  625863
  626945
  634968
  636666
  663151
  665678
  682861
  686862
  693658
  694953
  695737
  700724
  707196
  708292
  710253
  712053
  724888
  725231
  725442
  725448
  725467
  725476
  725477
  725513
  727491
  728243
  728523
  730902
  731073
  731083
  731276
  735924
  736797
  739767
  740115
  741073
  745374
  745495
  746594
  750430
  758097
  758307
  760973
  763182
  765554
  775042
  780030
  784731
  786098
  789229
  796011
  796343
  797132
  801026
  801148
  802222
  803719
  804982
  810781
  810970
  813260
  820187
]
2.55 ms
(1.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cum pantyhose"
]
1.87 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cum pantyhose"
]
1.59 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cum pantyhose"
]

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.