Query Metrics
7
Database Queries
7
Different statements
170.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.34 ms (84.78%) |
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 385479 387436 388631 404083 477698 490437 538040 539658 540782 545735 550544 550711 551664 554715 555619 556102 557607 562479 563779 576237 576766 577270 578754 579473 588074 588075 588214 593066 604779 605713 607748 609073 610726 610926 612622 616660 622195 622289 623137 627232 628761 629740 637407 637938 639480 640281 640448 645447 645613 648017 648273 658140 660458 665039 665602 665956 668007 668023 674271 684780 694987 696127 701416 703709 703750 703762 703772 703783 707158 707600 708683 712569 713973 714361 714407 714934 715349 717125 722145 722167 723966 725294 728148 729050 730271 731255 733509 734205 734320 736499 736725 739895 739949 740666 742273 742785 745895 746034 748102 751799 752140 754177 760191 762186 771561 790711 792876 794401 795067 795334 795344 795879 795898 796704 802336 803510 809555 810004 810394 812032 ] |
||||||||||||||||||||||||||||||
|
14.31 ms (8.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 550711 550544 556102 562479 694987 703750 645447 701416 708683 645613 658140 674271 696127 712569 714934 555619 588214 593066 622289 629740 637938 640281 588075 607748 623137 616660 802336 792876 794401 795067 795334 810004 731255 733509 748102 760191 725294 742273 751799 742785 745895 610726 622195 722145 404083 387436 385479 388631 540782 477698 490437 539658 538040 545735 551664 554715 563779 576237 557607 576766 577270 579473 665039 684780 713973 715349 648273 660458 668023 707600 648017 665602 668007 703772 722167 609073 612622 628761 604779 605713 588074 627232 639480 640448 795344 790711 795879 795898 796704 810394 734205 734320 736725 809555 728148 729050 730271 752140 762186 739895 771561 740666 610926 703709 703783 714361 714407 803510 812032 578754 736499 707158 665956 703762 717125 637407 746034 723966 739949 754177 ] |
||||||||||||||||||||||||||||||
|
4.37 ms (2.57%) |
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 385479 387436 388631 404083 477698 490437 538040 539658 540782 545735 550544 550711 551664 554715 555619 556102 557607 562479 563779 576237 576766 577270 578754 579473 588074 588075 588214 593066 604779 605713 607748 609073 610726 610926 612622 616660 622195 622289 623137 627232 628761 629740 637407 637938 639480 640281 640448 645447 645613 648017 648273 658140 660458 665039 665602 665956 668007 668023 674271 684780 694987 696127 701416 703709 703750 703762 703772 703783 707158 707600 708683 712569 713973 714361 714407 714934 715349 717125 722145 722167 723966 725294 728148 729050 730271 731255 733509 734205 734320 736499 736725 739895 739949 740666 742273 742785 745895 746034 748102 751799 752140 754177 760191 762186 771561 790711 792876 794401 795067 795334 795344 795879 795898 796704 802336 803510 809555 810004 810394 812032 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife hairy"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.88%) |
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.