Query Metrics
7
Database Queries
7
Different statements
143.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.81 ms (84.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 188515 191343 229555 382272 382937 384988 396969 398462 398551 398749 412992 419560 465555 467007 480077 489321 499328 499330 504820 505971 515060 521464 525481 525499 529676 534580 537830 540568 545924 547029 550652 554322 554512 554836 559348 588519 592791 610094 614378 615631 618759 636438 639652 664793 665235 665350 665419 665857 667517 678761 692253 698497 714145 714155 714647 721002 724290 726271 726910 728355 728940 731445 731767 734173 734270 738342 738356 741195 741795 744192 744369 745244 746112 746710 747071 749232 758293 760176 768866 770117 773901 773902 774317 781760 781976 784248 784632 788822 789301 790596 792588 792600 794629 794734 795221 796835 800771 801053 804130 804146 804177 804239 804241 805913 808172 809545 811087 811428 812530 814621 816781 817980 820313 824452 825036 827185 827278 827499 827500 827629 ] |
||||||||||||||||||||||||||||||
|
13.41 ms (9.34%) |
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 665857 667517 714647 554836 794629 796835 738342 773902 804130 804241 805913 728355 734270 744192 746112 728940 731445 734173 738356 745244 747071 768866 419560 382937 229555 827278 827500 816781 824452 489321 525481 534580 499328 499330 467007 545924 665350 636438 588519 614378 784248 804177 811087 741195 788822 790596 800771 774317 726271 749232 804239 382272 521464 384988 398749 412992 825036 817980 554512 559348 692253 664793 665419 610094 792600 726910 731767 721002 396969 465555 615631 398462 814621 820313 827185 827629 505971 537830 540568 515060 529676 550652 554322 665235 698497 678761 714145 592791 639652 618759 801053 804146 808172 809545 789301 746710 773901 781976 794734 795221 812530 770117 744369 724290 714155 781760 784632 811428 191343 398551 525499 504820 547029 760176 741795 758293 792588 188515 827499 480077 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (2.15%) |
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 188515 191343 229555 382272 382937 384988 396969 398462 398551 398749 412992 419560 465555 467007 480077 489321 499328 499330 504820 505971 515060 521464 525481 525499 529676 534580 537830 540568 545924 547029 550652 554322 554512 554836 559348 588519 592791 610094 614378 615631 618759 636438 639652 664793 665235 665350 665419 665857 667517 678761 692253 698497 714145 714155 714647 721002 724290 726271 726910 728355 728940 731445 731767 734173 734270 738342 738356 741195 741795 744192 744369 745244 746112 746710 747071 749232 758293 760176 768866 770117 773901 773902 774317 781760 781976 784248 784632 788822 789301 790596 792588 792600 794629 794734 795221 796835 800771 801053 804130 804146 804177 804239 804241 805913 808172 809545 811087 811428 812530 814621 816781 817980 820313 824452 825036 827185 827278 827499 827500 827629 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"granny big but"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"granny большие"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"granny большие"
]
|
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.