GET https://search.jues.net/search/embeds/5?q=put

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
238.19 ms
(89.84%)
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
  154675
  388732
  396093
  399516
  427335
  441476
  446929
  447693
  447972
  450996
  452880
  456819
  457186
  458080
  458561
  460714
  466403
  484747
  485851
  487359
  496120
  500843
  503812
  504740
  506446
  506744
  511338
  517069
  520646
  524454
  525618
  526456
  526497
  527477
  527591
  527618
  528326
  529833
  531647
  534434
  538294
  542505
  547222
  547865
  548966
  552817
  558757
  560979
  561165
  563718
  564188
  565654
  568598
  570182
  576886
  578430
  583737
  583773
  584259
  587851
  588760
  591335
  593890
  596868
  598124
  600788
  605802
  610598
  612179
  613787
  615602
  617698
  619009
  623797
  625477
  631069
  635667
  648387
  689436
  700263
  700722
  702038
  723885
  726523
  727739
  729287
  731111
  737276
  740157
  741656
  742735
  748416
  756294
  759888
  759891
  759900
  760178
  761481
  766818
  768571
  769160
  775697
  777846
  782760
  789594
  789746
  794162
  794654
  796132
  796168
  797806
  797816
  800722
  800880
  806838
  809842
  810719
  811696
  811906
  813917
]
17.94 ms
(6.76%)
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
  700263
  700722
  702038
  558757
  563718
  564188
  612179
  591335
  598124
  600788
  596868
  619009
  593890
  617698
  625477
  631069
  635667
  775697
  796132
  796168
  800880
  811696
  777846
  789594
  794162
  797806
  810719
  811906
  726523
  760178
  766818
  768571
  769160
  789746
  794654
  800722
  731111
  759891
  761481
  723885
  729287
  741656
  737276
  740157
  742735
  759888
  727739
  748416
  756294
  759900
  610598
  782760
  797816
  806838
  809842
  388732
  458080
  466403
  396093
  427335
  452880
  441476
  460714
  527618
  484747
  485851
  517069
  524454
  496120
  525618
  526456
  526497
  506744
  520646
  527477
  154675
  399516
  813917
  450996
  487359
  447693
  447972
  456819
  457186
  446929
  458561
  528326
  534434
  506446
  511338
  500843
  503812
  527591
  504740
  529833
  531647
  538294
  547222
  561165
  570182
  583773
  584259
  547865
  583737
  542505
  548966
  565654
  568598
  576886
  578430
  689436
  648387
  552817
  560979
  605802
  623797
  587851
  588760
  613787
  615602
]
2.69 ms
(1.01%)
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
  154675
  388732
  396093
  399516
  427335
  441476
  446929
  447693
  447972
  450996
  452880
  456819
  457186
  458080
  458561
  460714
  466403
  484747
  485851
  487359
  496120
  500843
  503812
  504740
  506446
  506744
  511338
  517069
  520646
  524454
  525618
  526456
  526497
  527477
  527591
  527618
  528326
  529833
  531647
  534434
  538294
  542505
  547222
  547865
  548966
  552817
  558757
  560979
  561165
  563718
  564188
  565654
  568598
  570182
  576886
  578430
  583737
  583773
  584259
  587851
  588760
  591335
  593890
  596868
  598124
  600788
  605802
  610598
  612179
  613787
  615602
  617698
  619009
  623797
  625477
  631069
  635667
  648387
  689436
  700263
  700722
  702038
  723885
  726523
  727739
  729287
  731111
  737276
  740157
  741656
  742735
  748416
  756294
  759888
  759891
  759900
  760178
  761481
  766818
  768571
  769160
  775697
  777846
  782760
  789594
  789746
  794162
  794654
  796132
  796168
  797806
  797816
  800722
  800880
  806838
  809842
  810719
  811696
  811906
  813917
]
2.02 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "put"
]
1.54 ms
(0.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "put"
]
1.22 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "put"
]

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.