Query Metrics
7
Database Queries
7
Different statements
146.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.41 ms (82.93%) |
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 2332 382554 403312 403361 404464 407052 407054 407187 408213 412081 416277 421328 427898 430495 432704 435745 435941 448829 453378 457624 464381 464815 468808 481665 491997 499332 507590 510466 517922 520686 523387 527430 528701 531894 531906 532265 532356 532587 533434 535540 536728 543909 558194 565686 567718 568546 579131 579813 579838 580522 585726 586652 586917 591588 596904 607235 612335 612854 624293 627280 629417 631654 650845 673981 674452 678940 699025 700753 713169 720117 726656 738082 741115 753064 766650 771517 772463 772775 774533 788075 788993 789712 790001 790004 796236 797593 804270 804543 805564 806153 806176 806987 807548 807612 808613 808633 808701 809241 812183 812716 813270 813767 813772 814188 814770 814917 815189 815581 815761 815765 815830 816209 816574 817247 821284 821345 821583 821899 824637 826971 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (10.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 766650 772463 738082 741115 627280 720117 788993 804270 806176 807612 812183 812716 813270 2332 468808 382554 403361 432704 404464 407052 407054 416277 435941 430495 435745 457624 464815 568546 650845 580522 586652 586917 806153 771517 403312 408213 464381 481665 421328 427898 453378 507590 517922 520686 523387 535540 536728 491997 527430 528701 558194 612335 596904 448829 412081 499332 510466 699025 407187 814188 815830 821284 813767 813772 814917 815581 815761 817247 821345 821899 824637 826971 815189 816574 821583 814770 815765 816209 532265 532356 531894 531906 532587 533434 543909 579838 567718 565686 579131 579813 674452 673981 700753 678940 713169 585726 629417 631654 612854 624293 591588 607235 789712 790001 790004 796236 797593 804543 806987 807548 808613 774533 805564 808633 808701 809241 726656 753064 772775 788075 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (2.01%) |
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 2332 382554 403312 403361 404464 407052 407054 407187 408213 412081 416277 421328 427898 430495 432704 435745 435941 448829 453378 457624 464381 464815 468808 481665 491997 499332 507590 510466 517922 520686 523387 527430 528701 531894 531906 532265 532356 532587 533434 535540 536728 543909 558194 565686 567718 568546 579131 579813 579838 580522 585726 586652 586917 591588 596904 607235 612335 612854 624293 627280 629417 631654 650845 673981 674452 678940 699025 700753 713169 720117 726656 738082 741115 753064 766650 771517 772463 772775 774533 788075 788993 789712 790001 790004 796236 797593 804270 804543 805564 806153 806176 806987 807548 807612 808613 808633 808701 809241 812183 812716 813270 813767 813772 814188 814770 814917 815189 815581 815761 815765 815830 816209 816574 817247 821284 821345 821583 821899 824637 826971 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom latina"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom латинская"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom латинская"
]
|
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.