Query Metrics
7
Database Queries
7
Different statements
162.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.88 ms (81.00%) |
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 390212 421853 434006 435452 436138 439530 439689 440568 443258 446724 456028 456457 457566 458759 463830 463858 464136 465308 465718 465807 465998 468533 468916 476593 482549 489321 495088 500384 503459 507771 509101 509174 511399 511582 512615 512745 518824 521174 521582 522441 531975 532488 542425 547865 549696 549708 561275 561381 561848 567218 569525 574434 587436 588724 594970 602632 604318 606134 606659 607518 609432 612178 613507 623702 672381 680313 692174 695368 725657 730046 740828 747052 756463 757415 764162 765376 765552 768453 768615 771398 772051 772219 773864 782129 784080 786243 786570 789314 790298 790619 793113 793237 794533 795140 795580 795847 796583 798715 799826 800621 800800 801415 801469 802517 803943 805808 809749 814150 815063 815078 815123 815141 815928 816419 817006 817739 819533 819690 823151 826971 ] |
||||||||||||||||||||||||||||||
|
18.40 ms (11.30%) |
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 795847 798715 799826 800800 795580 789314 800621 725657 765376 457566 561848 607518 588724 623702 465998 439530 468916 518824 512615 507771 817739 786570 793237 795140 801415 512745 796583 730046 768615 757415 542425 465807 509174 500384 421853 458759 436138 561381 815141 815078 815123 692174 521174 532488 495088 509101 435452 464136 567218 439689 456028 819533 680313 802517 606134 434006 503459 549696 521582 561275 815063 465308 456457 594970 443258 817006 823151 815928 463830 465718 476593 549708 547865 602632 612178 609432 790619 773864 784080 786243 809749 772219 772051 740828 771398 756463 446724 511399 468533 390212 522441 482549 574434 587436 440568 463858 826971 805808 765552 814150 819690 816419 489321 511582 531975 569525 695368 672381 604318 606659 613507 790298 793113 794533 764162 782129 801469 803943 768453 747052 ] |
||||||||||||||||||||||||||||||
|
4.40 ms (2.70%) |
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 390212 421853 434006 435452 436138 439530 439689 440568 443258 446724 456028 456457 457566 458759 463830 463858 464136 465308 465718 465807 465998 468533 468916 476593 482549 489321 495088 500384 503459 507771 509101 509174 511399 511582 512615 512745 518824 521174 521582 522441 531975 532488 542425 547865 549696 549708 561275 561381 561848 567218 569525 574434 587436 588724 594970 602632 604318 606134 606659 607518 609432 612178 613507 623702 672381 680313 692174 695368 725657 730046 740828 747052 756463 757415 764162 765376 765552 768453 768615 771398 772051 772219 773864 782129 784080 786243 786570 789314 790298 790619 793113 793237 794533 795140 795580 795847 796583 798715 799826 800621 800800 801415 801469 802517 803943 805808 809749 814150 815063 815078 815123 815141 815928 816419 817006 817739 819533 819690 823151 826971 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov milf stockings"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов milf чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов milf чулк нижн бел"
]
|
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.