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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.31 ms
(85.17%)
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
  83499
  117831
  188610
  393039
  398040
  398689
  401814
  409151
  409379
  410128
  413262
  414702
  424744
  429252
  433964
  443949
  451579
  451584
  453084
  458795
  461321
  462297
  469840
  474551
  478086
  481291
  487173
  489166
  493043
  500277
  504729
  504745
  507132
  514700
  514941
  516066
  522402
  522644
  525516
  525647
  526487
  533867
  534039
  546840
  547464
  548619
  551180
  551942
  556311
  559115
  559204
  564951
  579685
  584014
  585397
  595778
  603574
  606053
  609799
  611573
  616629
  618005
  620240
  622690
  623221
  626291
  630194
  635480
  637437
  644327
  649129
  649135
  649847
  651630
  653720
  658469
  659078
  659258
  661262
  661943
  664193
  669045
  670097
  670761
  671724
  672130
  672181
  674514
  677564
  688262
  689645
  693539
  694221
  695924
  703537
  703547
  705516
  705537
  707292
  708775
  710509
  717731
  717849
  718529
  720467
  720481
  721990
  753051
  756091
  759470
  774209
  775492
  775775
  798703
  807847
  811936
  813460
  815298
  815505
  827897
]
14.90 ms
(8.79%)
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
  649129
  649135
  630194
  525516
  807847
  623221
  398040
  815505
  551942
  653720
  661943
  672130
  659078
  622690
  827897
  669045
  664193
  756091
  661262
  547464
  618005
  584014
  522644
  616629
  401814
  514700
  429252
  649847
  413262
  83499
  117831
  433964
  409379
  658469
  611573
  753051
  393039
  546840
  526487
  677564
  717731
  710509
  443949
  451584
  525647
  514941
  774209
  533867
  798703
  478086
  462297
  522402
  559204
  595778
  620240
  717849
  493043
  458795
  461321
  813460
  500277
  579685
  516066
  585397
  693539
  424744
  559115
  489166
  188610
  414702
  551180
  811936
  708775
  469840
  635480
  775492
  410128
  474551
  670097
  672181
  720481
  556311
  705516
  674514
  548619
  451579
  534039
  481291
  659258
  487173
  504729
  703537
  707292
  718529
  720467
  671724
  504745
  721990
  689645
  694221
  705537
  637437
  644327
  398689
  409151
  453084
  670761
  688262
  775775
  759470
  603574
  626291
  703547
  507132
  815298
  564951
  651630
  695924
  606053
  609799
]
2.66 ms
(1.57%)
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
  83499
  117831
  188610
  393039
  398040
  398689
  401814
  409151
  409379
  410128
  413262
  414702
  424744
  429252
  433964
  443949
  451579
  451584
  453084
  458795
  461321
  462297
  469840
  474551
  478086
  481291
  487173
  489166
  493043
  500277
  504729
  504745
  507132
  514700
  514941
  516066
  522402
  522644
  525516
  525647
  526487
  533867
  534039
  546840
  547464
  548619
  551180
  551942
  556311
  559115
  559204
  564951
  579685
  584014
  585397
  595778
  603574
  606053
  609799
  611573
  616629
  618005
  620240
  622690
  623221
  626291
  630194
  635480
  637437
  644327
  649129
  649135
  649847
  651630
  653720
  658469
  659078
  659258
  661262
  661943
  664193
  669045
  670097
  670761
  671724
  672130
  672181
  674514
  677564
  688262
  689645
  693539
  694221
  695924
  703537
  703547
  705516
  705537
  707292
  708775
  710509
  717731
  717849
  718529
  720467
  720481
  721990
  753051
  756091
  759470
  774209
  775492
  775775
  798703
  807847
  811936
  813460
  815298
  815505
  827897
]
2.17 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex public security"
]
1.93 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс на security улиц"
]
1.59 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс на security улиц"
]

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.