GET https://search.jues.net/search/embeds?q=shared%20webcam%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
88.33 ms
(61.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
  437172
  438331
  447709
  458244
  460545
  460790
  481516
  500462
  500717
  506877
  516634
  516643
  520188
  525137
  525358
  528865
  536950
  545011
  545027
  551553
  560368
  577209
  577210
  577213
  579541
  582369
  585750
  588745
  590364
  590472
  601173
  603544
  603651
  605616
  608058
  618287
  618753
  620432
  633832
  661567
  663709
  664521
  683457
  695777
  699428
  707440
  709376
  710503
  718885
  727717
  730497
  731195
  733579
  742683
  753505
  758406
]
33.75 ms
(23.57%)
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:
[
  "shared webcam wife"
  "shared webcam wife"
  "shared webcam wife"
  20
]
9.65 ms
(6.74%)
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
  663709
  536950
  710503
  709376
  601173
  758406
  460545
  608058
  545011
  618753
  683457
  699428
  633832
  481516
  577213
  707440
  695777
  731195
  577210
  603544
  718885
  753505
  545027
  582369
  590472
  730497
  460790
  458244
  500462
  438331
  577209
  605616
  590364
  603651
  661567
  727717
  742683
  506877
  585750
  733579
  500717
  437172
  525358
  528865
  664521
  588745
  618287
  525137
  520188
  447709
  551553
  560368
  516634
  579541
  516643
  620432
]
3.53 ms
(2.46%)
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
  437172
  438331
  447709
  458244
  460545
  460790
  481516
  500462
  500717
  506877
  516634
  516643
  520188
  525137
  525358
  528865
  536950
  545011
  545027
  551553
  560368
  577209
  577210
  577213
  579541
  582369
  585750
  588745
  590364
  590472
  601173
  603544
  603651
  605616
  608058
  618287
  618753
  620432
  633832
  661567
  663709
  664521
  683457
  695777
  699428
  707440
  709376
  710503
  718885
  727717
  730497
  731195
  733579
  742683
  753505
  758406
]
2.15 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shared webcam wife"
]
1.98 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "shared вебкамер жен"
]
1.93 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "shared вебкамер жен"
]

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.