GET https://search.jues.net/search/embeds/8?q=public%20hard%20fuck

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.34 ms
(86.09%)
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
  32904
  391601
  391624
  397425
  398680
  416893
  417521
  417696
  420696
  420734
  420737
  421432
  434891
  437006
  437294
  437296
  439811
  440257
  442925
  443645
  447225
  453289
  453384
  453578
  454502
  455825
  456572
  456940
  458479
  458635
  459626
  459798
  464581
  464750
  466781
  468190
  471971
  472375
  476270
  478146
  478402
  478777
  480705
  482990
  487060
  487159
  487650
  487821
  488428
  488543
  488905
  489140
  490515
  491072
  492153
  493933
  494964
  495868
  496123
  496711
  496882
  497180
  499378
  501049
  503826
  504024
  504365
  506572
  506898
  510179
  514721
  520612
  522664
  523020
  523653
  526227
  526352
  527984
  528645
  529146
  548785
  549631
  550450
  552259
  552768
  553227
  553765
  555723
  560041
  563673
  564082
  565395
  568307
  569549
  570605
  575404
  576197
  577455
  579717
  582031
  583984
  586427
  588584
  589288
  589378
  589783
  598294
  602510
  651836
  667263
  668380
  668382
  675280
  681382
  690309
  694422
  756804
  787586
  788936
  810879
]
15.62 ms
(8.77%)
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
  471971
  506898
  488905
  602510
  523020
  455825
  555723
  466781
  528645
  482990
  459798
  570605
  397425
  667263
  589378
  788936
  496882
  496123
  694422
  756804
  548785
  458479
  690309
  464581
  478402
  495868
  497180
  480705
  464750
  487060
  526352
  565395
  586427
  487650
  442925
  458635
  668382
  391601
  494964
  478146
  437006
  582031
  391624
  576197
  668380
  417696
  472375
  504024
  493933
  579717
  575404
  552768
  439811
  488428
  526227
  496711
  569549
  527984
  492153
  487821
  453578
  583984
  589288
  421432
  504365
  549631
  589783
  434891
  447225
  553765
  553227
  523653
  488543
  491072
  522664
  398680
  443645
  681382
  453289
  437294
  514721
  468190
  416893
  32904
  489140
  499378
  577455
  420696
  456940
  560041
  420737
  454502
  456572
  437296
  487159
  478777
  501049
  563673
  564082
  453384
  598294
  552259
  510179
  675280
  490515
  459626
  440257
  417521
  550450
  520612
  588584
  568307
  787586
  529146
  810879
  506572
  476270
  503826
  651836
  420734
]
2.68 ms
(1.50%)
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
  32904
  391601
  391624
  397425
  398680
  416893
  417521
  417696
  420696
  420734
  420737
  421432
  434891
  437006
  437294
  437296
  439811
  440257
  442925
  443645
  447225
  453289
  453384
  453578
  454502
  455825
  456572
  456940
  458479
  458635
  459626
  459798
  464581
  464750
  466781
  468190
  471971
  472375
  476270
  478146
  478402
  478777
  480705
  482990
  487060
  487159
  487650
  487821
  488428
  488543
  488905
  489140
  490515
  491072
  492153
  493933
  494964
  495868
  496123
  496711
  496882
  497180
  499378
  501049
  503826
  504024
  504365
  506572
  506898
  510179
  514721
  520612
  522664
  523020
  523653
  526227
  526352
  527984
  528645
  529146
  548785
  549631
  550450
  552259
  552768
  553227
  553765
  555723
  560041
  563673
  564082
  565395
  568307
  569549
  570605
  575404
  576197
  577455
  579717
  582031
  583984
  586427
  588584
  589288
  589378
  589783
  598294
  602510
  651836
  667263
  668380
  668382
  675280
  681382
  690309
  694422
  756804
  787586
  788936
  810879
]
1.84 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public hard fuck"
]
1.64 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на hard улиц секс"
]
1.54 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на hard улиц секс"
]

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.