GET https://search.jues.net/search/embeds/4?q=big%20hole

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.15 ms
(87.07%)
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
  88182
  117844
  117890
  117941
  381810
  385107
  398941
  413388
  419880
  424519
  426259
  432299
  436132
  439514
  441027
  446797
  451138
  452269
  453996
  457228
  491259
  493398
  508171
  508556
  510783
  517816
  519699
  520909
  521145
  523355
  530373
  532727
  532854
  537654
  538992
  541197
  543128
  543930
  544851
  544860
  545245
  546248
  547368
  547472
  547488
  555035
  555250
  559363
  561042
  563703
  564104
  564387
  565104
  566843
  568031
  569656
  584164
  594389
  594491
  599964
  599969
  600171
  601584
  602259
  603362
  608174
  617411
  622398
  622402
  627162
  627196
  628091
  628391
  628415
  628591
  629045
  631245
  634044
  634778
  640777
  640785
  643673
  643705
  666901
  667222
  672780
  677142
  680266
  709693
  711699
  719333
  723167
  724002
  728745
  728775
  730355
  735120
  742363
  746425
  747298
  747404
  749012
  758226
  767190
  785621
  788111
  791508
  795523
  799683
  801287
  801314
  803255
  805736
  811643
  812562
  814156
  820628
  824435
  824969
  825783
]
16.60 ms
(8.25%)
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
  566843
  594389
  594491
  603362
  631245
  640777
  640785
  801287
  758226
  709693
  811643
  510783
  803255
  795523
  730355
  735120
  812562
  537654
  545245
  541197
  677142
  666901
  719333
  601584
  599964
  628415
  622402
  628391
  634778
  628091
  547488
  452269
  432299
  441027
  569656
  491259
  439514
  517816
  523355
  563703
  117844
  398941
  565104
  627162
  627196
  749012
  728745
  424519
  825783
  667222
  672780
  711699
  747298
  747404
  451138
  521145
  519699
  530373
  600171
  599969
  629045
  419880
  824435
  426259
  413388
  446797
  532727
  532854
  544860
  544851
  602259
  436132
  453996
  493398
  385107
  117941
  381810
  824969
  508556
  547472
  555035
  559363
  564104
  584164
  555250
  608174
  628591
  634044
  643705
  788111
  785621
  791508
  746425
  728775
  767190
  643673
  799683
  117890
  508171
  820628
  543930
  568031
  564387
  538992
  680266
  723167
  805736
  742363
  457228
  814156
  543128
  561042
  546248
  547368
  724002
  801314
  622398
  617411
  520909
  88182
]
2.38 ms
(1.18%)
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
  88182
  117844
  117890
  117941
  381810
  385107
  398941
  413388
  419880
  424519
  426259
  432299
  436132
  439514
  441027
  446797
  451138
  452269
  453996
  457228
  491259
  493398
  508171
  508556
  510783
  517816
  519699
  520909
  521145
  523355
  530373
  532727
  532854
  537654
  538992
  541197
  543128
  543930
  544851
  544860
  545245
  546248
  547368
  547472
  547488
  555035
  555250
  559363
  561042
  563703
  564104
  564387
  565104
  566843
  568031
  569656
  584164
  594389
  594491
  599964
  599969
  600171
  601584
  602259
  603362
  608174
  617411
  622398
  622402
  627162
  627196
  628091
  628391
  628415
  628591
  629045
  631245
  634044
  634778
  640777
  640785
  643673
  643705
  666901
  667222
  672780
  677142
  680266
  709693
  711699
  719333
  723167
  724002
  728745
  728775
  730355
  735120
  742363
  746425
  747298
  747404
  749012
  758226
  767190
  785621
  788111
  791508
  795523
  799683
  801287
  801314
  803255
  805736
  811643
  812562
  814156
  820628
  824435
  824969
  825783
]
1.85 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие дырк"
]
1.82 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие дырк"
]
1.74 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big hole"
]
1.63 ms
(0.81%)
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.