Query Metrics
7
Database Queries
7
Different statements
160.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.23 ms (86.15%) |
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 406867 417455 423799 427753 431593 435413 441752 441800 444550 447224 449854 450448 457871 459120 478079 485973 491235 492287 504003 517519 525304 525911 525988 530648 538172 539790 540427 548419 556174 557561 564133 577272 577458 577865 582431 584768 585420 586121 587134 587314 587337 587342 590517 592323 601527 605692 608900 609646 651373 655550 656635 663160 668752 673954 677906 683066 687432 703603 709896 710449 712874 713705 714300 718274 720669 722931 723252 726194 728548 731020 731609 733232 735581 738631 740123 740312 740577 740787 741700 741702 746235 751898 752565 753633 760401 761650 762414 762756 762843 762913 765545 768387 772035 775359 776007 777202 777260 786632 788827 789456 790437 790483 792050 794071 795244 796825 797349 800529 803371 804564 805190 806823 808186 808337 808531 811990 812290 813467 813562 819832 ] |
||||||||||||||||||||||||||||||
|
12.93 ms (8.06%) |
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 713705 714300 722931 423799 525911 449854 525988 556174 795244 813467 761650 786632 813562 525304 540427 491235 655550 687432 663160 677906 577272 587314 587134 592323 777202 777260 740123 740787 794071 808337 741700 753633 762414 762756 762843 731609 740577 720669 776007 806823 417455 517519 586121 805190 811990 447224 538172 587342 740312 441752 819832 459120 548419 582431 608900 585420 797349 790437 796825 812290 728548 765545 789456 790483 792050 804564 808531 733232 735581 738631 751898 752565 803371 406867 431593 441800 444550 478079 427753 539790 504003 577865 651373 656635 710449 668752 718274 673954 557561 609646 605692 601527 772035 808186 746235 709896 712874 530648 492287 590517 435413 450448 457871 485973 584768 564133 577458 723252 683066 703603 587337 775359 788827 731020 760401 800529 741702 762913 726194 768387 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.94%) |
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 406867 417455 423799 427753 431593 435413 441752 441800 444550 447224 449854 450448 457871 459120 478079 485973 491235 492287 504003 517519 525304 525911 525988 530648 538172 539790 540427 548419 556174 557561 564133 577272 577458 577865 582431 584768 585420 586121 587134 587314 587337 587342 590517 592323 601527 605692 608900 609646 651373 655550 656635 663160 668752 673954 677906 683066 687432 703603 709896 710449 712874 713705 714300 718274 720669 722931 723252 726194 728548 731020 731609 733232 735581 738631 740123 740312 740577 740787 741700 741702 746235 751898 752565 753633 760401 761650 762414 762756 762843 762913 765545 768387 772035 775359 776007 777202 777260 786632 788827 789456 790437 790483 792050 794071 795244 796825 797349 800529 803371 804564 805190 806823 808186 808337 808531 811990 812290 813467 813562 819832 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cowgirl amateur"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cowgirl любительск"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cowgirl любительск"
]
|
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.