Query Metrics
7
Database Queries
7
Different statements
197.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.24 ms (89.13%) |
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 392465 425574 436020 438493 445847 446649 455129 459205 462575 466390 467133 485392 488466 494682 494935 496555 500182 503869 510604 511995 515990 520925 522631 525775 526758 534370 537613 539353 542700 544971 551660 551691 556460 557797 563766 564673 566892 566897 581257 583190 583988 587423 592123 594602 595137 603046 604859 605401 610001 611980 619203 625722 646052 654659 659956 660340 662022 662874 670915 673496 675495 681343 687441 689989 693227 693794 693796 701221 704034 707233 709492 709818 710094 712165 717412 723264 724516 724677 729357 733076 733437 734251 734259 736360 737280 741737 742408 743559 750229 756989 763173 766728 767011 768725 773740 774080 776194 778844 779721 779817 783627 784284 785574 786549 790178 791681 792426 793700 794199 795075 796294 800975 809706 810134 812292 813842 824690 826238 827370 ] |
||||||||||||||||||||||||||||||
|
11.51 ms (5.82%) |
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 510604 496555 488466 551660 551691 581257 583988 646052 673496 675495 687441 693794 704034 717412 660340 710094 654659 659956 670915 681343 709818 556460 563766 595137 603046 610001 587423 605401 586568 604859 592123 619203 779721 796294 800975 778844 791681 729357 734251 741737 756989 790178 792426 793700 810134 812292 724516 724677 736360 763173 768725 733076 737280 742408 767011 774080 743559 750229 766728 773740 625722 712165 776194 779817 783627 784284 785574 786549 809706 445847 455129 467133 392465 511995 707233 734259 733437 611980 462575 544971 693227 594602 520925 494682 503869 446649 466390 564673 795075 794199 525775 425574 438493 436020 813842 824690 826238 827370 485392 459205 522631 494935 500182 515990 534370 539353 526758 537613 542700 566897 583190 557797 566892 662874 701221 723264 689989 693796 709492 662022 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"couple wife"
]
|
||||||||||||||||||||||||||||||
|
2.52 ms (1.27%) |
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 392465 425574 436020 438493 445847 446649 455129 459205 462575 466390 467133 485392 488466 494682 494935 496555 500182 503869 510604 511995 515990 520925 522631 525775 526758 534370 537613 539353 542700 544971 551660 551691 556460 557797 563766 564673 566892 566897 581257 583190 583988 587423 592123 594602 595137 603046 604859 605401 610001 611980 619203 625722 646052 654659 659956 660340 662022 662874 670915 673496 675495 681343 687441 689989 693227 693794 693796 701221 704034 707233 709492 709818 710094 712165 717412 723264 724516 724677 729357 733076 733437 734251 734259 736360 737280 741737 742408 743559 750229 756989 763173 766728 767011 768725 773740 774080 776194 778844 779721 779817 783627 784284 785574 786549 790178 791681 792426 793700 794199 795075 796294 800975 809706 810134 812292 813842 824690 826238 827370 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"couple жен"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"couple жен"
]
|
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.