Query Metrics
7
Database Queries
7
Different statements
153.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.18 ms (82.46%) |
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 400521 402518 426218 456363 508231 522976 523054 528294 530125 530234 533954 536050 542278 560030 565981 569657 576164 579749 583531 585785 590653 591559 593837 606999 608319 611547 612888 620486 622930 631356 634376 635587 635789 635850 647458 647915 652803 653359 665939 666987 669692 671408 686521 689229 693217 696173 702995 703140 704542 714544 716709 718142 720351 720844 725237 727543 730188 730987 732701 732816 732883 732893 734664 734677 736234 736861 737277 740789 746712 749632 750340 751397 754854 755111 757486 759474 762911 767704 768096 768895 770774 775542 776714 778135 778905 784274 788009 788245 789488 793308 794653 794817 796610 797123 797638 800618 800833 800901 801183 801533 802186 802376 803590 803804 803892 805788 806710 808240 812302 814967 816099 818395 819028 819146 819505 823285 823441 823549 824541 826087 ] |
||||||||||||||||||||||||||||||
|
16.63 ms (10.87%) |
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 788245 794653 800618 802376 806710 725237 730188 732893 750340 757486 746712 751397 727543 740789 768096 768895 612888 620486 635850 704542 718142 720844 778135 796610 797123 801183 803892 522976 591559 800901 736861 762911 754854 426218 826087 818395 824541 814967 819146 456363 530125 530234 696173 671408 720351 593837 590653 749632 759474 528294 400521 402518 823285 816099 819028 823549 819505 823441 523054 533954 508231 536050 542278 560030 565981 569657 579749 576164 583531 647458 652803 669692 647915 653359 665939 666987 686521 689229 703140 716709 693217 702995 714544 606999 611547 635789 585785 622930 634376 635587 608319 631356 776714 788009 793308 803590 808240 775542 778905 797638 801533 802186 803804 812302 730987 732816 734664 737277 755111 770774 784274 789488 794817 800833 805788 732701 734677 736234 767704 732883 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.30%) |
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 400521 402518 426218 456363 508231 522976 523054 528294 530125 530234 533954 536050 542278 560030 565981 569657 576164 579749 583531 585785 590653 591559 593837 606999 608319 611547 612888 620486 622930 631356 634376 635587 635789 635850 647458 647915 652803 653359 665939 666987 669692 671408 686521 689229 693217 696173 702995 703140 704542 714544 716709 718142 720351 720844 725237 727543 730188 730987 732701 732816 732883 732893 734664 734677 736234 736861 737277 740789 746712 749632 750340 751397 754854 755111 757486 759474 762911 767704 768096 768895 770774 775542 776714 778135 778905 784274 788009 788245 789488 793308 794653 794817 796610 797123 797638 800618 800833 800901 801183 801533 802186 802376 803590 803804 803892 805788 806710 808240 812302 814967 816099 818395 819028 819146 819505 823285 823441 823549 824541 826087 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass husband"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп husband"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп 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.