Query Metrics
7
Database Queries
7
Different statements
147.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.76 ms (81.02%) |
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 405426 409846 412460 412548 414384 420734 421844 421862 421900 421914 425319 426648 426660 426812 439746 439759 439809 443670 443722 447052 447076 450646 455377 461005 462123 463200 463737 464581 465344 465996 474777 476824 478020 482758 482906 486392 488249 490261 490841 491947 496850 497560 504250 504805 511723 512375 513466 514392 516804 517619 518160 518329 519014 519676 521965 522208 522733 523160 523429 523902 523907 523964 524069 525801 527079 528638 532498 533833 547874 551281 551820 552100 552234 552360 555852 560579 560899 564977 565284 566264 566579 566580 568317 569453 569989 574501 578382 578386 580675 582377 585099 592616 593485 597036 597255 597812 598136 598794 599027 599388 603742 603902 609343 609838 614954 621982 623440 626405 652271 653503 660664 709874 730497 739900 744753 745307 745404 790930 797785 799239 ] |
||||||||||||||||||||||||||||||
|
17.92 ms (12.12%) |
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 560579 566264 569989 574501 552360 565284 566579 578386 652271 653503 660664 552234 555852 580675 597255 609343 621982 623440 599388 592616 603742 597036 597812 598136 790930 744753 745307 745404 797785 799239 730497 739900 609838 614954 405426 409846 426660 476824 421844 421862 421914 426648 439809 463200 465996 412548 414384 450646 425319 426812 455377 461005 462123 464581 443722 447076 465344 517619 518329 527079 486392 491947 504805 511723 513466 514392 519014 521965 523429 523964 522208 523902 525801 482906 490841 496850 516804 524069 532498 523160 599027 421900 478020 490261 564977 593485 598794 626405 603902 474777 439759 443670 463737 420734 439746 447052 512375 519676 523907 528638 488249 497560 504250 522733 412460 585099 482758 533833 518160 551281 551820 552100 578382 547874 568317 569453 582377 709874 560899 566580 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.90%) |
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 405426 409846 412460 412548 414384 420734 421844 421862 421900 421914 425319 426648 426660 426812 439746 439759 439809 443670 443722 447052 447076 450646 455377 461005 462123 463200 463737 464581 465344 465996 474777 476824 478020 482758 482906 486392 488249 490261 490841 491947 496850 497560 504250 504805 511723 512375 513466 514392 516804 517619 518160 518329 519014 519676 521965 522208 522733 523160 523429 523902 523907 523964 524069 525801 527079 528638 532498 533833 547874 551281 551820 552100 552234 552360 555852 560579 560899 564977 565284 566264 566579 566580 568317 569453 569989 574501 578382 578386 580675 582377 585099 592616 593485 597036 597255 597812 598136 598794 599027 599388 603742 603902 609343 609838 614954 621982 623440 626405 652271 653503 660664 709874 730497 739900 744753 745307 745404 790930 797785 799239 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real russian"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real русск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real русск"
]
|
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.