Query Metrics
7
Database Queries
7
Different statements
143.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.61 ms (83.45%) |
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 80529 119687 143396 184943 213017 357604 386430 388949 389514 390827 393347 395741 397168 398263 401992 403765 403780 405446 416038 427946 428799 435502 442050 444414 447244 448373 453333 460172 463824 465620 467986 471437 474085 476837 485699 491874 497773 511683 514273 517708 525502 527481 527505 527919 529525 533630 533809 539800 542779 559343 560141 563177 567116 572929 580866 582793 584541 589971 595434 600564 603702 605707 641847 642666 650159 670584 685579 702115 708504 712283 713476 715394 724261 724534 734624 735639 737722 745422 746623 750483 756252 757724 758248 759712 772151 773224 779464 785118 792265 794488 801121 802239 802783 803055 806208 806210 807387 807991 808068 808307 809412 811114 815770 817569 818394 818446 818483 818507 818717 819356 824269 825204 826604 827583 828311 828416 828486 828502 828643 ] |
||||||||||||||||||||||||||||||
|
13.82 ms (9.64%) |
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 567116 641847 595434 589971 605707 807387 745422 750483 808068 759712 779464 807991 388949 444414 527919 143396 818507 828643 828502 533630 708504 803055 811114 213017 600564 809412 670584 712283 386430 119687 357604 405446 817569 818483 825204 563177 808307 735639 401992 393347 80529 403765 826604 815770 827583 818394 642666 713476 824269 828416 828311 828298 828486 746623 529525 397168 398263 448373 453333 460172 467986 485699 539800 511683 527505 465620 491874 542779 572929 580866 582793 685579 715394 560141 584541 603702 801121 802239 757724 756252 772151 773224 395741 474085 476837 428799 447244 471437 514273 525502 427946 435502 517708 806208 463824 497773 416038 559343 792265 802783 758248 818446 533809 650159 806210 724261 390827 184943 389514 527481 702115 724534 737722 403780 442050 794488 734624 785118 819356 818717 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.88%) |
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 80529 119687 143396 184943 213017 357604 386430 388949 389514 390827 393347 395741 397168 398263 401992 403765 403780 405446 416038 427946 428799 435502 442050 444414 447244 448373 453333 460172 463824 465620 467986 471437 474085 476837 485699 491874 497773 511683 514273 517708 525502 527481 527505 527919 529525 533630 533809 539800 542779 559343 560141 563177 567116 572929 580866 582793 584541 589971 595434 600564 603702 605707 641847 642666 650159 670584 685579 702115 708504 712283 713476 715394 724261 724534 734624 735639 737722 745422 746623 750483 756252 757724 758248 759712 772151 773224 779464 785118 792265 794488 801121 802239 802783 803055 806208 806210 807387 807991 808068 808307 809412 811114 815770 817569 818394 818446 818483 818507 818717 819356 824269 825204 826604 827583 828311 828416 828486 828502 828643 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs ass"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs жоп"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs жоп"
]
|
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.