GET https://search.jues.net/search/embeds/7?q=white%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.41 ms
(84.73%)
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
  30680
  91570
  209790
  384350
  384518
  385007
  385851
  392480
  392918
  393886
  393980
  396765
  396864
  397802
  399061
  402020
  403400
  404272
  405987
  418710
  420736
  431897
  444603
  451608
  454648
  459708
  463596
  463709
  467366
  471504
  472267
  472463
  473042
  473484
  473997
  478091
  479918
  481193
  483573
  489234
  489546
  490291
  490699
  491011
  492313
  493004
  494740
  497174
  499780
  500892
  501457
  501541
  502063
  505142
  506707
  508197
  509021
  510197
  510830
  514237
  514405
  514976
  516702
  517254
  517608
  518527
  520039
  523072
  523338
  525052
  525305
  525856
  527374
  530047
  531909
  532304
  533612
  536381
  536991
  537215
  537678
  538099
  539260
  540892
  543085
  587303
  614881
  617526
  629260
  640672
  665741
  692510
  697352
  702106
  705359
  705362
  705471
  722463
  731679
  755840
  757112
  762912
  813291
  815424
  815660
  815894
  816296
  816459
  816759
  816918
  816967
  817141
  818771
  821095
  822631
  822683
  823307
  823343
  828824
  828828
]
15.75 ms
(9.44%)
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
  536381
  385851
  393886
  392480
  392918
  91570
  30680
  418710
  431897
  478091
  479918
  451608
  471504
  490291
  459708
  467366
  472267
  473484
  483573
  499780
  501457
  502063
  523338
  531909
  533612
  537678
  538099
  497174
  500892
  505142
  509021
  510197
  510830
  517608
  520039
  523072
  525305
  525856
  537215
  514405
  514976
  516702
  517254
  518527
  525052
  530047
  532304
  494740
  501541
  506707
  508197
  514237
  527374
  536991
  539260
  490699
  543085
  665741
  692510
  702106
  705359
  705362
  705471
  640672
  587303
  614881
  617526
  731679
  755840
  757112
  762912
  629260
  697352
  722463
  813291
  384350
  405987
  396864
  385007
  403400
  454648
  463709
  444603
  384518
  209790
  393980
  396765
  397802
  399061
  402020
  404272
  420736
  815424
  815660
  816918
  540892
  815894
  816759
  817141
  818771
  816459
  816967
  821095
  822683
  823343
  816296
  822631
  823307
  828828
  828824
  489234
  489546
  463596
  472463
  473042
  473997
  481193
  491011
  492313
  493004
]
2.53 ms
(1.51%)
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
  30680
  91570
  209790
  384350
  384518
  385007
  385851
  392480
  392918
  393886
  393980
  396765
  396864
  397802
  399061
  402020
  403400
  404272
  405987
  418710
  420736
  431897
  444603
  451608
  454648
  459708
  463596
  463709
  467366
  471504
  472267
  472463
  473042
  473484
  473997
  478091
  479918
  481193
  483573
  489234
  489546
  490291
  490699
  491011
  492313
  493004
  494740
  497174
  499780
  500892
  501457
  501541
  502063
  505142
  506707
  508197
  509021
  510197
  510830
  514237
  514405
  514976
  516702
  517254
  517608
  518527
  520039
  523072
  523338
  525052
  525305
  525856
  527374
  530047
  531909
  532304
  533612
  536381
  536991
  537215
  537678
  538099
  539260
  540892
  543085
  587303
  614881
  617526
  629260
  640672
  665741
  692510
  697352
  702106
  705359
  705362
  705471
  722463
  731679
  755840
  757112
  762912
  813291
  815424
  815660
  815894
  816296
  816459
  816759
  816918
  816967
  817141
  818771
  821095
  822631
  822683
  823307
  823343
  828824
  828828
]
1.98 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white ass"
]
1.76 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white жоп"
]
1.76 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white жоп"
]

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.