Query Metrics
7
Database Queries
7
Different statements
223.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.63 ms (86.92%) |
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 12731 130429 311734 381933 405860 415520 418405 421061 425725 425876 431684 432326 432805 441402 442325 442436 443464 444043 445530 445723 446942 448375 452869 453018 453165 458707 459173 459684 460335 463278 464246 467114 473310 474188 475542 476091 477505 478471 479202 484819 488858 494290 496810 496849 499549 500498 500576 506222 510836 511881 511982 513138 514642 514643 514790 516492 516670 517749 517885 519735 519738 519811 522446 522447 522802 525233 525597 526994 528942 531143 532364 532441 532976 533643 534193 539861 541878 542730 543552 546665 548620 550253 553629 555055 560867 565018 566074 568922 573543 573892 579471 580623 592891 597646 598483 600457 602666 605671 606946 607395 613973 630910 635160 635678 652577 661054 666428 681714 687108 690919 695940 700949 718160 718852 729344 781243 791209 799591 803492 813624 ] |
||||||||||||||||||||||||||||||
|
18.68 ms (8.34%) |
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 12731 443464 514643 553629 555055 533643 432805 580623 130429 405860 431684 445723 467114 519811 541878 543552 579471 652577 690919 597646 598483 600457 605671 606946 803492 460335 525233 452869 459173 499549 532976 565018 791209 799591 479202 517749 510836 513138 681714 635160 311734 453018 500498 539861 496849 550253 568922 613973 781243 729344 630910 432326 425876 477505 459684 514790 494290 516670 522446 488858 506222 516492 519738 522447 496810 546665 445530 532441 511881 566074 442436 474188 517885 484819 534193 475542 418405 473310 511982 500576 528942 531143 464246 542730 560867 661054 592891 607395 453165 444043 519735 522802 514642 635678 700949 381933 458707 446942 525597 532364 463278 718160 476091 425725 448375 441402 478471 442325 526994 813624 548620 573543 573892 666428 695940 687108 718852 602666 421061 415520 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (1.63%) |
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 12731 130429 311734 381933 405860 415520 418405 421061 425725 425876 431684 432326 432805 441402 442325 442436 443464 444043 445530 445723 446942 448375 452869 453018 453165 458707 459173 459684 460335 463278 464246 467114 473310 474188 475542 476091 477505 478471 479202 484819 488858 494290 496810 496849 499549 500498 500576 506222 510836 511881 511982 513138 514642 514643 514790 516492 516670 517749 517885 519735 519738 519811 522446 522447 522802 525233 525597 526994 528942 531143 532364 532441 532976 533643 534193 539861 541878 542730 543552 546665 548620 550253 553629 555055 560867 565018 566074 568922 573543 573892 579471 580623 592891 597646 598483 600457 602666 605671 606946 607395 613973 630910 635160 635678 652577 661054 666428 681714 687108 690919 695940 700949 718160 718852 729344 781243 791209 799591 803492 813624 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big video ass"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие video жоп"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие video жоп"
]
|
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.