GET https://search.jues.net/search/embeds/2?q=stockings%20suck%20cock

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
93.05 ms
(73.11%)
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
  389921
  398224
  411105
  421604
  424060
  428771
  444400
  449784
  451492
  455151
  455206
  455861
  460370
  464532
  465927
  470543
  471890
  474874
  481359
  482916
  485084
  485985
  486199
  487052
  487577
  489060
  489239
  491839
  504250
  507533
  510690
  512910
  513325
  513825
  514079
  518818
  520954
  522463
  523189
  528443
  528645
  532504
  546933
  552353
  562777
  566740
  569603
  577323
  580958
  583997
  601231
  601853
  610564
  616205
  617021
  624875
  624921
  625631
  625888
  627074
  631968
  632055
  721512
  734481
]
12.43 ms
(9.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:
[
  "stockings suck cock"
  "stockings suck cock"
  "stockings suck cock"
  20
]
11.88 ms
(9.33%)
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
  512910
  507533
  487577
  489060
  513825
  624875
  721512
  528645
  624921
  532504
  428771
  528443
  464532
  566740
  625631
  625888
  398224
  411105
  485084
  487052
  486199
  522463
  460370
  632055
  546933
  552353
  569603
  610564
  734481
  513325
  491839
  510690
  577323
  489239
  520954
  627074
  471890
  481359
  504250
  444400
  474874
  583997
  523189
  580958
  617021
  455861
  485985
  518818
  451492
  562777
  389921
  514079
  601853
  421604
  424060
  455151
  601231
  449784
  455206
  616205
  470543
  631968
  465927
  482916
]
2.80 ms
(2.20%)
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
  389921
  398224
  411105
  421604
  424060
  428771
  444400
  449784
  451492
  455151
  455206
  455861
  460370
  464532
  465927
  470543
  471890
  474874
  481359
  482916
  485084
  485985
  486199
  487052
  487577
  489060
  489239
  491839
  504250
  507533
  510690
  512910
  513325
  513825
  514079
  518818
  520954
  522463
  523189
  528443
  528645
  532504
  546933
  552353
  562777
  566740
  569603
  577323
  580958
  583997
  601231
  601853
  610564
  616205
  617021
  624875
  624921
  625631
  625888
  627074
  631968
  632055
  721512
  734481
]
2.10 ms
(1.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings suck cock"
]
1.87 ms
(1.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел suck cock"
]
1.37 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чулк нижн бел suck 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.