GET https://search.jues.net/search/embeds/9?q=sex%20white

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.99 ms
(84.29%)
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
  3976
  28197
  74181
  109012
  214238
  270932
  365295
  384053
  384188
  384545
  386662
  395523
  396268
  402398
  424910
  459536
  460142
  461127
  472077
  483349
  483758
  486067
  488513
  492372
  496727
  497056
  504242
  510145
  512981
  516019
  517747
  518314
  519253
  523921
  525168
  525528
  525642
  527325
  529611
  529629
  529743
  530070
  530461
  531665
  531667
  531942
  532112
  532706
  533162
  533208
  534022
  534134
  534908
  535843
  536079
  537683
  537817
  538179
  538954
  539182
  539357
  540103
  541932
  541954
  542570
  542819
  542848
  543132
  548832
  551693
  579057
  588562
  600659
  604037
  626783
  632483
  647278
  648572
  665897
  702115
  702116
  702943
  706667
  723067
  725621
  730437
  733361
  738875
  739879
  741436
  741802
  741890
  745154
  748618
  748912
  758159
  760778
  783386
  798381
  813779
  814761
  814941
  815908
  815920
  816941
  817428
  818655
  820585
  820901
  820954
  821241
  821692
  821984
  822045
  822249
  822386
  823414
  823482
  823485
  823517
]
13.86 ms
(8.72%)
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
  516019
  523921
  529629
  530461
  537683
  538179
  517747
  525168
  529611
  529743
  533208
  538954
  540103
  504242
  512981
  527325
  530070
  531665
  533162
  536079
  472077
  483758
  486067
  542570
  542848
  541932
  541954
  548832
  551693
  702115
  647278
  648572
  702116
  706667
  723067
  665897
  702943
  579057
  588562
  626783
  632483
  600659
  604037
  798381
  760778
  783386
  748912
  725621
  730437
  733361
  738875
  741890
  745154
  748618
  741802
  739879
  741436
  758159
  270932
  459536
  214238
  386662
  395523
  384053
  74181
  384188
  384545
  109012
  365295
  28197
  3976
  396268
  402398
  424910
  814761
  816941
  817428
  822386
  814941
  820954
  821692
  823482
  813779
  818655
  820585
  820901
  821984
  823485
  815908
  815920
  821241
  822045
  822249
  823414
  823517
  492372
  488513
  483349
  510145
  518314
  532706
  534022
  534134
  534908
  497056
  525528
  531942
  532112
  539182
  535843
  496727
  519253
  525642
  531667
  537817
  539357
  460142
  461127
  542819
  543132
]
3.16 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
  3976
  28197
  74181
  109012
  214238
  270932
  365295
  384053
  384188
  384545
  386662
  395523
  396268
  402398
  424910
  459536
  460142
  461127
  472077
  483349
  483758
  486067
  488513
  492372
  496727
  497056
  504242
  510145
  512981
  516019
  517747
  518314
  519253
  523921
  525168
  525528
  525642
  527325
  529611
  529629
  529743
  530070
  530461
  531665
  531667
  531942
  532112
  532706
  533162
  533208
  534022
  534134
  534908
  535843
  536079
  537683
  537817
  538179
  538954
  539182
  539357
  540103
  541932
  541954
  542570
  542819
  542848
  543132
  548832
  551693
  579057
  588562
  600659
  604037
  626783
  632483
  647278
  648572
  665897
  702115
  702116
  702943
  706667
  723067
  725621
  730437
  733361
  738875
  739879
  741436
  741802
  741890
  745154
  748618
  748912
  758159
  760778
  783386
  798381
  813779
  814761
  814941
  815908
  815920
  816941
  817428
  818655
  820585
  820901
  820954
  821241
  821692
  821984
  822045
  822249
  822386
  823414
  823482
  823485
  823517
]
2.45 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex white"
]
2.08 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс white"
]
1.73 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.