Query Metrics
7
Database Queries
7
Different statements
177.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.17 ms (86.63%) |
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 517539 517796 520879 540111 542442 544232 545409 548389 552599 552601 553696 554705 554841 555615 566973 567639 576817 579783 580868 582277 585350 586559 596222 599987 601578 607217 608679 610771 611467 618867 618902 628332 630552 630821 632579 632706 633244 634140 635812 638740 639060 639719 642006 642226 646255 664602 667354 669248 670405 670779 671773 672401 676428 678095 680176 683045 684318 684789 692621 692683 692721 692763 693985 704582 705351 707391 709913 710843 714836 716582 719649 719910 723383 726729 728860 729187 731022 733119 738694 739919 740846 741221 741402 745998 751384 751390 751453 752477 753707 756461 757217 759313 760939 768681 771272 771857 773277 778692 783308 783357 783920 785114 790104 791003 795974 796635 797255 798387 798447 800119 800726 804371 809358 809851 811658 811852 811902 812239 814058 817613 ] |
||||||||||||||||||||||||||||||
|
14.06 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 814058 517796 540111 554705 566973 576817 542442 553696 579783 552601 580868 670779 683045 684318 692763 692683 692721 714836 719910 669248 693985 704582 709913 710843 723383 555615 567639 633244 586559 607217 618867 785114 778692 798387 798447 800726 733119 783357 790104 812239 756461 768681 771272 728860 739919 759313 771857 741402 751390 705351 795974 796635 545409 676428 678095 707391 646255 680176 582277 628332 634140 599987 639719 601578 630552 639060 642006 632579 632706 817613 517539 520879 548389 552599 554841 544232 664602 671773 672401 684789 692621 719649 667354 670405 716582 642226 618902 596222 610771 630821 585350 611467 638740 800119 809358 809851 811902 791003 757217 783308 783920 797255 804371 811658 811852 731022 740846 751384 773277 741221 751453 760939 726729 729187 752477 753707 738694 745998 608679 635812 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.75%) |
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 517539 517796 520879 540111 542442 544232 545409 548389 552599 552601 553696 554705 554841 555615 566973 567639 576817 579783 580868 582277 585350 586559 596222 599987 601578 607217 608679 610771 611467 618867 618902 628332 630552 630821 632579 632706 633244 634140 635812 638740 639060 639719 642006 642226 646255 664602 667354 669248 670405 670779 671773 672401 676428 678095 680176 683045 684318 684789 692621 692683 692721 692763 693985 704582 705351 707391 709913 710843 714836 716582 719649 719910 723383 726729 728860 729187 731022 733119 738694 739919 740846 741221 741402 745998 751384 751390 751453 752477 753707 756461 757217 759313 760939 768681 771272 771857 773277 778692 783308 783357 783920 785114 790104 791003 795974 796635 797255 798387 798447 800119 800726 804371 809358 809851 811658 811852 811902 812239 814058 817613 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss on hair"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг hair"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг hair"
]
|
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.