Query Metrics
7
Database Queries
7
Different statements
167.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.38 ms (83.98%) |
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 6699 183022 248388 358507 365924 382205 383560 384196 393670 396811 397794 399909 401589 402217 407383 407548 407569 408129 411686 413174 414104 418540 419032 421681 422282 422884 423243 423516 425192 425738 426006 426022 426468 427192 428428 429202 429823 429955 430468 431484 431671 435726 443412 443715 444812 445001 445612 446316 446986 449418 450215 452915 453156 458009 461671 462598 469654 483087 483708 486939 489664 494068 497678 507283 507910 510615 522047 524233 526487 527228 527390 527890 539593 541962 545860 546640 549033 550622 552250 553842 555328 555336 555343 555404 555435 555450 555776 557271 559806 559841 564388 567422 569766 571050 572436 575185 583513 584387 586592 588204 589774 592436 598414 599519 600432 603553 610233 612313 614671 619718 622345 652577 655090 660052 663936 664223 665308 667690 668970 682374 ] |
||||||||||||||||||||||||||||||
|
15.37 ms (9.20%) |
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 524233 507910 567422 660052 382205 393670 419032 555336 588204 614671 665308 667690 443715 397794 469654 584387 655090 6699 411686 418540 423243 423516 426006 429823 452915 486939 527228 494068 510615 522047 526487 553842 555343 552250 663936 668970 555328 586592 600432 453156 407383 407569 445001 399909 462598 483708 429202 489664 564388 575185 599519 610233 612313 622345 603553 431671 413174 446986 384196 183022 425192 458009 449418 446316 555404 559806 555450 572436 589774 425738 445612 422884 435726 569766 592436 541962 401589 383560 358507 396811 407548 427192 428428 461671 550622 557271 682374 549033 555776 248388 365924 402217 429955 430468 414104 422282 443412 421681 431484 450215 483087 497678 539593 583513 571050 652577 545860 546640 559841 598414 619718 408129 426468 527890 507283 527390 555435 664223 444812 426022 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пизда с волоса"
]
|
||||||||||||||||||||||||||||||
|
2.87 ms (1.72%) |
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 6699 183022 248388 358507 365924 382205 383560 384196 393670 396811 397794 399909 401589 402217 407383 407548 407569 408129 411686 413174 414104 418540 419032 421681 422282 422884 423243 423516 425192 425738 426006 426022 426468 427192 428428 429202 429823 429955 430468 431484 431671 435726 443412 443715 444812 445001 445612 446316 446986 449418 450215 452915 453156 458009 461671 462598 469654 483087 483708 486939 489664 494068 497678 507283 507910 510615 522047 524233 526487 527228 527390 527890 539593 541962 545860 546640 549033 550622 552250 553842 555328 555336 555343 555404 555435 555450 555776 557271 559806 559841 564388 567422 569766 571050 572436 575185 583513 584387 586592 588204 589774 592436 598414 599519 600432 603553 610233 612313 614671 619718 622345 652577 655090 660052 663936 664223 665308 667690 668970 682374 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин волос"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.00%) |
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.