Query Metrics
7
Database Queries
7
Different statements
150.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.08 ms (81.74%) |
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 391949 400812 400993 401007 401601 439524 439621 439638 439641 439686 439722 439724 439735 439778 440593 440999 441910 442814 446549 448409 451464 460585 462022 462085 462130 465362 465364 466140 466228 466269 466307 467781 469391 470033 470272 470581 474097 474205 474782 475883 475903 476353 477389 477981 479082 479135 480814 481256 484409 484580 484629 484652 484704 486209 487602 488527 489224 496862 503961 508776 509043 518851 520514 524612 533052 535436 539341 544161 558123 558898 563161 563642 570936 591197 619513 622836 714614 731146 731217 731219 734026 734709 735881 735887 735890 735954 735984 738328 738363 739544 739553 739689 739725 742740 742776 744406 745357 746730 754649 755875 758046 761604 784162 794070 801025 803728 805340 809885 824312 825323 825400 825431 825881 826581 826928 826932 827142 827220 827432 827619 ] |
||||||||||||||||||||||||||||||
|
17.04 ms (11.32%) |
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 827142 824312 801025 754649 803728 739689 739725 622836 825323 825881 826581 825400 826928 826932 827220 827619 825431 533052 481256 487602 544161 805340 784162 734026 734709 742776 746730 735887 735984 738328 744406 745357 738363 742740 755875 731217 735881 735890 739544 739553 758046 731146 731219 735954 794070 401601 477389 509043 474097 479135 520514 470581 462085 465364 470272 400993 465362 439638 469391 475903 477981 446549 484409 489224 524612 441910 474782 570936 462022 476353 508776 714614 451464 474205 809885 488527 391949 563161 563642 558898 400812 401007 439724 466140 466228 466269 475883 439722 439778 442814 439524 503961 484580 484652 518851 535436 480814 439641 462130 486209 761604 619513 439621 448409 479082 439735 440593 439686 466307 484629 484704 496862 460585 470033 440999 591197 827432 539341 558123 467781 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.90%) |
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 391949 400812 400993 401007 401601 439524 439621 439638 439641 439686 439722 439724 439735 439778 440593 440999 441910 442814 446549 448409 451464 460585 462022 462085 462130 465362 465364 466140 466228 466269 466307 467781 469391 470033 470272 470581 474097 474205 474782 475883 475903 476353 477389 477981 479082 479135 480814 481256 484409 484580 484629 484652 484704 486209 487602 488527 489224 496862 503961 508776 509043 518851 520514 524612 533052 535436 539341 544161 558123 558898 563161 563642 570936 591197 619513 622836 714614 731146 731217 731219 734026 734709 735881 735887 735890 735954 735984 738328 738363 739544 739553 739689 739725 742740 742776 744406 745357 746730 754649 755875 758046 761604 784162 794070 801025 803728 805340 809885 824312 825323 825400 825431 825881 826581 826928 826932 827142 827220 827432 827619 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск mature домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian mature homemade"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск mature домашн любительск"
]
|
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.