Query Metrics
7
Database Queries
7
Different statements
169.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.85 ms (82.43%) |
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 388915 396817 412583 418018 418051 418057 425993 430828 446816 450386 452034 455978 458614 467715 472808 480363 481317 482139 483014 483394 485131 490785 499791 499885 503479 513140 513823 516873 519911 527465 531919 532182 532255 532751 532812 534239 537531 538915 541774 541848 542189 546858 547949 550316 552319 556973 559183 559922 560230 564767 565101 568061 577475 584336 584481 586032 586681 588067 590797 592592 592971 593002 593092 595761 595944 596462 596862 597917 598993 601742 603445 609067 609121 613995 615075 619475 631572 642069 649559 659025 672240 674410 678925 683237 688342 707566 713551 723096 729751 733480 738727 750876 756868 765604 774000 785525 786461 793082 795280 801043 801048 801890 802111 804703 804776 812781 813787 813803 814774 815137 819172 819173 819181 819975 820871 826061 827063 828060 ] |
||||||||||||||||||||||||||||||
|
19.03 ms (11.22%) |
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 458614 552319 559922 642069 823807 678925 542189 532751 595761 388915 815137 412583 531919 537531 480363 546858 564767 577475 674410 672240 688342 597917 592592 601742 631572 593002 593092 733480 795280 774000 532255 527465 485131 532182 538915 713551 812781 765604 804776 472808 756868 819975 588067 519911 541848 532812 499791 541774 568061 534239 824404 828060 499885 785525 418057 560230 813787 418051 819173 826061 819172 802111 649559 481317 446816 729751 820871 596462 559183 586681 490785 513823 547949 584481 556973 723096 592971 596862 750876 603445 786461 793082 827063 609067 738727 707566 619475 482139 467715 586032 813803 430828 483014 659025 683237 598993 613995 396817 483394 609121 516873 418018 814774 565101 550316 595944 503479 590797 801890 801043 452034 425993 455978 819181 513140 804703 801048 615075 450386 584336 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.79%) |
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 388915 396817 412583 418018 418051 418057 425993 430828 446816 450386 452034 455978 458614 467715 472808 480363 481317 482139 483014 483394 485131 490785 499791 499885 503479 513140 513823 516873 519911 527465 531919 532182 532255 532751 532812 534239 537531 538915 541774 541848 542189 546858 547949 550316 552319 556973 559183 559922 560230 564767 565101 568061 577475 584336 584481 586032 586681 588067 590797 592592 592971 593002 593092 595761 595944 596462 596862 597917 598993 601742 603445 609067 609121 613995 615075 619475 631572 642069 649559 659025 672240 674410 678925 683237 688342 707566 713551 723096 729751 733480 738727 750876 756868 765604 774000 785525 786461 793082 795280 801043 801048 801890 802111 804703 804776 812781 813787 813803 814774 815137 819172 819173 819181 819975 820871 826061 827063 828060 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother asian"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
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.