GET https://search.jues.net/search/embeds/6?q=public%20standing%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.73 ms
(87.53%)
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
  383110
  393274
  394297
  395332
  395803
  398902
  400677
  407120
  407487
  409984
  417709
  436828
  439829
  440667
  456125
  460395
  460895
  463115
  464570
  466531
  467782
  476862
  488851
  504660
  506555
  516692
  518309
  519401
  522857
  525481
  525734
  527481
  541071
  545798
  546825
  547992
  550107
  550123
  550941
  559655
  562927
  563336
  563408
  569538
  571725
  572951
  580990
  581028
  588549
  590606
  592851
  604099
  606408
  608926
  614455
  615466
  626351
  627141
  630399
  630879
  632054
  638971
  639218
  644850
  644854
  649024
  650037
  651865
  662097
  663893
  666978
  677626
  689143
  689296
  691240
  691603
  692824
  693270
  695646
  695682
  701604
  701623
  701644
  705433
  711548
  713145
  724039
  728188
  729564
  733511
  734372
  736498
  739151
  742126
  744933
  750686
  752625
  754635
  755737
  763932
  764879
  768765
  769118
  773620
  774033
  778925
  779852
  780828
  785454
  785515
  787458
  787558
  789033
  798918
  798975
  805229
  816187
  817981
  820475
]
13.59 ms
(7.35%)
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
  691603
  742126
  604099
  695682
  693270
  519401
  729564
  550107
  733511
  754635
  736498
  752625
  666978
  677626
  639218
  592851
  689143
  780828
  527481
  816187
  525481
  394297
  541071
  638971
  630399
  650037
  692824
  590606
  768765
  785454
  630879
  608926
  407120
  627141
  651865
  798975
  606408
  739151
  705433
  417709
  546825
  572951
  632054
  787458
  817981
  464570
  562927
  711548
  734372
  393274
  701623
  701644
  644850
  769118
  525734
  663893
  547992
  785515
  787558
  559655
  774033
  546559
  713145
  744933
  763932
  506555
  383110
  466531
  563336
  805229
  779852
  436828
  400677
  439829
  467782
  476862
  649024
  460895
  662097
  614455
  701604
  563408
  778925
  789033
  764879
  820475
  755737
  728188
  644854
  488851
  545798
  550123
  407487
  456125
  550941
  615466
  398902
  691240
  689296
  516692
  518309
  440667
  580990
  773620
  695646
  724039
  581028
  798918
  588549
  522857
  569538
  460395
  504660
  463115
  626351
  409984
  750686
  571725
  395332
  395803
]
2.36 ms
(1.28%)
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
  383110
  393274
  394297
  395332
  395803
  398902
  400677
  407120
  407487
  409984
  417709
  436828
  439829
  440667
  456125
  460395
  460895
  463115
  464570
  466531
  467782
  476862
  488851
  504660
  506555
  516692
  518309
  519401
  522857
  525481
  525734
  527481
  541071
  545798
  546825
  547992
  550107
  550123
  550941
  559655
  562927
  563336
  563408
  569538
  571725
  572951
  580990
  581028
  588549
  590606
  592851
  604099
  606408
  608926
  614455
  615466
  626351
  627141
  630399
  630879
  632054
  638971
  639218
  644850
  644854
  649024
  650037
  651865
  662097
  663893
  666978
  677626
  689143
  689296
  691240
  691603
  692824
  693270
  695646
  695682
  701604
  701623
  701644
  705433
  711548
  713145
  724039
  728188
  729564
  733511
  734372
  736498
  739151
  742126
  744933
  750686
  752625
  754635
  755737
  763932
  764879
  768765
  769118
  773620
  774033
  778925
  779852
  780828
  785454
  785515
  787458
  787558
  789033
  798918
  798975
  805229
  816187
  817981
  820475
]
2.11 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public standing sex"
]
1.95 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на standing улиц секс"
]
1.43 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на standing улиц секс"
]

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.