Query Metrics
7
Database Queries
7
Different statements
156.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.01 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 21575 56639 229015 382292 391745 396064 396273 397805 403904 404060 412515 414609 417748 422629 426200 429930 443699 444244 447316 447641 447645 447647 447850 447912 451683 453857 457764 458708 459164 460215 461622 465741 466604 468585 470238 470446 473058 473111 473112 476162 477552 482522 489507 493317 502290 502713 504325 505144 513101 527800 535686 537245 540896 541840 542624 552002 552233 557910 559985 560655 565062 565272 566644 566789 567411 569623 576836 578385 579375 584576 589687 596619 598045 606392 608015 623042 643624 648648 649622 652923 659042 664655 669339 670495 678783 688997 696114 708208 713840 714433 716804 718852 720406 720822 721206 721428 722850 722883 725382 725390 728730 729626 729673 729886 730946 737114 737734 739073 740471 743935 744723 748080 749733 769796 776020 784161 788540 790369 810472 814091 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (10.15%) |
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 537245 473112 579375 722850 584576 788540 737734 451683 404060 396064 504325 527800 458708 493317 576836 720822 730946 740471 748080 729673 623042 649622 721206 443699 422629 447647 453857 552002 729626 426200 477552 559985 565062 688997 714433 721428 718852 664655 720406 560655 810472 749733 739073 743935 444244 513101 540896 566789 391745 397805 447645 457764 461622 502713 502290 541840 659042 716804 722883 608015 725390 744723 725382 470238 21575 382292 468585 489507 403904 414609 417748 447316 447641 447850 460215 447912 459164 482522 566644 578385 652923 708208 567411 596619 606392 737114 769796 728730 784161 396273 465741 470446 473058 473111 466604 56639 814091 535686 542624 565272 713840 670495 598045 412515 229015 429930 505144 476162 557910 569623 648648 678783 669339 696114 552233 643624 589687 776020 729886 790369 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck skinny"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.40%) |
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 21575 56639 229015 382292 391745 396064 396273 397805 403904 404060 412515 414609 417748 422629 426200 429930 443699 444244 447316 447641 447645 447647 447850 447912 451683 453857 457764 458708 459164 460215 461622 465741 466604 468585 470238 470446 473058 473111 473112 476162 477552 482522 489507 493317 502290 502713 504325 505144 513101 527800 535686 537245 540896 541840 542624 552002 552233 557910 559985 560655 565062 565272 566644 566789 567411 569623 576836 578385 579375 584576 589687 596619 598045 606392 608015 623042 643624 648648 649622 652923 659042 664655 669339 670495 678783 688997 696114 708208 713840 714433 716804 718852 720406 720822 721206 721428 722850 722883 725382 725390 728730 729626 729673 729886 730946 737114 737734 739073 740471 743935 744723 748080 749733 769796 776020 784161 788540 790369 810472 814091 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс худые"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.00%) |
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.