GET https://search.jues.net/search/embeds/7?q=teen%20erotic

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.29 ms
(49.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen эротик"
]
200.45 ms
(45.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
  541470
  548917
  550386
  552210
  553547
  553604
  556032
  556252
  556261
  556342
  560049
  566564
  567437
  571049
  576316
  576880
  579253
  580241
  580853
  581661
  582753
  584350
  585845
  585899
  588798
  589991
  590029
  590084
  594159
  594170
  594227
  594241
  594255
  594469
  594499
  595623
  597596
  598728
  599606
  600454
  600468
  601612
  603519
  603528
  604032
  606247
  609970
  618072
  620908
  622160
  623846
  627835
  630624
  631224
  636508
  639112
  639210
  641796
  642106
  645389
  645400
  645604
  648569
  648895
  649300
  650113
  650922
  652212
  652235
  652274
  652286
  652952
  652954
  657536
  660289
  663715
  664160
  664206
  665980
  672356
  675401
  681355
  684516
  684847
  690062
  691790
  703926
  709844
  709916
  709946
  714253
  714941
  719949
  737382
  740570
  740807
  743075
  745634
  748561
  749542
  749979
  750287
  750407
  751013
  752180
  754172
  756287
  756838
  767946
  773340
  782710
  785571
  786239
  787069
  792547
  799039
  800406
  803383
  806593
  807093
]
12.99 ms
(2.96%)
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
  580241
  541470
  548917
  550386
  571049
  584350
  552210
  556032
  556261
  556342
  566564
  567437
  576316
  576880
  579253
  582753
  645400
  652954
  672356
  675401
  703926
  719949
  648895
  649300
  650113
  652212
  652274
  652286
  652952
  660289
  663715
  709844
  709916
  714253
  645389
  645604
  648569
  650922
  652235
  657536
  664160
  664206
  665980
  681355
  684516
  684847
  690062
  691790
  709946
  714941
  553547
  553604
  556252
  560049
  580853
  581661
  589991
  601612
  603528
  604032
  609970
  622160
  630624
  641796
  585845
  588798
  598728
  600468
  603519
  639112
  590029
  594499
  595623
  599606
  606247
  636508
  639210
  585899
  590084
  594159
  594170
  594227
  594241
  594255
  594469
  597596
  600454
  618072
  620908
  623846
  627835
  631224
  642106
  786239
  800406
  803383
  799039
  740570
  740807
  743075
  748561
  749979
  751013
  754172
  782710
  785571
  787069
  792547
  806593
  807093
  737382
  749542
  750407
  756838
  745634
  750287
  752180
  756287
  767946
  773340
]
3.14 ms
(0.72%)
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
  541470
  548917
  550386
  552210
  553547
  553604
  556032
  556252
  556261
  556342
  560049
  566564
  567437
  571049
  576316
  576880
  579253
  580241
  580853
  581661
  582753
  584350
  585845
  585899
  588798
  589991
  590029
  590084
  594159
  594170
  594227
  594241
  594255
  594469
  594499
  595623
  597596
  598728
  599606
  600454
  600468
  601612
  603519
  603528
  604032
  606247
  609970
  618072
  620908
  622160
  623846
  627835
  630624
  631224
  636508
  639112
  639210
  641796
  642106
  645389
  645400
  645604
  648569
  648895
  649300
  650113
  650922
  652212
  652235
  652274
  652286
  652952
  652954
  657536
  660289
  663715
  664160
  664206
  665980
  672356
  675401
  681355
  684516
  684847
  690062
  691790
  703926
  709844
  709916
  709946
  714253
  714941
  719949
  737382
  740570
  740807
  743075
  745634
  748561
  749542
  749979
  750287
  750407
  751013
  752180
  754172
  756287
  756838
  767946
  773340
  782710
  785571
  786239
  787069
  792547
  799039
  800406
  803383
  806593
  807093
]
1.76 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen эротик"
]
1.63 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen erotic"
]
1.60 ms
(0.37%)
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.