GET https://search.jues.net/search/embeds/2?q=touch%20teen%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
86.51 ms
(53.64%)
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
  395620
  406059
  430314
  442841
  443550
  446738
  449859
  451945
  457751
  458608
  485204
  485454
  487726
  488736
  489431
  489893
  492073
  493192
  495163
  500694
  501120
  508168
  512659
  515231
  518290
  519248
  521412
  521526
  522307
  522403
  523260
  523802
  523811
  524203
  526601
  527387
  529383
  529565
  530762
  536835
  551921
  556741
  559124
  560189
  561944
  562758
  562790
  564519
  565170
  565471
  565659
  569830
  576338
  578497
  579179
  582371
  585999
  588376
  595507
  596871
  598806
  600069
  610588
  613014
  614441
  619439
  653266
  677002
  681691
  682545
  688581
]
49.14 ms
(30.47%)
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:
[
  "touch teen pussy"
  "touch teen pussy"
  "touch teen pussy"
  20
]
15.88 ms
(9.85%)
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
  523802
  488736
  492073
  449859
  457751
  489431
  523811
  526601
  529565
  508168
  518290
  536835
  579179
  582371
  564519
  576338
  578497
  551921
  588376
  487726
  565471
  395620
  501120
  515231
  524203
  561944
  565659
  688581
  559124
  565170
  585999
  614441
  443550
  495163
  500694
  512659
  562758
  529383
  521412
  522307
  527387
  519248
  569830
  677002
  406059
  430314
  442841
  598806
  446738
  521526
  493192
  681691
  682545
  596871
  619439
  451945
  458608
  523260
  600069
  560189
  556741
  610588
  489893
  485454
  530762
  562790
  653266
  595507
  613014
  522403
  485204
]
2.71 ms
(1.68%)
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
  395620
  406059
  430314
  442841
  443550
  446738
  449859
  451945
  457751
  458608
  485204
  485454
  487726
  488736
  489431
  489893
  492073
  493192
  495163
  500694
  501120
  508168
  512659
  515231
  518290
  519248
  521412
  521526
  522307
  522403
  523260
  523802
  523811
  524203
  526601
  527387
  529383
  529565
  530762
  536835
  551921
  556741
  559124
  560189
  561944
  562758
  562790
  564519
  565170
  565471
  565659
  569830
  576338
  578497
  579179
  582371
  585999
  588376
  595507
  596871
  598806
  600069
  610588
  613014
  614441
  619439
  653266
  677002
  681691
  682545
  688581
]
2.04 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "touch teen pussy"
]
1.73 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трога teen pussy"
]
1.63 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трога teen pussy"
]

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.