Query Metrics
7
Database Queries
7
Different statements
228.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.03 ms (88.23%) |
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 419474 423382 432778 448088 456649 461893 477094 481244 490706 498723 501491 506217 520528 525571 526247 526605 534470 540422 540656 556104 556336 557089 557447 560917 566331 567040 567733 568875 572332 574153 575020 577912 579842 586430 587974 589969 591874 592955 593168 602359 614520 615147 617828 624501 624551 629337 631503 631684 633493 634527 634563 643595 644186 673314 683028 688199 688376 696753 704208 707480 708551 712540 712541 716246 720174 721450 723131 724853 725514 727532 728499 730315 736775 737992 739652 742010 745962 750729 750792 752308 756259 756706 757277 759502 765554 766402 767236 768844 770376 772517 773936 775231 776787 780030 781397 782059 782518 788291 788402 788903 788920 791580 791803 794183 796207 797551 800209 800211 800906 801026 803580 804226 804309 806556 806802 807194 807359 807835 809670 810970 ] |
||||||||||||||||||||||||||||||
|
15.52 ms (6.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 807835 775231 780030 791580 796207 801026 807359 810970 727532 759502 767236 772517 773936 782518 794183 804309 806556 736775 739652 752308 756259 756706 750729 757277 765554 730315 737992 770376 615147 629337 696753 720174 721450 776787 781397 782059 788291 788402 800211 800906 809670 419474 477094 481244 456649 423382 432778 526605 498723 506217 525571 526247 643595 448088 461893 540422 540656 534470 501491 520528 490706 556104 566331 572332 556336 557447 577912 557089 568875 575020 673314 683028 716246 723131 688199 688376 704208 712541 707480 708551 712540 560917 567040 567733 574153 579842 592955 587974 631684 644186 586430 589969 593168 624501 624551 631503 591874 634527 634563 788903 800209 806802 791803 804226 788920 797551 803580 724853 728499 742010 750792 766402 725514 768844 745962 602359 614520 617828 633493 807194 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (1.60%) |
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 419474 423382 432778 448088 456649 461893 477094 481244 490706 498723 501491 506217 520528 525571 526247 526605 534470 540422 540656 556104 556336 557089 557447 560917 566331 567040 567733 568875 572332 574153 575020 577912 579842 586430 587974 589969 591874 592955 593168 602359 614520 615147 617828 624501 624551 629337 631503 631684 633493 634527 634563 643595 644186 673314 683028 688199 688376 696753 704208 707480 708551 712540 712541 716246 720174 721450 723131 724853 725514 727532 728499 730315 736775 737992 739652 742010 745962 750729 750792 752308 756259 756706 757277 759502 765554 766402 767236 768844 770376 772517 773936 775231 776787 780030 781397 782059 782518 788291 788402 788903 788920 791580 791803 794183 796207 797551 800209 800211 800906 801026 803580 804226 804309 806556 806802 807194 807359 807835 809670 810970 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор cum"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор cum"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme cum"
]
|
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.