Query Metrics
7
Database Queries
7
Different statements
180.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.04 ms (85.40%) |
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 6651 282542 324183 383020 386567 389900 391561 391715 392721 392817 396554 397739 398302 400662 400730 400941 400954 402032 403134 404443 404968 406513 409995 412725 413641 414061 414070 415761 418534 421369 426026 430366 432927 436132 440016 447444 452875 485527 495747 497690 506371 510393 510402 515572 521588 523205 524183 524193 524793 529574 530012 530478 531085 531209 532727 532799 533012 533090 535423 536227 536271 540685 544147 545465 547852 563943 565575 568518 575601 594208 604105 609804 618769 623204 635900 641562 641569 641761 644066 648679 651666 656919 656936 656944 660713 661973 663317 675762 677671 680248 687204 696598 711291 713113 717553 720756 723094 740269 745101 745123 748530 750123 750145 752592 752706 757061 757868 761430 766945 770267 786872 787514 794310 799786 800282 800318 801313 805301 814443 ] |
||||||||||||||||||||||||||||||
|
16.41 ms (9.10%) |
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 506371 529574 533090 540685 544147 565575 656936 656944 661973 717553 648679 656919 713113 663317 720756 547852 609804 641569 641761 618769 641562 799786 805301 801313 761430 786872 794310 800318 762121 745123 766945 770267 745101 740269 750123 750145 752592 757061 604105 723094 787514 800282 324183 402032 406513 398302 282542 396554 403134 391561 392721 392817 397739 523205 524183 651666 635900 426026 391715 400662 400941 400954 414070 418534 432927 413641 440016 485527 497690 532799 495747 533012 510402 530012 531209 532727 535423 677671 594208 644066 623204 748530 415761 436132 404443 421369 430366 452875 404968 409995 447444 524793 510393 521588 524193 530478 814443 536227 531085 515572 545465 563943 568518 575601 680248 696598 752706 711291 675762 757868 536271 660713 687204 386567 383020 6651 389900 400730 412725 414061 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.34%) |
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 6651 282542 324183 383020 386567 389900 391561 391715 392721 392817 396554 397739 398302 400662 400730 400941 400954 402032 403134 404443 404968 406513 409995 412725 413641 414061 414070 415761 418534 421369 426026 430366 432927 436132 440016 447444 452875 485527 495747 497690 506371 510393 510402 515572 521588 523205 524183 524193 524793 529574 530012 530478 531085 531209 532727 532799 533012 533090 535423 536227 536271 540685 544147 545465 547852 563943 565575 568518 575601 594208 604105 609804 618769 623204 635900 641562 641569 641761 644066 648679 651666 656919 656936 656944 660713 661973 663317 675762 677671 680248 687204 696598 711291 713113 717553 720756 723094 740269 745101 745123 748530 750123 750145 752592 752706 757061 757868 761430 766945 770267 786872 787514 794310 799786 800282 800318 801313 805301 814443 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme teen"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор teen"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор teen"
]
|
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.