Query Metrics
7
Database Queries
7
Different statements
367.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.60 ms (56.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass pov"
]
|
||||||||||||||||||||||||||||||
|
135.89 ms (36.97%) |
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 61498 387046 396924 397036 397493 400516 403707 408894 419100 421113 421806 426999 432505 432548 433419 433619 433866 441535 448968 452364 452600 453431 455788 459193 463367 464089 464176 475789 480508 490042 521671 529840 530648 538103 539652 556932 559745 576221 577486 578285 578551 581170 585330 588666 589314 591944 593648 595051 595283 602336 604228 612718 616832 625816 627154 631607 632144 633651 636504 639674 639801 641267 642176 645527 656651 660403 672275 680777 707181 718070 730668 730819 732800 737065 740847 753059 757488 757535 761794 762763 766937 767004 776142 776161 777939 779130 780729 781574 782033 783143 784000 786718 788341 789327 791416 793028 793855 795193 796395 796702 797096 797792 799848 802415 802564 803854 807316 807450 810005 810305 814982 815095 825730 828235 828253 828778 ] |
||||||||||||||||||||||||||||||
|
14.34 ms (3.90%) |
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 825730 828778 828235 828253 539652 645527 656651 633651 780729 782033 795193 802415 779130 788341 793028 766937 769682 732800 764866 730668 766932 602336 783143 789327 802564 459193 578285 784000 432548 433419 521671 397036 490042 672275 576221 762763 433619 814982 529840 559745 707181 793855 755642 810305 757535 761794 777939 797096 426999 432505 433866 589314 452600 396924 408894 403707 387046 397493 421806 464089 452364 604228 400516 455788 815095 581170 718070 556932 625816 639674 612718 631607 585330 61498 464176 448968 530648 578551 588666 419100 463367 480508 441535 421113 475789 453431 538103 680777 660403 577486 591944 595051 639801 641267 593648 632144 636504 642176 595283 616832 776161 807316 786718 796395 797792 803854 730819 740847 796702 799848 753059 767004 757488 737065 627154 776142 781574 791416 807450 810005 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (0.88%) |
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 61498 387046 396924 397036 397493 400516 403707 408894 419100 421113 421806 426999 432505 432548 433419 433619 433866 441535 448968 452364 452600 453431 455788 459193 463367 464089 464176 475789 480508 490042 521671 529840 530648 538103 539652 556932 559745 576221 577486 578285 578551 581170 585330 588666 589314 591944 593648 595051 595283 602336 604228 612718 616832 625816 627154 631607 632144 633651 636504 639674 639801 641267 642176 645527 656651 660403 672275 680777 707181 718070 730668 730819 732800 737065 740847 753059 757488 757535 761794 762763 766937 767004 776142 776161 777939 779130 780729 781574 782033 783143 784000 786718 788341 789327 791416 793028 793855 795193 796395 796702 797096 797792 799848 802415 802564 803854 807316 807450 810005 810305 814982 815095 825730 828235 828253 828778 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп пов"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп пов"
]
|
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.