Query Metrics
7
Database Queries
7
Different statements
197.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.92 ms (86.63%) |
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 383095 386862 387221 387910 390701 392580 403979 421543 448867 450204 506813 511392 512821 514738 514942 520162 520619 532987 533547 534804 536957 540967 541082 542502 550741 552018 566431 566464 567160 579304 581394 585159 587226 591167 593839 603239 603507 603548 607403 608645 612383 620616 621371 631927 634851 637566 638451 640706 641757 642501 642525 644321 649609 653328 653435 654275 654295 654297 654624 660300 664823 665226 667498 672122 675233 675960 676404 681785 682914 693596 694032 703540 705875 710320 714084 715583 716298 728169 731777 732326 732743 733050 733148 736141 736663 744212 745663 746889 747234 756869 761145 761588 766583 770490 771453 773416 775473 775893 775995 785333 790026 790063 792488 792801 797126 797574 799553 799951 800260 801275 803343 805543 809927 810286 813018 814236 814807 814936 815132 818169 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (8.16%) |
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 567160 654275 682914 675233 703540 634851 644321 603239 790063 792801 803343 799553 797574 799951 773416 637566 775893 383095 390701 815132 818169 814236 514738 534804 540967 542502 653435 654295 654297 710320 579304 603548 608645 642501 620616 809927 732326 746889 792488 805543 813018 732743 747234 728169 387910 450204 386862 392580 421543 814807 814936 448867 520162 511392 536957 552018 566431 550741 566464 581394 649609 654624 681785 714084 665226 675960 653328 672122 676404 705875 631927 641757 603507 642525 587226 593839 621371 640706 800260 775473 790026 736141 766583 770490 801275 810286 731777 736663 745663 733148 733050 756869 716298 387221 403979 506813 512821 520619 532987 514942 533547 541082 660300 664823 667498 693596 715583 694032 591167 612383 585159 638451 785333 744212 771453 761145 607403 797126 761588 775995 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.47%) |
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 383095 386862 387221 387910 390701 392580 403979 421543 448867 450204 506813 511392 512821 514738 514942 520162 520619 532987 533547 534804 536957 540967 541082 542502 550741 552018 566431 566464 567160 579304 581394 585159 587226 591167 593839 603239 603507 603548 607403 608645 612383 620616 621371 631927 634851 637566 638451 640706 641757 642501 642525 644321 649609 653328 653435 654275 654295 654297 654624 660300 664823 665226 667498 672122 675233 675960 676404 681785 682914 693596 694032 703540 705875 710320 714084 715583 716298 728169 731777 732326 732743 733050 733148 736141 736663 744212 745663 746889 747234 756869 761145 761588 766583 770490 771453 773416 775473 775893 775995 785333 790026 790063 792488 792801 797126 797574 799553 799951 800260 801275 803343 805543 809927 810286 813018 814236 814807 814936 815132 818169 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"втро"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.