GET https://search.jues.net/search/embeds/6?q=get%20fuck

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.31 ms
(83.11%)
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
  70476
  336986
  386796
  398355
  424287
  427163
  536972
  545166
  550322
  572208
  586104
  589545
  597728
  605203
  606881
  606999
  609241
  611013
  612832
  613784
  615411
  617657
  622411
  625360
  627575
  628191
  629439
  636605
  650886
  656875
  664489
  666386
  666645
  670010
  693367
  697519
  698855
  699309
  704702
  708061
  708584
  709721
  714175
  715000
  715163
  717248
  719856
  720906
  724441
  725602
  725616
  727648
  727853
  728258
  730979
  735029
  736592
  742887
  743400
  744075
  746229
  756871
  758059
  761981
  763064
  763966
  765128
  765411
  767462
  767692
  770331
  770681
  771679
  773662
  776042
  777013
  778283
  778450
  778801
  779004
  781051
  781170
  782016
  784638
  785230
  789073
  792811
  793213
  793910
  793970
  794703
  796178
  797355
  800898
  800914
  802012
  802351
  803926
  803932
  804188
  804666
  804981
  805927
  805978
  806204
  807710
  809177
  810046
  813880
  815932
  816544
  817318
  817963
  819658
  820800
  820809
  824273
  825388
]
13.77 ms
(9.84%)
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
  815932
  550322
  664489
  666645
  719856
  627575
  781170
  793910
  802351
  805978
  725616
  728258
  765128
  773662
  763064
  765411
  727853
  744075
  617657
  697519
  709721
  714175
  800914
  802012
  427163
  386796
  817963
  825388
  817318
  816544
  820800
  820809
  824273
  650886
  666386
  670010
  704702
  720906
  625360
  597728
  622411
  778801
  779004
  779257
  785230
  792811
  809177
  727648
  784638
  806204
  810046
  736592
  770681
  735029
  746229
  742887
  758059
  771679
  770331
  699309
  776042
  782016
  789073
  793970
  796178
  803932
  807710
  398355
  424287
  536972
  572208
  698855
  708061
  656875
  693367
  708584
  545166
  606999
  611013
  613784
  628191
  629439
  589545
  615411
  606881
  612832
  586104
  609241
  636605
  777013
  778283
  778450
  805927
  767692
  773292
  793213
  800898
  803926
  804666
  804981
  724441
  730979
  756871
  767462
  761981
  725602
  743400
  763966
  605203
  715000
  715163
  717248
  781051
  797355
  70476
  794703
  819658
  804188
  336986
  813880
]
2.73 ms
(1.95%)
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
  70476
  336986
  386796
  398355
  424287
  427163
  536972
  545166
  550322
  572208
  586104
  589545
  597728
  605203
  606881
  606999
  609241
  611013
  612832
  613784
  615411
  617657
  622411
  625360
  627575
  628191
  629439
  636605
  650886
  656875
  664489
  666386
  666645
  670010
  693367
  697519
  698855
  699309
  704702
  708061
  708584
  709721
  714175
  715000
  715163
  717248
  719856
  720906
  724441
  725602
  725616
  727648
  727853
  728258
  730979
  735029
  736592
  742887
  743400
  744075
  746229
  756871
  758059
  761981
  763064
  763966
  765128
  765411
  767462
  767692
  770331
  770681
  771679
  773662
  776042
  777013
  778283
  778450
  778801
  779004
  781051
  781170
  782016
  784638
  785230
  789073
  792811
  793213
  793910
  793970
  794703
  796178
  797355
  800898
  800914
  802012
  802351
  803926
  803932
  804188
  804666
  804981
  805927
  805978
  806204
  807710
  809177
  810046
  813880
  815932
  816544
  817318
  817963
  819658
  820800
  820809
  824273
  825388
]
2.13 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "get fuck"
]
1.73 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "get секс"
]
1.63 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "get секс"
]

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.