Query Metrics
7
Database Queries
7
Different statements
162.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.39 ms (86.22%) |
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 4497 48366 89362 233489 359492 393350 401634 401636 412493 416426 443491 457162 462101 467967 468487 472931 474784 476709 490308 495038 501616 504376 515601 516274 516784 519347 537596 544093 554310 562731 564992 575459 576317 578703 592005 593180 593975 594842 599313 602754 603130 618561 618679 626616 636247 638047 656336 656846 658723 673044 673567 684314 696265 698607 700495 705966 706687 713197 713458 715403 720540 726116 727327 728144 732132 735541 735547 736689 737700 738950 739082 739654 742110 742527 742832 743228 743250 743251 748017 749053 749388 750444 751395 753604 753667 753682 754624 755889 757266 758038 758344 759061 759577 760634 763368 766284 769840 773606 776244 780180 780562 780678 783140 786206 787195 790659 790758 792473 793244 795026 796618 797069 800961 801427 803733 804390 806592 810631 812338 814221 ] |
||||||||||||||||||||||||||||||
|
11.70 ms (7.19%) |
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 603130 790659 793244 797069 803733 812338 727327 737700 739654 743228 748017 749053 758344 759061 800961 726116 728144 739082 743250 753604 769840 735541 749388 751395 700495 713458 780180 780562 787195 790758 801427 476709 575459 576317 578703 562731 564992 592005 602754 593180 636247 593975 599313 618561 626616 416426 443491 467967 474784 462101 472931 457162 468487 515601 516274 495038 504376 516784 537596 490308 519347 89362 814221 544093 554310 656846 684314 658723 673044 673567 698607 656336 696265 705966 713197 715403 720540 594842 618679 638047 776244 796618 804390 780678 786206 735547 742832 757266 759577 783140 806592 742110 754624 736689 742527 743251 753667 766284 732132 753682 755889 738950 750444 758038 760634 763368 773606 706687 792473 795026 810631 401634 401636 233489 393350 359492 48366 4497 412493 501616 ] |
||||||||||||||||||||||||||||||
|
3.87 ms (2.38%) |
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 4497 48366 89362 233489 359492 393350 401634 401636 412493 416426 443491 457162 462101 467967 468487 472931 474784 476709 490308 495038 501616 504376 515601 516274 516784 519347 537596 544093 554310 562731 564992 575459 576317 578703 592005 593180 593975 594842 599313 602754 603130 618561 618679 626616 636247 638047 656336 656846 658723 673044 673567 684314 696265 698607 700495 705966 706687 713197 713458 715403 720540 726116 727327 728144 732132 735541 735547 736689 737700 738950 739082 739654 742110 742527 742832 743228 743250 743251 748017 749053 749388 750444 751395 753604 753667 753682 754624 755889 757266 758038 758344 759061 759577 760634 763368 766284 769840 773606 776244 780180 780562 780678 783140 786206 787195 790659 790758 792473 793244 795026 796618 797069 800961 801427 803733 804390 806592 810631 812338 814221 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.19%) |
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.63 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 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.