Query Metrics
7
Database Queries
7
Different statements
279.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
253.97 ms (90.99%) |
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 476539 485611 496399 501367 506818 520196 537518 543465 552875 558911 560693 571107 578716 579500 580816 581581 585343 586346 590612 591559 599398 599539 603668 604432 606497 606772 611443 620189 624819 626328 631986 634298 636014 644178 644478 656674 656915 659334 663562 665997 667057 678607 679564 684705 686385 689214 697604 700902 702275 702382 703587 704594 704598 707145 708696 709721 710091 718699 725097 726169 726623 727343 729082 729170 729217 730158 732592 733202 734365 737926 740080 742661 753058 754854 759474 761372 761953 766334 766457 766462 766702 769248 771069 774597 780831 785180 787907 788332 788866 794588 794676 794861 795332 795795 795843 795906 796288 796497 796611 797783 797878 799136 799886 801612 802022 803202 803562 803840 805098 808492 809347 810310 812724 814026 818825 819708 819948 824420 827182 827936 ] |
||||||||||||||||||||||||||||||
|
15.16 ms (5.43%) |
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 679564 703587 665997 684705 689214 571107 591559 644178 586346 606497 611443 794676 805098 740080 794588 761953 733202 734365 754854 787907 796288 537518 814026 827936 636014 753058 819948 827182 476539 496399 581581 702382 700902 697604 552875 634298 585343 795795 803840 809347 785180 810310 729170 730158 726169 766702 726623 759474 732592 737926 620189 709721 819708 543465 578716 686385 710091 678607 644478 590612 780831 796497 788332 794861 796611 803562 795843 801612 769248 704594 799136 812724 603668 729082 761372 704598 656674 520196 824420 560693 702275 708696 599539 626328 802022 803202 766334 766457 729217 742661 771069 795332 797783 506818 818825 485611 501367 579500 580816 659334 663562 707145 718699 656915 667057 558911 606772 599398 604432 624819 631986 774597 788866 797878 799886 808492 727343 795906 725097 766462 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (0.97%) |
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 476539 485611 496399 501367 506818 520196 537518 543465 552875 558911 560693 571107 578716 579500 580816 581581 585343 586346 590612 591559 599398 599539 603668 604432 606497 606772 611443 620189 624819 626328 631986 634298 636014 644178 644478 656674 656915 659334 663562 665997 667057 678607 679564 684705 686385 689214 697604 700902 702275 702382 703587 704594 704598 707145 708696 709721 710091 718699 725097 726169 726623 727343 729082 729170 729217 730158 732592 733202 734365 737926 740080 742661 753058 754854 759474 761372 761953 766334 766457 766462 766702 769248 771069 774597 780831 785180 787907 788332 788866 794588 794676 794861 795332 795795 795843 795906 796288 796497 796611 797783 797878 799136 799886 801612 802022 803202 803562 803840 805098 808492 809347 810310 812724 814026 818825 819708 819948 824420 827182 827936 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"my husband"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.61%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"my husband"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"my husband"
]
|
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.