Query Metrics
7
Database Queries
7
Different statements
251.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
229.55 ms (91.24%) |
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 413124 421592 422044 422230 423134 424682 433581 439243 440862 440926 442332 446431 449717 452178 453028 453269 457428 457976 460771 461635 466331 467656 467925 470685 472524 473889 473970 475266 475488 481591 482689 483380 483607 484316 484633 486185 488423 488429 489105 489738 490558 491157 497342 500527 500978 503043 506578 508441 508515 508589 508594 509437 509515 510112 511907 513686 513687 513701 515800 517496 518723 520799 521447 521483 521904 522730 523841 524135 524187 525301 527676 527962 528030 528428 528573 528882 529353 534678 543342 546105 555112 557161 559542 559560 571708 572844 575241 579876 581231 587998 589573 589590 596739 597956 602981 603235 603900 607630 610096 615608 617060 617219 619003 620266 621222 621735 623150 628632 637737 647362 651632 677892 695164 727780 741762 743610 752973 767601 776869 778613 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (5.44%) |
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 510112 518723 528428 500978 513701 515800 521483 484316 484633 481591 521447 677892 581231 637737 776869 778613 442332 527676 587998 596739 424682 423134 440926 449717 467656 508515 528882 572844 579876 543342 559542 559560 589573 621222 589590 615608 767601 457428 466331 475266 421592 461635 508594 483380 513686 513687 488423 523841 489738 557161 517496 695164 647362 628632 752973 743610 475488 446431 452178 603235 413124 422230 482689 473889 575241 603900 623150 610096 473970 488429 511907 527962 727780 457976 529353 620266 483607 472524 460771 607630 497342 508589 524135 453269 467925 433581 602981 521904 525301 546105 571708 651632 555112 509437 520799 522730 508441 617060 422044 490558 503043 524187 470685 440862 509515 534678 597956 741762 489105 491157 528573 528030 619003 621735 617219 439243 453028 486185 500527 506578 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (0.98%) |
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 413124 421592 422044 422230 423134 424682 433581 439243 440862 440926 442332 446431 449717 452178 453028 453269 457428 457976 460771 461635 466331 467656 467925 470685 472524 473889 473970 475266 475488 481591 482689 483380 483607 484316 484633 486185 488423 488429 489105 489738 490558 491157 497342 500527 500978 503043 506578 508441 508515 508589 508594 509437 509515 510112 511907 513686 513687 513701 515800 517496 518723 520799 521447 521483 521904 522730 523841 524135 524187 525301 527676 527962 528030 528428 528573 528882 529353 534678 543342 546105 555112 557161 559542 559560 571708 572844 575241 579876 581231 587998 589573 589590 596739 597956 602981 603235 603900 607630 610096 615608 617060 617219 619003 620266 621222 621735 623150 628632 637737 647362 651632 677892 695164 727780 741762 743610 752973 767601 776869 778613 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov short hair"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов short hair"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов short hair"
]
|
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.