GET https://search.jues.net/search/embeds/4?q=sperm%20out

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.26 ms
(82.00%)
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
  384857
  392477
  452743
  456022
  467028
  469978
  516016
  522700
  525917
  529329
  538619
  542976
  545957
  551145
  558576
  561460
  565789
  565881
  574444
  578738
  593147
  593179
  598632
  605765
  607589
  610393
  615759
  617625
  618506
  631479
  633479
  638117
  651231
  651926
  653388
  664215
  667805
  670904
  671499
  671569
  682951
  700201
  702223
  703684
  707145
  707446
  707572
  716180
  722060
  722088
  724168
  727101
  729036
  729316
  731197
  733555
  735528
  736483
  737144
  740093
  740879
  742149
  746070
  747858
  750613
  757328
  757631
  759180
  759747
  761889
  765083
  767391
  767810
  768928
  768997
  769828
  772421
  772516
  776106
  778461
  780630
  781840
  785246
  786754
  786851
  786937
  787851
  790632
  791222
  791250
  794143
  795521
  799774
  801028
  801183
  802078
  802402
  802756
  803212
  804030
  805094
  805672
  809322
  809743
  811289
  811956
  812980
  813077
  816622
  818666
  819431
  819708
  820987
  822231
  822846
  825016
  825103
  826557
  828453
]
15.88 ms
(10.48%)
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
  787851
  746070
  761889
  757631
  384857
  826557
  818666
  822846
  825016
  819431
  828453
  467028
  469978
  538619
  522700
  565789
  682951
  667805
  716180
  598632
  631479
  610393
  615759
  593179
  618506
  780630
  791222
  794143
  802402
  809322
  811289
  802078
  805672
  724168
  747858
  769828
  799774
  803212
  811956
  767391
  729316
  731197
  737144
  759180
  757328
  772516
  727101
  768997
  702223
  703684
  722060
  529329
  574444
  542976
  578738
  653388
  633479
  776106
  801028
  785246
  786851
  729036
  763699
  768928
  700201
  786754
  801183
  812980
  452743
  558576
  651231
  670904
  671499
  722088
  593147
  790632
  735528
  765083
  767810
  772421
  809743
  813077
  733555
  759747
  736483
  638117
  802756
  525917
  456022
  545957
  651926
  565881
  791250
  740093
  740879
  742149
  392477
  816622
  819708
  825103
  820987
  822231
  516016
  561460
  551145
  707446
  664215
  671569
  707145
  707572
  605765
  607589
  617625
  778461
  786937
  804030
  781840
  805094
  750613
  795521
]
2.91 ms
(1.92%)
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
  384857
  392477
  452743
  456022
  467028
  469978
  516016
  522700
  525917
  529329
  538619
  542976
  545957
  551145
  558576
  561460
  565789
  565881
  574444
  578738
  593147
  593179
  598632
  605765
  607589
  610393
  615759
  617625
  618506
  631479
  633479
  638117
  651231
  651926
  653388
  664215
  667805
  670904
  671499
  671569
  682951
  700201
  702223
  703684
  707145
  707446
  707572
  716180
  722060
  722088
  724168
  727101
  729036
  729316
  731197
  733555
  735528
  736483
  737144
  740093
  740879
  742149
  746070
  747858
  750613
  757328
  757631
  759180
  759747
  761889
  765083
  767391
  767810
  768928
  768997
  769828
  772421
  772516
  776106
  778461
  780630
  781840
  785246
  786754
  786851
  786937
  787851
  790632
  791222
  791250
  794143
  795521
  799774
  801028
  801183
  802078
  802402
  802756
  803212
  804030
  805094
  805672
  809322
  809743
  811289
  811956
  812980
  813077
  816622
  818666
  819431
  819708
  820987
  822231
  822846
  825016
  825103
  826557
  828453
]
2.34 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм out"
]
2.10 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm out"
]
2.00 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм out"
]

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.