Query Metrics
7
Database Queries
7
Different statements
157.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.78 ms (85.16%) |
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 339392 382493 382769 386080 387058 388393 410356 434009 452662 523044 530257 538460 540581 550638 553294 558082 566299 585793 586925 590242 595544 600058 609873 620576 620737 621161 625639 627763 645370 651806 653270 654419 657758 659220 660513 666134 669868 672890 677349 678421 680676 684883 687280 691690 692024 694131 694455 694468 695665 698482 705556 705798 709837 710068 712462 713977 715964 718487 719347 720432 720767 727824 727906 728814 730043 732041 741193 743527 744338 746096 746406 750328 751242 751723 752646 753736 753866 754199 755403 756312 757815 757934 758740 758832 765084 768043 771163 773580 777687 779140 779611 779894 780002 783104 783630 784708 785141 785772 787405 788405 791071 791091 791235 791303 791437 795620 797104 797958 798665 805310 805350 808981 811244 812436 812511 813308 813453 814307 814476 826705 ] |
||||||||||||||||||||||||||||||
|
13.14 ms (8.37%) |
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 595544 621161 625639 627763 779894 785141 795620 813308 785772 798665 751242 758832 783630 757934 743527 744338 727824 752646 709837 791091 791235 812436 812511 382769 382493 826705 814476 538460 558082 566299 684883 651806 669868 694131 698482 720432 710068 719347 730043 758740 791437 797104 751723 750328 705798 386080 452662 523044 387058 410356 530257 659220 666134 692024 694455 660513 680676 691690 695665 713977 720767 654419 657758 678421 687280 694468 585793 586925 620737 620576 783104 779140 780002 784708 787405 813453 732041 746406 756312 791071 805350 811244 757815 728814 753736 755403 727906 746096 768043 771163 718487 777687 788405 791303 808981 434009 672890 609873 814307 677349 712462 705556 600058 797958 773580 753866 754199 741193 765084 388393 339392 540581 550638 553294 653270 645370 715964 590242 805310 779611 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.67%) |
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 339392 382493 382769 386080 387058 388393 410356 434009 452662 523044 530257 538460 540581 550638 553294 558082 566299 585793 586925 590242 595544 600058 609873 620576 620737 621161 625639 627763 645370 651806 653270 654419 657758 659220 660513 666134 669868 672890 677349 678421 680676 684883 687280 691690 692024 694131 694455 694468 695665 698482 705556 705798 709837 710068 712462 713977 715964 718487 719347 720432 720767 727824 727906 728814 730043 732041 741193 743527 744338 746096 746406 750328 751242 751723 752646 753736 753866 754199 755403 756312 757815 757934 758740 758832 765084 768043 771163 773580 777687 779140 779611 779894 780002 783104 783630 784708 785141 785772 787405 788405 791071 791091 791235 791303 791437 795620 797104 797958 798665 805310 805350 808981 811244 812436 812511 813308 813453 814307 814476 826705 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex cute"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс cute"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс cute"
]
|
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.