Query Metrics
7
Database Queries
7
Different statements
205.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.96 ms (88.00%) |
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 390554 412274 437742 448974 458030 469047 572501 572773 575860 577918 585263 588635 590401 591228 599666 600190 605082 609090 609479 611611 612250 619011 619371 621431 622429 622879 623624 638147 649139 651227 651727 651998 657469 660042 661928 669852 669914 670003 670315 673947 677581 677604 683689 683802 685916 689794 690265 692994 694810 695706 698039 700671 704166 706596 709556 711531 711660 712231 716880 719225 720798 720881 721429 724342 726393 730606 731783 734923 736241 736433 737752 738583 744450 744703 744735 747154 747340 749215 751321 755328 755588 758088 758163 758819 760941 762047 762183 762187 765150 767868 767962 768255 769424 769809 772571 775732 775783 777587 777878 778137 780047 780835 781677 781749 785459 785584 787345 789281 790761 792980 793062 793934 795187 796904 801492 802954 809150 810507 812340 812378 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (6.99%) |
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 572773 577918 651727 651998 670003 670315 677581 683802 694810 695706 698039 711660 712231 720798 721429 651227 657469 673947 677604 685916 689794 704166 706596 709556 719225 649139 660042 661928 669852 669914 683689 690265 692994 711531 716880 572501 575860 609090 622879 623624 585263 591228 599666 609479 611611 590401 600190 588635 612250 619011 621431 775783 790761 795187 796904 775732 777587 778137 780047 780835 781749 785459 809150 810507 749215 755588 758819 769424 785584 787345 801492 812340 812378 734923 758163 765150 767868 724342 726393 736241 736433 744703 747154 762183 767962 768255 769809 730606 731783 737752 744450 751321 760941 762047 772571 738583 744735 747340 755328 758088 762187 605082 619371 622429 638147 700671 720881 777878 781677 789281 792980 793062 793934 802954 390554 448974 458030 469047 412274 437742 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.39%) |
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 390554 412274 437742 448974 458030 469047 572501 572773 575860 577918 585263 588635 590401 591228 599666 600190 605082 609090 609479 611611 612250 619011 619371 621431 622429 622879 623624 638147 649139 651227 651727 651998 657469 660042 661928 669852 669914 670003 670315 673947 677581 677604 683689 683802 685916 689794 690265 692994 694810 695706 698039 700671 704166 706596 709556 711531 711660 712231 716880 719225 720798 720881 721429 724342 726393 730606 731783 734923 736241 736433 737752 738583 744450 744703 744735 747154 747340 749215 751321 755328 755588 758088 758163 758819 760941 762047 762183 762187 765150 767868 767962 768255 769424 769809 772571 775732 775783 777587 777878 778137 780047 780835 781677 781749 785459 785584 787345 789281 790761 792980 793062 793934 795187 796904 801492 802954 809150 810507 812340 812378 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"new"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"they are new"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"new"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.74%) |
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.