GET https://search.jues.net/search/embeds/6?q=hairy%20pussy%20facesitting

Query Metrics

7 Database Queries
7 Different statements
164.52 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
131.99 ms
(80.23%)
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
  383597
  397530
  400196
  402001
  404292
  406206
  411201
  411790
  412363
  412433
  416364
  417631
  418833
  419882
  420223
  421219
  421318
  424443
  425027
  425028
  426409
  428451
  428477
  429985
  430630
  431117
  434282
  434723
  442726
  442946
  442994
  443704
  443737
  443796
  443819
  444238
  446718
  447890
  448793
  448798
  448842
  449880
  449886
  449914
  450318
  452080
  454267
  454658
  456615
  462483
  463098
  464935
  465307
  468754
  469017
  470254
  471443
  471848
  473037
  474745
  476123
  477200
  478877
  480429
  481581
  482367
  483152
  484377
  484914
  485749
  491478
  492336
  497337
  497889
  513189
  514587
  518931
  519226
  519903
  522883
  524895
  525349
  527428
  530833
  530884
  535021
  541373
  541602
  550960
  562106
  563079
  565539
  577366
  581300
  582617
  586805
  587098
  591369
  596534
  598225
  606738
  607293
  607637
  610247
  611241
  612053
  614023
  622714
  640022
  671746
  675537
  688041
  688663
  690124
  788225
  807363
  807386
  815017
  815735
  820871
]
21.76 ms
(13.23%)
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
  411790
  421219
  412363
  418833
  421318
  429985
  442994
  820871
  815735
  448793
  449880
  452080
  454658
  456615
  465307
  471443
  473037
  449886
  449914
  535021
  497889
  497337
  514587
  525349
  527428
  464935
  478877
  482367
  541373
  562106
  565539
  541602
  563079
  581300
  688663
  688041
  582617
  586805
  614023
  640022
  591369
  596534
  606738
  607637
  807363
  807386
  622714
  400196
  448798
  463098
  424443
  468754
  447890
  471848
  481581
  419882
  425028
  454267
  491478
  492336
  518931
  484914
  485749
  484377
  522883
  430630
  788225
  383597
  402001
  404292
  406206
  412433
  417631
  442726
  425027
  428477
  434282
  428451
  431117
  815017
  448842
  450318
  476123
  483152
  530833
  513189
  519226
  524895
  530884
  519903
  477200
  577366
  675537
  690124
  671746
  550960
  607293
  598225
  610247
  611241
  612053
  587098
  416364
  443704
  443737
  443796
  443819
  420223
  434723
  469017
  426409
  446718
  470254
  474745
  397530
  442946
  444238
  462483
  480429
  411201
]
3.32 ms
(2.02%)
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
  383597
  397530
  400196
  402001
  404292
  406206
  411201
  411790
  412363
  412433
  416364
  417631
  418833
  419882
  420223
  421219
  421318
  424443
  425027
  425028
  426409
  428451
  428477
  429985
  430630
  431117
  434282
  434723
  442726
  442946
  442994
  443704
  443737
  443796
  443819
  444238
  446718
  447890
  448793
  448798
  448842
  449880
  449886
  449914
  450318
  452080
  454267
  454658
  456615
  462483
  463098
  464935
  465307
  468754
  469017
  470254
  471443
  471848
  473037
  474745
  476123
  477200
  478877
  480429
  481581
  482367
  483152
  484377
  484914
  485749
  491478
  492336
  497337
  497889
  513189
  514587
  518931
  519226
  519903
  522883
  524895
  525349
  527428
  530833
  530884
  535021
  541373
  541602
  550960
  562106
  563079
  565539
  577366
  581300
  582617
  586805
  587098
  591369
  596534
  598225
  606738
  607293
  607637
  610247
  611241
  612053
  614023
  622714
  640022
  671746
  675537
  688041
  688663
  690124
  788225
  807363
  807386
  815017
  815735
  820871
]
2.26 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy pussy facesitting"
]
1.83 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая pussy фейсситтинг"
]
1.73 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая pussy фейсситтинг"
]
1.64 ms
(0.99%)
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.