Query Metrics
7
Database Queries
7
Different statements
172.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.98 ms (85.38%) |
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 409667 414315 415109 434443 445737 462406 507915 515896 516584 523013 524198 526817 530373 530378 530495 531062 532738 533837 536676 537184 537204 537253 537648 537864 539801 541207 541863 550887 562499 577651 583444 583609 590230 590297 592126 593695 593818 599955 599961 600019 600296 600297 600716 601581 601583 612298 624805 628333 628402 630764 632707 633577 635258 636554 639760 642025 646427 647859 666895 666902 668122 675012 676638 677303 686938 689013 695764 703350 706433 709709 712676 713398 716640 723478 724719 726385 728996 731350 733138 734534 736925 738222 738410 743968 744895 746280 750484 750697 753195 761784 768199 778281 778796 779948 780252 781136 781606 782430 785617 787571 787845 788565 791773 792042 793005 793449 793657 795379 796142 796157 800394 802638 802822 803082 803363 803443 805001 810592 812644 818270 ] |
||||||||||||||||||||||||||||||
|
15.03 ms (8.73%) |
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 539801 583444 583609 562499 550887 600716 601581 733138 636554 409667 415109 530373 532738 537204 530378 533837 541207 541863 677303 647859 666902 600296 642025 590230 599955 599961 628402 632707 635258 600019 601583 434443 445737 414315 516584 524198 515896 462406 709709 686938 723478 668122 695764 703350 713398 593818 612298 780252 781606 802822 778281 778796 791773 803082 734534 736925 738222 738410 743968 744895 753195 785617 788565 793449 796157 800394 724719 726385 728996 731350 706433 795379 802638 675012 689013 628333 523013 536676 537184 530495 537648 537864 666895 646427 676638 600297 630764 639760 531062 537253 577651 624805 593695 507915 818270 526817 716640 712676 592126 590297 633577 781136 792042 796142 810592 812644 779948 787845 793005 793657 805001 746280 750484 750697 761784 768199 782430 787571 803363 803443 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.56%) |
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 409667 414315 415109 434443 445737 462406 507915 515896 516584 523013 524198 526817 530373 530378 530495 531062 532738 533837 536676 537184 537204 537253 537648 537864 539801 541207 541863 550887 562499 577651 583444 583609 590230 590297 592126 593695 593818 599955 599961 600019 600296 600297 600716 601581 601583 612298 624805 628333 628402 630764 632707 633577 635258 636554 639760 642025 646427 647859 666895 666902 668122 675012 676638 677303 686938 689013 695764 703350 706433 709709 712676 713398 716640 723478 724719 726385 728996 731350 733138 734534 736925 738222 738410 743968 744895 746280 750484 750697 753195 761784 768199 778281 778796 779948 780252 781136 781606 782430 785617 787571 787845 788565 791773 792042 793005 793449 793657 795379 796142 796157 800394 802638 802822 803082 803363 803443 805001 810592 812644 818270 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum extreme"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.97%) |
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.