Query Metrics
7
Database Queries
7
Different statements
168.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.25 ms (83.22%) |
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 397065 397568 398025 410690 414082 414132 415303 415921 415961 415966 416536 416580 416614 416670 416733 417334 419439 424001 430350 430366 432927 432970 439365 443247 444524 445431 448854 450323 452791 454633 467885 470337 478489 483742 494493 497474 497697 498319 500339 505798 509820 511240 516588 529034 532749 534546 536641 541394 545411 545473 547452 547467 547481 547482 547494 548723 556476 561021 561034 561038 568267 569168 573188 574388 576479 580189 580207 586975 587260 588520 595339 598115 600348 601542 601696 601766 602024 604855 607799 609889 609890 624197 633755 637654 648648 651161 660364 660373 660410 669067 669075 669079 669361 669376 669386 670368 671052 671099 672925 672950 673257 695866 695868 706359 726292 737578 738814 742224 752602 755437 785606 790234 796950 798291 801284 801311 804306 806947 814459 ] |
||||||||||||||||||||||||||||||
|
17.32 ms (10.28%) |
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 561034 695868 669075 670368 478489 671099 397065 814459 532749 541394 580207 673257 586975 601542 624197 633755 806947 726292 742224 398025 672925 416580 416670 547482 573188 669067 483742 671052 448854 511240 609890 414082 416733 497697 432970 414132 419439 432927 497689 547481 547494 561038 669079 669361 669376 669386 561021 595339 430366 450323 790234 430350 410690 494493 569168 498319 648648 397568 804306 467885 439365 516588 587260 470337 452791 604855 801284 695866 637654 801311 737578 609889 588520 416536 536641 602024 798291 529034 415966 443247 416614 738814 444524 556476 547452 706359 651161 660373 672950 600348 601766 607799 755437 752602 417334 500339 505798 415303 497474 601696 424001 415961 509820 445431 547467 660410 574388 454633 545473 415921 534546 545411 580189 568267 576479 660364 548723 598115 796950 785606 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.09%) |
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 397065 397568 398025 410690 414082 414132 415303 415921 415961 415966 416536 416580 416614 416670 416733 417334 419439 424001 430350 430366 432927 432970 439365 443247 444524 445431 448854 450323 452791 454633 467885 470337 478489 483742 494493 497474 497697 498319 500339 505798 509820 511240 516588 529034 532749 534546 536641 541394 545411 545473 547452 547467 547481 547482 547494 548723 556476 561021 561034 561038 568267 569168 573188 574388 576479 580189 580207 586975 587260 588520 595339 598115 600348 601542 601696 601766 602024 604855 607799 609889 609890 624197 633755 637654 648648 651161 660364 660373 660410 669067 669075 669079 669361 669376 669386 670368 671052 671099 672925 672950 673257 695866 695868 706359 726292 737578 738814 742224 752602 755437 785606 790234 796950 798291 801284 801311 804306 806947 814459 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo anal skinny"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд анал худые"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.