GET https://search.jues.net/search/embeds/5?q=body%20to%20body

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.98 ms
(83.79%)
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
  7741
  188293
  382158
  386996
  392388
  397145
  427749
  429298
  441802
  501118
  513935
  527838
  529765
  532536
  538771
  539983
  542905
  545349
  547715
  548026
  550682
  552092
  553884
  555503
  556261
  558403
  565970
  566596
  567295
  570852
  577293
  579234
  583656
  587663
  589428
  589857
  589922
  589991
  590048
  596969
  599407
  606000
  615277
  617775
  619600
  620029
  622986
  629001
  629099
  632075
  634249
  636261
  636747
  637470
  643777
  644623
  645400
  650113
  652274
  652926
  662437
  662512
  676408
  681388
  683766
  693250
  697853
  709036
  709061
  709090
  711606
  713667
  719535
  720791
  723807
  725353
  734472
  739222
  744170
  776467
  778350
  780249
  781055
  782430
  783952
  784340
  788124
  790314
  791010
  791598
  796607
  796927
  799075
  799821
  799892
  801245
  802760
  802935
  803118
  804039
  804737
  804954
  805160
  808070
  808740
  811126
  811147
  811338
  813616
  814278
  815781
  816143
  816804
  816815
  818910
  819197
  821231
  821760
  825572
]
14.50 ms
(10.05%)
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
  791010
  796607
  796927
  802935
  803118
  804039
  804954
  808070
  188293
  386996
  392388
  382158
  7741
  397145
  441802
  427749
  429298
  825572
  813616
  816143
  816804
  819197
  814278
  815781
  816815
  818910
  821231
  821760
  539983
  527838
  513935
  532536
  538771
  501118
  529765
  547715
  552092
  553884
  558403
  565970
  577293
  542905
  545349
  550682
  555503
  570852
  548026
  556261
  567295
  645400
  652926
  693250
  697853
  709036
  720791
  650113
  652274
  662437
  676408
  713667
  662512
  681388
  683766
  709061
  709090
  711606
  719535
  566596
  579234
  583656
  587663
  589428
  589991
  590048
  599407
  606000
  615277
  629001
  636261
  644623
  589857
  589922
  622986
  629099
  637470
  643777
  607641
  619600
  620029
  632075
  636747
  596969
  617775
  634249
  776467
  780249
  781055
  790314
  791598
  799075
  799821
  799892
  811126
  811147
  778350
  788124
  801245
  723807
  725353
  734472
  739222
  744170
  782430
  783952
  784340
  802760
  804737
  805160
  808740
  811338
]
2.43 ms
(1.68%)
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
  7741
  188293
  382158
  386996
  392388
  397145
  427749
  429298
  441802
  501118
  513935
  527838
  529765
  532536
  538771
  539983
  542905
  545349
  547715
  548026
  550682
  552092
  553884
  555503
  556261
  558403
  565970
  566596
  567295
  570852
  577293
  579234
  583656
  587663
  589428
  589857
  589922
  589991
  590048
  596969
  599407
  606000
  615277
  617775
  619600
  620029
  622986
  629001
  629099
  632075
  634249
  636261
  636747
  637470
  643777
  644623
  645400
  650113
  652274
  652926
  662437
  662512
  676408
  681388
  683766
  693250
  697853
  709036
  709061
  709090
  711606
  713667
  719535
  720791
  723807
  725353
  734472
  739222
  744170
  776467
  778350
  780249
  781055
  782430
  783952
  784340
  788124
  790314
  791010
  791598
  796607
  796927
  799075
  799821
  799892
  801245
  802760
  802935
  803118
  804039
  804737
  804954
  805160
  808070
  808740
  811126
  811147
  811338
  813616
  814278
  815781
  816143
  816804
  816815
  818910
  819197
  821231
  821760
  825572
]
1.85 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "body to body"
]
1.76 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "body body"
]
1.49 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "body body"
]

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.