Query Metrics
7
Database Queries
7
Different statements
155.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.19 ms (83.15%) |
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 191495 233365 358592 399164 415551 415822 423505 444223 446993 448398 450198 452330 453147 454551 455747 457038 457199 461860 462002 466948 467639 470689 471336 472268 473449 474205 474891 475715 491331 494227 507249 509075 513766 520318 523601 524314 526938 527061 530045 533740 534651 536381 537075 540461 542522 543623 545181 547614 549298 551073 552852 552863 555009 558750 558757 559674 565328 566014 567411 567481 568216 568346 572605 573216 576972 579213 581135 582615 585380 587533 587996 592511 592857 596292 601030 604082 604704 611186 625849 630448 630890 631807 635486 644588 649093 668937 689701 690050 691510 692806 693799 693990 694470 695246 695249 695628 697369 698550 700953 714623 725303 729453 750729 750893 751958 756504 760687 760862 768032 782978 786258 791567 795832 801569 803148 803292 803676 811093 812495 821596 ] |
||||||||||||||||||||||||||||||
|
16.20 ms (10.43%) |
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 821596 450198 457199 466948 473449 491331 446993 452330 453147 457038 472268 474205 494227 530045 534651 513766 533740 524314 507249 523601 527061 536381 537075 540461 467639 471336 551073 552863 558750 568346 572605 581135 543623 549298 555009 565328 576972 579213 582615 542522 545181 552852 559674 566014 567481 568216 573216 668937 691510 694470 695628 700953 690050 692806 693799 697369 714623 649093 689701 693990 695246 695249 547614 558757 567411 585380 592857 596292 604704 604082 630448 631807 635486 644588 587533 592511 601030 611186 587996 625849 630890 791567 801569 803148 782978 803292 812495 729453 795832 803676 725303 750729 751958 760687 760862 750893 756504 768032 698550 786258 811093 399164 462002 474891 191495 358592 415551 423505 454551 233365 444223 461860 475715 415822 448398 455747 470689 520318 526938 509075 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.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 191495 233365 358592 399164 415551 415822 423505 444223 446993 448398 450198 452330 453147 454551 455747 457038 457199 461860 462002 466948 467639 470689 471336 472268 473449 474205 474891 475715 491331 494227 507249 509075 513766 520318 523601 524314 526938 527061 530045 533740 534651 536381 537075 540461 542522 543623 545181 547614 549298 551073 552852 552863 555009 558750 558757 559674 565328 566014 567411 567481 568216 568346 572605 573216 576972 579213 581135 582615 585380 587533 587996 592511 592857 596292 601030 604082 604704 611186 625849 630448 630890 631807 635486 644588 649093 668937 689701 690050 691510 692806 693799 693990 694470 695246 695249 695628 697369 698550 700953 714623 725303 729453 750729 750893 751958 756504 760687 760862 768032 782978 786258 791567 795832 801569 803148 803292 803676 811093 812495 821596 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf video"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf video"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf video"
]
|
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.