Query Metrics
7
Database Queries
7
Different statements
154.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.37 ms (84.55%) |
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 399500 457780 464297 482890 485648 512466 520188 531121 531249 542760 543360 544177 546802 547989 551186 559026 562592 562827 566579 568281 574501 574596 579635 581427 590375 590472 593622 599525 599783 603041 603553 606910 607376 608035 609121 609603 618199 618591 619408 621972 622661 633899 636269 638631 640712 644314 644321 644686 645879 649137 649180 649602 650808 650850 653378 653943 654275 654295 655078 661354 661955 663466 664823 665227 665284 665457 665816 665916 666828 667498 667636 667859 679102 681057 683247 684014 688325 690040 691990 691992 692293 692455 693596 702234 703096 707275 707546 708094 715554 718376 720965 723919 730409 736141 740804 741280 743803 745785 746990 748354 759473 770882 770912 771453 771670 775772 775897 775982 779591 794944 808112 809521 814556 815080 815347 816905 817469 817762 823622 825119 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (8.94%) |
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 574596 542760 562592 649137 661354 546802 581427 775982 457780 568281 485648 566579 579635 653378 715554 649602 667859 707546 606910 644686 607376 633899 743803 707275 399500 679102 603553 808112 691990 645879 654275 684014 640712 644321 748354 547989 654295 655078 603041 482890 816905 825119 817469 544177 574501 665816 681057 691992 665916 562827 599525 636269 609603 644314 608035 638631 736141 759473 770912 809521 723919 740804 702234 775897 817762 512466 559026 653943 663466 664823 667498 688325 692455 693596 650850 661955 683247 708094 619408 590375 590472 618199 622661 621972 779591 794944 775772 741280 771453 746990 745785 771670 730409 770882 520188 814556 815080 815347 823622 531121 531249 464297 551186 543360 650808 665457 667636 703096 720965 649180 665227 666828 718376 665284 690040 692293 609121 593622 599783 618591 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.71%) |
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 399500 457780 464297 482890 485648 512466 520188 531121 531249 542760 543360 544177 546802 547989 551186 559026 562592 562827 566579 568281 574501 574596 579635 581427 590375 590472 593622 599525 599783 603041 603553 606910 607376 608035 609121 609603 618199 618591 619408 621972 622661 633899 636269 638631 640712 644314 644321 644686 645879 649137 649180 649602 650808 650850 653378 653943 654275 654295 655078 661354 661955 663466 664823 665227 665284 665457 665816 665916 666828 667498 667636 667859 679102 681057 683247 684014 688325 690040 691990 691992 692293 692455 693596 702234 703096 707275 707546 708094 715554 718376 720965 723919 730409 736141 740804 741280 743803 745785 746990 748354 759473 770882 770912 771453 771670 775772 775897 775982 779591 794944 808112 809521 814556 815080 815347 816905 817469 817762 823622 825119 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob sex"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.