Query Metrics
7
Database Queries
7
Different statements
159.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.78 ms (83.14%) |
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 9021 29661 38261 80916 81869 146508 210052 412554 421491 422264 424903 428783 432573 433323 433596 438056 438062 438324 441850 442010 444607 446003 452616 453259 455273 461631 462657 463074 464868 465310 467380 468982 469399 472574 477067 477498 478949 483472 483855 485511 487185 488885 501378 506891 508101 509532 509580 509772 512832 515263 516473 517374 520200 525678 527036 527697 529663 530395 531927 532110 543928 544639 552369 555600 571044 597150 599681 605261 622972 644984 680664 695759 697769 710453 712135 715908 725465 725652 727803 728297 731126 731225 733417 735461 736378 737085 739762 741088 742578 746169 746447 746553 746603 753515 753673 759889 761278 761403 768636 769475 774511 789160 791673 792546 795750 795927 795947 795987 806343 808870 809789 811383 811801 813628 817536 817556 824115 827214 828435 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (10.24%) |
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 725652 769475 477498 81869 477067 483855 695759 739762 746603 80916 428783 422264 9021 210052 769530 737085 795750 543928 644984 472574 506891 485511 759889 731126 789160 817556 827214 817536 795987 774511 791673 795947 741088 761278 795927 433323 146508 441850 809789 811383 529663 712135 746169 742578 768636 725465 746553 824115 680664 544639 728297 753673 727803 438062 483472 444607 465310 531927 532110 530395 715908 597150 806343 469399 421491 446003 735461 697769 527697 828435 622972 761403 516473 509580 438324 512832 733417 29661 813628 599681 731225 424903 552369 433596 38261 605261 753515 438056 412554 455273 468982 478949 452616 487185 517374 463074 527036 746447 811801 453259 808870 508101 571044 792546 442010 509772 520200 555600 501378 432573 736378 710453 461631 509532 515263 525678 488885 462657 467380 464868 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.81%) |
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 9021 29661 38261 80916 81869 146508 210052 412554 421491 422264 424903 428783 432573 433323 433596 438056 438062 438324 441850 442010 444607 446003 452616 453259 455273 461631 462657 463074 464868 465310 467380 468982 469399 472574 477067 477498 478949 483472 483855 485511 487185 488885 501378 506891 508101 509532 509580 509772 512832 515263 516473 517374 520200 525678 527036 527697 529663 530395 531927 532110 543928 544639 552369 555600 571044 597150 599681 605261 622972 644984 680664 695759 697769 710453 712135 715908 725465 725652 727803 728297 731126 731225 733417 735461 736378 737085 739762 741088 742578 746169 746447 746553 746603 753515 753673 759889 761278 761403 768636 769475 774511 789160 791673 792546 795750 795927 795947 795987 806343 808870 809789 811383 811801 813628 817536 817556 824115 827214 828435 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамки дрочка члена"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин дрочк член"
]
|
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.