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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.25 ms
(84.10%)
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
  397780
  460395
  463115
  476971
  485158
  487872
  489361
  493314
  501039
  508648
  510145
  514719
  522857
  525642
  526136
  532189
  532286
  532807
  534862
  542621
  543683
  549471
  550483
  551590
  559655
  564860
  567164
  569530
  575257
  576740
  580721
  584014
  591888
  592487
  592971
  595029
  600499
  601900
  604099
  606265
  608151
  609653
  609918
  612007
  612990
  613579
  615184
  618967
  623450
  630450
  631879
  632065
  636151
  638517
  642482
  643668
  644706
  645023
  648905
  649863
  649866
  651916
  660279
  661004
  662861
  673100
  673829
  683570
  689143
  691223
  691267
  691603
  692413
  693174
  694124
  695968
  696044
  696046
  696613
  698171
  702506
  708170
  709333
  711320
  725782
  729333
  730959
  731711
  732931
  734895
  736485
  737569
  738414
  739263
  740697
  745078
  748126
  771647
  779141
  779634
  780171
  787475
  788836
  819514
  820426
  820532
  820536
  820960
  821072
  821215
  821525
  821635
  821740
  821742
  822193
  822668
  823801
  824539
  828249
  828593
]
13.11 ms
(9.32%)
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
  609918
  711320
  651916
  592487
  485158
  643668
  595029
  508648
  476971
  569530
  660279
  584014
  609653
  702506
  489361
  592971
  820426
  820532
  820536
  820960
  821215
  822193
  822668
  821525
  821740
  821742
  821072
  510145
  532189
  525642
  542621
  543683
  645023
  691603
  693174
  691267
  692413
  694124
  649866
  691223
  696613
  608151
  615184
  636151
  631879
  612990
  630450
  642482
  788836
  779141
  779634
  739263
  736485
  729333
  748126
  725782
  731711
  604099
  623450
  780171
  601900
  526136
  532807
  576740
  550483
  567164
  683570
  689143
  698171
  708170
  606265
  638517
  644706
  632065
  787475
  738414
  734895
  740697
  819514
  828593
  673100
  730959
  580721
  709333
  534862
  564860
  487872
  575257
  559655
  737569
  661004
  549471
  745078
  821635
  824539
  823801
  828249
  600499
  612007
  732931
  648905
  551590
  771647
  397780
  463115
  493314
  514719
  522857
  532286
  501039
  460395
  673829
  696046
  662861
  695968
  649863
  696044
  613579
  591888
  618967
]
2.31 ms
(1.64%)
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
  397780
  460395
  463115
  476971
  485158
  487872
  489361
  493314
  501039
  508648
  510145
  514719
  522857
  525642
  526136
  532189
  532286
  532807
  534862
  542621
  543683
  549471
  550483
  551590
  559655
  564860
  567164
  569530
  575257
  576740
  580721
  584014
  591888
  592487
  592971
  595029
  600499
  601900
  604099
  606265
  608151
  609653
  609918
  612007
  612990
  613579
  615184
  618967
  623450
  630450
  631879
  632065
  636151
  638517
  642482
  643668
  644706
  645023
  648905
  649863
  649866
  651916
  660279
  661004
  662861
  673100
  673829
  683570
  689143
  691223
  691267
  691603
  692413
  693174
  694124
  695968
  696044
  696046
  696613
  698171
  702506
  708170
  709333
  711320
  725782
  729333
  730959
  731711
  732931
  734895
  736485
  737569
  738414
  739263
  740697
  745078
  748126
  771647
  779141
  779634
  780171
  787475
  788836
  819514
  820426
  820532
  820536
  820960
  821072
  821215
  821525
  821635
  821740
  821742
  822193
  822668
  823801
  824539
  828249
  828593
]
2.14 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock in public"
]
1.75 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock на улиц"
]
1.38 ms
(0.98%)
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.