Query Metrics
7
Database Queries
7
Different statements
232.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.17 ms (87.39%) |
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 382880 387379 400491 420362 421819 421836 423934 430598 439704 440644 440949 442754 447475 447971 448663 450847 452624 453701 456610 464550 464868 468362 469831 474213 477485 478824 483732 490513 491141 492449 503169 503544 505781 508713 510783 517739 519610 520923 530437 531858 532813 535348 543366 544452 554981 562423 566093 574664 576193 576859 588091 597855 602976 604683 613995 617788 627156 641032 644849 652148 671681 674825 686768 717541 719537 734269 740868 741521 744780 747062 757924 759751 763139 767277 769031 769834 769913 769968 770031 771939 771979 779887 789473 793585 794031 794366 794482 794686 796514 798787 798829 799037 799381 800664 800669 800690 800693 802545 803766 804612 805124 805125 808306 810354 810480 813946 813947 816101 816109 816609 819709 819851 824041 825288 825972 826749 826757 826863 828285 ] |
||||||||||||||||||||||||||||||
|
18.27 ms (7.86%) |
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 430598 440949 469831 574664 543366 544452 554981 566093 421836 478824 421819 474213 452624 442754 464868 477485 503544 508713 491141 826863 816609 535348 613995 517739 456610 771939 387379 813946 813947 652148 805125 808306 759751 804612 816109 819709 825288 826757 825972 531858 627156 588091 779887 794366 794686 798787 800664 794482 800669 800690 734269 769913 794031 740868 763139 769031 769968 770031 803766 450847 440644 420362 447475 492449 530437 562423 423934 447971 439704 448663 464550 468362 453701 503169 519610 532813 483732 490513 510783 505781 520923 719537 674825 796514 805124 400491 816101 824041 826428 826749 819851 828285 576193 602976 604683 641032 799381 802545 800693 744780 757924 767277 769834 789473 771979 741521 617788 793585 810354 810480 382880 576859 671681 686768 717541 597855 799037 747062 798829 644849 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (1.70%) |
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 382880 387379 400491 420362 421819 421836 423934 430598 439704 440644 440949 442754 447475 447971 448663 450847 452624 453701 456610 464550 464868 468362 469831 474213 477485 478824 483732 490513 491141 492449 503169 503544 505781 508713 510783 517739 519610 520923 530437 531858 532813 535348 543366 544452 554981 562423 566093 574664 576193 576859 588091 597855 602976 604683 613995 617788 627156 641032 644849 652148 671681 674825 686768 717541 719537 734269 740868 741521 744780 747062 757924 759751 763139 767277 769031 769834 769913 769968 770031 771939 771979 779887 789473 793585 794031 794366 794482 794686 796514 798787 798829 799037 799381 800664 800669 800690 800693 802545 803766 804612 805124 805125 808306 810354 810480 813946 813947 816101 816109 816609 819709 819851 824041 825288 825972 826749 826757 826863 828285 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"вебкам redhead milf"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер рыжая milf"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер рыжая milf"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.63%) |
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.