GET https://search.jues.net/search/embeds/3?q=sexmachine%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
347.35 ms
(92.43%)
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
  88942
  182110
  182895
  209216
  384463
  386077
  386707
  401806
  402634
  402648
  403215
  413098
  414675
  416007
  417030
  418135
  421518
  429602
  430350
  432335
  432963
  434104
  434306
  434314
  434327
  434339
  439102
  439125
  440639
  440641
  441042
  443224
  443250
  444540
  446225
  448898
  449022
  449173
  450262
  452576
  452876
  454688
  455914
  457814
  458527
  458676
  460382
  466360
  467877
  468151
  468163
  468244
  468665
  469046
  469086
  469139
  469162
  469734
  473873
  475319
  476051
  476052
  476198
  476672
  476674
  476699
  476704
  476847
  481871
  483658
  498200
  499924
  502765
  502770
  509996
  510001
  518892
  521559
  529795
  535367
  545677
  555236
  555771
  559749
  564040
  569728
  570115
  571039
  571386
  593053
  596402
  596478
  602320
  609027
  630470
  638829
  651700
  656803
  660580
  701303
  728039
  731779
  731785
  736872
  738486
  750084
  755942
  756138
  756752
  779747
  782462
  782938
  790463
  790500
  791928
  800540
  806991
  826829
  826832
  827633
]
17.44 ms
(4.64%)
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
  476704
  701303
  791928
  800540
  755942
  756138
  782462
  728039
  736872
  738486
  209216
  402648
  444540
  450262
  509996
  440641
  476051
  473873
  475319
  434327
  518892
  443250
  455914
  476847
  452876
  609027
  467877
  441042
  421518
  416007
  502765
  555236
  555771
  656803
  413098
  448898
  458527
  483658
  402634
  429602
  434339
  434314
  449022
  439125
  386707
  826829
  826832
  468151
  571386
  559749
  660580
  602320
  790463
  806991
  731779
  731785
  782938
  790500
  401806
  481871
  432335
  443224
  446225
  476672
  476699
  469162
  460382
  476198
  469086
  545677
  651700
  569728
  593053
  630470
  596402
  468163
  457814
  432963
  469139
  458676
  468244
  469734
  498200
  510001
  430350
  414675
  468665
  449173
  476674
  440639
  454688
  529795
  521559
  571039
  596478
  756752
  403215
  417030
  434306
  439102
  384463
  88942
  182110
  827633
  535367
  638829
  750084
  779747
  386077
  476052
  499924
  182895
  418135
  434104
  466360
  452576
  502770
  469046
  564040
  570115
]
3.03 ms
(0.81%)
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
  88942
  182110
  182895
  209216
  384463
  386077
  386707
  401806
  402634
  402648
  403215
  413098
  414675
  416007
  417030
  418135
  421518
  429602
  430350
  432335
  432963
  434104
  434306
  434314
  434327
  434339
  439102
  439125
  440639
  440641
  441042
  443224
  443250
  444540
  446225
  448898
  449022
  449173
  450262
  452576
  452876
  454688
  455914
  457814
  458527
  458676
  460382
  466360
  467877
  468151
  468163
  468244
  468665
  469046
  469086
  469139
  469162
  469734
  473873
  475319
  476051
  476052
  476198
  476672
  476674
  476699
  476704
  476847
  481871
  483658
  498200
  499924
  502765
  502770
  509996
  510001
  518892
  521559
  529795
  535367
  545677
  555236
  555771
  559749
  564040
  569728
  570115
  571039
  571386
  593053
  596402
  596478
  602320
  609027
  630470
  638829
  651700
  656803
  660580
  701303
  728039
  731779
  731785
  736872
  738486
  750084
  755942
  756138
  756752
  779747
  782462
  782938
  790463
  790500
  791928
  800540
  806991
  826829
  826832
  827633
]
2.21 ms
(0.59%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.12 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexmachine dildo"
]
2.05 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сексмашин дилд"
]
1.59 ms
(0.42%)
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.