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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.43 ms
(87.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
  231164
  385373
  421718
  425536
  446093
  453762
  464419
  469810
  476891
  478498
  485191
  521013
  537837
  540523
  543996
  556346
  556930
  591424
  591636
  597020
  605032
  607249
  613724
  619504
  624722
  632820
  639305
  644912
  650118
  652605
  654729
  656951
  657612
  658588
  658740
  659150
  659643
  660542
  661866
  662533
  664889
  666647
  667014
  669500
  669806
  671365
  674524
  675036
  681926
  689713
  691241
  697510
  702381
  706011
  706787
  717778
  719114
  719323
  720265
  720352
  723954
  728683
  730569
  731059
  733747
  734126
  734313
  735443
  737825
  738146
  738182
  738548
  738920
  742206
  743925
  744956
  745219
  745407
  745736
  745864
  746929
  747467
  748746
  748859
  752702
  753378
  753848
  759177
  763449
  767536
  768985
  789326
  789716
  789940
  793482
  802420
  804805
  809890
  813713
  815512
  816343
  816497
  817229
  817255
  817785
  817933
  817949
  819844
  819954
  820003
  820155
  820359
  820538
  820637
  820646
  820849
  820933
  823481
  827257
  828644
]
12.02 ms
(6.65%)
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
  656951
  657612
  658588
  658740
  659643
  660542
  661866
  664889
  669806
  675036
  689713
  706011
  706787
  719323
  720352
  591424
  607249
  639305
  613724
  624722
  591636
  597020
  619504
  789716
  793482
  804805
  731059
  733747
  745219
  767536
  802420
  734126
  734313
  738548
  745864
  768985
  723954
  730569
  737825
  744956
  745736
  748746
  759177
  763449
  728683
  735443
  738146
  738182
  738920
  742206
  743925
  745407
  753378
  753848
  746929
  747467
  748859
  752702
  605032
  632820
  697510
  702381
  717778
  719114
  720265
  789326
  789940
  809890
  385373
  231164
  421718
  425536
  816343
  819954
  820359
  820538
  820646
  644912
  816497
  817785
  827257
  815512
  817229
  817255
  817933
  817949
  820155
  820637
  820933
  813713
  819844
  820003
  820849
  823481
  828644
  453762
  469810
  478498
  446093
  464419
  476891
  485191
  537837
  540523
  521013
  556930
  543996
  556346
  650118
  652605
  654729
  659150
  662533
  666647
  667014
  669500
  671365
  674524
  681926
  691241
]
3.53 ms
(1.95%)
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
  231164
  385373
  421718
  425536
  446093
  453762
  464419
  469810
  476891
  478498
  485191
  521013
  537837
  540523
  543996
  556346
  556930
  591424
  591636
  597020
  605032
  607249
  613724
  619504
  624722
  632820
  639305
  644912
  650118
  652605
  654729
  656951
  657612
  658588
  658740
  659150
  659643
  660542
  661866
  662533
  664889
  666647
  667014
  669500
  669806
  671365
  674524
  675036
  681926
  689713
  691241
  697510
  702381
  706011
  706787
  717778
  719114
  719323
  720265
  720352
  723954
  728683
  730569
  731059
  733747
  734126
  734313
  735443
  737825
  738146
  738182
  738548
  738920
  742206
  743925
  744956
  745219
  745407
  745736
  745864
  746929
  747467
  748746
  748859
  752702
  753378
  753848
  759177
  763449
  767536
  768985
  789326
  789716
  789940
  793482
  802420
  804805
  809890
  813713
  815512
  816343
  816497
  817229
  817255
  817785
  817933
  817949
  819844
  819954
  820003
  820155
  820359
  820538
  820637
  820646
  820849
  820933
  823481
  827257
  828644
]
2.44 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shaving cock"
]
1.89 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "shaving cock"
]
1.86 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "shaving 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.