GET https://search.jues.net/search/embeds/10?q=big%20step

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.27 ms
(84.89%)
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
  407384
  420926
  425360
  450843
  482246
  510012
  519253
  521463
  524175
  530463
  530546
  530817
  532054
  532112
  532132
  547705
  554153
  561461
  567319
  576194
  576609
  579440
  582269
  584753
  585434
  599368
  607311
  616530
  616677
  621348
  626169
  627243
  632316
  636117
  638743
  643792
  645773
  651167
  653754
  660618
  667244
  674542
  680853
  684336
  695741
  697441
  697848
  698936
  701388
  702454
  709363
  714327
  716517
  716995
  717227
  717790
  718969
  719120
  719168
  720991
  721679
  731499
  733401
  734539
  736104
  736575
  738879
  746638
  747263
  747270
  749529
  749532
  750883
  750890
  753057
  756257
  757503
  760359
  762067
  772059
  775782
  793604
  795433
  798113
  798594
  801362
  807466
  808200
  808427
  810421
  811712
  812805
  814414
  816712
  816760
  817591
  818092
  818212
  818588
  819645
  820323
  821146
  821758
  823619
  823637
  824524
  824534
  825953
  826732
  827010
  827400
  827784
  827844
  827868
  827882
  827908
  828443
  828469
  828764
]
11.79 ms
(8.53%)
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
  825953
  826732
  818588
  824534
  827010
  827400
  817591
  821146
  821758
  824524
  828469
  532132
  579440
  567319
  576194
  684336
  701388
  716517
  719168
  651167
  653754
  697441
  716995
  721679
  645773
  680853
  695741
  698936
  714327
  717227
  720991
  576609
  616530
  616677
  636117
  626169
  643792
  632316
  638743
  795433
  807466
  775782
  812805
  734539
  736104
  747263
  749532
  760359
  733401
  747270
  749529
  757503
  731499
  738879
  627243
  717790
  719120
  775768
  808427
  810421
  811712
  407384
  425360
  823619
  818212
  827868
  828764
  827784
  827908
  827844
  828443
  482246
  521463
  547705
  561461
  709363
  585434
  607311
  808200
  793604
  798113
  801362
  772059
  798594
  736575
  750890
  762067
  753057
  750883
  746638
  702454
  621348
  756257
  582269
  599368
  819645
  818092
  532054
  718969
  554153
  420926
  814414
  816712
  816760
  823637
  820323
  827882
  450843
  530463
  524175
  530546
  532112
  510012
  530817
  519253
  584753
  674542
  697848
  660618
  667244
]
2.81 ms
(2.03%)
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
  407384
  420926
  425360
  450843
  482246
  510012
  519253
  521463
  524175
  530463
  530546
  530817
  532054
  532112
  532132
  547705
  554153
  561461
  567319
  576194
  576609
  579440
  582269
  584753
  585434
  599368
  607311
  616530
  616677
  621348
  626169
  627243
  632316
  636117
  638743
  643792
  645773
  651167
  653754
  660618
  667244
  674542
  680853
  684336
  695741
  697441
  697848
  698936
  701388
  702454
  709363
  714327
  716517
  716995
  717227
  717790
  718969
  719120
  719168
  720991
  721679
  731499
  733401
  734539
  736104
  736575
  738879
  746638
  747263
  747270
  749529
  749532
  750883
  750890
  753057
  756257
  757503
  760359
  762067
  772059
  775782
  793604
  795433
  798113
  798594
  801362
  807466
  808200
  808427
  810421
  811712
  812805
  814414
  816712
  816760
  817591
  818092
  818212
  818588
  819645
  820323
  821146
  821758
  823619
  823637
  824524
  824534
  825953
  826732
  827010
  827400
  827784
  827844
  827868
  827882
  827908
  828443
  828469
  828764
]
1.74 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big step"
]
1.64 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие step"
]
1.46 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие step"
]
1.43 ms
(1.04%)
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.