Query Metrics
7
Database Queries
7
Different statements
158.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.10 ms (86.02%) |
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 28568 40051 56464 327170 393865 394120 395731 400166 400857 403279 403340 407550 413889 416408 430833 430839 430979 446706 461841 465649 477335 478835 482248 486252 490801 492331 496118 510466 510934 513113 514589 519929 530325 532770 533411 536279 537727 540549 544255 549342 549911 556659 558272 559129 563100 579910 580300 596576 606884 611345 615990 617190 629479 644253 644254 668438 677590 680878 683530 687471 687571 695186 699536 704987 710568 711671 714457 714475 721060 721155 721674 721822 724706 725362 726887 726891 730955 734528 745036 751491 751655 757107 758564 764919 765045 770749 771000 771320 776820 776970 777220 777270 781171 781326 786462 787342 787636 793121 793410 796451 797867 799259 799604 801192 802384 805548 807369 813118 814382 815288 815684 816772 818865 819474 821238 822094 822278 822585 822775 827074 ] |
||||||||||||||||||||||||||||||
|
13.24 ms (8.36%) |
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 393865 478835 519929 486252 668438 818865 814382 819474 821238 533411 510934 490801 549911 683530 677590 596576 793410 734528 796451 771320 403279 695186 781326 563100 606884 777220 777270 813118 726887 765045 764919 629479 787342 540549 400857 413889 465649 514589 751655 400166 492331 430833 786462 787636 724706 725362 758564 710568 56464 403340 815288 815684 822278 822585 816772 822094 827074 822775 530325 721155 721674 680878 687471 644253 799604 776820 781171 751491 797867 801192 771000 776970 799259 802384 40051 395731 28568 558272 416408 482248 477335 714475 580300 617190 699536 714457 430979 430839 394120 513113 745036 510466 611345 327170 446706 496118 644254 407550 461841 532770 537727 549342 559129 687571 615990 805548 757107 704987 721822 556659 730955 793121 726891 711671 721060 579910 536279 544255 770749 807369 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.50%) |
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 28568 40051 56464 327170 393865 394120 395731 400166 400857 403279 403340 407550 413889 416408 430833 430839 430979 446706 461841 465649 477335 478835 482248 486252 490801 492331 496118 510466 510934 513113 514589 519929 530325 532770 533411 536279 537727 540549 544255 549342 549911 556659 558272 559129 563100 579910 580300 596576 606884 611345 615990 617190 629479 644253 644254 668438 677590 680878 683530 687471 687571 695186 699536 704987 710568 711671 714457 714475 721060 721155 721674 721822 724706 725362 726887 726891 730955 734528 745036 751491 751655 757107 758564 764919 765045 770749 771000 771320 776820 776970 777220 777270 781171 781326 786462 787342 787636 793121 793410 796451 797867 799259 799604 801192 802384 805548 807369 813118 814382 815288 815684 816772 818865 819474 821238 822094 822278 822585 822775 827074 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mom beauty"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex mom beauty"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mom beauty"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.91%) |
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.