Query Metrics
7
Database Queries
7
Different statements
171.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.85 ms (85.30%) |
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 489807 494682 494935 500182 503869 511995 515990 520925 522631 525775 526758 531747 534370 537613 539353 542700 544971 556460 557797 563766 564673 566892 566897 583190 587423 588529 589102 592123 594602 595137 600170 600526 602491 603046 604859 605401 605875 610001 611980 619203 625722 633334 637176 654659 659956 662022 662874 670915 674292 681343 689989 693227 693796 693806 701221 707233 707673 708718 709492 709818 710094 712165 723264 724516 724677 729217 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 ] |
||||||||||||||||||||||||||||||
|
14.84 ms (8.68%) |
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 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 489807 511995 707233 729217 734259 733437 611980 462575 531747 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 674292 693806 707673 708718 588529 605875 633334 637176 589102 600170 600526 602491 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.94%) |
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 489807 494682 494935 500182 503869 511995 515990 520925 522631 525775 526758 531747 534370 537613 539353 542700 544971 556460 557797 563766 564673 566892 566897 583190 587423 588529 589102 592123 594602 595137 600170 600526 602491 603046 604859 605401 605875 610001 611980 619203 625722 633334 637176 654659 659956 662022 662874 670915 674292 681343 689989 693227 693796 693806 701221 707233 707673 708718 709492 709818 710094 712165 723264 724516 724677 729217 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.85 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife couple"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен couple"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.