GET https://search.jues.net/search/embeds/3?q=russian%20doggy%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.00 ms
(83.61%)
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
  55731
  187723
  233340
  233517
  233915
  324288
  384338
  387012
  388772
  389587
  390858
  391251
  391767
  392036
  396201
  398930
  400861
  400923
  401757
  402931
  403321
  404201
  421590
  421648
  421824
  421865
  421883
  421894
  423913
  424105
  424121
  426865
  426994
  435512
  439802
  441288
  443913
  443924
  444910
  445256
  447130
  447981
  448082
  454726
  455787
  456239
  457443
  459837
  462763
  463874
  464250
  465878
  465971
  466898
  469587
  469613
  470012
  470062
  470090
  470137
  470284
  471346
  472679
  474567
  477543
  478377
  478385
  479549
  481447
  486578
  487468
  490235
  490278
  493610
  493681
  496164
  498081
  500289
  506866
  511811
  513052
  514445
  524718
  524780
  535437
  535439
  537972
  538011
  549540
  552285
  552294
  576214
  584706
  588878
  591042
  591977
  595440
  597560
  604217
  634532
  685400
  685429
  685437
  696128
  705461
  713420
  722925
  762272
  768715
  782131
  782184
  782515
  790446
  794071
  799805
  799914
  804814
  819269
  826827
  828555
]
16.59 ms
(10.51%)
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
  463874
  464250
  471346
  524718
  487468
  493610
  685437
  794071
  187723
  396201
  400923
  470062
  447130
  388772
  462763
  478385
  392036
  444910
  549540
  391767
  421865
  426865
  506866
  400861
  435512
  511811
  470284
  576214
  584706
  588878
  604217
  403321
  404201
  477543
  479549
  448082
  233340
  424105
  478377
  441288
  445256
  469613
  490278
  513052
  486578
  496164
  233517
  535437
  470090
  595440
  762272
  457443
  685429
  782515
  384338
  421824
  535439
  459837
  447981
  790446
  768715
  634532
  324288
  696128
  421648
  481447
  826827
  685400
  390858
  398930
  552294
  591977
  591042
  455787
  439802
  470137
  424121
  456239
  469587
  490235
  538011
  500289
  514445
  474567
  552285
  401757
  402931
  423913
  421883
  465878
  55731
  597560
  782131
  426994
  391251
  722925
  466898
  705461
  233915
  819269
  387012
  443924
  498081
  421894
  472679
  421590
  465971
  454726
  470012
  828555
  493681
  799914
  804814
  443913
  537972
  713420
  799805
  389587
  524780
  782184
]
2.76 ms
(1.75%)
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
  55731
  187723
  233340
  233517
  233915
  324288
  384338
  387012
  388772
  389587
  390858
  391251
  391767
  392036
  396201
  398930
  400861
  400923
  401757
  402931
  403321
  404201
  421590
  421648
  421824
  421865
  421883
  421894
  423913
  424105
  424121
  426865
  426994
  435512
  439802
  441288
  443913
  443924
  444910
  445256
  447130
  447981
  448082
  454726
  455787
  456239
  457443
  459837
  462763
  463874
  464250
  465878
  465971
  466898
  469587
  469613
  470012
  470062
  470090
  470137
  470284
  471346
  472679
  474567
  477543
  478377
  478385
  479549
  481447
  486578
  487468
  490235
  490278
  493610
  493681
  496164
  498081
  500289
  506866
  511811
  513052
  514445
  524718
  524780
  535437
  535439
  537972
  538011
  549540
  552285
  552294
  576214
  584706
  588878
  591042
  591977
  595440
  597560
  604217
  634532
  685400
  685429
  685437
  696128
  705461
  713420
  722925
  762272
  768715
  782131
  782184
  782515
  790446
  794071
  799805
  799914
  804814
  819269
  826827
  828555
]
1.91 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian doggy anal"
]
1.63 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск рак анал"
]
1.47 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.