GET https://search.jues.net/search/embeds/8?q=mature%20milf%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
236.08 ms
(88.68%)
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
  3444
  24944
  98871
  146508
  327659
  359134
  365893
  384340
  391594
  415548
  423837
  443704
  453311
  459254
  462584
  466064
  466205
  468076
  469774
  471414
  472857
  473261
  474089
  479989
  482304
  482441
  484540
  486270
  489989
  490030
  491209
  497699
  501556
  505826
  506318
  509114
  511826
  517238
  517540
  517610
  518573
  518583
  524470
  528401
  529713
  530509
  533198
  533642
  534243
  539450
  543448
  547414
  549825
  552844
  555732
  555776
  555959
  560093
  563187
  563206
  570730
  581599
  587180
  588895
  588911
  589408
  590952
  591130
  600394
  604306
  607096
  614032
  619791
  620307
  621152
  621310
  621350
  652446
  660006
  664817
  665250
  665940
  667293
  667538
  682145
  686009
  695603
  703554
  710265
  711671
  716192
  716299
  720410
  726590
  737185
  739613
  746021
  756431
  759756
  760454
  761743
  762379
  766537
  766767
  767272
  789740
  790752
  792507
  795136
  799352
  799802
  799947
  804458
  806356
  808449
  814359
  815263
  815866
  816050
  818283
]
20.56 ms
(7.72%)
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
  469774
  528401
  384340
  391594
  327659
  3444
  98871
  415548
  423837
  814359
  815263
  818283
  815866
  816050
  472857
  489989
  490030
  462584
  466064
  486270
  501556
  517610
  530509
  509114
  529713
  524470
  533198
  533642
  534243
  471414
  482441
  484540
  563206
  555732
  563187
  570730
  552844
  560093
  581599
  665940
  667293
  695603
  652446
  664817
  665250
  667538
  686009
  710265
  660006
  703554
  720410
  547414
  555776
  555959
  588911
  620307
  621152
  587180
  589408
  614032
  588895
  590952
  604306
  619791
  607096
  621310
  799352
  799802
  792507
  761743
  767272
  789740
  790752
  795136
  808449
  759756
  737185
  746021
  766537
  739613
  760454
  762379
  726590
  756431
  766767
  621350
  711671
  716192
  716299
  799947
  804458
  806356
  24944
  473261
  146508
  359134
  459254
  365893
  466205
  517238
  517540
  506318
  482304
  443704
  468076
  491209
  479989
  453311
  505826
  511826
  518573
  497699
  518583
  539450
  474089
  543448
  549825
  682145
  600394
  591130
]
3.13 ms
(1.18%)
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
  3444
  24944
  98871
  146508
  327659
  359134
  365893
  384340
  391594
  415548
  423837
  443704
  453311
  459254
  462584
  466064
  466205
  468076
  469774
  471414
  472857
  473261
  474089
  479989
  482304
  482441
  484540
  486270
  489989
  490030
  491209
  497699
  501556
  505826
  506318
  509114
  511826
  517238
  517540
  517610
  518573
  518583
  524470
  528401
  529713
  530509
  533198
  533642
  534243
  539450
  543448
  547414
  549825
  552844
  555732
  555776
  555959
  560093
  563187
  563206
  570730
  581599
  587180
  588895
  588911
  589408
  590952
  591130
  600394
  604306
  607096
  614032
  619791
  620307
  621152
  621310
  621350
  652446
  660006
  664817
  665250
  665940
  667293
  667538
  682145
  686009
  695603
  703554
  710265
  711671
  716192
  716299
  720410
  726590
  737185
  739613
  746021
  756431
  759756
  760454
  761743
  762379
  766537
  766767
  767272
  789740
  790752
  792507
  795136
  799352
  799802
  799947
  804458
  806356
  808449
  814359
  815263
  815866
  816050
  818283
]
1.78 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature milf shower"
]
1.73 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature milf shower"
]
1.61 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature milf shower"
]

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.