Query Metrics
7
Database Queries
7
Different statements
193.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.94 ms (85.56%) |
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 123751 382275 383112 388183 389536 398196 401769 414070 414090 414104 415874 416613 416632 416681 416693 417621 421759 423783 428860 430262 430366 436639 437190 438752 438962 439169 439417 443244 448090 449626 450707 452565 452920 457814 457815 459005 459028 460038 460540 466624 468818 471083 477021 477246 477519 478720 479319 480206 481226 485472 488801 492942 508554 509446 511869 513000 521682 522173 525281 525489 525738 526061 547241 547746 552263 552699 554286 557650 561961 562786 564961 585788 586136 588846 589181 591427 595871 598940 599653 600907 601862 602109 602281 605791 623793 632920 659057 663811 667045 692943 718785 733676 739802 747298 752921 753635 754776 757448 758822 769435 772651 774883 784030 784662 785814 785816 786365 789436 791479 794013 797773 806543 806577 807583 808337 808997 809001 811343 812477 823310 ] |
||||||||||||||||||||||||||||||
|
17.49 ms (9.02%) |
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 492942 552699 421759 438752 452565 449626 466624 509446 659057 589181 623793 785814 602109 459028 823310 663811 774883 785816 786365 806543 769435 791479 794013 797773 812477 758822 747298 739802 753635 602281 789436 807583 522173 562786 599653 457814 481226 547241 554286 525281 508554 416693 591427 809001 436639 452920 479319 605791 588846 439169 477519 552263 806577 808337 439417 415874 772651 733676 430366 547746 595871 471083 401769 525489 430262 414070 485472 718785 123751 414104 416632 561961 632920 437190 398196 383112 389536 457815 557650 692943 752921 757448 811343 784030 438962 511869 600907 382275 388183 526061 417621 459005 468818 460038 488801 416681 477246 513000 586136 598940 784662 460540 754776 423783 443244 525738 477021 448090 564961 478720 414090 416613 450707 480206 667045 601862 585788 808997 428860 521682 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.66%) |
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 123751 382275 383112 388183 389536 398196 401769 414070 414090 414104 415874 416613 416632 416681 416693 417621 421759 423783 428860 430262 430366 436639 437190 438752 438962 439169 439417 443244 448090 449626 450707 452565 452920 457814 457815 459005 459028 460038 460540 466624 468818 471083 477021 477246 477519 478720 479319 480206 481226 485472 488801 492942 508554 509446 511869 513000 521682 522173 525281 525489 525738 526061 547241 547746 552263 552699 554286 557650 561961 562786 564961 585788 586136 588846 589181 591427 595871 598940 599653 600907 601862 602109 602281 605791 623793 632920 659057 663811 667045 692943 718785 733676 739802 747298 752921 753635 754776 757448 758822 769435 772651 774883 784030 784662 785814 785816 786365 789436 791479 794013 797773 806543 806577 807583 808337 808997 809001 811343 812477 823310 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful girl dildo"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая девушк дилд"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая девушк дилд"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.