Query Metrics
7
Database Queries
7
Different statements
204.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.63 ms (87.70%) |
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 460895 494643 509185 529990 533401 541210 546281 558309 567542 568700 584946 586295 587689 590211 593837 604367 605185 605899 606497 610699 610743 618260 619814 625462 626840 629711 632928 634646 635624 636071 636981 639597 642430 645052 646012 654236 657735 660573 664665 668006 668959 669692 674202 680581 682728 689180 690222 690630 693392 695078 701533 704447 709468 710862 714037 714071 714121 714126 715043 715061 715065 717417 721900 721966 730116 730702 732191 732757 732953 733505 735197 735805 736401 736544 738616 738888 739487 740727 745502 748328 751403 753772 757572 758337 759158 760520 760932 761138 764367 773971 777907 780318 780601 782521 785158 785174 786403 787779 789487 791308 791995 792438 793914 796512 796811 797075 800689 800726 801494 805319 806298 807019 809879 811915 815908 816807 824122 824325 827735 828453 ] |
||||||||||||||||||||||||||||||
|
16.05 ms (7.84%) |
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 815908 827735 567542 660573 714121 664665 701533 645052 690222 715043 721966 635624 791308 797075 805319 807019 785174 800726 806298 740727 757572 753772 733505 738616 751403 777907 669692 587689 730116 732191 780601 689180 773971 786403 730702 735197 738888 816807 824122 668006 680581 693392 695078 710862 717417 546281 604367 625462 642430 610699 636071 586295 610743 636981 605899 634646 785158 800689 789487 748328 761138 732757 759158 760932 764367 758337 619814 639597 714037 715065 721900 793914 460895 796512 618260 828453 558309 593837 606497 796811 732953 715061 809879 533401 646012 654236 657735 632928 735805 494643 709468 801494 811915 824325 509185 529990 541210 568700 584946 674202 714071 704447 714126 668959 682728 690630 590211 626840 629711 605185 780318 787779 791995 792438 736401 739487 745502 760520 782521 736544 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.12%) |
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 460895 494643 509185 529990 533401 541210 546281 558309 567542 568700 584946 586295 587689 590211 593837 604367 605185 605899 606497 610699 610743 618260 619814 625462 626840 629711 632928 634646 635624 636071 636981 639597 642430 645052 646012 654236 657735 660573 664665 668006 668959 669692 674202 680581 682728 689180 690222 690630 693392 695078 701533 704447 709468 710862 714037 714071 714121 714126 715043 715061 715065 717417 721900 721966 730116 730702 732191 732757 732953 733505 735197 735805 736401 736544 738616 738888 739487 740727 745502 748328 751403 753772 757572 758337 759158 760520 760932 761138 764367 773971 777907 780318 780601 782521 785158 785174 786403 787779 789487 791308 791995 792438 793914 796512 796811 797075 800689 800726 801494 805319 806298 807019 809879 811915 815908 816807 824122 824325 827735 828453 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife front of"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен front"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен front"
]
|
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.