GET https://search.jues.net/search/embeds/8?q=%D0%B2%20%D0%B6%D0%BE%D0%BF%D1%83%20%D1%80%D1%83%D0%BA%D0%BE%D0%B9

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.69 ms
(87.71%)
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
  388036
  393091
  411455
  415233
  428575
  441120
  441506
  442986
  448791
  456217
  465854
  467936
  470355
  470403
  471663
  472906
  476323
  477543
  477556
  478512
  479549
  480724
  493493
  494060
  494141
  496340
  499084
  499288
  501098
  501324
  505266
  508187
  508542
  510180
  512961
  513052
  513157
  514837
  516140
  517416
  518083
  518451
  520752
  520788
  521589
  521836
  522187
  522340
  523062
  525042
  526646
  526904
  528942
  529338
  529709
  530456
  531347
  532826
  533333
  534432
  534550
  536278
  536444
  541575
  541732
  542710
  552544
  555348
  565907
  566764
  569146
  578327
  578566
  579859
  583381
  584021
  584257
  584706
  586897
  586905
  587191
  587795
  588436
  589045
  589647
  590373
  590843
  591095
  591727
  592187
  596738
  597666
  598370
  600143
  601789
  602251
  602409
  603313
  604214
  604225
  604326
  604357
  609436
  610346
  613482
  618857
  619552
  626117
  627420
  628116
  629151
  631508
  632563
  633980
  667166
  679656
  680441
  686113
  691179
  786911
]
13.46 ms
(7.13%)
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
  686113
  691179
  667166
  552544
  555348
  566764
  578327
  578566
  579859
  583381
  584021
  584706
  613482
  626117
  629151
  633980
  592187
  598370
  600143
  587191
  587795
  589045
  590843
  596738
  603313
  610346
  586905
  588436
  590373
  591095
  604214
  604326
  609436
  627420
  602251
  786911
  442986
  465854
  477543
  479549
  388036
  428575
  471663
  441506
  456217
  513052
  516140
  536278
  499288
  505266
  470355
  493493
  510180
  536444
  508542
  513157
  520788
  532826
  534432
  499084
  501324
  517416
  529709
  514837
  518083
  476323
  480724
  541732
  565907
  584257
  542710
  569146
  679656
  680441
  602409
  589647
  597666
  591727
  601789
  586897
  604225
  619552
  631508
  604357
  411455
  618857
  632563
  501098
  529338
  496340
  522187
  521589
  522340
  541575
  628116
  393091
  441120
  415233
  467936
  470403
  472906
  477556
  448791
  478512
  494060
  508187
  512961
  526904
  533333
  494141
  518451
  521836
  523062
  525042
  526646
  520752
  528942
  530456
  531347
  534550
]
3.29 ms
(1.74%)
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
  388036
  393091
  411455
  415233
  428575
  441120
  441506
  442986
  448791
  456217
  465854
  467936
  470355
  470403
  471663
  472906
  476323
  477543
  477556
  478512
  479549
  480724
  493493
  494060
  494141
  496340
  499084
  499288
  501098
  501324
  505266
  508187
  508542
  510180
  512961
  513052
  513157
  514837
  516140
  517416
  518083
  518451
  520752
  520788
  521589
  521836
  522187
  522340
  523062
  525042
  526646
  526904
  528942
  529338
  529709
  530456
  531347
  532826
  533333
  534432
  534550
  536278
  536444
  541575
  541732
  542710
  552544
  555348
  565907
  566764
  569146
  578327
  578566
  579859
  583381
  584021
  584257
  584706
  586897
  586905
  587191
  587795
  588436
  589045
  589647
  590373
  590843
  591095
  591727
  592187
  596738
  597666
  598370
  600143
  601789
  602251
  602409
  603313
  604214
  604225
  604326
  604357
  609436
  610346
  613482
  618857
  619552
  626117
  627420
  628116
  629151
  631508
  632563
  633980
  667166
  679656
  680441
  686113
  691179
  786911
]
1.93 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал рук"
]
1.58 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в жопу рукой"
]
1.49 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал рук"
]
1.48 ms
(0.78%)
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.