Query Metrics
7
Database Queries
7
Different statements
182.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.57 ms (85.13%) |
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 13492 14700 25021 188507 387350 392238 396690 400931 401153 404212 408463 409179 410393 416315 442632 457754 460672 465652 468479 477532 478487 491228 501480 501488 513126 521587 530696 530703 532754 532995 533011 533367 533372 533374 533378 534027 535532 537653 545791 545803 550200 564304 564392 583953 590794 599836 599862 599863 599875 599922 599955 600016 604447 604514 604562 605449 605677 612182 625242 628126 632618 632659 633755 634500 634542 634550 634553 634560 635215 636293 636304 636308 637021 637139 638543 638932 640732 641686 641690 645276 648870 649964 655153 665931 667741 674688 681295 681666 696204 703435 708923 711606 711685 718945 720117 720123 720386 720827 721016 722504 723509 724557 725606 736440 739668 743165 744653 747469 747481 756228 756230 770402 798207 805271 810705 813731 814656 815493 817846 818856 ] |
||||||||||||||||||||||||||||||
|
16.87 ms (9.23%) |
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 637021 460672 720123 720386 725606 743165 724557 747481 739668 392238 720827 770402 599875 640732 550200 722504 625242 637139 600016 501488 645276 665931 667741 711606 634550 634560 605677 634542 468479 815493 798207 636293 533367 533378 648870 564392 564304 718945 537653 636304 387350 530696 604562 477532 814656 674688 655153 681295 604514 604447 747469 599836 632618 188507 521587 535532 756228 478487 465652 599863 632659 641690 13492 416315 491228 532995 533372 599955 599862 25021 813731 634500 638932 638543 810705 720117 817846 605449 636308 534027 599922 396690 711685 641686 756230 408463 410393 400931 14700 401153 583953 708923 590794 633755 612182 545791 533011 532754 533374 696204 545803 442632 457754 681666 723509 744653 404212 513126 628126 649964 634553 805271 818856 409179 703435 736440 721016 501480 530703 635215 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.48%) |
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 13492 14700 25021 188507 387350 392238 396690 400931 401153 404212 408463 409179 410393 416315 442632 457754 460672 465652 468479 477532 478487 491228 501480 501488 513126 521587 530696 530703 532754 532995 533011 533367 533372 533374 533378 534027 535532 537653 545791 545803 550200 564304 564392 583953 590794 599836 599862 599863 599875 599922 599955 600016 604447 604514 604562 605449 605677 612182 625242 628126 632618 632659 633755 634500 634542 634550 634553 634560 635215 636293 636304 636308 637021 637139 638543 638932 640732 641686 641690 645276 648870 649964 655153 665931 667741 674688 681295 681666 696204 703435 708923 711606 711685 718945 720117 720123 720386 720827 721016 722504 723509 724557 725606 736440 739668 743165 744653 747469 747481 756228 756230 770402 798207 805271 810705 813731 814656 815493 817846 818856 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc anal big"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc анал большие"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc анал большие"
]
|
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.