Query Metrics
7
Database Queries
7
Different statements
164.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.47 ms (82.99%) |
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 47689 72386 191093 363976 389643 397004 398475 406306 407064 407626 417206 417219 418912 418929 419051 423461 423511 425632 440631 442248 444475 446276 448710 449613 451477 453446 453463 454335 457016 457875 457976 458731 460134 462443 462849 465235 465528 465535 466383 466806 469380 469485 470046 472629 473364 477621 481939 487749 489317 489926 496595 496632 497189 499334 499336 505821 507673 513721 517047 525742 526401 526698 529150 529285 535820 536801 537143 537854 540428 541125 542796 557840 563096 582545 582774 591355 601357 604811 608039 609791 625765 642407 664381 666361 670891 686177 692086 707318 718213 721060 728049 728253 728381 729058 731898 735459 735904 736893 742553 742610 757113 757315 758152 761455 763604 764518 771269 774205 789523 796672 797775 801043 804991 806004 811126 818488 820380 828528 828595 828747 ] |
||||||||||||||||||||||||||||||
|
18.14 ms (11.03%) |
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 731898 735459 736893 72386 457976 397004 398475 448710 458731 828528 761455 642407 692086 363976 828595 664381 407064 423511 444475 818488 446276 469485 472629 513721 460134 466806 541125 557840 608039 804991 806004 797775 742610 721060 418912 465535 453463 417206 425632 453446 470046 442248 499336 526698 604811 462443 440631 507673 505821 526401 582774 582545 828747 542796 820380 477621 537854 537143 496632 718213 686177 811126 789523 796672 729058 801043 758152 728049 728253 728381 771269 774205 735904 742553 757113 457016 454335 419051 465235 457875 469380 529285 540428 529150 536801 563096 591355 406306 451477 473364 496595 497189 757315 423461 489317 449613 517047 499334 487749 601357 609791 462849 465528 481939 466383 525742 535820 666361 670891 707318 764518 763604 625765 191093 47689 389643 418929 407626 417219 489926 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.00%) |
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 47689 72386 191093 363976 389643 397004 398475 406306 407064 407626 417206 417219 418912 418929 419051 423461 423511 425632 440631 442248 444475 446276 448710 449613 451477 453446 453463 454335 457016 457875 457976 458731 460134 462443 462849 465235 465528 465535 466383 466806 469380 469485 470046 472629 473364 477621 481939 487749 489317 489926 496595 496632 497189 499334 499336 505821 507673 513721 517047 525742 526401 526698 529150 529285 535820 536801 537143 537854 540428 541125 542796 557840 563096 582545 582774 591355 601357 604811 608039 609791 625765 642407 664381 666361 670891 686177 692086 707318 718213 721060 728049 728253 728381 729058 731898 735459 735904 736893 742553 742610 757113 757315 758152 761455 763604 764518 771269 774205 789523 796672 797775 801043 804991 806004 811126 818488 820380 828528 828595 828747 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock milf"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock milf"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock milf"
]
|
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.