Query Metrics
7
Database Queries
7
Different statements
163.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.32 ms (85.59%) |
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 435521 464929 466991 475947 482433 485851 488888 495003 499541 502869 504725 508230 508711 529141 533417 536297 542211 545946 547385 548040 553225 559422 560789 562703 577125 577916 578355 578547 580034 582001 584229 588516 590848 595832 600725 605426 607391 608204 613443 615861 616056 617042 625116 632983 633215 633656 634042 634307 634426 639155 645748 653952 660846 661917 666399 668766 675124 675602 679582 680913 681756 686516 693897 696498 699938 701198 703601 707982 708015 708247 709587 710118 710779 711934 711946 712644 714546 716273 720899 722134 727739 731028 732911 738442 742622 746494 752650 761781 765317 769308 773063 775184 775226 786048 787943 790079 792645 794134 800578 803706 804558 807353 809842 816155 818881 824675 824742 824792 825035 825270 825698 825904 827165 827492 827685 827790 828463 828606 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (8.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 464929 466991 529141 508711 502869 482433 547385 584229 560789 553225 577125 577916 653952 668766 693897 711934 711946 675124 696498 661917 686516 708015 708247 578547 588516 608204 632983 595832 617042 625116 633215 600725 605426 607391 639155 794134 807353 775226 786048 800578 742622 761781 769308 787943 790079 803706 804558 731028 738442 752650 773063 765317 746494 727739 732911 613443 775184 792645 809842 475947 435521 508230 485851 495003 499541 504725 488888 816155 824792 825698 825904 824675 824742 827165 827492 818881 825035 825270 827790 827685 828463 828606 533417 536297 529752 542211 545946 580034 582001 660846 679582 703601 716273 645748 666399 675602 681756 701198 709587 710118 714546 722134 680913 699938 707982 710779 712644 720899 548040 559422 562703 578355 592272 615861 634042 634426 590848 616056 633656 634307 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.57%) |
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 435521 464929 466991 475947 482433 485851 488888 495003 499541 502869 504725 508230 508711 529141 533417 536297 542211 545946 547385 548040 553225 559422 560789 562703 577125 577916 578355 578547 580034 582001 584229 588516 590848 595832 600725 605426 607391 608204 613443 615861 616056 617042 625116 632983 633215 633656 634042 634307 634426 639155 645748 653952 660846 661917 666399 668766 675124 675602 679582 680913 681756 686516 693897 696498 699938 701198 703601 707982 708015 708247 709587 710118 710779 711934 711946 712644 714546 716273 720899 722134 727739 731028 732911 738442 742622 746494 752650 761781 765317 769308 773063 775184 775226 786048 787943 790079 792645 794134 800578 803706 804558 807353 809842 816155 818881 824675 824742 824792 825035 825270 825698 825904 827165 827492 827685 827790 828463 828606 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dogging my жен"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dogging my wife"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dogging my жен"
]
|
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.