Query Metrics
7
Database Queries
7
Different statements
176.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.51 ms (85.93%) |
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 391669 397894 401807 422280 423772 424265 424269 424274 424276 433281 439727 444144 446975 452215 454555 455284 455331 460143 460748 462117 462708 465387 474797 475871 477794 477996 479124 483654 486846 488887 500432 505747 508367 508784 512485 513501 516923 523528 535332 541847 542370 542925 543332 545726 545874 547778 558117 568698 572190 578007 598483 620247 630448 651006 659197 659986 669892 714320 716754 718744 718768 731436 736572 736880 740975 741728 742303 751528 751539 751554 751560 751564 751573 751574 751613 751702 757866 758512 760637 765194 765815 765867 765868 765956 767752 777750 777973 778781 779069 779478 779563 779564 779565 779595 779599 783302 783303 784911 786183 786352 788413 788824 789296 790132 790634 791653 794857 794980 796583 799859 801430 801608 806986 808411 808562 810483 811339 814295 816111 825545 ] |
||||||||||||||||||||||||||||||
|
13.87 ms (7.87%) |
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 806986 811339 778781 779563 801430 736880 765194 783302 790132 757866 765867 740975 751564 765956 716754 791653 794980 801608 535332 542370 796583 742303 455331 718768 630448 433281 460748 391669 424265 454555 462708 523528 513501 452215 488887 460143 543332 547778 558117 568698 423772 462117 477794 397894 439727 446975 479124 424276 477996 474797 444144 475871 505747 508367 512485 486846 508784 483654 598483 401807 659986 816111 814295 825545 545874 541847 714320 718744 651006 669892 620247 779478 784911 808562 810483 779069 779564 779565 786352 790634 741728 751613 760637 786183 788413 794857 799859 808411 731436 751554 736572 751574 751702 758512 751528 751539 751560 751573 765815 765868 777973 779595 779599 783303 788824 789296 422280 455284 500432 516923 545726 542925 424269 424274 465387 777750 767752 572190 578007 659197 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.58%) |
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 391669 397894 401807 422280 423772 424265 424269 424274 424276 433281 439727 444144 446975 452215 454555 455284 455331 460143 460748 462117 462708 465387 474797 475871 477794 477996 479124 483654 486846 488887 500432 505747 508367 508784 512485 513501 516923 523528 535332 541847 542370 542925 543332 545726 545874 547778 558117 568698 572190 578007 598483 620247 630448 651006 659197 659986 669892 714320 716754 718744 718768 731436 736572 736880 740975 741728 742303 751528 751539 751554 751560 751564 751573 751574 751613 751702 757866 758512 760637 765194 765815 765867 765868 765956 767752 777750 777973 778781 779069 779478 779563 779564 779565 779595 779599 783302 783303 784911 786183 786352 788413 788824 789296 790132 790634 791653 794857 794980 796583 799859 801430 801608 806986 808411 808562 810483 811339 814295 816111 825545 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.56%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск домашн любительск mom"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian homemade mom"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск домашн любительск mom"
]
|
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.