Query Metrics
7
Database Queries
7
Different statements
159.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.97 ms (87.09%) |
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 388284 391513 391564 391774 391799 398138 400696 406340 410193 420007 423128 427214 433964 436825 437993 439922 451613 453680 456125 457796 464553 465435 466531 472814 473278 480651 489785 495382 509508 514702 517437 523286 525283 527262 533675 533700 533712 533778 535371 535396 535407 535408 535598 536082 540708 543660 543710 545878 552587 554034 555826 555967 565382 573989 577002 579124 585091 590606 598789 601948 608666 609765 614385 614625 634221 635569 638858 650037 659282 659472 669896 682956 685466 685524 688741 689266 692824 695419 714602 721918 723383 730656 731147 731399 740126 740148 740238 744810 745074 751377 751490 754635 757026 763463 777137 777156 777229 778523 778765 779324 779339 779820 780509 780734 782668 782745 789090 790647 791494 792757 793019 798940 803303 809987 811637 813329 813545 819438 819801 825665 ] |
||||||||||||||||||||||||||||||
|
11.55 ms (7.24%) |
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 659472 669896 608666 779339 754635 782668 811637 793019 740148 451613 763463 388284 533778 533675 543710 579124 789090 400696 391774 798940 554034 819438 740238 751377 436825 457796 535396 573989 650037 790647 778765 782745 791494 423128 533712 536082 533700 535371 535407 731399 777156 398138 406340 420007 473278 472814 555826 638858 565382 535408 464553 509508 813545 552587 689266 692824 635569 590606 614385 779324 780734 809987 745074 731147 779820 813329 433964 391513 723383 517437 545878 495382 659282 523286 825665 585091 535598 695419 688741 634221 527262 391564 489785 465435 480651 410193 466531 391799 540708 721918 757026 778523 792757 525283 685466 685524 819801 714602 682956 780509 744810 751490 437993 439922 456125 555967 543660 577002 598789 609765 614625 777137 777229 803303 730656 740126 601948 514702 427214 453680 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.61%) |
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 388284 391513 391564 391774 391799 398138 400696 406340 410193 420007 423128 427214 433964 436825 437993 439922 451613 453680 456125 457796 464553 465435 466531 472814 473278 480651 489785 495382 509508 514702 517437 523286 525283 527262 533675 533700 533712 533778 535371 535396 535407 535408 535598 536082 540708 543660 543710 545878 552587 554034 555826 555967 565382 573989 577002 579124 585091 590606 598789 601948 608666 609765 614385 614625 634221 635569 638858 650037 659282 659472 669896 682956 685466 685524 688741 689266 692824 695419 714602 721918 723383 730656 731147 731399 740126 740148 740238 744810 745074 751377 751490 754635 757026 763463 777137 777156 777229 778523 778765 779324 779339 779820 780509 780734 782668 782745 789090 790647 791494 792757 793019 798940 803303 809987 811637 813329 813545 819438 819801 825665 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian public agemt"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск на agemt улиц"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск на agemt улиц"
]
|
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.