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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.84 ms
(85.19%)
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
  65811
  109233
  264846
  280512
  385783
  409984
  414340
  419850
  428383
  428469
  438029
  440274
  440747
  454504
  458962
  461244
  465435
  466551
  469153
  479724
  480515
  482207
  488984
  494279
  495499
  496115
  513136
  513202
  517486
  519600
  521447
  523972
  530403
  533055
  533179
  533617
  533635
  533675
  533778
  534691
  535410
  537722
  537759
  540113
  541173
  541906
  542623
  543589
  543752
  543955
  545152
  546307
  550039
  555388
  558971
  565826
  566798
  573916
  574630
  575004
  575029
  575278
  579003
  584980
  594872
  622472
  622681
  628656
  637765
  641444
  648659
  649119
  655548
  667230
  669196
  670839
  672417
  685527
  695671
  698784
  698994
  701204
  703498
  704351
  707281
  709552
  710405
  736489
  736531
  744551
  754212
  760863
  765534
  768017
  774050
  789078
  795913
  798169
  804323
  812285
  814277
  814540
  816987
  817375
  817424
  817776
  818646
  819027
  819066
  819081
  819804
  819904
  823592
  827860
  828070
  828215
  828219
  828257
  828326
  828332
]
15.12 ms
(8.06%)
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
  707281
  594872
  641444
  798169
  789078
  736531
  760863
  765534
  768017
  804323
  465435
  409984
  414340
  428383
  533179
  565826
  701204
  667230
  685527
  695671
  575278
  795913
  736489
  774050
  622472
  519600
  670839
  440274
  461244
  488984
  428469
  812285
  744551
  703498
  698784
  545152
  480515
  495499
  698994
  438029
  109233
  458962
  523972
  466551
  535410
  385783
  469153
  542623
  704351
  814277
  814540
  543589
  709552
  669196
  754212
  419850
  672417
  622681
  710405
  494279
  513202
  555388
  280512
  440747
  584980
  521447
  574630
  628656
  637765
  454504
  482207
  513136
  496115
  264846
  65811
  817375
  819904
  816987
  817776
  819027
  819804
  823592
  818646
  819066
  819081
  817424
  828219
  827860
  828257
  828326
  828332
  828215
  828070
  479724
  530403
  533617
  533635
  533778
  534691
  533055
  533675
  537722
  537759
  517486
  540113
  558971
  573916
  575029
  541173
  543752
  546307
  550039
  541906
  543955
  566798
  575004
  579003
  648659
  649119
  655548
]
4.15 ms
(2.21%)
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
  65811
  109233
  264846
  280512
  385783
  409984
  414340
  419850
  428383
  428469
  438029
  440274
  440747
  454504
  458962
  461244
  465435
  466551
  469153
  479724
  480515
  482207
  488984
  494279
  495499
  496115
  513136
  513202
  517486
  519600
  521447
  523972
  530403
  533055
  533179
  533617
  533635
  533675
  533778
  534691
  535410
  537722
  537759
  540113
  541173
  541906
  542623
  543589
  543752
  543955
  545152
  546307
  550039
  555388
  558971
  565826
  566798
  573916
  574630
  575004
  575029
  575278
  579003
  584980
  594872
  622472
  622681
  628656
  637765
  641444
  648659
  649119
  655548
  667230
  669196
  670839
  672417
  685527
  695671
  698784
  698994
  701204
  703498
  704351
  707281
  709552
  710405
  736489
  736531
  744551
  754212
  760863
  765534
  768017
  774050
  789078
  795913
  798169
  804323
  812285
  814277
  814540
  816987
  817375
  817424
  817776
  818646
  819027
  819066
  819081
  819804
  819904
  823592
  827860
  828070
  828215
  828219
  828257
  828326
  828332
]
2.36 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass public"
]
2.28 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп на улиц"
]
1.81 ms
(0.96%)
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.