GET https://search.jues.net/search/embeds/9?q=mom%20sport

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.88 ms
(84.99%)
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
  550678
  551108
  557870
  561124
  583564
  585589
  585728
  585754
  586323
  586883
  589522
  589928
  592805
  593232
  594955
  595031
  595953
  596051
  596086
  596140
  599075
  600210
  600952
  601143
  604717
  604913
  610275
  611044
  616188
  619122
  621059
  621092
  622988
  627155
  629313
  630316
  630479
  630492
  630903
  633042
  638074
  641444
  641462
  641625
  644656
  647682
  673997
  676147
  677749
  690315
  694225
  697449
  697760
  698959
  713272
  718786
  721167
  723731
  731618
  732625
  740024
  740435
  756285
  757063
  758634
  758668
  758680
  764348
  765837
  765867
  766018
  770990
  771375
  772319
  772575
  773103
  774244
  775889
  776189
  776554
  777191
  778337
  778383
  778749
  779389
  780088
  784338
  784986
  785038
  785223
  786197
  786360
  787454
  788847
  788960
  789036
  789217
  789575
  789710
  789736
  789981
  791479
  797054
  797431
  797774
  797846
  798588
  798611
  800218
  801206
  801438
  802785
  805145
  805150
  805291
  807394
  808379
  808409
  811351
  813099
]
14.94 ms
(8.77%)
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
  690315
  697760
  698959
  713272
  718786
  721167
  647682
  673997
  676147
  677749
  694225
  697449
  550678
  551108
  557870
  561124
  583564
  585728
  585754
  592805
  593232
  594955
  595953
  596051
  601143
  604717
  611044
  616188
  629313
  630492
  641625
  586883
  622988
  630479
  633042
  589522
  595031
  596140
  600210
  619122
  621059
  630316
  638074
  641462
  644656
  585589
  586323
  589928
  596086
  599075
  600952
  604913
  610275
  621092
  627155
  630903
  641444
  775889
  776554
  778383
  779389
  784338
  786197
  789036
  789217
  789710
  789981
  800218
  802785
  805145
  808409
  811351
  813099
  776189
  777191
  778337
  778749
  780088
  785223
  788847
  788960
  789575
  789736
  797054
  797846
  798588
  798611
  807394
  740024
  756285
  758680
  764348
  772319
  784986
  785038
  786360
  787454
  791479
  797431
  797774
  801206
  801438
  805150
  805291
  808379
  731618
  740435
  757063
  765837
  765867
  766018
  771375
  772575
  723731
  758634
  758668
  770990
  773103
  774244
  732625
]
3.39 ms
(1.99%)
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
  550678
  551108
  557870
  561124
  583564
  585589
  585728
  585754
  586323
  586883
  589522
  589928
  592805
  593232
  594955
  595031
  595953
  596051
  596086
  596140
  599075
  600210
  600952
  601143
  604717
  604913
  610275
  611044
  616188
  619122
  621059
  621092
  622988
  627155
  629313
  630316
  630479
  630492
  630903
  633042
  638074
  641444
  641462
  641625
  644656
  647682
  673997
  676147
  677749
  690315
  694225
  697449
  697760
  698959
  713272
  718786
  721167
  723731
  731618
  732625
  740024
  740435
  756285
  757063
  758634
  758668
  758680
  764348
  765837
  765867
  766018
  770990
  771375
  772319
  772575
  773103
  774244
  775889
  776189
  776554
  777191
  778337
  778383
  778749
  779389
  780088
  784338
  784986
  785038
  785223
  786197
  786360
  787454
  788847
  788960
  789036
  789217
  789575
  789710
  789736
  789981
  791479
  797054
  797431
  797774
  797846
  798588
  798611
  800218
  801206
  801438
  802785
  805145
  805150
  805291
  807394
  808379
  808409
  811351
  813099
]
1.97 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom спортивная"
]
1.96 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom sport"
]
1.73 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom спортивная"
]
1.59 ms
(0.93%)
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.