GET https://search.jues.net/search/embeds/6?q=xxx%20free

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.28 ms
(84.82%)
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
  381956
  388281
  401235
  412180
  414184
  416324
  416522
  416683
  416696
  421033
  421199
  422625
  422879
  424481
  425569
  425572
  425875
  426481
  427244
  429033
  433921
  435350
  440052
  440079
  441120
  443797
  455114
  455863
  456162
  458094
  461146
  464737
  466341
  469120
  473051
  473799
  475962
  478471
  483130
  484547
  484879
  487134
  488220
  490208
  490854
  496096
  496585
  496795
  501051
  501131
  501653
  510721
  513160
  513230
  513943
  515413
  517749
  517927
  518032
  522126
  523453
  523705
  524723
  524725
  528751
  533959
  536863
  538221
  538388
  540722
  540899
  540918
  540925
  540932
  542674
  551640
  554394
  557205
  557209
  557992
  563068
  566615
  566653
  568518
  571233
  573587
  573644
  574162
  578198
  592382
  596228
  597152
  601519
  601923
  602926
  602944
  606730
  607608
  616396
  620072
  624191
  628094
  628096
  671400
  679379
  679389
  689622
  693023
  694028
  696598
  741581
  744265
  750876
  764352
  767018
  767025
  786486
  788821
  790930
  791164
]
19.15 ms
(9.89%)
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
  790930
  767018
  788821
  741581
  764352
  601519
  601923
  786486
  424481
  425875
  429033
  433921
  427244
  421033
  455114
  466341
  475962
  523453
  524725
  540722
  484879
  501131
  510721
  518032
  523705
  538388
  540899
  483130
  496795
  501051
  501653
  513230
  536863
  422879
  441120
  412180
  422625
  425569
  416522
  421199
  426481
  435350
  416696
  440079
  455863
  487134
  517927
  522126
  515413
  490854
  554394
  542674
  566615
  568518
  573644
  551640
  573587
  671400
  693023
  694028
  689622
  696598
  566653
  571233
  596228
  592382
  620072
  628094
  616396
  628096
  597152
  602944
  791164
  744265
  750876
  767025
  469120
  381956
  458094
  416683
  478471
  540918
  496096
  524723
  528751
  538221
  488220
  517749
  496585
  540925
  440052
  416324
  425572
  461146
  464737
  513160
  484547
  557209
  557992
  574162
  578198
  557205
  679379
  679389
  563068
  607608
  624191
  602926
  606730
  414184
  456162
  473799
  401235
  473051
  388281
  443797
  490208
  513943
  533959
  540932
]
3.14 ms
(1.62%)
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
  381956
  388281
  401235
  412180
  414184
  416324
  416522
  416683
  416696
  421033
  421199
  422625
  422879
  424481
  425569
  425572
  425875
  426481
  427244
  429033
  433921
  435350
  440052
  440079
  441120
  443797
  455114
  455863
  456162
  458094
  461146
  464737
  466341
  469120
  473051
  473799
  475962
  478471
  483130
  484547
  484879
  487134
  488220
  490208
  490854
  496096
  496585
  496795
  501051
  501131
  501653
  510721
  513160
  513230
  513943
  515413
  517749
  517927
  518032
  522126
  523453
  523705
  524723
  524725
  528751
  533959
  536863
  538221
  538388
  540722
  540899
  540918
  540925
  540932
  542674
  551640
  554394
  557205
  557209
  557992
  563068
  566615
  566653
  568518
  571233
  573587
  573644
  574162
  578198
  592382
  596228
  597152
  601519
  601923
  602926
  602944
  606730
  607608
  616396
  620072
  624191
  628094
  628096
  671400
  679379
  679389
  689622
  693023
  694028
  696598
  741581
  744265
  750876
  764352
  767018
  767025
  786486
  788821
  790930
  791164
]
2.17 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx free"
]
1.87 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx free"
]
1.41 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx free"
]

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.