GET https://search.jues.net/search/embeds/3?q=deep%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
220.81 ms
(90.96%)
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
  118164
  187856
  212024
  233504
  385066
  385915
  398534
  401582
  417238
  420220
  432683
  446036
  449290
  449310
  451309
  459076
  460614
  480277
  487059
  512190
  518022
  521869
  524954
  526140
  530442
  536439
  539226
  541509
  543506
  548926
  550186
  553240
  555640
  563015
  567717
  568090
  571390
  578761
  586463
  591765
  591913
  604659
  608394
  617807
  620662
  622675
  623542
  624652
  626902
  630704
  632128
  633577
  634958
  642660
  644068
  673013
  685758
  693009
  695341
  695690
  698725
  699602
  703318
  706379
  708692
  710837
  716368
  717187
  717701
  720375
  722435
  722701
  724569
  724609
  733594
  734414
  734640
  737827
  740791
  742560
  744631
  749319
  752732
  756202
  756661
  757158
  763404
  769528
  770658
  771391
  773463
  775555
  776622
  777851
  780491
  782399
  784996
  786036
  790056
  790073
  790552
  792586
  794209
  794717
  800199
  801465
  801524
  803263
  804565
  809751
  810136
  811063
  811248
  812961
  815299
  819431
  822518
  824011
  825758
  826025
]
11.83 ms
(4.87%)
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
  553240
  644068
  626902
  724609
  733594
  622675
  449290
  826025
  819431
  480277
  518022
  539226
  526140
  512190
  548926
  550186
  568090
  722435
  673013
  693009
  706379
  720375
  717701
  571390
  620662
  633577
  630704
  604659
  623542
  786036
  790552
  792586
  803263
  784996
  812961
  790056
  790073
  811063
  811248
  756202
  724569
  737827
  749319
  763404
  624652
  634958
  776622
  780491
  801465
  810136
  398534
  401582
  385915
  815299
  460614
  567717
  543506
  685758
  586463
  716368
  233504
  446036
  521869
  187856
  417238
  822518
  451309
  563015
  541509
  695690
  695341
  710837
  722701
  703318
  555640
  591765
  608394
  591913
  794209
  801524
  775555
  734414
  734640
  752732
  770658
  782399
  794717
  809751
  742560
  771391
  773463
  744631
  769528
  740791
  756661
  757158
  617807
  632128
  698725
  699602
  777851
  800199
  804565
  459076
  385066
  642660
  212024
  118164
  432683
  420220
  824011
  825758
  487059
  449310
  530442
  524954
  536439
  578761
  717187
  708692
]
2.96 ms
(1.22%)
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
  118164
  187856
  212024
  233504
  385066
  385915
  398534
  401582
  417238
  420220
  432683
  446036
  449290
  449310
  451309
  459076
  460614
  480277
  487059
  512190
  518022
  521869
  524954
  526140
  530442
  536439
  539226
  541509
  543506
  548926
  550186
  553240
  555640
  563015
  567717
  568090
  571390
  578761
  586463
  591765
  591913
  604659
  608394
  617807
  620662
  622675
  623542
  624652
  626902
  630704
  632128
  633577
  634958
  642660
  644068
  673013
  685758
  693009
  695341
  695690
  698725
  699602
  703318
  706379
  708692
  710837
  716368
  717187
  717701
  720375
  722435
  722701
  724569
  724609
  733594
  734414
  734640
  737827
  740791
  742560
  744631
  749319
  752732
  756202
  756661
  757158
  763404
  769528
  770658
  771391
  773463
  775555
  776622
  777851
  780491
  782399
  784996
  786036
  790056
  790073
  790552
  792586
  794209
  794717
  800199
  801465
  801524
  803263
  804565
  809751
  810136
  811063
  811248
  812961
  815299
  819431
  822518
  824011
  825758
  826025
]
2.20 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deep pussy"
]
1.82 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "deep pussy"
]
1.63 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "deep pussy"
]
1.51 ms
(0.62%)
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.