Query Metrics
7
Database Queries
7
Different statements
167.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.65 ms (85.57%) |
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 8518 479074 497586 523797 533527 533679 534074 534132 535402 536959 540306 542494 542992 543405 553245 566418 584018 585269 593552 600359 600955 603668 604572 610972 618236 618862 619489 623346 623609 626814 631101 631150 632851 634216 635794 636821 637662 640523 640727 641303 641718 641755 644057 645046 650542 651906 653343 653384 653758 653912 654678 654695 656023 658273 663328 665342 665507 666754 667639 667669 667849 669783 673359 673361 673533 674515 675809 679360 681093 681106 681129 686615 686860 691991 692250 694322 694564 695278 695280 696009 703523 705934 712651 717607 717805 720877 720966 722648 727903 728327 728424 733024 739012 740764 742165 744744 748711 754644 761358 767874 768194 770788 775979 781996 782017 788177 788783 790615 803399 805842 807154 808047 808065 809470 815138 816216 819767 820106 824421 825629 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (7.85%) |
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 695280 712651 667639 673361 675809 679360 681093 686615 686860 717607 720877 720966 722648 651906 663328 666754 667669 691991 694564 695278 703523 584018 600359 641718 641755 585269 635794 603668 636821 641303 619489 626814 788177 788783 807154 808065 775979 790615 805842 809470 740764 761358 770788 728327 728424 742165 733024 744744 767874 748711 754644 727903 739012 768194 632851 640523 640727 717805 781996 782017 808047 8518 497586 523797 825629 816216 820106 819767 815138 824421 533679 534132 535402 540306 534074 533527 536959 479074 553245 542494 542992 543405 566418 650542 653343 653384 654678 658273 669783 681106 681129 692250 694322 696009 705934 653758 653912 654695 665342 665507 673359 674515 645046 656023 667849 673533 593552 618862 637662 604572 618236 634216 600955 610972 631101 631150 644057 623346 623609 803399 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (2.21%) |
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 8518 479074 497586 523797 533527 533679 534074 534132 535402 536959 540306 542494 542992 543405 553245 566418 584018 585269 593552 600359 600955 603668 604572 610972 618236 618862 619489 623346 623609 626814 631101 631150 632851 634216 635794 636821 637662 640523 640727 641303 641718 641755 644057 645046 650542 651906 653343 653384 653758 653912 654678 654695 656023 658273 663328 665342 665507 666754 667639 667669 667849 669783 673359 673361 673533 674515 675809 679360 681093 681106 681129 686615 686860 691991 692250 694322 694564 695278 695280 696009 703523 705934 712651 717607 717805 720877 720966 722648 727903 728327 728424 733024 739012 740764 742165 744744 748711 754644 761358 767874 768194 770788 775979 781996 782017 788177 788783 790615 803399 805842 807154 808047 808065 809470 815138 816216 819767 820106 824421 825629 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мжм мжм"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.98%) |
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.