GET https://search.jues.net/search/embeds/7?q=russian%20car%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.15 ms
(88.87%)
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
  233369
  250215
  382381
  384948
  437982
  439640
  443358
  443607
  443892
  446970
  451453
  451589
  455247
  455733
  462118
  466550
  469855
  470589
  470724
  473799
  474248
  475587
  479988
  480916
  481134
  485353
  485872
  486360
  488888
  490267
  491886
  496175
  502376
  504355
  513920
  514066
  517287
  520260
  522059
  522236
  522728
  524984
  525413
  527609
  534111
  542215
  543587
  551516
  551876
  552471
  564071
  565455
  567698
  575424
  578115
  581965
  585094
  587431
  587886
  588937
  590468
  597283
  597543
  598609
  598757
  599819
  602792
  603744
  611497
  613951
  615506
  618303
  619557
  620667
  620692
  625968
  631358
  638962
  663341
  668353
  673326
  685065
  689574
  705368
  707610
  710614
  715675
  719471
  751316
  756314
  764762
  764879
  765146
  765156
  765507
  765806
  768456
  770567
  778724
  779378
  779490
  779494
  780831
  785978
  786309
  788054
  788102
  788440
  788901
  793202
  793922
  794791
  799015
  799886
  810888
  818828
  821569
  822652
  823269
  825710
]
12.90 ms
(6.23%)
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
  513920
  825710
  462118
  707610
  615506
  765146
  764762
  779378
  793202
  439640
  821569
  799015
  437982
  443607
  486360
  517287
  585094
  818828
  768456
  520260
  564071
  619557
  597543
  611497
  785978
  799886
  770567
  788054
  765806
  514066
  823269
  719471
  597283
  765507
  715675
  384948
  470724
  551516
  567698
  469855
  522236
  488888
  446970
  502376
  668353
  565455
  778724
  793922
  751316
  473799
  587886
  552471
  620692
  470589
  522059
  481134
  786309
  822652
  638962
  620667
  490267
  673326
  689574
  590468
  764879
  480916
  575424
  527609
  598757
  788102
  810888
  451453
  625968
  534111
  780831
  581965
  613951
  603744
  524984
  588937
  602792
  233369
  598609
  525413
  479988
  455247
  496175
  543587
  551876
  599819
  788440
  788901
  451589
  663341
  618303
  631358
  794791
  756314
  475587
  443892
  578115
  705368
  443358
  382381
  491886
  466550
  522728
  485353
  474248
  485872
  542215
  779490
  710614
  504355
  685065
  587431
  765156
  779494
  455733
  250215
]
2.39 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian car sex"
]
2.31 ms
(1.12%)
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
  233369
  250215
  382381
  384948
  437982
  439640
  443358
  443607
  443892
  446970
  451453
  451589
  455247
  455733
  462118
  466550
  469855
  470589
  470724
  473799
  474248
  475587
  479988
  480916
  481134
  485353
  485872
  486360
  488888
  490267
  491886
  496175
  502376
  504355
  513920
  514066
  517287
  520260
  522059
  522236
  522728
  524984
  525413
  527609
  534111
  542215
  543587
  551516
  551876
  552471
  564071
  565455
  567698
  575424
  578115
  581965
  585094
  587431
  587886
  588937
  590468
  597283
  597543
  598609
  598757
  599819
  602792
  603744
  611497
  613951
  615506
  618303
  619557
  620667
  620692
  625968
  631358
  638962
  663341
  668353
  673326
  685065
  689574
  705368
  707610
  710614
  715675
  719471
  751316
  756314
  764762
  764879
  765146
  765156
  765507
  765806
  768456
  770567
  778724
  779378
  779490
  779494
  780831
  785978
  786309
  788054
  788102
  788440
  788901
  793202
  793922
  794791
  799015
  799886
  810888
  818828
  821569
  822652
  823269
  825710
]
1.92 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск вмашин секс"
]
1.80 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск вмашин секс"
]
1.72 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.