Query Metrics
7
Database Queries
7
Different statements
207.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.39 ms (87.41%) |
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 150487 391582 391760 397410 412627 415344 423971 423972 427006 438032 443950 443955 452215 465393 466495 470147 470920 473333 480692 485945 486118 488987 499493 510772 512060 533677 534083 535613 543332 545535 545878 559973 560005 566443 573300 579474 588939 601986 603834 618910 625268 635129 640306 642354 652971 661920 662147 669886 669896 672774 673425 684693 686384 700476 704673 705111 705458 709511 711777 712952 713434 714322 714336 714346 714565 714583 714591 721575 721597 722298 725454 725469 726398 727523 729205 732725 735830 735864 736128 736847 742405 749766 757613 758292 760517 763426 763859 764112 764121 768472 768486 768828 770049 778490 779261 782034 782665 783278 786095 787286 791412 794845 795207 795329 797348 797355 799913 800370 802160 803233 803479 805140 809561 810315 812104 812108 813628 823738 824094 825049 ] |
||||||||||||||||||||||||||||||
|
16.25 ms (7.83%) |
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 545535 545878 805140 799913 423972 742405 391760 443950 533677 782665 786095 729205 736847 714336 714346 714322 662147 704673 705111 560005 603834 601986 700476 709511 438032 443955 669886 573300 618910 625268 705458 813628 669896 802160 797348 803479 725469 794845 795207 735830 735864 732725 763859 791412 797355 810315 427006 480692 535613 721597 721575 787286 736128 760517 764121 809561 749766 768486 726398 727523 764112 768472 795329 465393 415344 485945 486118 825049 566443 579474 812104 782034 470147 559973 512060 534083 150487 823738 824094 711777 652971 588939 640306 642354 779261 770049 783278 800370 757613 768828 758292 635129 778490 812108 661920 673425 684693 714591 672774 686384 713434 712952 714583 714565 452215 473333 543332 423971 470920 391582 412627 466495 510772 488987 499493 397410 803233 722298 725454 763426 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.32%) |
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 150487 391582 391760 397410 412627 415344 423971 423972 427006 438032 443950 443955 452215 465393 466495 470147 470920 473333 480692 485945 486118 488987 499493 510772 512060 533677 534083 535613 543332 545535 545878 559973 560005 566443 573300 579474 588939 601986 603834 618910 625268 635129 640306 642354 652971 661920 662147 669886 669896 672774 673425 684693 686384 700476 704673 705111 705458 709511 711777 712952 713434 714322 714336 714346 714565 714583 714591 721575 721597 722298 725454 725469 726398 727523 729205 732725 735830 735864 736128 736847 742405 749766 757613 758292 760517 763426 763859 764112 764121 768472 768486 768828 770049 778490 779261 782034 782665 783278 786095 787286 791412 794845 795207 795329 797348 797355 799913 800370 802160 803233 803479 805140 809561 810315 812104 812108 813628 823738 824094 825049 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian milf amateur"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск milf любительск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.77%) |
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.