Query Metrics
7
Database Queries
7
Different statements
221.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
196.03 ms (88.70%) |
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 397879 402648 406176 409035 416683 419022 419644 420383 422069 429862 432884 432929 435548 439960 447352 449573 453788 454282 457071 459731 461100 466476 469619 476854 483732 504060 527922 531217 532856 532872 534257 536378 541832 542707 555599 562159 562578 564295 564475 564501 569593 575978 580867 582577 584047 584481 585251 587081 590255 599104 601460 602430 605379 607236 607692 609097 614979 618259 622720 624745 625553 626082 630254 630406 631358 631616 638477 638828 640133 640859 641808 654257 658907 661008 666470 672894 680252 686331 694751 697543 705451 706446 717859 728571 736024 741504 745927 749207 749221 750895 751035 752649 754436 756307 758633 760319 765179 772272 777052 778779 780151 782274 783048 783743 788528 791080 796753 802906 803557 804937 806839 806904 807122 808969 809046 811736 812189 814470 814989 816547 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (6.92%) |
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 686331 614979 599104 435548 466476 705451 564501 459731 609097 631616 397879 531217 809046 751035 736024 754436 640859 816547 476854 625553 811736 429862 582577 584047 654257 672894 618259 783743 807122 780151 791080 808969 749207 772272 796753 804937 745927 752649 778779 783048 806839 806904 439960 432929 590255 419644 422069 814989 453788 562159 564475 602430 638828 587081 607692 630254 631358 638477 812189 728571 750895 756307 630406 802906 536378 569593 661008 760319 626082 457071 416683 483732 449573 504060 532872 562578 564295 694751 680252 697543 601460 782274 788528 749221 765179 758633 622720 624745 640133 542707 527922 584481 658907 607236 585251 454282 419022 447352 803557 741504 666470 641808 469619 777052 541832 461100 409035 402648 406176 420383 432884 814470 532856 534257 575978 580867 706446 717859 555599 605379 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.41%) |
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 397879 402648 406176 409035 416683 419022 419644 420383 422069 429862 432884 432929 435548 439960 447352 449573 453788 454282 457071 459731 461100 466476 469619 476854 483732 504060 527922 531217 532856 532872 534257 536378 541832 542707 555599 562159 562578 564295 564475 564501 569593 575978 580867 582577 584047 584481 585251 587081 590255 599104 601460 602430 605379 607236 607692 609097 614979 618259 622720 624745 625553 626082 630254 630406 631358 631616 638477 638828 640133 640859 641808 654257 658907 661008 666470 672894 680252 686331 694751 697543 705451 706446 717859 728571 736024 741504 745927 749207 749221 750895 751035 752649 754436 756307 758633 760319 765179 772272 777052 778779 780151 782274 783048 783743 788528 791080 796753 802906 803557 804937 806839 806904 807122 808969 809046 811736 812189 814470 814989 816547 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dildo ass"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие дилд жоп"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.67%) |
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.