Query Metrics
7
Database Queries
7
Different statements
141.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.21 ms (85.13%) |
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 150305 392735 402556 402842 420001 420833 449478 463379 478274 480968 481409 485343 487824 492017 503085 508407 511932 516809 530587 531806 533084 537378 537608 542819 547741 551728 553854 554888 555547 556686 558264 562522 566220 566407 568821 576607 586928 589601 590214 593214 593261 610891 612508 612706 616845 619964 620568 621500 641516 642259 645052 646076 648193 648758 652422 663516 664473 672340 678339 679908 682691 689121 690621 692832 693151 711639 714018 715154 717131 721083 722035 727352 729549 733501 733767 734792 735678 736642 742131 746230 747171 750030 752492 753645 754146 756785 757667 761161 770095 770715 775297 777276 778945 779557 780304 782365 787142 788045 789580 789911 790237 791827 794142 794425 795672 796111 798863 800493 801833 803501 804360 804904 808082 808143 808468 809607 813428 ] |
||||||||||||||||||||||||||||||
|
11.05 ms (7.83%) |
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 714018 690621 642259 619964 778945 754040 754146 803501 733767 762229 478274 150305 485343 492017 576607 693151 692832 566220 566407 586928 589601 590214 808143 717131 508407 663516 621500 463379 487824 392735 402556 420833 530587 531806 537378 537608 533084 553854 558264 542819 551728 555547 554888 562522 648193 664473 679908 689121 646076 652422 678339 715154 721083 645052 672340 682691 556686 616845 620568 593261 610891 612508 612706 593214 641516 777276 779557 780304 782365 789580 801833 790237 795672 809607 813428 727352 729549 734792 770715 784610 787142 789911 794142 800493 808082 742131 733501 747171 752492 756785 736642 753645 761161 770095 746230 750030 711639 788045 791827 794425 796111 798863 804360 804904 402842 420001 449478 511932 503085 516809 480968 481409 547741 648758 722035 568821 775297 808468 735678 757667 ] |
||||||||||||||||||||||||||||||
|
2.53 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 150305 392735 402556 402842 420001 420833 449478 463379 478274 480968 481409 485343 487824 492017 503085 508407 511932 516809 530587 531806 533084 537378 537608 542819 547741 551728 553854 554888 555547 556686 558264 562522 566220 566407 568821 576607 586928 589601 590214 593214 593261 610891 612508 612706 616845 619964 620568 621500 641516 642259 645052 646076 648193 648758 652422 663516 664473 672340 678339 679908 682691 689121 690621 692832 693151 711639 714018 715154 717131 721083 722035 727352 729549 733501 733767 734792 735678 736642 742131 746230 747171 750030 752492 753645 754146 756785 757667 761161 770095 770715 775297 777276 778945 779557 780304 782365 787142 788045 789580 789911 790237 791827 794142 794425 795672 796111 798863 800493 801833 803501 804360 804904 808082 808143 808468 809607 813428 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"красивая жена изменяе…"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая жен жен"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.22%) |
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.