Query Metrics
7
Database Queries
7
Different statements
160.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.17 ms (85.46%) |
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 108764 186988 387393 394013 399795 407283 421965 425333 427397 433447 442384 443668 447076 455546 456695 457915 459098 461224 465970 466041 473893 488120 497365 507705 512590 525257 531935 539371 542305 545894 553713 560263 577287 578712 581181 581205 591085 597147 599473 601190 617353 625916 629610 637803 639304 645804 648167 659200 660276 661599 666197 677146 692840 695444 707459 707693 710041 710486 715573 715935 717455 718810 719033 719559 721748 724079 724802 725202 725207 725243 728042 732595 738471 738852 739079 739912 743350 744196 753250 759686 760706 769202 778815 781913 782475 784215 784410 784846 789023 791099 793653 793818 794717 796564 797474 800176 801489 802794 805004 808492 808601 809370 812377 814993 819346 819449 819756 819780 820722 820936 824068 825449 825975 826307 826371 826560 826703 826883 827620 ] |
||||||||||||||||||||||||||||||
|
12.67 ms (7.90%) |
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 707459 710486 791099 394013 456695 488120 760706 525257 461224 738471 421965 459098 457915 512590 597147 407283 433447 455546 465970 473893 399795 425333 427397 447076 186988 824068 539371 659200 719033 599473 617353 637803 782475 739912 739079 759686 725207 728042 738852 721748 531935 707693 753250 442384 718810 108764 387393 443668 814993 820936 826307 826703 826560 819780 820722 827620 819346 819449 819756 825975 826156 825449 826371 826883 466041 497365 507705 542305 553713 577287 578712 581205 560263 692840 695444 648167 661599 715573 715935 719559 645804 660276 666197 677146 710041 717455 545894 581181 601190 625916 639304 591085 629610 778815 784846 789023 793653 796564 800176 808601 781913 797474 801489 802794 805004 808492 812377 724079 724802 725243 732595 743350 744196 769202 784215 784410 793818 794717 809370 725202 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (2.28%) |
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 108764 186988 387393 394013 399795 407283 421965 425333 427397 433447 442384 443668 447076 455546 456695 457915 459098 461224 465970 466041 473893 488120 497365 507705 512590 525257 531935 539371 542305 545894 553713 560263 577287 578712 581181 581205 591085 597147 599473 601190 617353 625916 629610 637803 639304 645804 648167 659200 660276 661599 666197 677146 692840 695444 707459 707693 710041 710486 715573 715935 717455 718810 719033 719559 721748 724079 724802 725202 725207 725243 728042 732595 738471 738852 739079 739912 743350 744196 753250 759686 760706 769202 778815 781913 782475 784215 784410 784846 789023 791099 793653 793818 794717 796564 797474 800176 801489 802794 805004 808492 808601 809370 812377 814993 819346 819449 819756 819780 820722 820936 824068 825449 825975 826307 826371 826560 826703 826883 827620 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits cum"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон cum"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон cum"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.93%) |
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.