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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.35 ms
(82.52%)
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
  386671
  404101
  410328
  468914
  480552
  504101
  516061
  520472
  523044
  530397
  533711
  540705
  541184
  541194
  541996
  542460
  546164
  549781
  552497
  553707
  554704
  554706
  554734
  555677
  556093
  560166
  561203
  562032
  565382
  575663
  616839
  617789
  618662
  618955
  621004
  621230
  623352
  626411
  628623
  631136
  632224
  633182
  633408
  635519
  644850
  647126
  648485
  649913
  661347
  661577
  663836
  663893
  667820
  669857
  669899
  680954
  681234
  685523
  685525
  690441
  691231
  692436
  695674
  696004
  696052
  696701
  697934
  700906
  701628
  702350
  702372
  705736
  708010
  708090
  713145
  718600
  720474
  723971
  730499
  736514
  744933
  747535
  748346
  748643
  758176
  761069
  768770
  769019
  769094
  769118
  773275
  774084
  777327
  778523
  779614
  780230
  782133
  783656
  784050
  785930
  790395
  791497
  792058
  792757
  793973
  798837
  798848
  798938
  798959
  801649
  802803
  804389
  809948
  809966
  810208
  811987
  812228
  813338
  814715
  828402
]
17.07 ms
(10.72%)
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
  541194
  542460
  561203
  702350
  702372
  708090
  635519
  790395
  798938
  812228
  783656
  813338
  774084
  730499
  618662
  798959
  633408
  530397
  565382
  552497
  553707
  556093
  661577
  626411
  801649
  793973
  802803
  768770
  769118
  778523
  792757
  644850
  814715
  540705
  504101
  523044
  560166
  562032
  555677
  685523
  695674
  649913
  663836
  663893
  696004
  696052
  701628
  718600
  616839
  631136
  623352
  780230
  723971
  736514
  748346
  696701
  708010
  777327
  386671
  404101
  533711
  549781
  575663
  546164
  685525
  669857
  669899
  700906
  713145
  720474
  697934
  628623
  617789
  618955
  779614
  792058
  810208
  785930
  791497
  804389
  769094
  798837
  798848
  809948
  744933
  769019
  758176
  748643
  621230
  633182
  782133
  809966
  811987
  468914
  681234
  691231
  648485
  647126
  690441
  692436
  632224
  747535
  761069
  480552
  554734
  554704
  828402
  410328
  516061
  520472
  541996
  554706
  541184
  705736
  661347
  667820
  680954
  621004
  784050
  773275
]
2.98 ms
(1.87%)
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
  386671
  404101
  410328
  468914
  480552
  504101
  516061
  520472
  523044
  530397
  533711
  540705
  541184
  541194
  541996
  542460
  546164
  549781
  552497
  553707
  554704
  554706
  554734
  555677
  556093
  560166
  561203
  562032
  565382
  575663
  616839
  617789
  618662
  618955
  621004
  621230
  623352
  626411
  628623
  631136
  632224
  633182
  633408
  635519
  644850
  647126
  648485
  649913
  661347
  661577
  663836
  663893
  667820
  669857
  669899
  680954
  681234
  685523
  685525
  690441
  691231
  692436
  695674
  696004
  696052
  696701
  697934
  700906
  701628
  702350
  702372
  705736
  708010
  708090
  713145
  718600
  720474
  723971
  730499
  736514
  744933
  747535
  748346
  748643
  758176
  761069
  768770
  769019
  769094
  769118
  773275
  774084
  777327
  778523
  779614
  780230
  782133
  783656
  784050
  785930
  790395
  791497
  792058
  792757
  793973
  798837
  798848
  798938
  798959
  801649
  802803
  804389
  809948
  809966
  810208
  811987
  812228
  813338
  814715
  828402
]
2.25 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public cock"
]
2.00 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на cock улиц"
]
1.80 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на cock улиц"
]
1.71 ms
(1.08%)
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.