GET https://search.jues.net/search/embeds/7?q=sperm%20in%20mouth

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.25 ms
(81.65%)
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
  3100
  260350
  386731
  394161
  396302
  398331
  418430
  439184
  553679
  614900
  671472
  697613
  697723
  698608
  707516
  714168
  715655
  717181
  718461
  720137
  724729
  725789
  726408
  728857
  729860
  730039
  733356
  734473
  735943
  736284
  739411
  739989
  741863
  742750
  744221
  746139
  749168
  749171
  750711
  757311
  757634
  757744
  758225
  759388
  759674
  759688
  761021
  761437
  761458
  762193
  762306
  762499
  763701
  763873
  764068
  764615
  764691
  764950
  767399
  767402
  767663
  767713
  767748
  769429
  772290
  772343
  772353
  772368
  777175
  777521
  777539
  778554
  779165
  779797
  781297
  781571
  783078
  786684
  787231
  787233
  787249
  787658
  790706
  791828
  793751
  794264
  794758
  795603
  796010
  796013
  796022
  796024
  796172
  797903
  800751
  803419
  804910
  805626
  810179
  810344
  813981
  814668
  816128
  816653
  817993
  819365
  819720
  819794
  820196
  824018
  825020
  825081
  825145
  825174
  825305
  825381
  825641
]
17.88 ms
(11.38%)
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
  804910
  810344
  725789
  729860
  733356
  739411
  739989
  744221
  749168
  757311
  762499
  763873
  764950
  767402
  772368
  781297
  781571
  783078
  787249
  787658
  794758
  796010
  796013
  796172
  797903
  734473
  735943
  757744
  759388
  762193
  767713
  767748
  769429
  724729
  726408
  746139
  762306
  764068
  764537
  741863
  749171
  757634
  759688
  762511
  767663
  772290
  728857
  736284
  742750
  759674
  761021
  761437
  761458
  763701
  764615
  764691
  614900
  620715
  697613
  697723
  698608
  707516
  714168
  715655
  717181
  777521
  777539
  778554
  779165
  779797
  787231
  787233
  791828
  795603
  800751
  803419
  418430
  3100
  398331
  439184
  553679
  671472
  720137
  718461
  796022
  796024
  786684
  730039
  772343
  805626
  810179
  758225
  777175
  793751
  794264
  386731
  790706
  750711
  767399
  772353
  394161
  260350
  396302
  813981
  814668
  816128
  817993
  819720
  824018
  825020
  825081
  825174
  825641
  816653
  819365
  819794
  820196
  825145
  825305
  825381
]
3.50 ms
(2.23%)
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
  3100
  260350
  386731
  394161
  396302
  398331
  418430
  439184
  553679
  614900
  671472
  697613
  697723
  698608
  707516
  714168
  715655
  717181
  718461
  720137
  724729
  725789
  726408
  728857
  729860
  730039
  733356
  734473
  735943
  736284
  739411
  739989
  741863
  742750
  744221
  746139
  749168
  749171
  750711
  757311
  757634
  757744
  758225
  759388
  759674
  759688
  761021
  761437
  761458
  762193
  762306
  762499
  763701
  763873
  764068
  764615
  764691
  764950
  767399
  767402
  767663
  767713
  767748
  769429
  772290
  772343
  772353
  772368
  777175
  777521
  777539
  778554
  779165
  779797
  781297
  781571
  783078
  786684
  787231
  787233
  787249
  787658
  790706
  791828
  793751
  794264
  794758
  795603
  796010
  796013
  796022
  796024
  796172
  797903
  800751
  803419
  804910
  805626
  810179
  810344
  813981
  814668
  816128
  816653
  817993
  819365
  819720
  819794
  820196
  824018
  825020
  825081
  825145
  825174
  825305
  825381
  825641
]
2.29 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm in mouth"
]
1.91 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм mouth"
]
1.61 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм mouth"
]

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.