GET https://search.jues.net/search/embeds/7?q=fisting%20amateur%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.62 ms
(49.83%)
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
  386345
  398122
  404028
  412830
  423998
  428178
  434324
  435550
  441250
  443309
  445401
  449377
  451121
  464495
  465470
  467886
  469217
  475647
  476168
  478512
  482190
  508778
  510812
  514695
  516595
  520713
  524147
  524150
  529338
  529599
  529632
  529696
  529740
  530688
  531787
  531827
  531852
  531855
  531874
  531878
  531879
  533470
  534533
  534565
  534758
  535963
  537155
  538066
  542995
  545449
  545551
  547479
  547482
  547785
  548451
  550892
  550897
  550899
  550900
  550904
  550914
  550917
  550930
  555029
  565031
  568265
  568280
  585251
  590234
  608491
  610256
  616292
  621960
  622693
  627196
  627221
  627491
  632129
  636950
  639363
  648649
  650305
  651962
  653028
  661061
  665950
  668292
  669880
  710528
  713189
  713194
  713196
  713502
  722376
  725759
  735120
  735150
  735914
  738468
  738475
  738501
  739151
  742703
  752608
  752649
  752659
  752671
  788952
  792740
  794257
  796694
  796716
  799789
  801928
  804137
  804150
  807560
  813206
  824343
  824577
]
189.31 ms
(45.00%)
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
  386345
  398122
  404028
  412830
  423998
  428178
  434324
  435550
  441250
  443309
  445401
  449377
  451121
  464495
  465470
  467886
  469217
  475647
  476168
  478512
  482190
  508778
  510812
  514695
  516595
  520713
  524147
  524150
  529338
  529599
  529632
  529696
  529740
  530688
  531787
  531827
  531852
  531855
  531874
  531878
  531879
  533470
  534533
  534565
  534758
  535963
  537155
  538066
  542995
  545449
  545551
  547479
  547482
  547785
  548451
  550892
  550897
  550899
  550900
  550904
  550914
  550917
  550930
  555029
  565031
  568265
  568280
  585251
  590234
  608491
  610256
  616292
  621960
  622693
  627196
  627221
  627491
  632129
  636950
  639363
  648649
  650305
  651962
  653028
  661061
  665950
  668292
  669880
  710528
  713189
  713194
  713196
  713502
  722376
  725759
  735120
  735150
  735914
  738468
  738475
  738501
  739151
  742703
  752608
  752649
  752659
  752671
  788952
  792740
  794257
  796694
  796716
  799789
  801928
  804137
  804150
  807560
  813206
  824343
  824577
]
14.14 ms
(3.36%)
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
  788952
  616292
  434324
  435550
  514695
  449377
  412830
  464495
  534758
  530688
  531827
  538066
  531852
  531855
  548451
  542995
  568265
  665950
  710528
  713502
  610256
  636950
  627196
  627221
  804137
  799789
  807560
  752659
  735150
  752649
  713189
  722376
  520713
  622693
  386345
  445401
  469217
  451121
  476168
  478512
  482190
  510812
  516595
  524150
  465470
  475647
  547482
  608491
  585251
  467886
  404028
  428178
  508778
  524147
  443309
  550899
  668292
  529696
  669880
  441250
  824343
  529599
  531878
  537155
  531874
  565031
  568280
  550892
  550914
  661061
  550897
  590234
  801928
  796716
  739151
  735120
  738468
  752671
  725759
  796694
  804150
  398122
  533470
  713194
  529338
  824577
  529740
  534565
  529632
  535963
  531787
  531879
  534533
  545449
  550930
  555029
  547785
  550904
  545551
  547479
  550900
  648649
  653028
  713196
  650305
  651962
  550917
  632129
  639363
  621960
  627491
  794257
  738501
  752608
  792740
  813206
  738475
  735914
  742703
  423998
]
2.27 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting amateur milf"
]
1.81 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг любительск milf"
]
1.77 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фистинг любительск milf"
]
1.73 ms
(0.41%)
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.