Query Metrics
7
Database Queries
7
Different statements
189.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.37 ms (87.67%) |
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 91891 97571 213273 385285 391722 391833 404247 409725 412603 431487 457631 477784 490193 495379 509155 516627 530032 539700 547228 547972 557049 568340 571836 579793 588023 590907 604589 604679 605626 616470 616555 616916 618753 619275 620453 620563 622323 623322 623987 628293 633832 634271 635636 635842 636510 644331 652617 653612 661262 666782 667323 669628 673048 674733 677143 679037 679040 699428 701139 702299 703059 703432 704231 710263 710492 711643 711956 719057 725122 731805 732805 732819 733324 735855 736693 738653 742188 742691 745250 745378 745723 747269 748219 750454 755447 756877 760017 762382 771959 773352 773966 777813 784979 785381 788281 788859 788884 789541 792337 793337 793630 793915 794509 795173 796148 796964 797440 800709 800730 801473 802823 803776 805339 805565 805959 809580 809689 810718 813420 814440 ] |
||||||||||||||||||||||||||||||
|
12.94 ms (6.82%) |
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 622323 616916 623322 623987 635842 618753 636510 777813 788884 793915 802823 788859 800730 801473 805959 813420 793630 795173 796148 805565 745378 725122 732819 735855 747269 750454 742188 755447 762382 733324 748219 604589 635636 699428 701139 703059 797440 800709 809580 809689 810718 391833 404247 457631 509155 391722 91891 814440 477784 516627 530032 539700 547972 571836 579793 568340 652617 653612 666782 673048 702299 710492 667323 669628 677143 679037 703432 704231 711956 661262 674733 679040 710263 719057 547228 557049 588023 620563 633832 590907 616555 616470 628293 605626 620453 634271 793337 803776 792337 794509 805339 756877 760017 771959 773966 784979 785381 736693 745250 738653 745723 773352 731805 742691 732805 604679 619275 644331 711643 788281 789541 796964 495379 490193 385285 213273 97571 409725 412603 431487 ] |
||||||||||||||||||||||||||||||
|
3.09 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 91891 97571 213273 385285 391722 391833 404247 409725 412603 431487 457631 477784 490193 495379 509155 516627 530032 539700 547228 547972 557049 568340 571836 579793 588023 590907 604589 604679 605626 616470 616555 616916 618753 619275 620453 620563 622323 623322 623987 628293 633832 634271 635636 635842 636510 644331 652617 653612 661262 666782 667323 669628 673048 674733 677143 679037 679040 699428 701139 702299 703059 703432 704231 710263 710492 711643 711956 719057 725122 731805 732805 732819 733324 735855 736693 738653 742188 742691 745250 745378 745723 747269 748219 750454 755447 756877 760017 762382 771959 773352 773966 777813 784979 785381 788281 788859 788884 789541 792337 793337 793630 793915 794509 795173 796148 796964 797440 800709 800730 801473 802823 803776 805339 805565 805959 809580 809689 810718 813420 814440 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дел"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дел"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.