Query Metrics
7
Database Queries
7
Different statements
401.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.19 ms (52.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
167.85 ms (41.84%) |
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 6591 35344 191487 193666 236863 395702 395706 395919 398816 399401 404800 404829 406332 406992 407614 407777 411745 413833 418065 419551 432786 464743 468536 469846 469920 470236 470495 475799 484648 484735 499543 504173 515185 515187 515194 515213 518028 520774 521443 523854 533548 536998 550430 550979 554323 559195 560425 567339 568384 583592 589752 593368 598450 603436 604142 609568 615812 618513 619406 620768 623476 628292 632268 644686 644689 649602 654846 660963 663956 665681 665866 666159 667486 667693 672709 678778 678782 678790 684541 684543 684547 691995 693074 700426 710832 716777 720823 721109 722809 726892 730098 732733 734481 740690 741275 742449 742484 743803 744265 758180 760957 775836 790213 790220 805023 805372 805601 807514 809300 809302 810834 814069 815051 817033 817448 817597 821846 821852 821856 825561 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (3.62%) |
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 6591 821852 821856 821846 825561 533548 536998 654846 649602 666159 693074 716777 644686 619406 589752 623476 775836 790220 805372 742484 730098 726892 743803 790213 809302 815051 469846 499543 684541 665866 758180 470495 395919 598450 418065 583592 404829 470236 515185 550979 618513 593368 628292 615812 732733 484648 560425 515194 520774 678778 678782 678790 504173 663956 550430 523854 406992 710832 691995 807514 395706 406332 604142 469920 413833 518028 35344 399401 404800 407777 407614 432786 468536 475799 684543 722809 667693 684547 609568 644689 734481 740690 760957 398816 395702 193666 667486 672709 809300 464743 484735 515187 236863 191487 411745 817448 817033 817597 814069 515213 521443 559195 567339 554323 660963 665681 720823 568384 632268 805023 805601 742449 744265 741275 603436 620768 700426 721109 810834 419551 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (0.78%) |
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 6591 35344 191487 193666 236863 395702 395706 395919 398816 399401 404800 404829 406332 406992 407614 407777 411745 413833 418065 419551 432786 464743 468536 469846 469920 470236 470495 475799 484648 484735 499543 504173 515185 515187 515194 515213 518028 520774 521443 523854 533548 536998 550430 550979 554323 559195 560425 567339 568384 583592 589752 593368 598450 603436 604142 609568 615812 618513 619406 620768 623476 628292 632268 644686 644689 649602 654846 660963 663956 665681 665866 666159 667486 667693 672709 678778 678782 678790 684541 684543 684547 691995 693074 700426 710832 716777 720823 721109 722809 726892 730098 732733 734481 740690 741275 742449 742484 743803 744265 758180 760957 775836 790213 790220 805023 805372 805601 807514 809300 809302 810834 814069 815051 817033 817448 817597 821846 821852 821856 825561 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mmf old"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро old"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мжм секс втро old"
]
|
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.