GET https://search.jues.net/search/embeds/4?q=cock%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.43 ms
(83.46%)
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
  465246
  482884
  494682
  506544
  511047
  525771
  528341
  533729
  534864
  539099
  541986
  542475
  542487
  543559
  546814
  547073
  551221
  552587
  553610
  554209
  556869
  560493
  565382
  573989
  575615
  589771
  592159
  595086
  599763
  606090
  606212
  611687
  618189
  618600
  625750
  627191
  627851
  628669
  629774
  632224
  632679
  633052
  633664
  635720
  647126
  650037
  650226
  654187
  666978
  677916
  681234
  684055
  689266
  690441
  691227
  691231
  692436
  692824
  693541
  696049
  696053
  696058
  696642
  696664
  696675
  696687
  696698
  696716
  701708
  702347
  704355
  707562
  707973
  708671
  709512
  713951
  714040
  716582
  717052
  717224
  718593
  719899
  719905
  720470
  722993
  724303
  727448
  732919
  733511
  736498
  739337
  739339
  741580
  746481
  746840
  747535
  750345
  751217
  751240
  751242
  751419
  754635
  755863
  757606
  758064
  758949
  760856
  761069
  761160
  762061
  775815
  811853
  814096
  817620
  820442
  821477
  821555
  823155
  828125
]
15.29 ms
(9.56%)
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
  707562
  546814
  554209
  632679
  592159
  739337
  727448
  751240
  762061
  732919
  553610
  746481
  677916
  599763
  739339
  525771
  708671
  511047
  533729
  528341
  547073
  719905
  556869
  713951
  542487
  606090
  758064
  757606
  611687
  618189
  506544
  539099
  820442
  821477
  811853
  746840
  750345
  543559
  565382
  482884
  575615
  666978
  684055
  696053
  696058
  696698
  709512
  696716
  722993
  696675
  701708
  702347
  707973
  716582
  720470
  606212
  589771
  633664
  625750
  618600
  627191
  629774
  736498
  741580
  733511
  751217
  754635
  751419
  761160
  633052
  696664
  696687
  718593
  541986
  681234
  691231
  693541
  647126
  690441
  691227
  692436
  717052
  632224
  747535
  761069
  534864
  573989
  696642
  717224
  650037
  635720
  751242
  758949
  769831
  627851
  775815
  628669
  719899
  828125
  814096
  817620
  823155
  760856
  465246
  595086
  724303
  494682
  821555
  654187
  704355
  755863
  542475
  552587
  551221
  560493
  650226
  689266
  692824
  696049
  714040
]
3.42 ms
(2.14%)
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
  465246
  482884
  494682
  506544
  511047
  525771
  528341
  533729
  534864
  539099
  541986
  542475
  542487
  543559
  546814
  547073
  551221
  552587
  553610
  554209
  556869
  560493
  565382
  573989
  575615
  589771
  592159
  595086
  599763
  606090
  606212
  611687
  618189
  618600
  625750
  627191
  627851
  628669
  629774
  632224
  632679
  633052
  633664
  635720
  647126
  650037
  650226
  654187
  666978
  677916
  681234
  684055
  689266
  690441
  691227
  691231
  692436
  692824
  693541
  696049
  696053
  696058
  696642
  696664
  696675
  696687
  696698
  696716
  701708
  702347
  704355
  707562
  707973
  708671
  709512
  713951
  714040
  716582
  717052
  717224
  718593
  719899
  719905
  720470
  722993
  724303
  727448
  732919
  733511
  736498
  739337
  739339
  741580
  746481
  746840
  747535
  750345
  751217
  751240
  751242
  751419
  754635
  755863
  757606
  758064
  758949
  760856
  761069
  761160
  762061
  775815
  811853
  814096
  817620
  820442
  821477
  821555
  823155
  828125
]
2.27 ms
(1.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock public"
]
1.86 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock на улиц"
]
1.65 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock на улиц"
]

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.