Query Metrics
7
Database Queries
7
Different statements
187.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.52 ms (87.33%) |
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 23884 39843 130641 209941 253864 384906 414710 415539 514294 515311 521659 531202 531205 531215 532081 532658 532756 534004 536249 539171 541942 549417 554310 570821 578345 586190 595041 595595 597199 599977 600022 600312 600365 602603 603703 603746 604960 606717 606738 608772 612335 612343 612381 621290 632635 632646 633491 635222 645236 645284 655099 656055 656998 657591 657652 675458 678131 678243 680606 687529 689048 693885 695122 707726 719283 721568 724493 724745 729907 732336 735334 740179 743824 748532 749388 749946 754438 759671 762299 762781 767310 768079 771035 775429 777486 780180 781030 781318 782716 783732 789622 793556 796910 799576 800259 801774 801945 803785 810135 817003 817016 817403 817693 818676 818880 819792 821115 821491 822475 823123 823158 823379 824193 825111 825810 826229 827082 828074 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (7.35%) |
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 602603 606738 768079 824193 825810 687529 600365 532658 635222 612343 606717 595595 414710 534004 821115 532756 724493 536249 531215 531202 599977 597199 600312 595041 657591 724745 826056 828074 586190 632646 675458 608772 612335 541942 578345 781318 754438 801774 817693 539171 748532 23884 678131 783732 39843 645236 531205 633491 600022 632635 656998 680606 603746 777486 743824 767310 775429 780180 789622 826229 827082 693885 803785 719283 612381 822475 532081 799576 771167 209941 721568 800259 729907 130641 823123 823379 821491 819792 825111 554310 678243 689048 621290 796910 801945 759671 735334 810135 549417 781030 782716 732336 740179 749388 604960 415539 603703 514294 384906 817003 749946 762299 793556 762781 771035 253864 645284 695122 817403 818880 817016 818676 823158 515311 521659 570821 707726 656055 657652 655099 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.40%) |
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 23884 39843 130641 209941 253864 384906 414710 415539 514294 515311 521659 531202 531205 531215 532081 532658 532756 534004 536249 539171 541942 549417 554310 570821 578345 586190 595041 595595 597199 599977 600022 600312 600365 602603 603703 603746 604960 606717 606738 608772 612335 612343 612381 621290 632635 632646 633491 635222 645236 645284 655099 656055 656998 657591 657652 675458 678131 678243 680606 687529 689048 693885 695122 707726 719283 721568 724493 724745 729907 732336 735334 740179 743824 748532 749388 749946 754438 759671 762299 762781 767310 768079 771035 775429 777486 780180 781030 781318 782716 783732 789622 793556 796910 799576 800259 801774 801945 803785 810135 817003 817016 817403 817693 818676 818880 819792 821115 821491 822475 823123 823158 823379 824193 825111 825810 826229 827082 828074 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love секс"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love sex"
]
|
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.