GET https://search.jues.net/search/embeds/3?q=young%20boy%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.65 ms
(86.10%)
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
  122062
  187195
  188136
  233610
  233862
  338249
  382242
  383483
  386508
  387433
  388101
  389639
  390888
  391380
  395522
  395921
  395930
  397410
  398947
  400812
  401227
  401766
  401906
  402602
  406969
  407887
  409300
  409668
  409709
  411854
  412401
  416883
  421079
  428080
  428520
  428522
  432218
  432355
  441001
  443165
  443664
  443690
  443970
  448671
  452132
  454132
  454179
  454223
  454226
  454237
  454897
  455197
  460732
  462291
  462328
  473252
  479044
  479061
  482374
  484439
  484443
  484638
  486543
  490924
  512536
  516473
  517013
  518851
  520743
  522482
  536661
  546936
  546951
  550623
  562886
  567423
  570783
  576640
  584395
  587558
  589687
  591245
  665442
  669776
  682525
  712674
  714908
  717700
  726962
  728381
  728483
  733817
  736514
  737083
  738961
  746060
  775545
  781740
  781751
  784253
  785438
  788282
  788288
  788812
  788885
  788948
  794978
  799369
  802441
  803078
  803081
  803091
  807451
  807454
  807552
  808452
  810069
  820148
  823910
  828219
]
14.82 ms
(8.10%)
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
  799369
  788282
  728381
  233862
  338249
  401227
  550623
  728483
  788812
  473252
  522482
  428080
  587558
  589687
  802441
  387433
  406969
  828219
  576640
  402602
  807451
  823910
  717700
  737083
  726962
  746060
  395930
  382242
  738961
  570783
  411854
  428522
  395522
  432218
  416883
  443664
  443970
  409300
  546951
  546936
  584395
  665442
  669776
  794978
  810069
  395921
  412401
  462291
  462328
  391380
  454237
  479044
  479061
  443165
  484638
  484439
  484443
  490924
  409668
  591245
  781740
  781751
  784253
  808452
  736514
  807552
  807454
  448671
  443690
  785438
  389639
  454132
  386508
  401906
  714908
  788948
  733817
  397410
  122062
  401766
  409709
  454897
  567423
  775545
  788288
  788885
  187195
  383483
  388101
  486543
  421079
  432355
  562886
  428520
  455197
  517013
  233610
  398947
  188136
  452132
  512536
  536661
  390888
  441001
  460732
  400812
  454226
  454179
  454223
  516473
  518851
  520743
  803091
  803081
  820148
  482374
  682525
  803078
  712674
  407887
]
4.23 ms
(2.31%)
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
  122062
  187195
  188136
  233610
  233862
  338249
  382242
  383483
  386508
  387433
  388101
  389639
  390888
  391380
  395522
  395921
  395930
  397410
  398947
  400812
  401227
  401766
  401906
  402602
  406969
  407887
  409300
  409668
  409709
  411854
  412401
  416883
  421079
  428080
  428520
  428522
  432218
  432355
  441001
  443165
  443664
  443690
  443970
  448671
  452132
  454132
  454179
  454223
  454226
  454237
  454897
  455197
  460732
  462291
  462328
  473252
  479044
  479061
  482374
  484439
  484443
  484638
  486543
  490924
  512536
  516473
  517013
  518851
  520743
  522482
  536661
  546936
  546951
  550623
  562886
  567423
  570783
  576640
  584395
  587558
  589687
  591245
  665442
  669776
  682525
  712674
  714908
  717700
  726962
  728381
  728483
  733817
  736514
  737083
  738961
  746060
  775545
  781740
  781751
  784253
  785438
  788282
  788288
  788812
  788885
  788948
  794978
  799369
  802441
  803078
  803081
  803091
  807451
  807454
  807552
  808452
  810069
  820148
  823910
  828219
]
1.85 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young boy milf"
]
1.75 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young парен milf"
]
1.46 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young парен milf"
]

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.