Query Metrics
7
Database Queries
7
Different statements
144.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.60 ms (83.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 20715 385923 525406 525602 529600 532724 538746 539960 543038 550729 550990 552648 554683 558623 559296 559415 563283 565644 567240 569221 575449 575904 588790 595134 596112 597456 597935 605749 605899 609566 614185 616889 617768 620989 623056 627937 630478 630899 631294 632230 634476 635822 636954 638334 640073 641656 642764 645529 646639 648389 648891 648906 648948 654806 657959 658752 662872 663275 664446 673209 676213 686148 686521 691290 697610 697663 698236 698490 699185 700907 701811 704888 708704 708730 711717 713683 716532 718359 722094 724017 727028 730479 732980 738028 739135 742278 743870 750572 750978 751383 752625 753715 761449 762993 765326 766174 768384 768859 781175 783137 789387 791094 796603 802918 803742 807634 809971 811219 812046 812392 813315 819465 819840 823212 823923 824319 824663 827699 827741 828172 ] |
||||||||||||||||||||||||||||||
|
13.75 ms (9.54%) |
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 827741 819465 819840 823212 525602 525406 575449 569221 657959 664446 676213 646639 648389 658752 697610 708730 648891 648906 654806 663275 699185 708704 559296 559415 631294 641656 597456 597935 614185 620989 635822 595134 634476 636954 605749 609566 781175 803742 812046 791094 809971 812392 724017 738028 742278 750978 752625 753715 766174 789387 811219 732980 727028 730479 739135 750572 765326 762993 768384 743870 751383 761449 768859 617768 627937 632230 638334 642764 701811 722094 783137 796603 802918 807634 813315 20715 385923 824663 823923 824319 828172 827699 539960 529600 532724 538746 550729 550990 552648 565644 543038 554683 563283 575904 662872 691290 700907 716532 718359 645529 648948 673209 686148 686521 697663 698490 704888 698236 711717 713683 558623 567240 630478 596112 640073 588790 616889 623056 605899 630899 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (2.22%) |
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 20715 385923 525406 525602 529600 532724 538746 539960 543038 550729 550990 552648 554683 558623 559296 559415 563283 565644 567240 569221 575449 575904 588790 595134 596112 597456 597935 605749 605899 609566 614185 616889 617768 620989 623056 627937 630478 630899 631294 632230 634476 635822 636954 638334 640073 641656 642764 645529 646639 648389 648891 648906 648948 654806 657959 658752 662872 663275 664446 673209 676213 686148 686521 691290 697610 697663 698236 698490 699185 700907 701811 704888 708704 708730 711717 713683 716532 718359 722094 724017 727028 730479 732980 738028 739135 742278 743870 750572 750978 751383 752625 753715 761449 762993 765326 766174 768384 768859 781175 783137 789387 791094 796603 802918 803742 807634 809971 811219 812046 812392 813315 819465 819840 823212 823923 824319 824663 827699 827741 828172 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"and watch"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"watch"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"watch"
]
|
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.