Query Metrics
7
Database Queries
7
Different statements
236.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.09 ms (90.04%) |
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 93742 336986 422705 423247 427083 433668 433883 435406 451152 451175 456212 456743 456818 468594 468638 470580 477036 477882 479138 481679 484097 487199 491365 491611 493275 498719 499174 503488 504740 508857 508989 509677 511706 521789 523189 523778 526233 527630 531114 534742 535993 540614 541879 542699 548651 551049 552632 554366 559140 560281 567639 573246 574796 574803 574805 575093 575103 575469 575482 575496 575769 576063 582728 583979 585983 601472 606636 614057 640531 653520 667993 681815 695124 701280 705840 712222 715421 715628 716774 720286 730498 731339 742145 745227 747396 750136 751496 755238 755320 756450 763624 766687 767307 767751 768946 773877 778344 778355 783412 790487 794523 794976 795002 795111 796199 797110 801214 808774 810334 810604 810816 813253 814281 817007 817175 817191 817757 818605 825015 827064 ] |
||||||||||||||||||||||||||||||
|
13.40 ms (5.66%) |
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 827064 574796 712222 701280 716774 783412 794523 751496 755238 750136 773877 778355 790487 801214 433668 451152 523189 531114 541879 559140 640531 422705 427083 814281 521789 540614 567639 795002 767751 745227 747396 778344 795111 731339 456818 477882 583979 797110 499174 503488 487199 817191 817757 825015 817007 817175 818605 542699 720286 715421 681815 705840 585983 810816 767307 810604 755320 730498 742145 756450 768946 715628 794976 810334 93742 695124 614057 451175 433883 456743 491611 504740 575482 574805 575769 576063 552632 560281 574803 575093 575469 575496 653520 548651 551049 554366 575103 582728 601472 606636 766687 763624 813253 481679 423247 479138 477036 456212 468594 435406 468638 470580 491365 508857 511706 526233 527630 484097 493275 508989 509677 523778 336986 796199 808774 498719 534742 535993 573246 667993 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.13%) |
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 93742 336986 422705 423247 427083 433668 433883 435406 451152 451175 456212 456743 456818 468594 468638 470580 477036 477882 479138 481679 484097 487199 491365 491611 493275 498719 499174 503488 504740 508857 508989 509677 511706 521789 523189 523778 526233 527630 531114 534742 535993 540614 541879 542699 548651 551049 552632 554366 559140 560281 567639 573246 574796 574803 574805 575093 575103 575469 575482 575496 575769 576063 582728 583979 585983 601472 606636 614057 640531 653520 667993 681815 695124 701280 705840 712222 715421 715628 716774 720286 730498 731339 742145 745227 747396 750136 751496 755238 755320 756450 763624 766687 767307 767751 768946 773877 778344 778355 783412 790487 794523 794976 795002 795111 796199 797110 801214 808774 810334 810604 810816 813253 814281 817007 817175 817191 817757 818605 825015 827064 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм сперм"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gag on sperm"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.62%) |
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.