Query Metrics
7
Database Queries
7
Different statements
183.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.08 ms (85.63%) |
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 382462 389612 407423 409080 444703 445740 450814 460135 463828 505836 516704 524862 525756 529209 531171 536309 536337 539570 545330 545342 545365 547875 566758 581594 590312 590850 596900 597197 599260 599631 599971 601558 601620 604614 604661 604877 606392 611530 614742 617418 617429 636598 639027 640795 641359 641435 641946 643352 643406 644941 644961 648587 649964 650012 654200 681563 681636 681687 683308 684106 710685 710937 716745 720464 721060 721062 727888 732408 738089 746846 756398 757107 759865 759993 760797 766033 766166 773666 774131 785499 785688 787342 788466 788468 789201 790347 796558 798342 805367 805474 805571 805789 811094 812507 814733 814796 818419 819225 821379 821506 821524 821689 821905 821916 822217 822262 822279 822280 822822 822888 822988 822990 823230 823386 823592 825366 825965 826143 828006 828455 ] |
||||||||||||||||||||||||||||||
|
15.46 ms (8.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 796558 805367 606392 389612 409080 529209 444703 536309 746846 611530 604614 450814 463828 516704 599631 614742 407423 636598 787342 601558 604877 759993 805571 821379 641435 732408 738089 788466 823230 788468 805789 812507 599260 790347 766033 545330 683308 681636 641946 566758 601620 545342 581594 760797 721062 524862 649964 643352 805474 785499 825965 821905 644941 814796 716745 654200 545365 599971 547875 460135 531171 681687 640795 590312 756398 822217 823592 822262 828455 811094 819225 821524 821916 822280 757107 382462 721060 525756 604661 617429 590850 759865 727888 505836 826143 825366 822822 822988 823386 821506 821689 828006 539570 648587 650012 643406 773666 774131 720464 644961 814733 536337 681563 596900 617418 597197 639027 445740 818419 822888 822990 822279 710685 684106 710937 641359 789201 785688 798342 766166 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.77%) |
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 382462 389612 407423 409080 444703 445740 450814 460135 463828 505836 516704 524862 525756 529209 531171 536309 536337 539570 545330 545342 545365 547875 566758 581594 590312 590850 596900 597197 599260 599631 599971 601558 601620 604614 604661 604877 606392 611530 614742 617418 617429 636598 639027 640795 641359 641435 641946 643352 643406 644941 644961 648587 649964 650012 654200 681563 681636 681687 683308 684106 710685 710937 716745 720464 721060 721062 727888 732408 738089 746846 756398 757107 759865 759993 760797 766033 766166 773666 774131 785499 785688 787342 788466 788468 789201 790347 796558 798342 805367 805474 805571 805789 811094 812507 814733 814796 818419 819225 821379 821506 821524 821689 821905 821916 822217 822262 822279 822280 822822 822888 822988 822990 823230 823386 823592 825366 825965 826143 828006 828455 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom in black"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom black"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom black"
]
|
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.