Query Metrics
7
Database Queries
7
Different statements
186.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.85 ms (85.29%) |
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 116603 116720 116885 382472 383842 396082 396331 397390 397762 402230 402255 427358 429960 434428 435472 441425 441453 442121 452746 458070 459651 459686 466124 466454 467907 467910 469162 478652 483568 484318 493172 496149 496164 497338 498872 500468 504509 515003 521205 523743 525308 531557 532104 533948 540721 543648 544209 544863 545598 547947 548834 558087 560273 561703 563765 573453 578815 580423 581064 584184 585296 585992 592614 596212 604364 608070 618021 619727 620499 622932 625379 626842 637802 640390 652353 652501 653615 653628 653893 657160 658850 662043 663171 688885 691934 693369 695892 699892 720828 724052 727144 727575 728369 729082 729800 742847 744843 763490 766677 767046 769883 770326 777742 779010 792137 792938 794368 794772 795687 796153 796165 799349 800404 802053 803722 805502 813915 814457 817171 827855 ] |
||||||||||||||||||||||||||||||
|
15.87 ms (8.52%) |
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 496149 523743 533948 493172 496164 467907 434428 459651 544863 397762 441453 813915 827855 531557 658850 652353 652501 653628 688885 653615 691934 699892 619727 585992 626842 727144 742847 727575 640390 792938 794772 116603 396082 441425 397390 429960 466124 525308 620499 622932 604364 116720 382472 402230 442121 814457 817171 458070 452746 498872 543648 544209 548834 563765 584184 695892 693369 657160 663171 596212 625379 779010 795687 794368 800404 766677 724052 728369 729082 767046 769883 770326 796153 799349 116885 459686 396331 427358 402255 435472 483568 467910 573453 466454 478652 521205 497338 504509 540721 383842 484318 469162 515003 500468 532104 547947 560273 581064 558087 561703 653893 662043 720828 545598 578815 580423 585296 592614 618021 637802 608070 777742 792137 796165 805502 729800 744843 802053 803722 763490 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.58%) |
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 116603 116720 116885 382472 383842 396082 396331 397390 397762 402230 402255 427358 429960 434428 435472 441425 441453 442121 452746 458070 459651 459686 466124 466454 467907 467910 469162 478652 483568 484318 493172 496149 496164 497338 498872 500468 504509 515003 521205 523743 525308 531557 532104 533948 540721 543648 544209 544863 545598 547947 548834 558087 560273 561703 563765 573453 578815 580423 581064 584184 585296 585992 592614 596212 604364 608070 618021 619727 620499 622932 625379 626842 637802 640390 652353 652501 653615 653628 653893 657160 658850 662043 663171 688885 691934 693369 695892 699892 720828 724052 727144 727575 728369 729082 729800 742847 744843 763490 766677 767046 769883 770326 777742 779010 792137 792938 794368 794772 795687 796153 796165 799349 800404 802053 803722 805502 813915 814457 817171 827855 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy first time"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак вперв"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.01%) |
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.