GET https://search.jues.net/search/embeds/8?q=sperm%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.33 ms
(80.26%)
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
  407120
  412907
  413262
  416783
  428383
  428443
  440747
  456590
  457073
  457796
  465294
  469682
  470224
  476513
  478282
  479942
  487821
  489779
  504557
  512350
  514700
  514953
  516995
  519600
  521447
  525422
  526227
  530264
  531384
  533179
  539290
  551227
  551562
  554065
  554740
  555203
  558531
  559324
  559615
  560272
  561629
  565826
  568663
  575278
  576751
  579051
  579717
  580990
  582008
  587739
  587919
  589358
  597169
  601830
  601945
  601990
  606792
  610023
  611573
  622472
  623706
  625754
  627141
  629274
  638502
  651657
  662169
  664630
  666001
  667230
  671913
  682625
  685527
  697150
  705433
  714032
  714065
  717992
  719277
  723148
  723954
  724405
  725467
  729926
  734084
  734224
  742710
  747546
  748145
  758945
  760842
  760932
  761143
  761216
  763932
  764381
  764385
  767384
  768013
  768985
  769004
  773620
  774050
  777536
  778989
  780458
  782107
  784252
  785526
  785906
  787444
  789045
  791101
  792035
  799297
  799329
  801778
  810940
  818983
  823642
]
21.49 ms
(12.84%)
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
  760842
  764381
  747546
  748145
  627141
  629274
  705433
  789045
  412907
  407120
  457796
  601990
  428443
  666001
  651657
  717992
  582008
  625754
  792035
  785906
  787444
  764385
  714065
  782107
  531384
  610023
  760932
  576751
  554740
  587919
  440747
  516995
  521447
  561629
  589358
  606792
  763932
  526227
  559324
  579717
  560272
  714032
  671913
  723148
  780458
  758945
  823642
  818983
  530264
  539290
  579051
  587739
  734224
  742710
  734084
  768985
  723954
  801778
  810940
  479942
  554065
  697150
  662169
  767384
  799297
  725467
  761143
  769004
  512350
  413262
  428383
  457073
  456590
  514700
  533179
  565826
  568663
  682625
  667230
  685527
  664630
  558531
  559615
  575278
  597169
  601830
  623706
  638502
  784252
  729926
  774050
  622472
  719277
  799329
  469682
  519600
  504557
  489779
  514953
  580990
  778989
  777536
  791101
  761216
  773620
  785526
  487821
  416783
  470224
  478282
  476513
  551562
  551227
  555203
  611573
  724405
  768013
  601945
  465294
  525422
]
3.61 ms
(2.16%)
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
  407120
  412907
  413262
  416783
  428383
  428443
  440747
  456590
  457073
  457796
  465294
  469682
  470224
  476513
  478282
  479942
  487821
  489779
  504557
  512350
  514700
  514953
  516995
  519600
  521447
  525422
  526227
  530264
  531384
  533179
  539290
  551227
  551562
  554065
  554740
  555203
  558531
  559324
  559615
  560272
  561629
  565826
  568663
  575278
  576751
  579051
  579717
  580990
  582008
  587739
  587919
  589358
  597169
  601830
  601945
  601990
  606792
  610023
  611573
  622472
  623706
  625754
  627141
  629274
  638502
  651657
  662169
  664630
  666001
  667230
  671913
  682625
  685527
  697150
  705433
  714032
  714065
  717992
  719277
  723148
  723954
  724405
  725467
  729926
  734084
  734224
  742710
  747546
  748145
  758945
  760842
  760932
  761143
  761216
  763932
  764381
  764385
  767384
  768013
  768985
  769004
  773620
  774050
  777536
  778989
  780458
  782107
  784252
  785526
  785906
  787444
  789045
  791101
  792035
  799297
  799329
  801778
  810940
  818983
  823642
]
2.12 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.07 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm public"
]
1.99 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм на улиц"
]
1.76 ms
(1.05%)
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.