GET https://search.jues.net/search/embeds/8?q=glasses%20brunette

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.61 ms
(33.65%)
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
  13875
  31583
  145163
  270290
  318132
  375092
  383130
  384913
  385647
  385910
  386928
  387018
  389875
  392017
  393741
  395398
  395626
  395781
  395913
  396990
  398954
  399634
  399889
  402013
  405623
  411511
  417219
  425207
  428852
  431514
  435975
  440994
  446817
  450301
  453084
  455326
  461605
  467096
  467894
  469230
  469734
  476440
  477050
  480541
  481157
  481864
  483757
  484753
  488017
  499089
  507083
  507216
  508372
  513136
  515787
  517415
  518590
  526808
  526843
  527818
  530144
  530423
  532324
  534953
  544474
  577934
  585129
  587779
  591267
  592435
  594066
  599064
  600980
  605033
  605046
  605999
  620995
  626271
  642622
  664579
  664800
  665766
  669989
  678173
  681613
  682226
  685967
  703603
  709450
  713067
  715041
  720603
  740556
  750326
  752663
  757368
  769147
  778010
  778986
  792507
  794106
  795578
  796237
  796463
  797908
  803327
  803859
  804178
  806352
  807988
  810108
  812086
  813074
  813109
  815154
  816090
  816222
  816272
  816711
  820387
]
209.57 ms
(33.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "очкастая черноволосая"
]
172.72 ms
(27.60%)
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
  13875
  31583
  145163
  270290
  318132
  375092
  383130
  384913
  385647
  385910
  386928
  387018
  389875
  392017
  393741
  395398
  395626
  395781
  395913
  396990
  398954
  399634
  399889
  402013
  405623
  411511
  417219
  425207
  428852
  431514
  435975
  440994
  446817
  450301
  453084
  455326
  461605
  467096
  467894
  469230
  469734
  476440
  477050
  480541
  481157
  481864
  483757
  484753
  488017
  499089
  507083
  507216
  508372
  513136
  515787
  517415
  518590
  526808
  526843
  527818
  530144
  530423
  532324
  534953
  544474
  577934
  585129
  587779
  591267
  592435
  594066
  599064
  600980
  605033
  605046
  605999
  620995
  626271
  642622
  664579
  664800
  665766
  669989
  678173
  681613
  682226
  685967
  703603
  709450
  713067
  715041
  720603
  740556
  750326
  752663
  757368
  769147
  778010
  778986
  792507
  794106
  795578
  796237
  796463
  797908
  803327
  803859
  804178
  806352
  807988
  810108
  812086
  813074
  813109
  815154
  816090
  816222
  816272
  816711
  820387
]
27.66 ms
(4.42%)
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
  577934
  669989
  681613
  685967
  665766
  709450
  664579
  664800
  678173
  682226
  703603
  713067
  715041
  587779
  642622
  592435
  594066
  599064
  600980
  605046
  778010
  794106
  795578
  797908
  792507
  796463
  803327
  807988
  810108
  812086
  813074
  813109
  740556
  750326
  769147
  796237
  803859
  806352
  757368
  752663
  605033
  605999
  626271
  720603
  778986
  804178
  318132
  385647
  386928
  392017
  398954
  411511
  383130
  405623
  469734
  477050
  591267
  620995
  526808
  481157
  467894
  544474
  431514
  395913
  461605
  526843
  499089
  385910
  384913
  145163
  393741
  395398
  395626
  395781
  375092
  270290
  31583
  13875
  389875
  387018
  396990
  399634
  399889
  402013
  428852
  435975
  440994
  417219
  425207
  585129
  820387
  815154
  816090
  816222
  816272
  816711
  446817
  450301
  455326
  469230
  476440
  483757
  488017
  480541
  481864
  453084
  467096
  484753
  507216
  515787
  518590
  530144
  530423
  532324
  508372
  513136
  507083
  517415
  527818
  534953
]
1.93 ms
(0.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "очкастая черноволосая"
]
1.67 ms
(0.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "glasses brunette"
]

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.