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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
85.60 ms
(60.56%)
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
  458608
  461456
  493192
  498022
  503453
  506133
  508145
  509997
  510481
  511359
  514772
  517175
  517217
  523021
  526267
  526951
  529342
  529383
  532643
  539288
  541393
  548254
  548574
  554758
  560301
  562790
  563553
  566862
  566925
  567127
  569047
  578406
  580262
  583722
  585969
  585999
  588934
  590398
  591341
  592005
  594518
  595507
  596526
  597070
  597490
  598494
  600531
  601677
  603011
  614441
  615746
  621125
  623291
  624165
  624847
  628069
  649134
  662382
  668653
  677125
  680207
  814175
]
34.14 ms
(24.15%)
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 ass"
  "finger teen ass"
  "finger teen ass"
  20
]
12.33 ms
(8.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
  541393
  566862
  560301
  554758
  590398
  623291
  594518
  526951
  529342
  578406
  677125
  628069
  585999
  680207
  506133
  511359
  591341
  615746
  526267
  566925
  548574
  583722
  508145
  567127
  493192
  548254
  461456
  588934
  597490
  509997
  592005
  598494
  458608
  529383
  563553
  814175
  569047
  668653
  585969
  614441
  514772
  523021
  662382
  517217
  580262
  510481
  539288
  517175
  532643
  624165
  498022
  503453
  562790
  600531
  649134
  596526
  603011
  601677
  597070
  595507
  624847
  621125
]
2.28 ms
(1.61%)
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
  458608
  461456
  493192
  498022
  503453
  506133
  508145
  509997
  510481
  511359
  514772
  517175
  517217
  523021
  526267
  526951
  529342
  529383
  532643
  539288
  541393
  548254
  548574
  554758
  560301
  562790
  563553
  566862
  566925
  567127
  569047
  578406
  580262
  583722
  585969
  585999
  588934
  590398
  591341
  592005
  594518
  595507
  596526
  597070
  597490
  598494
  600531
  601677
  603011
  614441
  615746
  621125
  623291
  624165
  624847
  628069
  649134
  662382
  668653
  677125
  680207
  814175
]
2.17 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "finger teen ass"
]
1.85 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "палец teen жоп"
]
1.50 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "палец teen жоп"
]

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.