Query Metrics
7
Database Queries
7
Different statements
211.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.65 ms (84.64%) |
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 33974 206386 312831 382045 383305 392779 396849 404724 405504 407187 409901 413174 443793 448069 454029 458601 462478 462567 467838 471618 483142 485706 485737 489664 493199 509836 514270 514335 525778 531325 531494 558409 560408 561725 561777 572099 580670 582581 584674 596745 617440 619463 625866 626994 648504 652573 655366 655752 655940 657070 663353 663498 664811 665406 665496 666844 667231 667485 667836 667858 668648 669754 674356 678726 688307 688677 696966 697298 701118 708389 718755 721482 722281 725914 727393 727698 728994 737381 737401 740125 740522 741080 741581 741889 741980 748342 753256 753853 760586 762999 770114 770187 771596 772333 772340 780702 781721 781734 782272 788461 789551 790858 790977 792773 794769 800629 804052 805711 808506 809125 813919 814133 816233 816513 821178 822718 825683 827054 827975 827978 ] |
||||||||||||||||||||||||||||||
|
20.65 ms (9.78%) |
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 772340 741080 728994 753256 760586 696966 392779 727698 665496 206386 405504 407187 409901 816513 813919 827054 816233 825683 827975 584674 558409 626994 781721 809125 737381 772333 805711 727393 770114 771596 789551 808506 33974 514270 655940 382045 467838 770187 383305 458601 448069 462567 514335 489664 454029 413174 580670 560408 821178 814133 822718 827978 525778 655366 678726 701118 657070 667858 688307 722281 652573 655752 665406 667231 668648 688677 619463 780702 782272 790977 800629 725914 741889 753853 762999 748342 740522 617440 718755 561725 663353 697298 648504 674356 708389 572099 794769 804052 741980 790858 531494 531325 582581 664811 666844 667836 669754 667485 721482 596745 792773 740125 737401 625866 312831 561777 781734 788461 396849 404724 509836 462478 443793 483142 485737 471618 493199 663498 741581 485706 ] |
||||||||||||||||||||||||||||||
|
4.20 ms (1.99%) |
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 33974 206386 312831 382045 383305 392779 396849 404724 405504 407187 409901 413174 443793 448069 454029 458601 462478 462567 467838 471618 483142 485706 485737 489664 493199 509836 514270 514335 525778 531325 531494 558409 560408 561725 561777 572099 580670 582581 584674 596745 617440 619463 625866 626994 648504 652573 655366 655752 655940 657070 663353 663498 664811 665406 665496 666844 667231 667485 667836 667858 668648 669754 674356 678726 688307 688677 696966 697298 701118 708389 718755 721482 722281 725914 727393 727698 728994 737381 737401 740125 740522 741080 741581 741889 741980 748342 753256 753853 760586 762999 770114 770187 771596 772333 772340 780702 781721 781734 782272 788461 789551 790858 790977 792773 794769 800629 804052 805711 808506 809125 813919 814133 816233 816513 821178 822718 825683 827054 827975 827978 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐüÐéð░ÐÇÐïðÁ ð▒ð¥ð╗ÐîÐêð©ðÁ ð▓ð░ð│ð©ð¢Ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старые большие вагин"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.74%) |
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.