GET https://search.jues.net/search/embeds/9?q=facial%20sperm

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.73 ms
(51.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "facial сперм"
]
181.37 ms
(43.28%)
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
  388569
  388968
  411033
  412520
  416310
  423378
  435047
  436001
  440929
  443497
  445089
  449744
  456976
  457653
  458056
  458367
  459942
  460010
  461251
  469474
  474382
  474742
  476968
  488088
  488354
  496153
  497946
  499295
  502023
  505631
  506664
  510484
  511384
  524080
  524668
  525775
  526741
  528786
  534923
  539365
  545008
  546140
  549499
  552104
  552246
  553084
  554357
  555066
  559027
  559293
  559644
  561707
  565240
  565421
  565759
  566690
  570144
  573922
  577976
  579941
  585838
  589175
  591426
  593051
  604732
  607621
  613937
  620645
  624888
  626434
  636674
  638133
  646270
  649587
  653216
  654402
  671470
  679685
  679847
  693567
  694044
  695836
  708303
  709181
  712722
  713091
  714498
  716660
  716856
  722687
  723131
  724245
  725339
  747090
  751715
  757455
  758124
  763279
  763309
  764298
  764484
  775127
  775196
  775268
  782427
  783080
  784989
  785238
  785718
  788533
  792396
  793435
  796206
  797570
  799435
  806293
  806841
  807358
  807919
  810572
]
16.02 ms
(3.82%)
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
  555066
  570144
  549499
  559027
  552246
  561707
  577976
  579941
  646270
  653216
  712722
  679685
  694044
  695836
  713091
  671470
  693567
  714498
  722687
  573922
  585838
  626434
  620645
  591426
  613937
  624888
  636674
  589175
  607621
  638133
  792396
  797570
  775196
  775268
  784989
  793435
  799435
  806841
  807358
  810572
  757455
  758124
  783080
  785238
  796206
  806293
  807919
  724245
  725339
  747090
  751715
  764484
  763279
  763309
  764298
  709181
  775127
  782427
  785718
  788533
  388569
  458056
  469474
  388968
  411033
  440929
  461251
  474742
  435047
  456976
  457653
  459942
  436001
  449744
  496153
  510484
  528786
  502023
  525775
  604732
  524080
  443497
  445089
  416310
  423378
  412520
  488088
  458367
  460010
  511384
  499295
  524668
  526741
  534923
  497946
  505631
  506664
  539365
  474382
  476968
  488354
  552104
  565759
  545008
  546140
  553084
  559293
  559644
  654402
  679847
  716856
  723131
  649587
  716660
  708303
  554357
  565240
  565421
  566690
  593051
]
3.30 ms
(0.79%)
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
  388569
  388968
  411033
  412520
  416310
  423378
  435047
  436001
  440929
  443497
  445089
  449744
  456976
  457653
  458056
  458367
  459942
  460010
  461251
  469474
  474382
  474742
  476968
  488088
  488354
  496153
  497946
  499295
  502023
  505631
  506664
  510484
  511384
  524080
  524668
  525775
  526741
  528786
  534923
  539365
  545008
  546140
  549499
  552104
  552246
  553084
  554357
  555066
  559027
  559293
  559644
  561707
  565240
  565421
  565759
  566690
  570144
  573922
  577976
  579941
  585838
  589175
  591426
  593051
  604732
  607621
  613937
  620645
  624888
  626434
  636674
  638133
  646270
  649587
  653216
  654402
  671470
  679685
  679847
  693567
  694044
  695836
  708303
  709181
  712722
  713091
  714498
  716660
  716856
  722687
  723131
  724245
  725339
  747090
  751715
  757455
  758124
  763279
  763309
  764298
  764484
  775127
  775196
  775268
  782427
  783080
  784989
  785238
  785718
  788533
  792396
  793435
  796206
  797570
  799435
  806293
  806841
  807358
  807919
  810572
]
1.65 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "facial sperm"
]
1.61 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "facial сперм"
]
1.40 ms
(0.33%)
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.