Query Metrics
7
Database Queries
7
Different statements
161.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.40 ms (83.16%) |
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 405543 406812 414047 415594 419854 420685 421844 430215 435594 435624 435865 436446 438607 438619 442430 446251 447693 449038 449723 452462 453902 455440 456081 458313 458418 461251 461869 462682 464479 475316 477738 480888 482128 483057 484943 487417 488408 492844 495279 496044 500941 500996 504069 514123 514776 515744 521028 524399 525273 525395 527715 527862 528232 528351 534333 543084 544095 547235 547959 548246 551584 552046 552578 554308 557727 558914 560526 560594 561512 563871 565843 567136 569687 571835 572260 573802 577584 580161 580823 581751 591623 592571 594543 597925 598636 599377 599412 611331 614045 614436 619724 620067 630670 663864 665518 688990 702835 713630 725180 727089 738006 741441 750069 754111 756703 757750 772399 776566 777223 781178 788519 789670 790055 790224 793175 795832 802644 806695 810526 825864 ] |
||||||||||||||||||||||||||||||
|
16.74 ms (10.36%) |
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 597925 599377 611331 592571 614045 591623 777223 725180 790055 795832 806695 741441 750069 756703 738006 754111 802644 438607 461251 435865 415594 514776 492844 487417 480888 447693 458313 456081 500941 525273 528351 482128 543084 547235 547959 548246 567136 580161 551584 558914 544095 552046 560594 571835 688990 702835 713630 572260 580823 594543 619724 630670 790224 810526 776566 781178 757750 727089 614436 788519 789670 442430 453902 421844 458418 464479 477738 528232 484943 496044 534333 504069 524399 430215 462682 449723 461869 475316 452462 495279 563871 577584 581751 560526 565843 598636 599412 793175 772399 405543 436446 455440 446251 449038 435594 420685 438619 525395 483057 488408 414047 406812 419854 435624 825864 620067 514123 521028 527862 500996 515744 527715 569687 573802 552578 557727 554308 561512 663864 665518 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.73%) |
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 405543 406812 414047 415594 419854 420685 421844 430215 435594 435624 435865 436446 438607 438619 442430 446251 447693 449038 449723 452462 453902 455440 456081 458313 458418 461251 461869 462682 464479 475316 477738 480888 482128 483057 484943 487417 488408 492844 495279 496044 500941 500996 504069 514123 514776 515744 521028 524399 525273 525395 527715 527862 528232 528351 534333 543084 544095 547235 547959 548246 551584 552046 552578 554308 557727 558914 560526 560594 561512 563871 565843 567136 569687 571835 572260 573802 577584 580161 580823 581751 591623 592571 594543 597925 598636 599377 599412 611331 614045 614436 619724 620067 630670 663864 665518 688990 702835 713630 725180 727089 738006 741441 750069 754111 756703 757750 772399 776566 777223 781178 788519 789670 790055 790224 793175 795832 802644 806695 810526 825864 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"found"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"found"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"found"
]
|
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.