Query Metrics
7
Database Queries
7
Different statements
137.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.41 ms (83.06%) |
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 73571 91512 384883 404054 432480 608439 612146 617713 618510 632982 696894 698283 703749 705031 714249 719554 724525 724859 724991 725067 726609 728643 730469 730967 731823 732510 732903 734103 734109 735973 736909 737813 738642 738791 739240 740283 740850 740937 741240 741261 742540 743511 743640 743936 744371 744406 744521 744841 745474 746624 746677 747770 748095 748331 748526 749453 749579 750974 753405 753630 754360 754613 755228 755238 756847 757447 757894 757970 759051 759489 760334 760789 763470 763472 763644 763938 765005 765436 766221 767621 767803 768649 769139 769207 769217 769221 770101 770535 772570 772631 773061 773596 775631 777430 778182 778291 783113 783646 783846 784095 784611 785966 786431 786794 791789 794025 794186 795517 795885 797059 797606 797677 801425 802349 805452 808307 810307 810655 811823 812190 ] |
||||||||||||||||||||||||||||||
|
13.03 ms (9.46%) |
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 767621 767803 769139 769207 770535 772570 773061 783846 784095 794025 794186 802349 808307 811823 812190 724525 724991 734103 735973 736909 737813 743936 744371 744406 744521 744841 748331 749453 757970 760789 765436 769221 770101 772631 725067 730469 731823 732903 738791 739240 740283 741240 743511 745474 747770 748526 749579 754360 757894 759051 759489 763470 763938 765005 768649 769217 773596 730967 734109 740850 741261 746624 746677 748095 753630 755228 755238 757447 760334 763472 724859 726609 728643 732510 738642 740937 742540 743640 750974 753405 754613 756847 763644 766221 608439 612146 617713 618510 632982 696894 698283 703749 705031 714249 719554 775631 777430 778182 778291 783113 783646 784611 785966 786431 786794 791789 795517 795885 797059 797606 797677 801425 805452 810307 810655 91512 384883 404054 432480 73571 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.90%) |
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 73571 91512 384883 404054 432480 608439 612146 617713 618510 632982 696894 698283 703749 705031 714249 719554 724525 724859 724991 725067 726609 728643 730469 730967 731823 732510 732903 734103 734109 735973 736909 737813 738642 738791 739240 740283 740850 740937 741240 741261 742540 743511 743640 743936 744371 744406 744521 744841 745474 746624 746677 747770 748095 748331 748526 749453 749579 750974 753405 753630 754360 754613 755228 755238 756847 757447 757894 757970 759051 759489 760334 760789 763470 763472 763644 763938 765005 765436 766221 767621 767803 768649 769139 769207 769217 769221 770101 770535 772570 772631 773061 773596 775631 777430 778182 778291 783113 783646 783846 784095 784611 785966 786431 786794 791789 794025 794186 795517 795885 797059 797606 797677 801425 802349 805452 808307 810307 810655 811823 812190 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx hot"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx hot 1993"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx hot"
]
|
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.