Query Metrics
7
Database Queries
7
Different statements
175.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.40 ms (86.70%) |
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 365546 390108 392676 419312 419604 420505 423585 423593 428082 432380 432457 433855 436765 438466 438490 440895 442842 445012 447217 447237 452422 454674 456130 456262 457908 457913 463400 463827 467111 477507 487639 492969 494096 498419 506973 507113 509255 511017 514328 517940 524352 525201 525937 528705 528844 529654 530314 532830 540746 541451 547565 550952 557020 560887 561971 562543 563811 567309 567481 579649 580857 580867 582822 584425 585734 587208 587296 587484 592773 594443 595419 595581 602132 639969 650540 656891 662886 668620 676895 705856 736790 736830 741855 743790 746294 749902 751822 752308 752679 753124 753963 760220 762337 762763 765183 765250 768659 773278 776035 783466 783704 783849 785112 787516 791042 797010 801003 803635 804159 804568 806529 806834 806937 807606 808787 810059 813215 814492 827918 ] |
||||||||||||||||||||||||||||||
|
13.06 ms (7.43%) |
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 365546 442842 814492 447217 463827 457913 525201 528844 656891 662886 602132 783849 801003 804568 806529 746294 762763 787516 803635 806937 813215 736830 749902 804159 806834 432380 392676 456262 525937 705856 438490 419604 827918 447237 457908 487639 509255 511017 524352 529654 532830 517940 540746 494096 528705 561971 584425 541451 547565 562543 567309 567481 580867 650540 676895 585734 592773 639969 587296 587484 785112 807606 808787 810059 753124 762337 765250 783466 736790 752308 752679 765183 751822 768659 741855 760220 753963 773278 776035 783704 791042 797010 420505 432457 438466 463400 445012 423585 423593 454674 433855 440895 492969 826638 594443 530314 743790 390108 428082 436765 419312 467111 452422 456130 477507 498419 507113 514328 506973 550952 563811 557020 560887 580857 668620 579649 582822 595581 587208 595419 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.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 365546 390108 392676 419312 419604 420505 423585 423593 428082 432380 432457 433855 436765 438466 438490 440895 442842 445012 447217 447237 452422 454674 456130 456262 457908 457913 463400 463827 467111 477507 487639 492969 494096 498419 506973 507113 509255 511017 514328 517940 524352 525201 525937 528705 528844 529654 530314 532830 540746 541451 547565 550952 557020 560887 561971 562543 563811 567309 567481 579649 580857 580867 582822 584425 585734 587208 587296 587484 592773 594443 595419 595581 602132 639969 650540 656891 662886 668620 676895 705856 736790 736830 741855 743790 746294 749902 751822 752308 752679 753124 753963 760220 762337 762763 765183 765250 768659 773278 776035 783466 783704 783849 785112 787516 791042 797010 801003 803635 804159 804568 806529 806834 806937 807606 808787 810059 813215 814492 827918 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade riding"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск riding"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск riding"
]
|
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.