GET https://search.jues.net/search/embeds/4?q=finger%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.46 ms
(57.70%)
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
  406042
  458608
  461456
  469762
  493192
  498022
  503453
  506133
  509997
  510481
  511359
  514772
  516602
  517175
  517217
  523021
  529383
  530948
  532643
  539288
  547241
  548254
  551913
  562790
  563553
  568007
  580262
  585969
  585999
  588934
  590460
  591341
  592005
  595507
  596526
  597070
  598199
  598494
  600531
  601677
  603011
  610314
  613489
  614441
  614867
  615746
  621125
  624165
  624847
  628069
  649134
  662382
]
28.20 ms
(23.77%)
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:
[
  "finger teen"
  "finger teen"
  "finger teen"
  20
]
11.84 ms
(9.98%)
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
  628069
  585969
  585999
  614441
  506133
  529383
  516602
  511359
  517217
  563553
  580262
  548254
  568007
  590460
  591341
  614867
  613489
  615746
  461456
  406042
  498022
  503453
  514772
  523021
  509997
  493192
  662382
  588934
  592005
  610314
  598494
  458608
  539288
  517175
  649134
  596526
  603011
  532643
  547241
  600531
  601677
  597070
  598199
  624165
  469762
  510481
  530948
  562790
  551913
  595507
  624847
  621125
]
2.51 ms
(2.12%)
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
  406042
  458608
  461456
  469762
  493192
  498022
  503453
  506133
  509997
  510481
  511359
  514772
  516602
  517175
  517217
  523021
  529383
  530948
  532643
  539288
  547241
  548254
  551913
  562790
  563553
  568007
  580262
  585969
  585999
  588934
  590460
  591341
  592005
  595507
  596526
  597070
  598199
  598494
  600531
  601677
  603011
  610314
  613489
  614441
  614867
  615746
  621125
  624165
  624847
  628069
  649134
  662382
]
2.24 ms
(1.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "finger teen"
]
2.03 ms
(1.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "палец teen"
]
1.76 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "палец teen"
]
1.61 ms
(1.35%)
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.