GET https://search.jues.net/search/embeds/9?q=son%20long

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.67 ms
(80.59%)
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
  410806
  416408
  421813
  421841
  421856
  421859
  421868
  421876
  421881
  421892
  421927
  421954
  422166
  422168
  422185
  422191
  422192
  422200
  422204
  426865
  428102
  428514
  429089
  434003
  435934
  437314
  437497
  437583
  439633
  439638
  439666
  439670
  439674
  439678
  439687
  439710
  439770
  440222
  440631
  442122
  442814
  445393
  445615
  446132
  454411
  454421
  454423
  457435
  460197
  460751
  462466
  463630
  464438
  464890
  466049
  466429
  467294
  468884
  469391
  471589
  472679
  474610
  475224
  475632
  477156
  479114
  482248
  484775
  489941
  491988
  493158
  500469
  502305
  505822
  505826
  509382
  510518
  512212
  516226
  519929
  520695
  521520
  523779
  523824
  523907
  524284
  524637
  525152
  526517
  526523
  527017
  531685
  531996
  532012
  532689
  534228
  537123
  543794
  544420
  549822
  549828
  549848
  563438
  564173
  564378
  565626
  565782
  566257
  577051
  580038
  587072
  591296
  592951
  598999
  603055
  624288
  665518
  679709
  682181
]
17.60 ms
(11.85%)
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
  527017
  457435
  566257
  422200
  475632
  428514
  429089
  410806
  428102
  435934
  422191
  434003
  445615
  464890
  489941
  446132
  464438
  467294
  471589
  477156
  454423
  500469
  505826
  531996
  532012
  523779
  502305
  505822
  509382
  516226
  520695
  524284
  532689
  534228
  512212
  531685
  537123
  460197
  484775
  543794
  544420
  563438
  565626
  559076
  564173
  679709
  665518
  682181
  549822
  549828
  549848
  564378
  565782
  577051
  580038
  592951
  587072
  591296
  603055
  598999
  624288
  421813
  422168
  437314
  439670
  439678
  462466
  463630
  475224
  421856
  421868
  421892
  421954
  439674
  439687
  445393
  460751
  479114
  421841
  421859
  421881
  421927
  422185
  437497
  439666
  439710
  466429
  416408
  421876
  422166
  422204
  426865
  437583
  439633
  439638
  439770
  440222
  440631
  442122
  442814
  454411
  454421
  469391
  472679
  474610
  422192
  466049
  468884
  482248
  519929
  521520
  523907
  525152
  526523
  493158
  510518
  523824
  524637
  526517
  491988
]
3.41 ms
(2.30%)
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
  410806
  416408
  421813
  421841
  421856
  421859
  421868
  421876
  421881
  421892
  421927
  421954
  422166
  422168
  422185
  422191
  422192
  422200
  422204
  426865
  428102
  428514
  429089
  434003
  435934
  437314
  437497
  437583
  439633
  439638
  439666
  439670
  439674
  439678
  439687
  439710
  439770
  440222
  440631
  442122
  442814
  445393
  445615
  446132
  454411
  454421
  454423
  457435
  460197
  460751
  462466
  463630
  464438
  464890
  466049
  466429
  467294
  468884
  469391
  471589
  472679
  474610
  475224
  475632
  477156
  479114
  482248
  484775
  489941
  491988
  493158
  500469
  502305
  505822
  505826
  509382
  510518
  512212
  516226
  519929
  520695
  521520
  523779
  523824
  523907
  524284
  524637
  525152
  526517
  526523
  527017
  531685
  531996
  532012
  532689
  534228
  537123
  543794
  544420
  549822
  549828
  549848
  563438
  564173
  564378
  565626
  565782
  566257
  577051
  580038
  587072
  591296
  592951
  598999
  603055
  624288
  665518
  679709
  682181
]
2.26 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "son long"
]
1.92 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son длинные"
]
1.87 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son длинные"
]

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.