GET https://search.jues.net/search/embeds/9?q=pussy%20fuck

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.26 ms
(85.44%)
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
  151564
  276646
  388127
  398262
  402483
  411125
  422457
  441814
  450929
  455175
  469358
  476733
  481437
  501541
  512149
  518592
  544979
  555486
  557218
  559419
  567642
  569590
  571132
  586908
  588003
  589467
  594215
  595619
  604315
  608225
  610115
  613945
  614747
  624272
  626501
  631044
  634804
  634902
  659343
  664557
  665966
  672708
  674850
  679375
  684874
  689827
  695764
  696144
  697540
  700854
  700914
  708035
  708746
  709611
  711133
  712305
  712784
  714703
  715604
  716529
  722109
  724667
  726899
  728412
  729694
  731013
  731147
  735667
  737379
  738510
  741765
  743356
  743757
  743965
  745964
  746039
  747240
  749614
  752235
  753849
  753878
  757044
  757174
  759595
  762300
  765942
  767878
  771260
  777675
  778604
  778633
  778679
  779124
  780849
  781658
  782372
  784892
  785817
  786132
  787386
  791530
  792417
  792539
  794421
  795092
  797097
  800070
  801515
  803032
  803892
  805545
  807651
  809877
  810942
  812429
  812437
  813745
  815010
  820501
  827975
]
12.24 ms
(8.15%)
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
  797097
  569590
  729694
  753878
  715604
  777675
  765942
  741765
  807651
  679375
  753849
  402483
  813745
  782372
  441814
  469358
  557218
  674850
  712784
  559419
  803032
  757174
  792417
  724667
  767878
  726899
  737379
  762300
  743356
  749614
  809877
  411125
  501541
  708746
  812437
  794421
  745964
  276646
  398262
  476733
  571132
  696144
  700914
  610115
  626501
  778679
  785817
  784892
  801515
  743965
  792539
  771260
  803892
  614747
  820501
  805545
  711133
  778633
  827975
  695764
  708035
  778604
  780849
  743757
  757044
  781658
  624272
  716529
  800070
  594215
  812429
  422457
  684874
  689827
  787386
  728412
  747240
  544979
  714703
  664557
  709611
  722109
  634902
  586908
  779124
  791530
  786132
  735667
  746039
  450929
  659343
  631044
  731013
  481437
  712305
  589467
  738510
  518592
  151564
  634804
  697540
  595619
  604315
  608225
  731147
  815010
  455175
  795092
  665966
  588003
  613945
  752235
  810942
  759595
  388127
  512149
  567642
  700854
  672708
  555486
]
2.68 ms
(1.78%)
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
  151564
  276646
  388127
  398262
  402483
  411125
  422457
  441814
  450929
  455175
  469358
  476733
  481437
  501541
  512149
  518592
  544979
  555486
  557218
  559419
  567642
  569590
  571132
  586908
  588003
  589467
  594215
  595619
  604315
  608225
  610115
  613945
  614747
  624272
  626501
  631044
  634804
  634902
  659343
  664557
  665966
  672708
  674850
  679375
  684874
  689827
  695764
  696144
  697540
  700854
  700914
  708035
  708746
  709611
  711133
  712305
  712784
  714703
  715604
  716529
  722109
  724667
  726899
  728412
  729694
  731013
  731147
  735667
  737379
  738510
  741765
  743356
  743757
  743965
  745964
  746039
  747240
  749614
  752235
  753849
  753878
  757044
  757174
  759595
  762300
  765942
  767878
  771260
  777675
  778604
  778633
  778679
  779124
  780849
  781658
  782372
  784892
  785817
  786132
  787386
  791530
  792417
  792539
  794421
  795092
  797097
  800070
  801515
  803032
  803892
  805545
  807651
  809877
  810942
  812429
  812437
  813745
  815010
  820501
  827975
]
1.91 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy fuck"
]
1.75 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy секс"
]
1.71 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy секс"
]
1.58 ms
(1.05%)
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.