Query Metrics
7
Database Queries
7
Different statements
158.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.71 ms (84.40%) |
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 401861 415889 418069 423802 434072 435579 439522 450509 460461 465589 466470 472536 478983 483686 487548 500436 512483 513203 515624 524796 529643 532273 533717 535331 538558 541413 545327 547476 547734 557869 568646 574695 581196 589824 593098 594110 594998 595258 595946 601013 604969 604971 628104 629108 630270 634717 668509 669016 669370 682735 689042 690625 696140 696776 699534 707389 714369 716568 718014 718771 737578 738062 739556 739946 741368 742331 750739 750996 751531 751627 757234 757439 763738 763744 765490 765830 765870 769405 770226 771867 774575 774734 776083 781309 781332 781825 781936 783343 784005 784143 784633 787528 789636 791033 791090 794030 795409 795731 799033 799641 803142 803374 804117 805129 805154 806391 806973 807227 807594 807611 808030 808468 808652 808958 810791 811110 811313 811350 819235 824889 ] |
||||||||||||||||||||||||||||||
|
15.98 ms (10.09%) |
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 805154 806391 401861 435579 450509 434072 513203 535331 439522 465589 472536 547734 557869 594998 810791 423802 418069 487548 500436 524796 483686 515624 415889 824889 819235 478983 466470 512483 529643 532273 538558 533717 460461 545327 547476 574695 541413 568646 668509 699534 716568 718014 718771 669016 669370 682735 689042 696776 714369 690625 696140 707389 581196 629108 634717 593098 595946 601013 604971 628104 630270 589824 594110 595258 776083 781332 789636 794030 805129 808030 808652 811350 774734 781825 784633 787528 795409 803374 806973 808468 808958 741368 757234 765490 781309 783343 795731 799641 804117 807227 807594 807611 811313 742331 750739 765870 739946 751627 737578 739556 750996 751531 757439 763744 765830 738062 763738 769405 770226 771867 604969 774575 781936 784005 784143 791033 791090 799033 803142 811110 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.46%) |
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 401861 415889 418069 423802 434072 435579 439522 450509 460461 465589 466470 472536 478983 483686 487548 500436 512483 513203 515624 524796 529643 532273 533717 535331 538558 541413 545327 547476 547734 557869 568646 574695 581196 589824 593098 594110 594998 595258 595946 601013 604969 604971 628104 629108 630270 634717 668509 669016 669370 682735 689042 690625 696140 696776 699534 707389 714369 716568 718014 718771 737578 738062 739556 739946 741368 742331 750739 750996 751531 751627 757234 757439 763738 763744 765490 765830 765870 769405 770226 771867 774575 774734 776083 781309 781332 781825 781936 783343 784005 784143 784633 787528 789636 791033 791090 794030 795409 795731 799033 799641 803142 803374 804117 805129 805154 806391 806973 807227 807594 807611 808030 808468 808652 808958 810791 811110 811313 811350 819235 824889 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo shaved mom"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло бритая mom"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло бритая mom"
]
|
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.