Query Metrics
7
Database Queries
7
Different statements
166.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.16 ms (81.01%) |
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 154573 181334 383763 386250 392455 411304 411817 418315 464291 488841 495308 505608 511087 530316 531546 532415 533825 534502 534932 535495 543705 546104 559605 577691 588203 589366 600895 610079 612577 631012 631451 635726 635770 654351 660277 661380 663176 664696 671810 676168 677354 681533 685355 690394 698892 703395 703445 704722 706384 707774 710579 712927 718353 720644 724163 724811 730693 731887 732014 735166 735489 735979 736618 738405 739437 740485 743244 744168 745839 746853 749301 755154 755542 758104 760158 762555 763041 767095 767362 779178 782752 783710 784425 789300 789912 790991 791827 792364 793057 794758 794873 795060 797494 798722 798859 799276 800385 800738 801120 803339 803370 803427 804708 810621 812235 812287 812527 813144 814060 814280 817299 819554 820809 821434 822067 823475 824883 824951 825512 825516 ] |
||||||||||||||||||||||||||||||
|
21.26 ms (12.75%) |
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 783710 792364 789912 794873 803370 804708 813144 755542 763041 800385 812235 812527 724811 732014 738405 743244 767095 740485 744168 746853 755154 610079 631012 789300 790991 791827 411817 383763 814280 824951 814060 821434 825512 825516 531546 530316 532415 559605 660277 664696 685355 718353 677354 681533 690394 676168 704722 710579 546104 612577 600895 588203 589366 797494 798722 798859 779178 795060 800738 812287 735489 760158 784425 793057 794758 799276 801120 810621 731887 745839 735166 724163 730693 736618 739437 762555 767362 735979 749301 758104 631451 635726 635770 703445 782752 803339 803427 181334 392455 418315 495308 386250 154573 411304 819554 820809 823475 824883 817299 822067 464291 534932 511087 534502 505608 535495 533825 488841 577691 543705 663176 703395 706384 707774 720644 654351 661380 671810 698892 712927 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.56%) |
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 154573 181334 383763 386250 392455 411304 411817 418315 464291 488841 495308 505608 511087 530316 531546 532415 533825 534502 534932 535495 543705 546104 559605 577691 588203 589366 600895 610079 612577 631012 631451 635726 635770 654351 660277 661380 663176 664696 671810 676168 677354 681533 685355 690394 698892 703395 703445 704722 706384 707774 710579 712927 718353 720644 724163 724811 730693 731887 732014 735166 735489 735979 736618 738405 739437 740485 743244 744168 745839 746853 749301 755154 755542 758104 760158 762555 763041 767095 767362 779178 782752 783710 784425 789300 789912 790991 791827 792364 793057 794758 794873 795060 797494 798722 798859 799276 800385 800738 801120 803339 803370 803427 804708 810621 812235 812287 812527 813144 814060 814280 817299 819554 820809 821434 822067 823475 824883 824951 825512 825516 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"does"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"does"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"does"
]
|
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.