Query Metrics
7
Database Queries
7
Different statements
405.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
378.48 ms (93.27%) |
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 61243 209726 327981 389144 390987 391993 396111 401415 404090 408355 409126 410677 418544 419045 423963 426600 427540 428993 429603 429888 437791 439233 444615 446508 450852 458435 459163 464582 465250 468937 469035 469594 469994 470015 471194 472535 473453 476184 476214 477344 477590 479703 481734 483558 483754 486645 495144 496702 496711 500327 504903 510024 513789 526169 528139 531818 534612 538206 541589 545965 546577 546723 546838 547039 547565 549794 549797 550899 551829 553765 555485 556890 557617 560674 562126 563934 565627 569020 573908 574147 575424 576314 576742 577961 579384 582010 586086 592605 592617 593053 602025 614350 619792 623458 624220 665128 665271 666141 667525 678834 695887 704227 713876 720421 721486 724281 732930 734276 735658 742765 748727 748982 752188 754256 754426 807301 807341 809736 810945 819547 ] |
||||||||||||||||||||||||||||||
|
17.60 ms (4.34%) |
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 510024 546723 541589 614350 468937 619792 396111 574147 560674 748727 479703 563934 582010 469035 734276 742765 391993 469994 486645 754426 752188 534612 553765 458435 459163 555485 483558 819547 531818 469594 565627 667525 720421 665128 704227 665271 666141 602025 748982 810945 724281 624220 809736 419045 477590 546838 713876 592605 592617 732930 464582 427540 528139 426600 545965 557617 735658 754256 721486 496711 576314 586086 61243 404090 418544 465250 547039 409126 538206 576742 439233 477344 593053 401415 437791 389144 410677 471194 446508 569020 623458 807301 429603 476214 390987 408355 495144 496702 546577 549794 551829 483754 428993 429888 470015 473453 476184 577961 327981 450852 472535 513789 526169 678834 807341 481734 504903 209726 444615 423963 500327 549797 575424 547565 562126 579384 550899 695887 556890 573908 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (0.59%) |
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 61243 209726 327981 389144 390987 391993 396111 401415 404090 408355 409126 410677 418544 419045 423963 426600 427540 428993 429603 429888 437791 439233 444615 446508 450852 458435 459163 464582 465250 468937 469035 469594 469994 470015 471194 472535 473453 476184 476214 477344 477590 479703 481734 483558 483754 486645 495144 496702 496711 500327 504903 510024 513789 526169 528139 531818 534612 538206 541589 545965 546577 546723 546838 547039 547565 549794 549797 550899 551829 553765 555485 556890 557617 560674 562126 563934 565627 569020 573908 574147 575424 576314 576742 577961 579384 582010 586086 592605 592617 593053 602025 614350 619792 623458 624220 665128 665271 666141 667525 678834 695887 704227 713876 720421 721486 724281 732930 734276 735658 742765 748727 748982 752188 754256 754426 807301 807341 809736 810945 819547 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public big toys"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц большие toys"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на улиц большие toys"
]
|
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.