Query Metrics
7
Database Queries
7
Different statements
195.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.05 ms (87.15%) |
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 14806 382362 383154 389315 408961 415875 420116 420501 433516 443237 445730 446994 449573 457494 460356 463845 464161 468089 480357 484054 488931 496846 521631 525039 529330 533305 533681 536718 536740 541132 543035 547650 556250 578778 579195 584576 595214 596919 600933 601101 604588 605244 617074 617420 623965 631394 634523 635236 635932 646893 649863 650263 652548 662047 664260 669054 680754 681692 695939 697130 701309 701406 708667 715688 716088 720388 720667 720806 722534 725676 726154 726634 732345 737734 738926 742364 742439 743935 751309 751571 754162 754170 754321 761083 761116 765092 765810 767598 774058 776041 776506 783341 784618 785857 787215 787641 787885 788194 789497 790988 794769 795413 797105 798601 799695 801082 801799 802601 803836 807541 807579 807640 807660 810483 811100 811727 812385 813522 819223 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (6.92%) |
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 797105 803836 726634 774058 604588 617074 715688 722534 787885 789497 807640 813522 533305 443237 433516 415875 819223 449573 536718 525039 541132 556250 543035 720806 646893 669054 652548 584576 631394 600933 807541 810483 776041 776506 795413 726154 784618 785857 794769 751571 754170 767598 765810 460356 408961 464161 725676 601101 701309 708667 596919 605244 798601 738926 761083 701406 788194 521631 617420 821926 445730 547650 720667 649863 579195 595214 790988 787215 811727 751309 743935 468089 14806 446994 480357 420116 383154 382362 389315 420501 457494 484054 463845 488931 533681 529330 496846 536740 578778 650263 697130 664260 681692 662047 680754 695939 716088 720388 635236 635932 623965 799695 807579 787641 812385 754162 783341 801082 801799 802601 807660 811100 742364 754321 765092 732345 737734 742439 761116 634523 ] |
||||||||||||||||||||||||||||||
|
3.84 ms (1.97%) |
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 14806 382362 383154 389315 408961 415875 420116 420501 433516 443237 445730 446994 449573 457494 460356 463845 464161 468089 480357 484054 488931 496846 521631 525039 529330 533305 533681 536718 536740 541132 543035 547650 556250 578778 579195 584576 595214 596919 600933 601101 604588 605244 617074 617420 623965 631394 634523 635236 635932 646893 649863 650263 652548 662047 664260 669054 680754 681692 695939 697130 701309 701406 708667 715688 716088 720388 720667 720806 722534 725676 726154 726634 732345 737734 738926 742364 742439 743935 751309 751571 754162 754170 754321 761083 761116 765092 765810 767598 774058 776041 776506 783341 784618 785857 787215 787641 787885 788194 789497 790988 794769 795413 797105 798601 799695 801082 801799 802601 803836 807541 807579 807640 807660 810483 811100 811727 812385 813522 819223 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl black"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк black"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк black"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.91%) |
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.