GET https://search.jues.net/search/embeds/7?q=%D1%82%D0%B0%D1%82%D1%83%20%D1%80%D0%B0%D0%BA%D0%BE%D0%BC

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
193.57 ms
(86.82%)
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
  9734
  21731
  33236
  61726
  205147
  327338
  381849
  383500
  383547
  385600
  385759
  386097
  387046
  395226
  396139
  398448
  414960
  417067
  417847
  418193
  420193
  424918
  425648
  426085
  426703
  433755
  437233
  437996
  442025
  443493
  446777
  448090
  450183
  452662
  452795
  454368
  455809
  468437
  469114
  470120
  473194
  473388
  477759
  478385
  481262
  490235
  493819
  501679
  509654
  510068
  510783
  513528
  513530
  513550
  514020
  514050
  514111
  517800
  519446
  520587
  521432
  521478
  523539
  526984
  528584
  534007
  540898
  544906
  546772
  549726
  553014
  559426
  560867
  562986
  565585
  565722
  567198
  571359
  573023
  576184
  580928
  591042
  591977
  592198
  592282
  605903
  640469
  646307
  646673
  653820
  665745
  688403
  695158
  700682
  704059
  707933
  722999
  751483
  755617
  759717
  764441
  765781
  765961
  766552
  766606
  779419
  806286
  810448
  811878
  812055
  820582
  823102
  824296
  824461
  826716
  828067
]
19.10 ms
(8.57%)
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
  470120
  452795
  477759
  509654
  526984
  528584
  546772
  565585
  560867
  565722
  591977
  605903
  591042
  414960
  426703
  426085
  473194
  437996
  465885
  468437
  490235
  493819
  513550
  517800
  510068
  510783
  514050
  520587
  521432
  523539
  823921
  824296
  828067
  534007
  704059
  646307
  592282
  765961
  398448
  820582
  665745
  765781
  21731
  385600
  417067
  386097
  327338
  385759
  383547
  205147
  61726
  9734
  387046
  418193
  442025
  425648
  420193
  443493
  450183
  455809
  501679
  469114
  481262
  559426
  580928
  571359
  553014
  576184
  646673
  688403
  695158
  700682
  707933
  573023
  592198
  810448
  812055
  764441
  766606
  759717
  779419
  381849
  383500
  396139
  437233
  446777
  417847
  433755
  33236
  424918
  454368
  478385
  513530
  513528
  514111
  519446
  521478
  452662
  395226
  824461
  823102
  826716
  823807
  828298
  544906
  540898
  562986
  653820
  722999
  640469
  806286
  755617
  751483
  766552
  811878
  448090
  473388
  514020
  549726
  567198
]
3.51 ms
(1.57%)
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
  9734
  21731
  33236
  61726
  205147
  327338
  381849
  383500
  383547
  385600
  385759
  386097
  387046
  395226
  396139
  398448
  414960
  417067
  417847
  418193
  420193
  424918
  425648
  426085
  426703
  433755
  437233
  437996
  442025
  443493
  446777
  448090
  450183
  452662
  452795
  454368
  455809
  468437
  469114
  470120
  473194
  473388
  477759
  478385
  481262
  490235
  493819
  501679
  509654
  510068
  510783
  513528
  513530
  513550
  514020
  514050
  514111
  517800
  519446
  520587
  521432
  521478
  523539
  526984
  528584
  534007
  540898
  544906
  546772
  549726
  553014
  559426
  560867
  562986
  565585
  565722
  567198
  571359
  573023
  576184
  580928
  591042
  591977
  592198
  592282
  605903
  640469
  646307
  646673
  653820
  665745
  688403
  695158
  700682
  704059
  707933
  722999
  751483
  755617
  759717
  764441
  765781
  765961
  766552
  766606
  779419
  806286
  810448
  811878
  812055
  820582
  823102
  824296
  824461
  826716
  828067
]
2.03 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тату раком"
]
1.63 ms
(0.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "татуированные рак"
]
1.61 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "татуированные рак"
]
1.51 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.