Query Metrics
7
Database Queries
7
Different statements
150.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.81 ms (83.19%) |
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 383366 402984 403419 408659 419423 421735 422358 426994 428148 430437 431481 434097 437582 439743 445790 449622 457575 465840 466129 474035 477989 478985 478990 487405 493149 495198 502729 504927 512555 525802 526515 534218 535672 541561 541890 549367 549391 556817 560141 563009 563455 564127 565022 565557 568425 569015 577363 577422 578703 580971 581566 581969 585477 586584 588314 589036 592685 598253 603029 604109 604555 609759 610271 612321 614725 619204 621096 621676 622366 650195 654636 661976 673612 673651 677817 685579 697909 699516 702286 703509 703900 707315 709215 715972 723435 723732 726753 737633 741613 745827 751567 753248 755782 756803 769487 770149 771023 773412 773474 773850 776462 779610 784922 785856 786385 789968 792343 792634 794804 797657 797909 800936 803321 805149 806288 807390 807465 807529 812418 813249 ] |
||||||||||||||||||||||||||||||
|
16.05 ms (10.70%) |
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 556817 564127 569015 577363 580971 541561 565022 541890 549367 549391 563009 563455 581566 581969 650195 654636 661976 673651 699516 702286 673612 685579 703509 715972 677817 697909 707315 723435 560141 577422 592685 609759 585477 586584 588314 603029 612321 621676 598253 604109 614725 619204 621096 784922 785856 792343 806288 807390 807529 812418 779610 786385 794804 797909 805149 807465 723732 751567 773850 789968 800936 803321 813249 737633 769487 741613 745827 755782 756803 771023 773474 726753 770149 773412 753248 622366 703900 709215 776462 792634 797657 421735 439743 457575 478985 449622 477989 478990 383366 402984 419423 434097 445790 428148 466129 512555 493149 525802 535672 487405 502729 534218 526515 568425 565557 589036 610271 422358 426994 403419 465840 437582 495198 578703 604555 430437 474035 504927 408659 431481 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.70%) |
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 383366 402984 403419 408659 419423 421735 422358 426994 428148 430437 431481 434097 437582 439743 445790 449622 457575 465840 466129 474035 477989 478985 478990 487405 493149 495198 502729 504927 512555 525802 526515 534218 535672 541561 541890 549367 549391 556817 560141 563009 563455 564127 565022 565557 568425 569015 577363 577422 578703 580971 581566 581969 585477 586584 588314 589036 592685 598253 603029 604109 604555 609759 610271 612321 614725 619204 621096 621676 622366 650195 654636 661976 673612 673651 677817 685579 697909 699516 702286 703509 703900 707315 709215 715972 723435 723732 726753 737633 741613 745827 751567 753248 755782 756803 769487 770149 771023 773412 773474 773850 776462 779610 784922 785856 786385 789968 792343 792634 794804 797657 797909 800936 803321 805149 806288 807390 807465 807529 812418 813249 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom mom"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван mom"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван mom"
]
|
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.