Query Metrics
7
Database Queries
7
Different statements
188.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.78 ms (85.26%) |
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 379777 402378 405208 430824 434046 434163 434212 437843 448644 448669 448953 460267 464129 464542 486531 489934 495199 495868 497404 498057 499717 503449 504422 506908 511829 513137 514808 516790 519983 520113 522438 522605 523511 524283 525882 526930 527029 527139 528331 528336 528779 531943 538274 542094 542870 543026 549174 549688 553332 556002 561286 561295 562888 563122 563885 564194 564208 565101 565160 566375 566708 572194 572675 573941 574231 574414 577410 585163 585721 586805 592580 592662 597670 598361 600488 605356 608387 610241 612828 613683 614557 618813 619366 620275 623735 626857 671348 678899 682389 683369 683906 683952 684910 684997 696934 700426 702299 704561 706676 721617 730307 734008 734506 735867 746736 758847 788373 789175 790891 792614 796239 797280 801906 804771 805629 805874 807533 814781 814936 816541 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (9.36%) |
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 614557 801906 804771 807533 706676 448953 516790 528336 538274 520113 702299 684997 610241 597670 620275 789175 790891 797280 805629 734008 746736 522438 814936 816541 553332 574231 683906 556002 598361 600488 696934 525882 522605 734506 460267 524283 528331 503449 528779 519983 549174 678899 572675 623735 612828 626857 730307 735867 758847 618813 788373 796239 499717 526930 721617 586805 448669 566708 437843 506908 405208 434163 527139 542094 565160 562888 574414 605356 700426 511829 514808 577410 613683 495868 572194 564208 561295 608387 585163 592662 464129 513137 434212 434046 504422 549688 683369 704561 448644 671348 430824 543026 573941 564194 464542 531943 379777 814781 592580 486531 527029 542870 561286 563122 619366 792614 523511 489934 402378 684910 805874 498057 495199 497404 585721 566375 565101 683952 682389 563885 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.58%) |
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 379777 402378 405208 430824 434046 434163 434212 437843 448644 448669 448953 460267 464129 464542 486531 489934 495199 495868 497404 498057 499717 503449 504422 506908 511829 513137 514808 516790 519983 520113 522438 522605 523511 524283 525882 526930 527029 527139 528331 528336 528779 531943 538274 542094 542870 543026 549174 549688 553332 556002 561286 561295 562888 563122 563885 564194 564208 565101 565160 566375 566708 572194 572675 573941 574231 574414 577410 585163 585721 586805 592580 592662 597670 598361 600488 605356 608387 610241 612828 613683 614557 618813 619366 620275 623735 626857 671348 678899 682389 683369 683906 683952 684910 684997 696934 700426 702299 704561 706676 721617 730307 734008 734506 735867 746736 758847 788373 789175 790891 792614 796239 797280 801906 804771 805629 805874 807533 814781 814936 816541 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother stepdaughter"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин stepdaughter"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин stepdaughter"
]
|
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.