Query Metrics
7
Database Queries
7
Different statements
157.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.86 ms (82.52%) |
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 383604 386214 389457 391885 392033 393350 402788 409701 437265 438010 438100 440257 440749 456027 456220 457885 459935 460507 460782 461161 464530 477213 478143 479457 479498 484246 487604 488937 492010 499418 500277 501066 503020 506315 506492 512757 513520 526358 527845 537021 537622 544636 545896 546885 550963 554101 554955 555549 555670 555672 556154 557596 558715 561242 567862 573344 574124 576744 582031 582448 588862 593714 595848 599805 599818 601351 602712 609187 612482 617710 622615 623731 626841 627167 636487 643636 645976 650275 659065 660090 664514 667406 691125 708681 709900 713924 714755 718703 721275 729357 729897 729903 745685 748134 748699 750298 756914 760303 763886 769573 773446 784410 786040 796521 798735 798852 801725 807289 817214 817391 817409 817470 817530 817672 818808 819937 824002 824943 825846 827406 ] |
||||||||||||||||||||||||||||||
|
15.94 ms (10.13%) |
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 506492 818808 501066 546885 437265 487604 558715 555549 650275 659065 660090 623731 599805 807289 798735 748699 461161 512757 748134 478143 506315 561242 786040 729903 438010 643636 456220 817672 817214 819937 825846 691125 769573 557596 721275 391885 544636 588862 500277 503020 545896 555672 555670 582448 718703 554101 593714 729357 784410 617710 713924 456027 386214 459935 576744 567862 773446 756914 817470 537622 556154 595848 599818 622615 460782 477213 492010 664514 609187 745685 763886 612482 438100 393350 554955 667406 402788 817391 817409 824002 574124 729897 827406 645976 601351 798852 537021 440257 409701 626841 796521 824943 582031 464530 499418 750298 457885 573344 479498 484246 383604 389457 627167 392033 817530 440749 714755 709900 479457 526358 513520 488937 527845 550963 708681 636487 801725 760303 602712 460507 ] |
||||||||||||||||||||||||||||||
|
3.60 ms (2.29%) |
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 383604 386214 389457 391885 392033 393350 402788 409701 437265 438010 438100 440257 440749 456027 456220 457885 459935 460507 460782 461161 464530 477213 478143 479457 479498 484246 487604 488937 492010 499418 500277 501066 503020 506315 506492 512757 513520 526358 527845 537021 537622 544636 545896 546885 550963 554101 554955 555549 555670 555672 556154 557596 558715 561242 567862 573344 574124 576744 582031 582448 588862 593714 595848 599805 599818 601351 602712 609187 612482 617710 622615 623731 626841 627167 636487 643636 645976 650275 659065 660090 664514 667406 691125 708681 709900 713924 714755 718703 721275 729357 729897 729903 745685 748134 748699 750298 756914 760303 763886 769573 773446 784410 786040 796521 798735 798852 801725 807289 817214 817391 817409 817470 817530 817672 818808 819937 824002 824943 825846 827406 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс жен вмашин"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трахает жену в машине…"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс жен вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.19%) |
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.