Query Metrics
7
Database Queries
7
Different statements
189.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.87 ms (85.81%) |
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 51911 83386 382518 384039 387200 392037 395515 396925 402346 403334 404585 413525 413531 415782 425987 439640 443358 450635 451629 459222 461367 462691 463136 464264 464530 467048 470664 470680 470932 472389 480869 482681 485967 486561 489792 490267 490708 496220 501001 504854 506351 506535 515481 517324 526421 527785 529150 529441 537109 543123 555007 555233 555260 555399 555437 555982 565343 566171 574380 574444 585704 585755 590331 596766 597172 598124 599770 599796 599806 599810 602670 604906 605167 607359 609220 613095 620108 626841 626915 633738 640892 641106 649905 651106 651741 652010 657788 666096 667860 670501 694379 695410 719880 719893 721267 725433 728348 733561 734386 734653 739173 777537 789325 789997 793187 798219 798901 798905 799010 799020 801587 817432 817639 817853 818727 818737 824865 827916 828027 828256 ] |
||||||||||||||||||||||||||||||
|
17.46 ms (9.20%) |
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 555982 555437 543123 657788 565343 596766 598124 620108 633738 613095 626841 793187 51911 480869 396925 464530 464264 470664 382518 413525 415782 602670 818737 537109 566171 739173 384039 555399 467048 626915 527785 462691 719893 501001 529150 526421 652010 649905 585755 607359 459222 472389 506535 515481 486561 489792 728348 482681 555007 640892 450635 403334 817639 463136 585704 721267 798901 828256 651106 504854 404585 651741 695410 733561 443358 490708 574380 597172 599796 734386 83386 395515 818727 694379 670501 425987 517324 496220 798219 609220 485967 506351 827916 828027 666096 555260 604906 599806 725433 734653 719880 799010 555233 439640 387200 402346 413531 451629 461367 574444 599810 599770 641106 777537 470680 470932 529441 490267 667860 590331 605167 789997 801587 789325 799020 798905 392037 817432 817853 824865 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.20%) |
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 51911 83386 382518 384039 387200 392037 395515 396925 402346 403334 404585 413525 413531 415782 425987 439640 443358 450635 451629 459222 461367 462691 463136 464264 464530 467048 470664 470680 470932 472389 480869 482681 485967 486561 489792 490267 490708 496220 501001 504854 506351 506535 515481 517324 526421 527785 529150 529441 537109 543123 555007 555233 555260 555399 555437 555982 565343 566171 574380 574444 585704 585755 590331 596766 597172 598124 599770 599796 599806 599810 602670 604906 605167 607359 609220 613095 620108 626841 626915 633738 640892 641106 649905 651106 651741 652010 657788 666096 667860 670501 694379 695410 719880 719893 721267 725433 728348 733561 734386 734653 739173 777537 789325 789997 793187 798219 798901 798905 799010 799020 801587 817432 817639 817853 818727 818737 824865 827916 828027 828256 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature in car"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature вмашин"
]
|
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.