Query Metrics
7
Database Queries
7
Different statements
147.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.65 ms (83.91%) |
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 80314 394162 395451 396369 401845 440749 441958 461866 466224 471769 479174 489946 492750 521837 524102 529699 530289 530698 531839 535612 535637 536991 539454 541868 544140 550925 553732 564500 564830 567126 567137 568938 571126 572235 575665 577883 592396 592587 600540 607296 618782 626589 628709 632379 632887 635558 636428 639040 645525 645669 647316 655294 656497 656548 662065 666820 668305 673526 676654 680386 682397 683028 683700 684383 685203 686155 688534 697460 718087 718128 723988 725030 726194 728739 729337 729453 730315 737561 740481 746305 749672 750145 752603 757747 757792 760401 760713 761162 761757 763428 765784 766941 767236 767247 769576 770261 776327 778670 780799 787521 790087 791160 795628 798633 799348 800301 800387 800901 801313 802620 803494 803603 804935 805310 812070 814445 817199 817383 825910 827878 ] |
||||||||||||||||||||||||||||||
|
13.35 ms (9.06%) |
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 666820 80314 461866 471769 662065 479174 567137 628709 795628 799348 805310 798633 766941 761162 718128 787521 686155 683700 639040 729453 575665 530698 791160 440749 814445 553732 564500 541868 550925 564830 656548 668305 632887 737561 760401 790087 804935 767247 770261 726194 749672 697460 776327 780799 803494 530289 529699 647316 676654 680386 688534 645525 682397 618782 626589 632379 441958 568938 577883 592587 767236 729337 740481 730315 778670 396369 521837 524102 825910 827878 723988 673526 803603 489946 645669 656497 685203 466224 531839 544140 635558 592396 607296 725030 752603 757747 802620 571126 572235 683028 684383 636428 600540 395451 817383 817199 539454 535612 567126 718087 812070 800901 801313 746305 757792 763428 800301 800387 769576 765784 728739 750145 761757 401845 536991 760713 535637 492750 655294 394162 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.98%) |
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 80314 394162 395451 396369 401845 440749 441958 461866 466224 471769 479174 489946 492750 521837 524102 529699 530289 530698 531839 535612 535637 536991 539454 541868 544140 550925 553732 564500 564830 567126 567137 568938 571126 572235 575665 577883 592396 592587 600540 607296 618782 626589 628709 632379 632887 635558 636428 639040 645525 645669 647316 655294 656497 656548 662065 666820 668305 673526 676654 680386 682397 683028 683700 684383 685203 686155 688534 697460 718087 718128 723988 725030 726194 728739 729337 729453 730315 737561 740481 746305 749672 750145 752603 757747 757792 760401 760713 761162 761757 763428 765784 766941 767236 767247 769576 770261 776327 778670 780799 787521 790087 791160 795628 798633 799348 800301 800387 800901 801313 802620 803494 803603 804935 805310 812070 814445 817199 817383 825910 827878 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal riding amateurs"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал riding любительск"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал riding любительск"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.