GET https://search.jues.net/search/embeds/3?q=son%20and%20old

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.31 ms
(87.52%)
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
  181902
  263299
  334847
  346210
  366296
  382184
  383063
  390566
  393102
  393508
  395531
  395688
  395891
  395922
  396982
  397217
  397894
  398224
  400134
  400199
  400481
  400493
  401957
  401971
  402145
  403907
  404644
  407346
  407686
  407703
  407709
  407768
  408437
  408765
  409080
  409093
  414000
  414036
  415809
  421780
  422255
  422345
  422352
  427452
  428547
  428840
  428881
  428920
  432864
  439549
  443149
  443428
  443747
  443970
  443996
  446087
  446269
  446628
  451797
  454029
  454187
  458011
  459131
  460181
  461017
  463216
  464296
  464436
  464963
  468720
  469383
  469466
  472164
  472166
  473492
  474790
  474797
  476268
  476274
  476328
  479177
  480833
  482239
  482255
  482386
  483389
  491281
  493198
  496112
  504104
  520883
  523031
  527658
  547601
  561463
  561590
  563141
  563148
  563436
  563437
  563453
  563455
  565625
  565730
  569970
  589628
  590735
  663451
  706294
  712311
  721724
  726577
  736399
  748228
  748231
  748239
  782626
  794951
  807485
  825114
]
15.47 ms
(7.72%)
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
  397894
  400134
  400481
  454187
  459131
  474790
  334847
  464436
  479177
  346210
  395891
  427452
  474797
  480833
  409093
  523031
  527658
  493198
  520883
  383063
  181902
  393508
  395531
  395688
  366296
  263299
  382184
  396982
  397217
  400199
  403907
  407686
  407703
  407709
  408765
  428547
  414000
  422255
  432864
  428881
  414036
  428920
  443970
  415809
  421780
  422352
  439549
  825114
  446269
  476328
  491281
  446087
  446628
  451797
  460181
  463216
  472166
  458011
  468720
  469383
  482239
  482255
  496112
  504104
  461017
  464296
  464963
  472164
  473492
  476274
  483389
  547601
  561590
  561463
  563436
  563437
  563148
  563455
  663451
  706294
  712311
  721724
  563141
  563453
  565625
  565730
  569970
  589628
  590735
  782626
  794951
  736399
  748228
  748231
  748239
  726577
  807485
  393102
  398224
  401957
  402145
  404644
  409080
  422345
  443149
  443747
  469466
  482386
  390566
  395922
  401971
  407346
  408437
  443428
  476268
  400493
  407768
  428840
  443996
  454029
]
2.72 ms
(1.36%)
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
  181902
  263299
  334847
  346210
  366296
  382184
  383063
  390566
  393102
  393508
  395531
  395688
  395891
  395922
  396982
  397217
  397894
  398224
  400134
  400199
  400481
  400493
  401957
  401971
  402145
  403907
  404644
  407346
  407686
  407703
  407709
  407768
  408437
  408765
  409080
  409093
  414000
  414036
  415809
  421780
  422255
  422345
  422352
  427452
  428547
  428840
  428881
  428920
  432864
  439549
  443149
  443428
  443747
  443970
  443996
  446087
  446269
  446628
  451797
  454029
  454187
  458011
  459131
  460181
  461017
  463216
  464296
  464436
  464963
  468720
  469383
  469466
  472164
  472166
  473492
  474790
  474797
  476268
  476274
  476328
  479177
  480833
  482239
  482255
  482386
  483389
  491281
  493198
  496112
  504104
  520883
  523031
  527658
  547601
  561463
  561590
  563141
  563148
  563436
  563437
  563453
  563455
  565625
  565730
  569970
  589628
  590735
  663451
  706294
  712311
  721724
  726577
  736399
  748228
  748231
  748239
  782626
  794951
  807485
  825114
]
2.08 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "son and old"
]
1.83 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son old"
]
1.25 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son old"
]

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.