Query Metrics
7
Database Queries
7
Different statements
156.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.87 ms (82.15%) |
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 395566 408563 415615 420192 420575 421526 423518 426033 428409 429088 431410 435496 439695 440816 443320 444586 446004 448121 448351 448828 451578 451974 458905 459784 468044 468717 468753 472720 472937 474644 474655 483875 484695 485270 487150 488156 490533 492434 496551 502249 502890 504536 506800 507078 509998 514467 514600 515742 516245 517849 517981 522843 522899 525657 526735 528202 528791 531070 531252 531540 532982 535094 542753 542791 543475 545586 550437 554519 558138 559374 559760 561103 562204 562247 562269 564160 565355 567762 569096 571847 572537 576271 581349 581552 581660 583503 583716 593162 593850 598038 603675 604894 608928 621371 630765 632256 633786 637121 640380 640806 641671 644914 648740 650823 661382 666766 677766 679034 681310 689521 696518 719336 720197 724177 756469 766021 775866 793425 804531 811738 ] |
||||||||||||||||||||||||||||||
|
17.76 ms (11.32%) |
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 542791 581552 648740 650823 661382 696518 561103 565355 567762 572537 581660 641671 593850 640806 775866 793425 811738 766021 724177 632256 451578 423518 428409 426033 474644 420575 440816 446004 517849 526735 492434 504536 506800 531070 583716 562204 395566 468753 472720 515742 554519 564160 443320 429088 431410 435496 459784 448121 448828 472937 485270 522899 525657 531252 532982 496551 502249 502890 531540 543475 550437 562269 583503 542753 559760 559374 562247 666766 679034 681310 719336 630765 640380 598038 804531 720197 444586 439695 408563 522843 484695 487150 488156 507078 517981 509998 514600 528202 448351 576271 689521 621371 514467 483875 516245 451974 604894 608928 490533 535094 415615 421526 420192 644914 468044 458905 474655 468717 528791 558138 571847 581349 677766 545586 569096 637121 593162 603675 633786 756469 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (2.12%) |
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 395566 408563 415615 420192 420575 421526 423518 426033 428409 429088 431410 435496 439695 440816 443320 444586 446004 448121 448351 448828 451578 451974 458905 459784 468044 468717 468753 472720 472937 474644 474655 483875 484695 485270 487150 488156 490533 492434 496551 502249 502890 504536 506800 507078 509998 514467 514600 515742 516245 517849 517981 522843 522899 525657 526735 528202 528791 531070 531252 531540 532982 535094 542753 542791 543475 545586 550437 554519 558138 559374 559760 561103 562204 562247 562269 564160 565355 567762 569096 571847 572537 576271 581349 581552 581660 583503 583716 593162 593850 598038 603675 604894 608928 621371 630765 632256 633786 637121 640380 640806 641671 644914 648740 650823 661382 666766 677766 679034 681310 689521 696518 719336 720197 724177 756469 766021 775866 793425 804531 811738 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дрочит двум"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк двум"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
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.