Query Metrics
7
Database Queries
7
Different statements
155.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.58 ms (78.41%) |
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 195676 396980 405777 406556 409699 410724 411425 414204 416083 417363 417473 417707 420042 426547 435277 440250 441546 441631 444313 444412 445766 445778 446551 446719 448316 448375 451567 453064 453069 453073 454333 454669 455799 455873 456138 456887 457611 457644 457667 457708 457721 457723 457743 457767 457774 457776 457782 457787 457801 458437 458442 458991 459160 462644 463456 466451 467101 468928 470015 471080 471699 475062 475849 479637 479787 479928 484923 488541 495275 498402 499720 500482 505421 507831 511028 511562 512890 513517 513828 516418 517428 517626 518590 523050 525647 526168 526647 528947 529358 533631 537268 537721 539248 541606 542525 543612 544828 549137 559069 559736 562903 565095 570832 578494 579814 592917 601854 615831 633209 635577 663992 672761 784887 786651 817947 818638 818815 819440 820671 825014 ] |
||||||||||||||||||||||||||||||
|
22.93 ms (14.78%) |
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 786651 601854 457708 672761 454333 457782 457801 471699 507831 448316 457721 457743 495275 825014 453064 420042 470015 820671 817947 451567 537721 466451 784887 409699 405777 517428 457667 528947 479928 543612 819440 818638 579814 592917 457787 411425 417363 457776 518590 406556 458442 195676 517626 541606 513828 498402 818815 468928 446551 484923 525647 562903 570832 440250 456887 446719 523050 455873 417707 453073 457767 453069 578494 663992 549137 416083 455799 457723 445766 457774 459160 457644 467101 512890 499720 529358 516418 475849 559736 633209 615831 479787 454669 526647 505421 444412 444313 445778 471080 435277 463456 462644 396980 458991 456138 542525 635577 448375 488541 511562 544828 441631 426547 414204 526168 441546 410724 458437 479637 475062 417473 511028 457611 533631 500482 559069 565095 513517 537268 539248 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.99%) |
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 195676 396980 405777 406556 409699 410724 411425 414204 416083 417363 417473 417707 420042 426547 435277 440250 441546 441631 444313 444412 445766 445778 446551 446719 448316 448375 451567 453064 453069 453073 454333 454669 455799 455873 456138 456887 457611 457644 457667 457708 457721 457723 457743 457767 457774 457776 457782 457787 457801 458437 458442 458991 459160 462644 463456 466451 467101 468928 470015 471080 471699 475062 475849 479637 479787 479928 484923 488541 495275 498402 499720 500482 505421 507831 511028 511562 512890 513517 513828 516418 517428 517626 518590 523050 525647 526168 526647 528947 529358 533631 537268 537721 539248 541606 542525 543612 544828 549137 559069 559736 562903 565095 570832 578494 579814 592917 601854 615831 633209 635577 663992 672761 784887 786651 817947 818638 818815 819440 820671 825014 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass beach"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп пляж природ"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.07%) |
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.