GET https://search.jues.net/search/embeds/5?q=pussy%20sweet

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.43 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
  12066
  185377
  390214
  414220
  420717
  426176
  446036
  447483
  452220
  456774
  458090
  462778
  469435
  472983
  482052
  484173
  485262
  493858
  494663
  496705
  502751
  530426
  532661
  532662
  533750
  536110
  545731
  562381
  563274
  564625
  573343
  575443
  576037
  585896
  589746
  591664
  594420
  594935
  595938
  596404
  601847
  604084
  604137
  605930
  608467
  609925
  614747
  615995
  617422
  620547
  620880
  623238
  624285
  625901
  627636
  632296
  648229
  649226
  649832
  650348
  654208
  655359
  669859
  669886
  672890
  677011
  678807
  679713
  680677
  682763
  684898
  687282
  692669
  693012
  693906
  696123
  699556
  702006
  706077
  711637
  712085
  712533
  718955
  719210
  721736
  722706
  723008
  736664
  736973
  737662
  740503
  740848
  742928
  744871
  751373
  753866
  754086
  757320
  759565
  773044
  775780
  777721
  777827
  778588
  780867
  786729
  790264
  792309
  794015
  794811
  795397
  799367
  799980
  801669
  803090
  809125
  813291
  814350
  815846
  821554
]
12.00 ms
(8.11%)
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
  484173
  614747
  617422
  462778
  485262
  502751
  562381
  575443
  576037
  679713
  722706
  591664
  595938
  594420
  623238
  775780
  625901
  723008
  472983
  426176
  446036
  414220
  447483
  821554
  814350
  815846
  456774
  469435
  536110
  533750
  530426
  573343
  702006
  711637
  718955
  721736
  648229
  650348
  669859
  669886
  672890
  677011
  680677
  699556
  706077
  712085
  654208
  684898
  687282
  693012
  693906
  719210
  585896
  605930
  589746
  594935
  627636
  601847
  632296
  777827
  777721
  778588
  790264
  794811
  799367
  742928
  757320
  736664
  737662
  740503
  744871
  753866
  754086
  773044
  751373
  712533
  786729
  803090
  813291
  452220
  493858
  496705
  532662
  532661
  185377
  12066
  390214
  420717
  458090
  482052
  494663
  545731
  564625
  649226
  649832
  655359
  682763
  678807
  692669
  696123
  563274
  596404
  620547
  624285
  620880
  604084
  604137
  608467
  609925
  615995
  795397
  799980
  801669
  809125
  780867
  792309
  794015
  736973
  740848
  759565
]
2.72 ms
(1.84%)
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
  12066
  185377
  390214
  414220
  420717
  426176
  446036
  447483
  452220
  456774
  458090
  462778
  469435
  472983
  482052
  484173
  485262
  493858
  494663
  496705
  502751
  530426
  532661
  532662
  533750
  536110
  545731
  562381
  563274
  564625
  573343
  575443
  576037
  585896
  589746
  591664
  594420
  594935
  595938
  596404
  601847
  604084
  604137
  605930
  608467
  609925
  614747
  615995
  617422
  620547
  620880
  623238
  624285
  625901
  627636
  632296
  648229
  649226
  649832
  650348
  654208
  655359
  669859
  669886
  672890
  677011
  678807
  679713
  680677
  682763
  684898
  687282
  692669
  693012
  693906
  696123
  699556
  702006
  706077
  711637
  712085
  712533
  718955
  719210
  721736
  722706
  723008
  736664
  736973
  737662
  740503
  740848
  742928
  744871
  751373
  753866
  754086
  757320
  759565
  773044
  775780
  777721
  777827
  778588
  780867
  786729
  790264
  792309
  794015
  794811
  795397
  799367
  799980
  801669
  803090
  809125
  813291
  814350
  815846
  821554
]
1.99 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy sweet"
]
1.73 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy милая"
]
1.65 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy милая"
]

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.