Query Metrics
7
Database Queries
7
Different statements
401.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.91 ms (51.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
162.74 ms (40.52%) |
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 191343 233292 233667 385638 385826 397220 398466 406063 408978 409945 411742 425590 447806 466804 466888 466919 466970 470861 471600 472696 472860 475674 476408 476966 479028 483138 485813 487354 504820 507691 525499 536955 537827 540668 545897 546133 547029 548049 548393 557183 579382 589577 599735 607607 610034 615631 623335 642286 643071 663893 665115 665346 665440 665499 665895 666070 666798 667273 667484 670501 685910 692503 710011 712823 714155 721002 726311 726808 726910 731767 733424 738296 739174 739686 739709 741787 741795 742536 745444 752977 754133 758293 770112 770117 773901 779198 780670 780710 781657 781760 781976 781978 782256 784632 788721 789407 794734 795221 797007 801029 801822 803684 804453 807638 808271 810770 811428 812537 814113 817393 818648 819628 820284 823944 823976 824900 824938 825238 827184 827668 ] |
||||||||||||||||||||||||||||||
|
22.08 ms (5.50%) |
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 773901 781976 794734 795221 803684 804453 808271 726311 726910 739174 770117 745444 739686 741787 731767 710011 714155 721002 780710 781760 784632 811428 409945 191343 233292 479028 485813 385826 397220 398466 824938 814113 820284 823976 827184 818648 825238 817393 819628 824900 827668 466804 487354 537827 540668 504820 536955 507691 466919 472860 476408 546133 548393 545897 547029 548049 579382 666070 666798 685910 663893 665115 665499 667484 670501 692503 665346 665440 665895 667273 557183 589577 610034 643071 607607 623335 599735 781978 788721 797007 801822 779198 780670 781657 801029 789407 739709 754133 742536 733424 738296 741795 770112 726808 752977 758293 642286 782256 807638 812537 466970 425590 233667 615631 525499 466888 475674 712823 810770 472696 385638 406063 408978 411742 823944 447806 470861 471600 476966 483138 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (0.91%) |
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 191343 233292 233667 385638 385826 397220 398466 406063 408978 409945 411742 425590 447806 466804 466888 466919 466970 470861 471600 472696 472860 475674 476408 476966 479028 483138 485813 487354 504820 507691 525499 536955 537827 540668 545897 546133 547029 548049 548393 557183 579382 589577 599735 607607 610034 615631 623335 642286 643071 663893 665115 665346 665440 665499 665895 666070 666798 667273 667484 670501 685910 692503 710011 712823 714155 721002 726311 726808 726910 731767 733424 738296 739174 739686 739709 741787 741795 742536 745444 752977 754133 758293 770112 770117 773901 779198 780670 780710 781657 781760 781976 781978 782256 784632 788721 789407 794734 795221 797007 801029 801822 803684 804453 807638 808271 810770 811428 812537 814113 817393 818648 819628 820284 823944 823976 824900 824938 825238 827184 827668 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"granny hair"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"granny hair"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"granny 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.