Query Metrics
7
Database Queries
7
Different statements
140.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.39 ms (85.08%) |
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 149158 188064 233683 387271 391704 392790 417846 425560 427004 428475 432390 432625 439441 439485 440372 440817 440902 440918 443159 443186 449901 450647 450654 450827 452175 454370 457859 457976 460318 460551 462455 464274 464456 465545 466935 469523 473227 474465 477984 477985 484363 485595 489102 514458 517280 518954 522510 522857 532131 537064 543970 550216 555223 555254 556818 560504 563428 563916 563925 565679 566701 568539 570175 571194 576641 577718 582222 585130 587989 589649 592799 596704 606498 626366 647602 670749 688335 693396 697231 709545 713853 718547 724294 728479 728513 734716 737925 740129 741904 742497 744277 745751 753510 755243 755611 756361 756614 759105 772775 777734 788277 789659 793165 793526 793530 793770 794766 795908 800449 807352 808096 810819 811712 813226 813920 815458 823265 823857 824229 826645 ] |
||||||||||||||||||||||||||||||
|
11.58 ms (8.26%) |
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 670749 697231 566701 592799 793165 808096 793526 793530 810819 724294 755611 759105 800449 728513 756361 728479 753510 755243 734716 742497 795908 811712 149158 387271 565679 563916 543970 626366 449901 439441 428475 440902 443159 813920 823857 466935 450654 462455 450827 522857 532131 582222 570175 647602 688335 568539 606498 789659 794766 813226 745751 425560 450647 188064 440817 454370 460318 464456 474465 571194 556818 807352 793770 709545 777734 788277 465545 233683 473227 391704 514458 522510 392790 440372 432625 439485 457859 464274 469523 452175 537064 484363 555254 563925 577718 560504 563428 576641 555223 718547 693396 713853 550216 589649 596704 587989 772775 740129 741904 737925 744277 756614 457976 477984 477985 427004 460551 485595 417846 432390 443186 440918 815458 585130 826645 823265 824229 489102 517280 518954 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.77%) |
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 149158 188064 233683 387271 391704 392790 417846 425560 427004 428475 432390 432625 439441 439485 440372 440817 440902 440918 443159 443186 449901 450647 450654 450827 452175 454370 457859 457976 460318 460551 462455 464274 464456 465545 466935 469523 473227 474465 477984 477985 484363 485595 489102 514458 517280 518954 522510 522857 532131 537064 543970 550216 555223 555254 556818 560504 563428 563916 563925 565679 566701 568539 570175 571194 576641 577718 582222 585130 587989 589649 592799 596704 606498 626366 647602 670749 688335 693396 697231 709545 713853 718547 724294 728479 728513 734716 737925 740129 741904 742497 744277 745751 753510 755243 755611 756361 756614 759105 772775 777734 788277 789659 793165 793526 793530 793770 794766 795908 800449 807352 808096 810819 811712 813226 813920 815458 823265 823857 824229 826645 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женщины спящие"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"женщин спящ"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женщин спящ"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.