Query Metrics
7
Database Queries
7
Different statements
170.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.38 ms (87.06%) |
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 383924 391915 391926 409035 412855 414292 414662 415885 421827 423508 428729 434346 435529 435548 435549 438490 444684 452815 454688 455133 455794 465334 469125 470473 473450 476163 476655 476664 484241 493763 499921 511278 516057 518614 526061 529599 529632 529740 531844 531879 534828 535963 538045 540746 541451 545550 546972 547556 547743 547772 553646 554980 555089 556871 561034 565031 567172 568652 568814 575860 576590 582577 583694 583712 586100 588929 591333 591884 595072 597691 618259 619570 631728 637186 638885 641997 653028 656200 656801 660043 660412 670368 672939 702375 712098 713194 713196 738468 738501 739125 740167 741186 748653 752614 752647 760598 767731 778864 782052 791479 796326 796673 796996 798457 798759 803367 803633 803770 807170 809076 810622 810776 811570 812493 813206 819256 824007 824573 826237 827290 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (7.40%) |
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 476163 567172 561034 672939 660412 670368 597691 641997 739125 434346 391926 470473 547772 444684 454688 499921 555089 809076 465334 484241 438490 414662 423508 827290 455794 476664 455133 473450 493763 531844 540746 538045 583694 583712 541451 545550 546972 568814 553646 554980 556871 591884 752614 469125 435529 435548 452815 526061 412855 414292 415885 547556 656801 713194 631728 637186 619570 383924 819256 824573 391915 826237 529599 516057 565031 582577 586100 618259 796326 803367 796673 796996 798759 803633 807170 741186 812493 767731 738468 702375 803770 428729 435549 712098 591333 421827 409035 518614 740167 824007 595072 638885 511278 534828 529740 529632 535963 531879 476655 547743 653028 713196 656200 660043 568652 575860 576590 588929 798457 810776 738501 748653 752647 760598 791479 813206 778864 782052 810622 811570 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.80%) |
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 383924 391915 391926 409035 412855 414292 414662 415885 421827 423508 428729 434346 435529 435548 435549 438490 444684 452815 454688 455133 455794 465334 469125 470473 473450 476163 476655 476664 484241 493763 499921 511278 516057 518614 526061 529599 529632 529740 531844 531879 534828 535963 538045 540746 541451 545550 546972 547556 547743 547772 553646 554980 555089 556871 561034 565031 567172 568652 568814 575860 576590 582577 583694 583712 586100 588929 591333 591884 595072 597691 618259 619570 631728 637186 638885 641997 653028 656200 656801 660043 660412 670368 672939 702375 712098 713194 713196 738468 738501 739125 740167 741186 748653 752614 752647 760598 767731 778864 782052 791479 796326 796673 796996 798457 798759 803367 803633 803770 807170 809076 810622 810776 811570 812493 813206 819256 824007 824573 826237 827290 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf дилд любительск"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf dildo amateur"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf дилд любительск"
]
|
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.