Query Metrics
7
Database Queries
7
Different statements
186.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.75 ms (90.45%) |
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 79520 149538 207540 392987 494539 500311 502540 517440 532137 532195 536951 543284 545890 546143 546264 547115 562453 565517 566804 567621 588002 620485 629579 632820 697683 701238 702381 704345 704401 706154 715440 716268 716452 716975 720666 722106 725344 725421 725449 726126 726281 726764 730060 730413 730837 730951 731271 735478 736681 739684 740274 741094 742352 742505 743773 743789 744169 744342 744811 746854 749648 750700 751954 752110 753781 754850 755043 760173 761526 762887 763449 767513 767536 768508 768676 768894 771347 780912 782595 783133 788673 794645 794731 795013 795197 797290 801703 803301 808246 818257 818265 818978 818983 819116 819347 819745 820129 820161 820749 823744 823867 824143 824717 824801 824879 825089 825837 826091 826229 826276 826491 826507 826770 827055 827087 827418 827525 827580 828572 ] |
||||||||||||||||||||||||||||||
|
8.78 ms (4.70%) |
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 801703 726126 746854 725449 741094 742505 629579 632820 700231 702381 704401 706154 715440 794731 797290 744169 783133 725421 744811 731271 744342 392987 826770 818983 726281 500311 543284 826276 824717 532137 567621 716975 762887 149538 546143 546264 742352 755043 749648 826491 819347 827087 827418 827525 826507 819745 826091 828572 532195 565517 716268 720666 788673 782595 726764 730060 730413 760173 767513 767536 794645 803301 730951 736681 754850 768508 740274 763449 735478 739684 743789 752110 771347 761526 768894 780912 795013 207540 795197 750700 751954 725344 536951 566804 547115 704345 562453 620485 743773 701238 79520 722106 808246 753781 818978 824879 827580 820161 517440 697683 502540 545890 588002 730837 716452 768676 818265 826229 825837 825089 819116 820129 823744 823867 827055 824143 824801 818257 820749 494539 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.16%) |
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 79520 149538 207540 392987 494539 500311 502540 517440 532137 532195 536951 543284 545890 546143 546264 547115 562453 565517 566804 567621 588002 620485 629579 632820 697683 701238 702381 704345 704401 706154 715440 716268 716452 716975 720666 722106 725344 725421 725449 726126 726281 726764 730060 730413 730837 730951 731271 735478 736681 739684 740274 741094 742352 742505 743773 743789 744169 744342 744811 746854 749648 750700 751954 752110 753781 754850 755043 760173 761526 762887 763449 767513 767536 768508 768676 768894 771347 780912 782595 783133 788673 794645 794731 795013 795197 797290 801703 803301 808246 818257 818265 818978 818983 819116 819347 819745 820129 820161 820749 823744 823867 824143 824717 824801 824879 825089 825837 826091 826229 826276 826491 826507 826770 827055 827087 827418 827525 827580 828572 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateurs wife"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск жен"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.