Query Metrics
7
Database Queries
7
Different statements
590.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
564.46 ms (95.55%) |
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 40835 90460 188462 308583 383672 384543 386567 388734 389966 391561 422819 490250 490310 497757 507851 513394 534191 538948 551551 558808 560339 562450 572128 572129 575010 584463 587340 588121 590105 590111 595078 595469 598486 599619 605592 607814 611518 615068 616505 617374 626470 629955 630447 635055 636786 640302 647547 647586 648379 650263 654785 654794 660306 661414 663208 673332 673825 674866 681926 697108 702047 706693 712609 712676 715246 716303 717130 718570 719454 720407 720906 721095 724450 725309 725604 725709 726305 733510 735597 752470 753550 753589 755515 756639 758048 758059 758763 761359 761706 761892 762643 762714 764030 765560 768059 768150 769370 774883 775716 776404 778078 780219 784477 787356 788853 792618 792964 792970 795628 798799 800515 801686 802238 802351 804979 810756 813181 826066 826177 827785 ] |
||||||||||||||||||||||||||||||
|
15.57 ms (2.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 560339 681926 648379 673332 654785 673825 674866 706693 712676 715246 718570 720906 562450 588121 599619 626470 635055 636786 587340 595469 590111 595078 630447 780219 792970 776404 800515 802351 726305 733510 752470 761892 762714 765560 768059 735597 755515 758059 761359 724450 615068 629955 697108 792964 798799 804979 391561 490310 584463 572128 188462 490250 513394 386567 90460 40835 826177 538948 507851 719454 720407 717130 647586 654794 663208 702047 607814 616505 590105 611518 617374 640302 774883 778078 795628 810756 784477 788853 802238 725309 725604 725709 761706 792618 813181 753550 753589 758763 768150 756639 762643 764030 758048 769370 605592 716303 721095 775716 787356 801686 308583 384543 422819 598486 389966 497757 660306 383672 388734 826066 827785 534191 558808 551551 572129 575010 650263 712609 647547 661414 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (0.58%) |
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 40835 90460 188462 308583 383672 384543 386567 388734 389966 391561 422819 490250 490310 497757 507851 513394 534191 538948 551551 558808 560339 562450 572128 572129 575010 584463 587340 588121 590105 590111 595078 595469 598486 599619 605592 607814 611518 615068 616505 617374 626470 629955 630447 635055 636786 640302 647547 647586 648379 650263 654785 654794 660306 661414 663208 673332 673825 674866 681926 697108 702047 706693 712609 712676 715246 716303 717130 718570 719454 720407 720906 721095 724450 725309 725604 725709 726305 733510 735597 752470 753550 753589 755515 756639 758048 758059 758763 761359 761706 761892 762643 762714 764030 765560 768059 768150 769370 774883 775716 776404 778078 780219 784477 787356 788853 792618 792964 792970 795628 798799 800515 801686 802238 802351 804979 810756 813181 826066 826177 827785 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ridding hard"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз hard"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"наездниц поз hard"
]
|
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.