Query Metrics
7
Database Queries
7
Different statements
184.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.86 ms (85.70%) |
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 41433 182008 382840 384463 386707 398085 398116 402643 402649 414077 414241 414676 419439 425431 430353 432268 432936 433001 443239 443246 443247 446751 448063 452803 452833 454000 454009 455901 455915 464971 467929 468237 469199 471124 471125 475404 476055 476191 478028 481871 486240 486765 486784 493837 495204 495211 502767 509981 509991 511272 522156 530459 531892 533828 545390 591217 595132 599979 601167 602614 604667 623281 636955 642134 656851 660409 660575 660577 668300 669689 671531 702336 702341 702342 708570 713289 713500 723361 736740 736872 736903 738505 740450 745119 751486 754707 756921 758336 772211 774872 774884 776538 780028 782823 782936 782942 785577 790442 790463 790500 791010 791888 791889 791890 791895 793297 795373 796698 800507 800549 801621 803547 803995 804981 807601 811329 817172 822313 827619 ] |
||||||||||||||||||||||||||||||
|
15.33 ms (8.32%) |
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 807601 443239 419439 433001 448063 486784 502767 476055 468237 425431 402649 454000 475404 455901 455915 471124 604667 469199 414077 430353 509981 509991 591217 432268 467929 827619 774884 599979 464971 486765 471125 454009 398085 822313 623281 414241 452833 511272 476191 446751 398116 531892 660575 791890 791888 796698 800507 736903 745119 756921 713289 443247 660409 443246 493837 817172 495204 803995 182008 660577 669689 723361 793297 795373 758336 754707 736740 736872 432936 452803 595132 486240 602614 656851 668300 713500 636955 774872 776538 772211 782936 801621 740450 738505 780028 545390 522156 751486 414676 702341 708570 790442 791889 41433 478028 642134 601167 790463 803547 782823 800549 791010 382840 495211 533828 384463 386707 402643 804981 762206 785577 790500 481871 671531 811329 530459 702336 782942 791895 702342 ] |
||||||||||||||||||||||||||||||
|
2.97 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 41433 182008 382840 384463 386707 398085 398116 402643 402649 414077 414241 414676 419439 425431 430353 432268 432936 433001 443239 443246 443247 446751 448063 452803 452833 454000 454009 455901 455915 464971 467929 468237 469199 471124 471125 475404 476055 476191 478028 481871 486240 486765 486784 493837 495204 495211 502767 509981 509991 511272 522156 530459 531892 533828 545390 591217 595132 599979 601167 602614 604667 623281 636955 642134 656851 660409 660575 660577 668300 669689 671531 702336 702341 702342 708570 713289 713500 723361 736740 736872 736903 738505 740450 745119 751486 754707 756921 758336 772211 774872 774884 776538 780028 782823 782936 782942 785577 790442 790463 790500 791010 791888 791889 791890 791895 793297 795373 796698 800507 800549 801621 803547 803995 804981 807601 811329 817172 822313 827619 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло секс machine"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo fuck machine"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло секс machine"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.