Query Metrics
7
Database Queries
7
Different statements
192.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.20 ms (84.19%) |
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 73926 381776 384233 385794 386060 386326 388482 393706 393729 393743 393749 393754 393762 393779 393781 393782 393790 393793 394191 394198 400436 400457 400482 400624 402245 402249 403045 403054 413243 418493 419073 419386 428951 430303 443362 447482 448373 448383 453668 456865 458926 464283 464312 464324 470561 470847 472132 472908 475918 484126 484127 487052 487910 487915 487926 488309 489146 491490 495030 503926 503936 509532 513326 515097 515133 515201 515224 516793 521772 523259 525486 526588 528353 529219 529564 540912 545526 550441 550444 550445 550449 554134 560384 566511 566522 566527 566538 566549 567146 567149 569673 569675 569683 569690 570075 578446 578481 582137 584495 585141 586628 586632 596543 598450 621647 625295 650788 665295 688370 694536 712817 712829 722658 736917 743100 744314 759595 766043 767950 812150 ] |
||||||||||||||||||||||||||||||
|
20.52 ms (10.65%) |
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 491490 598450 447482 400436 393743 393749 503936 523259 487052 566538 582137 393793 515201 393706 413243 393782 386060 393781 550445 550444 566527 393790 403054 418493 428951 525486 464324 566522 489146 566549 545526 516793 495030 385794 736917 393729 688370 694536 393762 586628 393779 586632 487910 625295 381776 402245 487915 458926 722658 767950 464283 550449 456865 650788 448373 453668 472132 509532 566511 472908 393754 400624 430303 569690 578446 569683 578481 584495 394198 515097 529564 513326 528353 487926 386326 73926 402249 503926 712817 812150 759595 388482 394191 419386 443362 585141 488309 569673 569675 570075 400457 464312 712829 560384 744314 766043 475918 448383 515133 665295 550441 596543 403045 419073 567146 400482 515224 484126 621647 470561 484127 526588 540912 743100 384233 554134 567149 470847 521772 529219 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.62%) |
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 73926 381776 384233 385794 386060 386326 388482 393706 393729 393743 393749 393754 393762 393779 393781 393782 393790 393793 394191 394198 400436 400457 400482 400624 402245 402249 403045 403054 413243 418493 419073 419386 428951 430303 443362 447482 448373 448383 453668 456865 458926 464283 464312 464324 470561 470847 472132 472908 475918 484126 484127 487052 487910 487915 487926 488309 489146 491490 495030 503926 503936 509532 513326 515097 515133 515201 515224 516793 521772 523259 525486 526588 528353 529219 529564 540912 545526 550441 550444 550445 550449 554134 560384 566511 566522 566527 566538 566549 567146 567149 569673 569675 569683 569690 570075 578446 578481 582137 584495 585141 586628 586632 596543 598450 621647 625295 650788 665295 688370 694536 712817 712829 722658 736917 743100 744314 759595 766043 767950 812150 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"старый секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дед оттрахал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"старый секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.76%) |
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.