Query Metrics
7
Database Queries
7
Different statements
153.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.35 ms (83.61%) |
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 298519 382374 383433 386587 395380 400365 420157 421108 444052 445024 453972 456764 464176 477619 479954 518203 521388 521510 529989 532978 535769 536406 544127 546361 546826 554188 555642 556933 559906 563747 566236 569183 571335 579040 585812 588844 591051 597187 598991 606137 606897 607565 608188 612682 612687 614931 617319 619683 622730 624284 626573 642263 643368 648758 648762 661912 662588 676676 687306 706021 706831 708918 711604 712714 714600 715073 718014 720299 726194 727667 730342 730736 736054 738493 741082 741544 745002 749294 755568 755695 757700 758070 758584 759762 760169 761299 761314 765254 769467 769513 778170 780318 780571 782006 782341 784796 786474 789780 789915 790044 791029 795966 796448 798838 802734 807134 809771 810231 810563 811668 812589 813109 813757 817709 817973 818428 821866 825643 826087 828769 ] |
||||||||||||||||||||||||||||||
|
14.80 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 521388 529989 617319 585812 796448 477619 386587 706021 769467 791029 382374 828769 445024 464176 687306 726194 395380 400365 521510 532978 579040 624284 727667 755568 760169 802734 812589 479954 566236 444052 456764 421108 569183 518203 420157 536406 546361 559906 571335 612687 817709 818428 826087 817973 825643 535769 555642 712714 714600 720299 606137 591051 607565 608188 626573 780318 807134 778170 782341 795966 757700 761314 614931 782006 789780 453972 298519 715073 730736 809771 383433 813757 821866 563747 554188 544127 661912 706831 708918 718014 648758 662588 676676 648762 711604 546826 556933 598991 612682 622730 588844 597187 619683 642263 643368 780571 790044 798838 810563 784796 810231 813109 738493 755695 786474 789915 811668 749294 759762 765254 741544 769513 730342 741082 761299 736054 745002 758070 758584 606897 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.92%) |
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 298519 382374 383433 386587 395380 400365 420157 421108 444052 445024 453972 456764 464176 477619 479954 518203 521388 521510 529989 532978 535769 536406 544127 546361 546826 554188 555642 556933 559906 563747 566236 569183 571335 579040 585812 588844 591051 597187 598991 606137 606897 607565 608188 612682 612687 614931 617319 619683 622730 624284 626573 642263 643368 648758 648762 661912 662588 676676 687306 706021 706831 708918 711604 712714 714600 715073 718014 720299 726194 727667 730342 730736 736054 738493 741082 741544 745002 749294 755568 755695 757700 758070 758584 759762 760169 761299 761314 765254 769467 769513 778170 780318 780571 782006 782341 784796 786474 789780 789915 790044 791029 795966 796448 798838 802734 807134 809771 810231 810563 811668 812589 813109 813757 817709 817973 818428 821866 825643 826087 828769 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties in her"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел her"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел her"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.06%) |
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.