Query Metrics
7
Database Queries
7
Different statements
175.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.50 ms (86.67%) |
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 74588 384251 393148 402234 404672 417154 421718 421762 441576 457917 459055 461026 479746 493770 513014 514918 529479 531006 532536 535290 544951 558189 558356 573343 575308 584615 586970 591923 595497 603428 616592 617100 620974 621507 626862 627756 631521 638059 641625 645644 650230 656556 656582 656647 657228 657458 659397 660341 660597 661632 661973 664702 665727 665777 672304 672511 673214 676663 682961 684410 684487 684513 686034 688404 694071 695879 698733 701535 709639 714578 715896 720146 720318 720549 721592 725118 733911 734626 735516 735767 735880 740788 743079 744053 747832 755025 757347 757446 757715 759422 765729 766737 768414 769064 770295 771830 773578 779579 783617 785723 789926 790989 791600 792591 793869 794001 796687 797061 798588 800824 801101 803090 810207 814068 814123 815517 816649 817782 823468 824568 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (8.17%) |
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 792591 794001 796687 766737 725118 768414 709639 721592 790989 791600 441576 814068 814123 824568 815517 558189 573343 650230 664702 665727 672304 686034 660597 672511 684513 695879 715896 665777 714578 720318 626862 641625 586970 595497 617100 621507 638059 616592 620974 627756 591923 779579 793869 798588 800824 734626 757347 783617 789926 801101 735880 747832 769064 755025 771830 733911 735516 735767 743079 744053 757446 759422 770295 740788 757715 765729 773578 603428 631521 797061 803090 404672 74588 384251 457917 479746 694071 785723 810207 402234 459055 393148 421718 417154 421762 817782 823468 816649 461026 493770 514918 529479 513014 532536 535290 531006 558356 584615 544951 575308 645644 656582 657228 660341 661973 673214 676663 688404 720549 682961 684410 684487 698733 701535 720146 656556 656647 657458 659397 661632 ] |
||||||||||||||||||||||||||||||
|
2.76 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 74588 384251 393148 402234 404672 417154 421718 421762 441576 457917 459055 461026 479746 493770 513014 514918 529479 531006 532536 535290 544951 558189 558356 573343 575308 584615 586970 591923 595497 603428 616592 617100 620974 621507 626862 627756 631521 638059 641625 645644 650230 656556 656582 656647 657228 657458 659397 660341 660597 661632 661973 664702 665727 665777 672304 672511 673214 676663 682961 684410 684487 684513 686034 688404 694071 695879 698733 701535 709639 714578 715896 720146 720318 720549 721592 725118 733911 734626 735516 735767 735880 740788 743079 744053 747832 755025 757347 757446 757715 759422 765729 766737 768414 769064 770295 771830 773578 779579 783617 785723 789926 790989 791600 792591 793869 794001 796687 797061 798588 800824 801101 803090 810207 814068 814123 815517 816649 817782 823468 824568 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"tight секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tight fuck"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"tight секс"
]
|
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.