Query Metrics
7
Database Queries
7
Different statements
182.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.97 ms (84.70%) |
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 181804 187704 192968 194224 233135 233143 233617 233683 233710 311235 334847 358592 359420 365880 381860 382802 388769 390231 390252 391163 391566 391581 391913 392031 392037 393701 397874 397892 397921 398950 398955 398957 398958 400810 401124 402340 402926 411324 411360 411389 411392 411398 411406 414091 417276 419520 426725 443673 444001 444113 444115 444142 444258 454205 461057 462099 462579 465386 466023 466155 469844 469898 470957 473252 473954 477958 477980 479036 479043 479133 482324 490878 490881 494382 494573 501519 501845 504251 506177 512643 513399 516498 526111 535972 539381 556740 556849 558950 563207 579998 590449 594604 598041 598583 620241 628219 645728 654717 656751 657434 658014 669344 691676 695849 710959 713441 721377 721413 721449 721463 721476 816693 818073 818994 820086 820228 820280 825804 827041 827944 ] |
||||||||||||||||||||||||||||||
|
15.48 ms (8.46%) |
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 477958 194224 233683 397892 398955 398958 402926 419520 466155 470957 477980 479036 479133 334847 358592 392031 411360 411389 411398 444142 444258 462099 479043 482324 233135 388769 390231 391163 391913 398950 411406 454205 462579 469844 469898 473252 411392 443673 444001 444115 501519 501845 490878 494382 513399 526111 598041 233617 391566 192968 414091 181804 233143 365880 382802 393701 556849 558950 563207 187704 233710 311235 390252 401124 411324 417276 426725 473954 359420 397874 402340 465386 391581 398957 461057 392037 397921 400810 444113 466023 494573 504251 506177 516498 490881 512643 381860 820228 816693 820280 827041 818994 825804 818073 820086 827944 535972 539381 657434 713441 721377 721413 721476 645728 654717 669344 691676 721449 721463 656751 658014 695849 710959 556740 579998 590449 594604 598583 620241 628219 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск old"
]
|
||||||||||||||||||||||||||||||
|
3.05 ms (1.67%) |
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 181804 187704 192968 194224 233135 233143 233617 233683 233710 311235 334847 358592 359420 365880 381860 382802 388769 390231 390252 391163 391566 391581 391913 392031 392037 393701 397874 397892 397921 398950 398955 398957 398958 400810 401124 402340 402926 411324 411360 411389 411392 411398 411406 414091 417276 419520 426725 443673 444001 444113 444115 444142 444258 454205 461057 462099 462579 465386 466023 466155 469844 469898 470957 473252 473954 477958 477980 479036 479043 479133 482324 490878 490881 494382 494573 501519 501845 504251 506177 512643 513399 516498 526111 535972 539381 556740 556849 558950 563207 579998 590449 594604 598041 598583 620241 628219 645728 654717 656751 657434 658014 669344 691676 695849 710959 713441 721377 721413 721449 721463 721476 816693 818073 818994 820086 820228 820280 825804 827041 827944 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian old"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск old"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.07%) |
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.