GET https://search.jues.net/search/embeds/4?q=girl%20boy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.47 ms
(54.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк парен"
]
147.85 ms
(38.45%)
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
  293499
  386735
  395661
  396792
  402207
  403664
  404412
  405544
  413246
  420510
  422499
  433904
  437516
  439350
  444252
  446592
  448168
  448725
  452611
  453902
  455819
  456703
  460119
  460727
  460906
  463146
  463493
  465202
  466282
  466594
  467194
  468824
  469093
  469915
  469917
  472647
  472930
  473614
  475158
  476021
  478914
  479656
  481489
  483418
  487502
  487599
  489818
  490714
  491378
  491661
  492491
  496850
  496987
  497002
  498967
  500043
  501317
  502420
  505133
  508738
  509558
  510495
  510832
  511218
  512118
  516054
  516534
  517832
  518420
  519101
  520587
  520901
  521963
  522019
  522502
  524972
  526205
  528897
  529449
  536872
  536937
  538368
  548621
  548753
  552908
  554819
  556494
  558085
  559539
  561813
  562209
  564423
  565394
  565678
  567677
  568954
  570407
  570538
  572696
  572913
  573655
  573810
  574893
  575789
  578848
  581082
  586598
  592607
  595744
  604217
  605659
  611767
  631632
  657667
  716834
  717850
  722035
  722860
  756775
  783992
]
17.53 ms
(4.56%)
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
  522019
  413246
  433904
  446592
  722035
  536937
  522502
  559539
  562209
  558085
  554819
  565394
  293499
  520901
  490714
  510495
  573655
  548621
  611767
  439350
  472647
  475158
  512118
  491661
  508738
  509558
  467194
  468824
  548753
  444252
  536872
  491378
  460906
  500043
  575789
  716834
  722860
  386735
  465202
  472930
  501317
  568954
  605659
  420510
  581082
  476021
  502420
  516054
  520587
  469093
  492491
  511218
  479656
  717850
  521963
  483418
  519101
  452611
  395661
  466594
  405544
  516534
  517832
  573810
  556494
  592607
  756775
  404412
  528897
  564423
  604217
  466282
  469917
  489818
  498967
  505133
  586598
  396792
  570538
  572696
  574893
  783992
  422499
  481489
  456703
  478914
  518420
  538368
  497002
  469915
  561813
  657667
  448725
  567677
  570407
  437516
  496987
  526205
  529449
  552908
  631632
  463146
  455819
  402207
  524972
  496850
  463493
  578848
  572913
  510832
  460119
  487599
  565678
  595744
  448168
  453902
  403664
  460727
  473614
  487502
]
3.91 ms
(1.02%)
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
  293499
  386735
  395661
  396792
  402207
  403664
  404412
  405544
  413246
  420510
  422499
  433904
  437516
  439350
  444252
  446592
  448168
  448725
  452611
  453902
  455819
  456703
  460119
  460727
  460906
  463146
  463493
  465202
  466282
  466594
  467194
  468824
  469093
  469915
  469917
  472647
  472930
  473614
  475158
  476021
  478914
  479656
  481489
  483418
  487502
  487599
  489818
  490714
  491378
  491661
  492491
  496850
  496987
  497002
  498967
  500043
  501317
  502420
  505133
  508738
  509558
  510495
  510832
  511218
  512118
  516054
  516534
  517832
  518420
  519101
  520587
  520901
  521963
  522019
  522502
  524972
  526205
  528897
  529449
  536872
  536937
  538368
  548621
  548753
  552908
  554819
  556494
  558085
  559539
  561813
  562209
  564423
  565394
  565678
  567677
  568954
  570407
  570538
  572696
  572913
  573655
  573810
  574893
  575789
  578848
  581082
  586598
  592607
  595744
  604217
  605659
  611767
  631632
  657667
  716834
  717850
  722035
  722860
  756775
  783992
]
2.03 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl boy"
]
1.94 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк парен"
]
1.79 ms
(0.46%)
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.