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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.75 ms
(88.36%)
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
  13181
  311884
  406780
  406933
  410217
  415254
  417333
  419219
  419694
  428424
  434673
  435244
  437561
  441647
  442520
  444029
  447722
  454409
  454895
  457940
  461252
  463385
  464014
  465479
  465711
  465719
  467913
  473740
  475253
  475475
  478303
  478665
  479779
  480413
  484086
  484521
  489291
  491025
  493254
  493818
  494782
  507513
  511548
  511677
  511936
  512397
  513641
  513814
  515013
  515583
  516493
  516719
  518878
  520306
  520323
  520964
  524479
  524753
  524845
  528642
  529703
  529829
  530294
  530315
  531010
  531035
  533233
  533392
  533626
  534148
  539205
  548194
  551824
  552535
  556216
  558205
  559203
  567623
  572245
  578241
  583626
  600898
  604790
  676241
  717321
  732121
  758576
  762820
  769493
  772442
  773552
  774238
  775657
  781494
  784425
  788728
  788858
  789992
  806158
  811620
  812935
  814208
  815691
  816089
  816459
  816738
  816806
  816996
  817927
  817941
  819053
  819183
  819257
  820360
  821977
  822499
  822974
  824471
  826163
  827408
]
16.05 ms
(7.21%)
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
  788858
  758576
  784425
  762820
  769493
  774238
  775657
  806158
  811620
  826163
  817941
  465479
  515013
  531035
  534148
  788728
  812935
  789992
  13181
  406933
  520306
  530315
  781494
  773552
  441647
  434673
  417333
  435244
  419694
  454409
  484521
  457940
  479779
  551824
  552535
  556216
  559203
  572245
  558205
  567623
  604790
  444029
  467913
  475475
  428424
  478303
  406780
  419219
  473740
  475253
  478665
  463385
  524479
  491025
  507513
  511548
  511936
  515583
  493254
  511677
  513641
  520323
  520964
  524845
  494782
  512397
  516493
  528642
  410217
  454895
  578241
  583626
  676241
  732121
  772442
  717321
  415254
  461252
  518878
  548194
  447722
  464014
  465719
  493818
  480413
  484086
  600898
  437561
  442520
  516719
  524753
  311884
  814208
  816089
  816996
  819053
  820360
  821977
  824471
  827408
  815691
  816459
  817927
  822499
  822974
  816738
  816806
  819183
  819257
  489291
  465711
  530294
  533233
  513814
  529703
  529829
  531010
  533392
  533626
  539205
]
2.71 ms
(1.22%)
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
  13181
  311884
  406780
  406933
  410217
  415254
  417333
  419219
  419694
  428424
  434673
  435244
  437561
  441647
  442520
  444029
  447722
  454409
  454895
  457940
  461252
  463385
  464014
  465479
  465711
  465719
  467913
  473740
  475253
  475475
  478303
  478665
  479779
  480413
  484086
  484521
  489291
  491025
  493254
  493818
  494782
  507513
  511548
  511677
  511936
  512397
  513641
  513814
  515013
  515583
  516493
  516719
  518878
  520306
  520323
  520964
  524479
  524753
  524845
  528642
  529703
  529829
  530294
  530315
  531010
  531035
  533233
  533392
  533626
  534148
  539205
  548194
  551824
  552535
  556216
  558205
  559203
  567623
  572245
  578241
  583626
  600898
  604790
  676241
  717321
  732121
  758576
  762820
  769493
  772442
  773552
  774238
  775657
  781494
  784425
  788728
  788858
  789992
  806158
  811620
  812935
  814208
  815691
  816089
  816459
  816738
  816806
  816996
  817927
  817941
  819053
  819183
  819257
  820360
  821977
  822499
  822974
  824471
  826163
  827408
]
1.92 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп спортивная"
]
1.88 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass sport"
]
1.75 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.