Query Metrics
7
Database Queries
7
Different statements
374.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.96 ms (54.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex young"
]
|
||||||||||||||||||||||||||||||
|
146.98 ms (39.22%) |
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 382017 382456 383472 384285 384880 385228 386470 386653 392086 392393 393737 393759 393771 394227 396294 396805 397279 399554 400421 400422 400423 400425 400718 401996 402091 402094 403060 403496 413208 417220 463141 467169 470734 470855 474719 492205 506213 512043 517867 519976 522443 524120 552631 557300 562312 566509 566519 566807 567160 569662 571209 574589 581691 583872 597264 613465 617759 618882 622198 654363 660055 665128 665271 667323 673260 675499 676453 676473 676968 683546 693074 693410 701406 702396 703105 706912 708519 714455 716078 716613 717887 720469 720491 722662 722687 722688 722717 722913 723492 731810 740854 741998 741999 743130 743134 743161 744312 744320 744326 745445 747573 748139 748147 748252 750561 752523 755213 759650 760769 766990 767964 788582 810286 810939 812082 812141 812153 825119 827523 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (4.06%) |
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 812082 382017 617759 748147 800948 741999 744320 747573 722662 400718 403060 743161 744326 760769 402094 506213 385228 382456 401996 512043 574589 675499 706912 683546 722717 566519 810939 750561 720469 720491 463141 393759 396294 400422 402091 386653 397279 392393 396805 470734 569662 567160 400421 581691 618882 743134 394227 825119 717887 810286 812153 766990 743130 731810 812141 386470 562312 676968 740854 755213 708519 723492 399554 566509 571209 673260 693410 714455 665128 676473 665271 676453 716078 722687 583872 613465 622198 767964 703105 467169 393737 474719 492205 517867 722688 383472 392086 702396 660055 667323 741998 745445 701406 393771 417220 827523 470855 654363 722913 557300 748139 759650 744312 400423 403496 413208 522443 524120 519976 566807 552631 716613 693074 597264 752523 788582 748252 384285 384880 400425 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (0.81%) |
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 382017 382456 383472 384285 384880 385228 386470 386653 392086 392393 393737 393759 393771 394227 396294 396805 397279 399554 400421 400422 400423 400425 400718 401996 402091 402094 403060 403496 413208 417220 463141 467169 470734 470855 474719 492205 506213 512043 517867 519976 522443 524120 552631 557300 562312 566509 566519 566807 567160 569662 571209 574589 581691 583872 597264 613465 617759 618882 622198 654363 660055 665128 665271 667323 673260 675499 676453 676473 676968 683546 693074 693410 701406 702396 703105 706912 708519 714455 716078 716613 717887 720469 720491 722662 722687 722688 722717 722913 723492 731810 740854 741998 741999 743130 743134 743161 744312 744320 744326 745445 747573 748139 748147 748252 750561 752523 755213 759650 760769 766990 767964 788582 810286 810939 812082 812141 812153 825119 827523 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс young"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс young"
]
|
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.