Query Metrics
7
Database Queries
7
Different statements
192.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.88 ms (85.13%) |
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 398428 414808 417068 423063 425056 456167 460114 486070 492285 523521 528470 531587 536018 539228 548512 552363 570701 571385 580482 585436 591721 603032 605437 613380 614281 616525 617072 617161 618737 626121 629265 632755 652665 654891 662085 666392 693843 694161 697732 712409 719400 755595 761782 763232 763550 764086 764471 764526 764610 764991 765816 767332 767664 769116 769622 770640 772256 773781 776364 777471 778074 778135 778169 778855 778990 779869 779977 780353 780405 780599 780840 781202 781531 781630 783027 783199 783354 783637 783788 784086 784222 787034 787196 787588 787840 790526 790540 790838 791702 791903 791951 792520 793251 793349 794392 796279 797891 799732 802607 803674 808199 809203 809992 813457 813614 814241 817971 817982 818693 819382 819783 822989 823763 824003 825047 825220 826998 ] |
||||||||||||||||||||||||||||||
|
12.51 ms (6.50%) |
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 767332 571385 777471 531587 548512 652665 654891 616525 629265 617072 632755 822989 826998 780353 791702 779869 712409 819382 825220 780405 791951 755595 764086 781630 784086 802607 803674 808199 765816 779977 781202 792520 796279 778074 809992 539228 613380 580482 693843 591721 603032 662085 764526 417068 528470 570701 414808 814241 617161 783637 764517 818693 819783 764610 780599 769116 666392 778169 697732 492285 824003 823763 769622 770640 773781 398428 423063 797891 585436 486070 626121 783354 763550 614281 536018 694161 456167 787840 791903 764471 813457 761782 817971 825047 817982 460114 719400 776364 799732 793251 809203 763232 764991 767664 772256 783027 784222 787196 790526 790540 793349 778135 778855 778990 780840 781531 783788 787034 787588 425056 552363 605437 618737 828580 813614 523521 825755 794392 790838 783199 ] |
||||||||||||||||||||||||||||||
|
9.43 ms (4.90%) |
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 398428 414808 417068 423063 425056 456167 460114 486070 492285 523521 528470 531587 536018 539228 548512 552363 570701 571385 580482 585436 591721 603032 605437 613380 614281 616525 617072 617161 618737 626121 629265 632755 652665 654891 662085 666392 693843 694161 697732 712409 719400 755595 761782 763232 763550 764086 764471 764526 764610 764991 765816 767332 767664 769116 769622 770640 772256 773781 776364 777471 778074 778135 778169 778855 778990 779869 779977 780353 780405 780599 780840 781202 781531 781630 783027 783199 783354 783637 783788 784086 784222 787034 787196 787588 787840 790526 790540 790838 791702 791903 791951 792520 793251 793349 794392 796279 797891 799732 802607 803674 808199 809203 809992 813457 813614 814241 817971 817982 818693 819382 819783 822989 823763 824003 825047 825220 826998 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов минет оральн секс домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov blowjob homemade"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.