GET https://search.jues.net/search/embeds/4?q=amateur%20penis

Query Metrics

8 Database Queries
8 Different statements
322.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
280.54 ms
(86.96%)
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
  439785
  439786
  440016
  440726
  449125
  453409
  455337
  455503
  456603
  457432
  457440
  464487
  464542
  464835
  468592
  483639
  488061
  493176
  493181
  493191
  496069
  498816
  499072
  499098
  504670
  504742
  506142
  511631
  513536
  516682
  517769
  520492
  521534
  522679
  528262
  528269
  537991
  541928
  543048
  552570
  559477
  562853
  563161
  567901
  573953
  583099
  583139
  589590
  596294
  603407
  605693
  618718
  618861
  632794
  662376
  662378
  677108
  707740
  794963
]
18.50 ms
(5.74%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "amateur penis"
  "amateur penis"
  "amateur penis"
  20
]
13.25 ms
(4.11%)
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
  488061
  493191
  499098
  504742
  541928
  662376
  596294
  707740
  794963
  440016
  562853
  563161
  605693
  618861
  457432
  456603
  457440
  520492
  528262
  513536
  511631
  559477
  449125
  455503
  528269
  537991
  618718
  589590
  496069
  499072
  567901
  632794
  464835
  521534
  498816
  522679
  439786
  455337
  483639
  493181
  677108
  543048
  506142
  603407
  440726
  504670
  468592
  453409
  464487
  493176
  573953
  439785
  517769
  464542
  583139
  552570
  583099
  516682
  662378
]
2.57 ms
(0.80%)
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
  439785
  439786
  440016
  440726
  449125
  453409
  455337
  455503
  456603
  457432
  457440
  464487
  464542
  464835
  468592
  483639
  488061
  493176
  493181
  493191
  496069
  498816
  499072
  499098
  504670
  504742
  506142
  511631
  513536
  516682
  517769
  520492
  521534
  522679
  528262
  528269
  537991
  541928
  543048
  552570
  559477
  562853
  563161
  567901
  573953
  583099
  583139
  589590
  596294
  603407
  605693
  618718
  618861
  632794
  662376
  662378
  677108
  707740
  794963
]
2.47 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur penis"
]
2.11 ms
(0.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск penis"
]
1.66 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск penis"
]

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.