Query Metrics
7
Database Queries
7
Different statements
182.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.89 ms (85.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 385042 391718 393731 393741 393745 393751 393780 395221 396757 400418 400458 400903 418484 429257 445040 452490 455180 459811 460036 462781 462961 464145 465805 467320 470733 473928 475918 480006 512869 514787 515108 515165 515189 515220 519973 520730 523172 525605 550227 552014 556379 557270 560372 561734 566517 566524 566526 567149 567934 569659 569672 577515 578465 593138 593440 594014 597259 599548 603126 612296 614094 618887 618970 622888 624276 625490 644654 663940 664287 664958 665399 666141 669430 669443 670513 672767 676930 676978 681813 684187 684995 688579 696969 700541 700945 708823 721006 732421 735820 736022 736980 740610 741646 741650 743116 743142 744443 748632 748989 754216 757973 759578 759581 775258 775578 775825 778419 780713 788647 794702 798897 805346 805847 810775 817622 817630 818920 823700 824824 828053 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (8.96%) |
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 452490 577515 741650 567934 612296 552014 664958 614094 599548 775258 743142 759581 569659 569672 465805 519973 462781 560372 663940 669430 670513 696969 684995 561734 780713 736022 794702 721006 778419 385042 622888 473928 828053 391718 700541 557270 744443 393745 462961 464145 556379 676930 665399 666141 681813 566517 566526 593440 597259 594014 775825 805847 805346 748989 732421 788647 393731 429257 480006 550227 567149 566524 475918 470733 455180 512869 515189 523172 515165 810775 817630 817622 684187 603126 798897 393741 393780 400418 400458 459811 467320 515220 515108 525605 514787 460036 578465 672767 664287 669443 688579 700945 708823 593138 618970 624276 736980 740610 741646 754216 757973 748632 759578 735820 743116 644654 445040 400903 395221 396757 818920 824824 823700 625490 775578 393751 418484 520730 676978 618887 ] |
||||||||||||||||||||||||||||||
|
2.85 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 385042 391718 393731 393741 393745 393751 393780 395221 396757 400418 400458 400903 418484 429257 445040 452490 455180 459811 460036 462781 462961 464145 465805 467320 470733 473928 475918 480006 512869 514787 515108 515165 515189 515220 519973 520730 523172 525605 550227 552014 556379 557270 560372 561734 566517 566524 566526 567149 567934 569659 569672 577515 578465 593138 593440 594014 597259 599548 603126 612296 614094 618887 618970 622888 624276 625490 644654 663940 664287 664958 665399 666141 669430 669443 670513 672767 676930 676978 681813 684187 684995 688579 696969 700541 700945 708823 721006 732421 735820 736022 736980 740610 741646 741650 743116 743142 744443 748632 748989 754216 757973 759578 759581 775258 775578 775825 778419 780713 788647 794702 798897 805346 805847 810775 817622 817630 818920 823700 824824 828053 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young girl old"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк old"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк old"
]
|
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.