GET https://search.jues.net/search/embeds/3?q=piss%20panties

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
241.94 ms
(90.04%)
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
  428686
  499904
  528995
  541803
  542724
  545982
  546036
  548422
  548559
  548879
  550066
  551535
  554684
  554701
  554702
  554711
  554716
  554721
  554733
  555616
  556040
  558622
  558630
  562053
  562067
  563939
  565997
  569379
  570704
  571135
  571708
  573516
  574398
  577019
  578642
  578718
  580129
  584107
  584762
  585050
  585331
  585916
  586565
  597163
  607050
  607238
  607325
  612553
  614865
  615634
  618177
  618378
  621363
  623337
  623339
  626332
  629967
  633182
  633742
  637500
  639637
  641955
  642006
  642705
  646176
  646255
  649440
  650919
  651148
  662796
  664494
  666894
  678095
  680937
  681546
  683054
  692713
  692763
  710221
  710471
  715951
  724029
  725229
  728276
  729287
  734342
  737857
  738564
  740268
  748637
  748931
  748951
  748975
  749087
  751170
  751360
  751470
  754209
  755057
  757211
  760446
  768683
  776822
  778762
  784048
  784294
  795416
  799934
  800763
  802949
  809925
  811450
  811882
  812564
  819573
  825018
  825824
  826295
  826763
  827080
]
16.88 ms
(6.28%)
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
  554721
  558630
  569379
  715951
  760446
  751360
  755057
  768683
  728276
  541803
  646176
  618177
  580129
  692763
  428686
  680937
  586565
  621363
  800763
  573516
  556040
  562053
  546036
  554716
  615634
  778762
  795416
  811882
  784048
  751170
  748637
  633182
  637500
  585050
  678095
  574398
  570704
  554733
  578718
  825018
  826295
  577019
  649440
  626332
  802949
  725229
  724029
  757211
  809925
  710221
  554711
  614865
  651148
  641955
  618378
  633742
  683054
  554701
  607050
  812564
  826763
  827080
  550066
  623339
  799934
  738564
  754209
  710471
  554684
  585916
  542724
  642705
  692713
  565997
  548422
  548559
  623337
  819573
  548879
  776822
  811450
  734342
  748975
  740268
  729287
  612553
  784294
  558622
  571708
  664494
  554702
  584107
  545982
  607325
  578642
  528995
  666894
  646255
  642006
  585331
  629967
  555616
  650919
  639637
  563939
  584762
  499904
  551535
  597163
  748951
  751470
  737857
  607238
  749087
  748931
  681546
  825824
  571135
  662796
  562067
]
3.06 ms
(1.14%)
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
  428686
  499904
  528995
  541803
  542724
  545982
  546036
  548422
  548559
  548879
  550066
  551535
  554684
  554701
  554702
  554711
  554716
  554721
  554733
  555616
  556040
  558622
  558630
  562053
  562067
  563939
  565997
  569379
  570704
  571135
  571708
  573516
  574398
  577019
  578642
  578718
  580129
  584107
  584762
  585050
  585331
  585916
  586565
  597163
  607050
  607238
  607325
  612553
  614865
  615634
  618177
  618378
  621363
  623337
  623339
  626332
  629967
  633182
  633742
  637500
  639637
  641955
  642006
  642705
  646176
  646255
  649440
  650919
  651148
  662796
  664494
  666894
  678095
  680937
  681546
  683054
  692713
  692763
  710221
  710471
  715951
  724029
  725229
  728276
  729287
  734342
  737857
  738564
  740268
  748637
  748931
  748951
  748975
  749087
  751170
  751360
  751470
  754209
  755057
  757211
  760446
  768683
  776822
  778762
  784048
  784294
  795416
  799934
  800763
  802949
  809925
  811450
  811882
  812564
  819573
  825018
  825824
  826295
  826763
  827080
]
1.95 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг трусик нижн бел"
]
1.69 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss panties"
]
1.69 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг трусик нижн бел"
]
1.51 ms
(0.56%)
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.