GET https://search.jues.net/search/embeds/7?q=dildo%20girl%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.80 ms
(85.99%)
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
  154491
  382670
  394574
  398376
  403896
  410694
  412721
  414253
  416175
  416707
  421993
  437723
  439392
  444531
  444967
  447158
  449970
  468670
  471130
  474596
  493861
  494293
  496714
  505093
  511407
  511858
  512852
  513830
  514083
  514117
  515423
  516676
  522174
  522639
  524215
  524964
  529634
  531347
  531834
  532639
  536551
  540868
  556139
  569610
  573283
  584031
  592773
  593039
  595213
  595591
  600887
  608664
  620486
  625462
  626044
  628105
  628106
  629379
  635722
  639065
  639850
  642013
  642134
  647530
  647549
  648931
  655242
  659234
  661582
  662046
  662550
  671450
  675163
  686335
  696595
  697466
  697876
  701313
  704100
  709150
  709865
  710068
  712097
  713500
  713734
  722394
  735931
  736037
  739119
  740926
  743164
  744688
  744980
  748525
  751004
  751491
  752648
  759335
  773166
  779294
  782861
  785075
  788652
  789181
  791332
  796692
  796939
  798593
  803608
  804638
  804639
  806139
  806828
  807110
  807642
  809660
  811714
  814671
  824256
  824351
]
16.11 ms
(8.72%)
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
  584031
  647530
  697466
  713500
  722394
  639850
  593039
  639065
  807110
  811714
  791332
  796692
  798593
  803608
  748525
  751491
  785075
  809660
  736037
  744980
  773166
  744688
  759335
  735931
  608664
  620486
  789181
  806139
  806828
  807642
  824351
  556139
  437723
  398376
  511858
  531347
  444967
  569610
  573283
  804638
  804639
  439392
  154491
  412721
  414253
  416175
  540868
  531834
  529634
  522639
  655242
  592773
  628105
  739119
  752648
  628106
  796939
  382670
  524215
  522174
  524964
  743164
  444531
  403896
  416707
  410694
  449970
  468670
  505093
  516676
  474596
  662046
  626044
  421993
  447158
  824256
  686335
  511407
  788652
  751004
  513830
  515423
  493861
  600887
  740926
  642013
  512852
  496714
  471130
  782861
  394574
  814671
  494293
  536551
  514083
  514117
  532639
  659234
  661582
  671450
  709150
  712097
  713734
  647549
  662550
  697876
  704100
  709865
  648931
  675163
  696595
  701313
  710068
  625462
  629379
  642134
  595591
  595213
  635722
  779294
]
3.04 ms
(1.65%)
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
  154491
  382670
  394574
  398376
  403896
  410694
  412721
  414253
  416175
  416707
  421993
  437723
  439392
  444531
  444967
  447158
  449970
  468670
  471130
  474596
  493861
  494293
  496714
  505093
  511407
  511858
  512852
  513830
  514083
  514117
  515423
  516676
  522174
  522639
  524215
  524964
  529634
  531347
  531834
  532639
  536551
  540868
  556139
  569610
  573283
  584031
  592773
  593039
  595213
  595591
  600887
  608664
  620486
  625462
  626044
  628105
  628106
  629379
  635722
  639065
  639850
  642013
  642134
  647530
  647549
  648931
  655242
  659234
  661582
  662046
  662550
  671450
  675163
  686335
  696595
  697466
  697876
  701313
  704100
  709150
  709865
  710068
  712097
  713500
  713734
  722394
  735931
  736037
  739119
  740926
  743164
  744688
  744980
  748525
  751004
  751491
  752648
  759335
  773166
  779294
  782861
  785075
  788652
  789181
  791332
  796692
  796939
  798593
  803608
  804638
  804639
  806139
  806828
  807110
  807642
  809660
  811714
  814671
  824256
  824351
]
2.14 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo girl solo"
]
1.65 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд девушк соло"
]
1.51 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.