Query Metrics
7
Database Queries
7
Different statements
162.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.85 ms (84.19%) |
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 118201 131726 381226 385880 386732 405761 407503 414078 423586 425422 433814 438513 444265 445984 452738 454038 458973 468511 469411 472535 480424 481828 485020 487216 487871 493084 495165 495233 499911 505989 506584 507481 508172 509512 511002 511164 511546 513450 514227 514938 517664 518415 521799 522729 522739 526816 528541 529178 532040 533397 535515 535962 536392 537173 538472 538794 539589 540760 542740 544054 550510 550806 550913 554954 555191 555232 555298 555447 555467 557098 559399 563600 565028 576421 576437 581964 581974 584389 584843 584871 585888 586157 586488 588603 588646 590502 591874 592562 594088 594420 595612 596637 596989 599648 600812 600889 601777 602379 603321 603993 604444 605651 605809 610012 615908 616062 616510 618465 619040 622503 623370 623646 625753 626551 626872 628692 628823 629498 629663 635694 ] |
||||||||||||||||||||||||||||||
|
15.05 ms (9.26%) |
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 586488 599648 600812 616062 623370 588646 590502 604444 605809 610012 626872 628823 629663 635694 586157 588603 594088 601777 603993 619040 622503 628692 585888 591874 592562 594420 595612 596637 596989 600889 603321 605651 616510 618465 623646 626551 629498 602379 615908 625753 454038 495233 509512 385880 386732 118201 131726 381226 405761 407503 444265 414078 425422 423586 438513 433814 468511 469411 445984 452738 481828 485020 458973 472535 487871 499911 522739 533397 506584 511002 517664 521799 522729 526816 528541 529178 538472 538794 540760 507481 511164 514227 514938 532040 535515 535962 495165 505989 508172 511546 513450 518415 536392 537173 539589 480424 487216 493084 542740 544054 550510 550806 555447 563600 576421 584843 584871 550913 555232 555298 555467 557098 559399 565028 576437 581964 581974 584389 554954 555191 ] |
||||||||||||||||||||||||||||||
|
3.60 ms (2.21%) |
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 118201 131726 381226 385880 386732 405761 407503 414078 423586 425422 433814 438513 444265 445984 452738 454038 458973 468511 469411 472535 480424 481828 485020 487216 487871 493084 495165 495233 499911 505989 506584 507481 508172 509512 511002 511164 511546 513450 514227 514938 517664 518415 521799 522729 522739 526816 528541 529178 532040 533397 535515 535962 536392 537173 538472 538794 539589 540760 542740 544054 550510 550806 550913 554954 555191 555232 555298 555447 555467 557098 559399 563600 565028 576421 576437 581964 581974 584389 584843 584871 585888 586157 586488 588603 588646 590502 591874 592562 594088 594420 595612 596637 596989 599648 600812 600889 601777 602379 603321 603993 604444 605651 605809 610012 615908 616062 616510 618465 619040 622503 623370 623646 625753 626551 626872 628692 628823 629498 629663 635694 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"киску"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.