GET https://search.jues.net/search/embeds/9?q=xxx%20sport

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.71 ms
(81.99%)
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
  307940
  393697
  402777
  411228
  414329
  417428
  421009
  424098
  425102
  437582
  438934
  439899
  445764
  447090
  447775
  448842
  450867
  454462
  454798
  456302
  457327
  457877
  457898
  458111
  458513
  460997
  461215
  463381
  464010
  465122
  467942
  469931
  471173
  471409
  472070
  476029
  477488
  477516
  477973
  478609
  479485
  480895
  485586
  486710
  487674
  487775
  488769
  492225
  492230
  493483
  494406
  496083
  497399
  497485
  498311
  500314
  502674
  502756
  506861
  508744
  509303
  510138
  510189
  511999
  514731
  514978
  515465
  515522
  515537
  515632
  515652
  516369
  516915
  517370
  517564
  517772
  517905
  517957
  519281
  519736
  520036
  520793
  521841
  521890
  521896
  522302
  522524
  522766
  523700
  525328
  526167
  526289
  526315
  526505
  526649
  526770
  526814
  526945
  527262
  528092
  528975
  529769
  531069
  532652
  535462
  535473
  577322
  601650
  641090
  816723
  816848
  816859
  818205
  819100
  819101
  820044
  820503
  823894
  825653
  828728
]
15.27 ms
(10.73%)
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
  439899
  447090
  447775
  450867
  454798
  461215
  465122
  471173
  472070
  477516
  477973
  478609
  402777
  414329
  424098
  437582
  445764
  454462
  457327
  457877
  457898
  458513
  460997
  463381
  464010
  469931
  479485
  480895
  417428
  421009
  425102
  456302
  458111
  467942
  471409
  476029
  477488
  500314
  506861
  509303
  511999
  514731
  515465
  515632
  516915
  517905
  519736
  521890
  521896
  522524
  522766
  523700
  526315
  526770
  526945
  529769
  492225
  492230
  496083
  497485
  502674
  502756
  510138
  515522
  515537
  517370
  517772
  520036
  522302
  526649
  527262
  535473
  486710
  488769
  494406
  498311
  514978
  516369
  517957
  519281
  521841
  525328
  526167
  526505
  531069
  485586
  487674
  487775
  493483
  497399
  508744
  510189
  515652
  526289
  528092
  528975
  535462
  438934
  448842
  577322
  601650
  641090
  307940
  517564
  520793
  526814
  393697
  411228
  816859
  819100
  816723
  819101
  816848
  820044
  823894
  818205
  820503
  825653
  828728
  532652
]
2.67 ms
(1.88%)
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
  307940
  393697
  402777
  411228
  414329
  417428
  421009
  424098
  425102
  437582
  438934
  439899
  445764
  447090
  447775
  448842
  450867
  454462
  454798
  456302
  457327
  457877
  457898
  458111
  458513
  460997
  461215
  463381
  464010
  465122
  467942
  469931
  471173
  471409
  472070
  476029
  477488
  477516
  477973
  478609
  479485
  480895
  485586
  486710
  487674
  487775
  488769
  492225
  492230
  493483
  494406
  496083
  497399
  497485
  498311
  500314
  502674
  502756
  506861
  508744
  509303
  510138
  510189
  511999
  514731
  514978
  515465
  515522
  515537
  515632
  515652
  516369
  516915
  517370
  517564
  517772
  517905
  517957
  519281
  519736
  520036
  520793
  521841
  521890
  521896
  522302
  522524
  522766
  523700
  525328
  526167
  526289
  526315
  526505
  526649
  526770
  526814
  526945
  527262
  528092
  528975
  529769
  531069
  532652
  535462
  535473
  577322
  601650
  641090
  816723
  816848
  816859
  818205
  819100
  819101
  820044
  820503
  823894
  825653
  828728
]
2.60 ms
(1.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx sport"
]
1.90 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx спортивная"
]
1.44 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx спортивная"
]

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.