GET https://search.jues.net/search/embeds/8?q=step%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.09 ms
(54.17%)
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
  409369
  413890
  499294
  504390
  506619
  546088
  575241
  601879
  609238
  609861
  617195
  621348
  624390
  627243
  636972
  694138
  716651
  716726
  716916
  717227
  717790
  719352
  720991
  724635
  730602
  731499
  732181
  734539
  735069
  735146
  736104
  738791
  738856
  738879
  739295
  744536
  746105
  746317
  747263
  747270
  748015
  749455
  749529
  749532
  750208
  752009
  757503
  760359
  761122
  762653
  763938
  769053
  771253
  771690
  771718
  777244
  781130
  781437
  782704
  787285
  791333
  792285
  792921
  793530
  795007
  795433
  796639
  799490
  801435
  801439
  802079
  802082
  802242
  804185
  804934
  807466
  808099
  808307
  811985
  812452
  812805
  813218
  816193
  816824
  817186
  817565
  817591
  818159
  818195
  818766
  818767
  819875
  820078
  820117
  821758
  821776
  823667
  823835
  824044
  824426
  824524
  824534
  825130
  825484
  825953
  825989
  826219
  826732
  827010
  827254
  827400
  827991
  827992
  828326
  828469
  828667
]
155.89 ms
(40.78%)
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
  409369
  413890
  499294
  504390
  506619
  546088
  575241
  601879
  609238
  609861
  617195
  621348
  624390
  627243
  636972
  694138
  716651
  716726
  716916
  717227
  717790
  719352
  720991
  724635
  730602
  731499
  732181
  734539
  735069
  735146
  736104
  738791
  738856
  738879
  739295
  744536
  746105
  746317
  747263
  747270
  748015
  749455
  749529
  749532
  750208
  752009
  757503
  760359
  761122
  762653
  763938
  769053
  771253
  771690
  771718
  777244
  781130
  781437
  782704
  787285
  791333
  792285
  792921
  793530
  795007
  795433
  796639
  799490
  801435
  801439
  802079
  802082
  802242
  804185
  804934
  807466
  808099
  808307
  811985
  812452
  812805
  813218
  816193
  816824
  817186
  817565
  817591
  818159
  818195
  818766
  818767
  819875
  820078
  820117
  821758
  821776
  823667
  823835
  824044
  824426
  824524
  824534
  825130
  825484
  825953
  825989
  826219
  826732
  827010
  827254
  827400
  827991
  827992
  828326
  828469
  828667
]
11.96 ms
(3.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
  736104
  746317
  747263
  749532
  760359
  802242
  744536
  750208
  735146
  752009
  732181
  627243
  719352
  818195
  546088
  812452
  506619
  575241
  617195
  817186
  820078
  820117
  821776
  827254
  816824
  499294
  802082
  781130
  781437
  799490
  748015
  795007
  802079
  609861
  621348
  601879
  624390
  816193
  818766
  824044
  825953
  826732
  824534
  825484
  826219
  827010
  827400
  817591
  821758
  504390
  777244
  793530
  801435
  730602
  734539
  769053
  787285
  808307
  724635
  771690
  771718
  738791
  761122
  763938
  747270
  757503
  731499
  735069
  738856
  749455
  771729
  716651
  716916
  775768
  796639
  811985
  813218
  409369
  413890
  636972
  739295
  609238
  817565
  819875
  825130
  818159
  818767
  823667
  825989
  823835
  824426
  824524
  828326
  827992
  827991
  828667
  828469
  694138
  716726
  717227
  720991
  791333
  792285
  792921
  795433
  801439
  807466
  804934
  812805
  808099
  762823
  771253
  746105
  749529
  762653
  768738
  738879
  717790
  782704
  804185
]
2.15 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step amateur"
]
1.82 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step любительск"
]
1.74 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step любительск"
]

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.