GET https://search.jues.net/search/embeds/6?q=big%20video

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.83 ms
(76.77%)
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
  197982
  329606
  338311
  382098
  384401
  386796
  407592
  411878
  412578
  457743
  459442
  467677
  479969
  485635
  509431
  510628
  514785
  528376
  529884
  530547
  532160
  532261
  532354
  532356
  534183
  535831
  535859
  537876
  538318
  539609
  539611
  548919
  554809
  559342
  563572
  566419
  568312
  582448
  583405
  593057
  599017
  601021
  607850
  612250
  621291
  624078
  629313
  629837
  633480
  636136
  636582
  647091
  649034
  649885
  651066
  651128
  651227
  654092
  659353
  661435
  661928
  662797
  663796
  666046
  668085
  668331
  668797
  673488
  679564
  687453
  687896
  691514
  694172
  694188
  694455
  695236
  695928
  696134
  698483
  704918
  708657
  709504
  710620
  712582
  713497
  714596
  715546
  715872
  718369
  726904
  727951
  732651
  736447
  737129
  737752
  739471
  740575
  745214
  765650
  769408
  771530
  775668
  780765
  781045
  782487
  783449
  789009
  789475
  793600
  802287
  803758
  809912
  810027
  810209
  812328
  823097
  823475
  823892
  825449
  827624
]
30.36 ms
(17.16%)
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
  825449
  823892
  479969
  457743
  509431
  532160
  559342
  548919
  582448
  668797
  695236
  704918
  651227
  651066
  654092
  663796
  666046
  621291
  636582
  607850
  775668
  782487
  783449
  780765
  793600
  802287
  739471
  810027
  732651
  769408
  736447
  737129
  765650
  737752
  771530
  698483
  809912
  197982
  537876
  708657
  593057
  412578
  384401
  338311
  407592
  459442
  467677
  532261
  538318
  539609
  534183
  539611
  528376
  659353
  696134
  715546
  661928
  662797
  691514
  554809
  629313
  599017
  601021
  612250
  789009
  803758
  812328
  781045
  789475
  810209
  727951
  745214
  740575
  633480
  510628
  514785
  329606
  382098
  411878
  823097
  529884
  532356
  535831
  532354
  535859
  687896
  687453
  713497
  649885
  694188
  624078
  636136
  629837
  726904
  485635
  386796
  823475
  827624
  530547
  563572
  566419
  568312
  583405
  647091
  651128
  668085
  673488
  694455
  712582
  718369
  668331
  679564
  694172
  695928
  709504
  710620
  714596
  715872
  649034
  661435
]
2.56 ms
(1.45%)
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
  197982
  329606
  338311
  382098
  384401
  386796
  407592
  411878
  412578
  457743
  459442
  467677
  479969
  485635
  509431
  510628
  514785
  528376
  529884
  530547
  532160
  532261
  532354
  532356
  534183
  535831
  535859
  537876
  538318
  539609
  539611
  548919
  554809
  559342
  563572
  566419
  568312
  582448
  583405
  593057
  599017
  601021
  607850
  612250
  621291
  624078
  629313
  629837
  633480
  636136
  636582
  647091
  649034
  649885
  651066
  651128
  651227
  654092
  659353
  661435
  661928
  662797
  663796
  666046
  668085
  668331
  668797
  673488
  679564
  687453
  687896
  691514
  694172
  694188
  694455
  695236
  695928
  696134
  698483
  704918
  708657
  709504
  710620
  712582
  713497
  714596
  715546
  715872
  718369
  726904
  727951
  732651
  736447
  737129
  737752
  739471
  740575
  745214
  765650
  769408
  771530
  775668
  780765
  781045
  782487
  783449
  789009
  789475
  793600
  802287
  803758
  809912
  810027
  810209
  812328
  823097
  823475
  823892
  825449
  827624
]
2.54 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big video"
]
2.21 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие video"
]
1.55 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие video"
]

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.