Query Metrics
7
Database Queries
7
Different statements
178.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.35 ms (86.66%) |
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 12573 14599 33401 180923 233298 366283 373981 382362 382788 383154 389315 395504 397958 398388 408508 411118 415714 415875 417469 420501 421408 430380 433516 443237 446351 446352 449573 457494 461755 463845 468475 479703 484054 488931 529330 529664 530304 533559 533681 536718 536725 536740 542614 543035 554834 556250 575197 578778 584576 591684 595194 597678 599006 600933 601101 604464 606956 616989 622582 623960 623965 626357 631394 635236 635932 638988 641075 646893 650263 651872 652548 659057 662047 664260 666850 669054 669564 675008 680030 681511 681692 683404 684970 686776 694116 695939 697130 705702 714830 715920 716088 717162 718803 720388 720806 720889 722489 726154 737470 754162 774524 775607 776041 777761 783896 784618 785857 790985 792587 794009 794560 794769 795413 797029 802601 803757 807541 810709 811100 822286 ] |
||||||||||||||||||||||||||||||
|
14.39 ms (8.08%) |
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 714830 715920 718803 777761 783896 790985 794009 797029 803757 810709 12573 180923 366283 446352 395504 33401 417469 233298 382788 397958 421408 411118 533559 666850 675008 575197 601101 595194 383154 373981 382362 14599 389315 398388 408508 420501 430380 415714 443237 433516 415875 822286 446351 457494 484054 449573 463845 468475 488931 533681 530304 536718 536725 529330 529664 536740 461755 479703 554834 556250 543035 542614 578778 650263 659057 669564 697130 717162 720806 646893 651872 664260 669054 681692 694116 652548 662047 680030 681511 683404 684970 686776 695939 705702 716088 720388 720889 722489 584576 616989 626357 635236 591684 597678 604464 635932 631394 599006 600933 606956 622582 623960 623965 638988 641075 807541 774524 775607 776041 794560 795413 726154 737470 754162 784618 785857 792587 794769 802601 811100 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.43%) |
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 12573 14599 33401 180923 233298 366283 373981 382362 382788 383154 389315 395504 397958 398388 408508 411118 415714 415875 417469 420501 421408 430380 433516 443237 446351 446352 449573 457494 461755 463845 468475 479703 484054 488931 529330 529664 530304 533559 533681 536718 536725 536740 542614 543035 554834 556250 575197 578778 584576 591684 595194 597678 599006 600933 601101 604464 606956 616989 622582 623960 623965 626357 631394 635236 635932 638988 641075 646893 650263 651872 652548 659057 662047 664260 666850 669054 669564 675008 680030 681511 681692 683404 684970 686776 694116 695939 697130 705702 714830 715920 716088 717162 718803 720388 720806 720889 722489 726154 737470 754162 774524 775607 776041 777761 783896 784618 785857 790985 792587 794009 794560 794769 795413 797029 802601 803757 807541 810709 811100 822286 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens black"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens black"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens black"
]
|
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.