Query Metrics
7
Database Queries
7
Different statements
215.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.78 ms (86.79%) |
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 413594 416252 417306 418828 419067 420132 421357 424672 425555 425835 426117 428029 428117 430349 431530 433486 434212 435341 435452 435697 439203 441536 442237 442680 443138 444315 446148 446587 447373 449372 450785 451034 454856 457781 460282 461435 462566 463059 464699 468054 469763 473180 473297 473586 473596 473597 475428 476921 477895 478828 479021 490035 500583 500591 502453 502477 508468 514642 516674 523712 523803 526383 528100 528525 529462 530870 533209 542539 543048 543133 558353 558522 559686 565195 574364 574426 578610 579669 579792 583329 585003 587251 587253 587791 591402 596642 596739 598655 598786 600973 601234 601400 608921 609096 609816 619255 622594 628653 633173 641901 644070 649225 668472 672418 673583 707434 720271 727871 755181 766021 772024 784801 785397 804071 808898 809668 812790 820871 821053 822598 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (8.64%) |
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 461435 446587 473297 526383 479021 578610 672418 608921 587791 609096 596642 622594 772024 808898 435341 462566 419067 451034 424672 454856 478828 529462 447373 523803 516674 559686 673583 579792 628653 785397 804071 428117 442237 591402 533209 609816 784801 514642 425555 530870 574364 707434 755181 727871 433486 508468 475428 473586 476921 435452 441536 444315 820871 601400 469763 418828 446148 449372 463059 500591 600973 596739 413594 558353 473596 457781 460282 502453 500583 473597 558522 473180 442680 450785 809668 420132 585003 523712 542539 720271 598655 644070 766021 477895 421357 431530 435697 439203 425835 443138 821053 528100 668472 598786 619255 601234 464699 430349 428029 502477 434212 417306 822598 468054 490035 528525 543048 543133 565195 579669 574426 583329 649225 587251 587253 812790 633173 641901 416252 426117 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.27%) |
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 413594 416252 417306 418828 419067 420132 421357 424672 425555 425835 426117 428029 428117 430349 431530 433486 434212 435341 435452 435697 439203 441536 442237 442680 443138 444315 446148 446587 447373 449372 450785 451034 454856 457781 460282 461435 462566 463059 464699 468054 469763 473180 473297 473586 473596 473597 475428 476921 477895 478828 479021 490035 500583 500591 502453 502477 508468 514642 516674 523712 523803 526383 528100 528525 529462 530870 533209 542539 543048 543133 558353 558522 559686 565195 574364 574426 578610 579669 579792 583329 585003 587251 587253 587791 591402 596642 596739 598655 598786 600973 601234 601400 608921 609096 609816 619255 622594 628653 633173 641901 644070 649225 668472 672418 673583 707434 720271 727871 755181 766021 772024 784801 785397 804071 808898 809668 812790 820871 821053 822598 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пов жмж"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.71%) |
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.