Query Metrics
7
Database Queries
7
Different statements
168.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.00 ms (83.60%) |
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 102043 185332 285356 381740 381758 385105 385389 389516 390215 390908 390950 396013 399352 402611 406433 406993 407054 407507 409291 411012 411555 412068 415189 418400 418933 419794 421235 428583 443380 447545 448684 449254 450530 453555 459231 467273 469675 469825 472212 474823 476366 484289 487514 489618 498544 499656 501720 503215 507168 510244 511263 516536 518328 518483 520599 524003 527660 530718 551292 551321 551388 558617 560848 563796 566848 572010 572016 573776 575730 577496 578437 594500 596908 600276 600607 603096 603516 603583 618883 619604 634755 636836 643520 653247 654331 663381 663391 668905 672457 672518 681411 682268 689323 697178 711576 720458 722810 722896 737921 738907 740235 740485 747363 747383 749522 749553 756460 782003 786356 799635 800005 800066 801666 810842 811675 813228 816517 818390 820009 821572 ] |
||||||||||||||||||||||||||||||
|
17.16 ms (10.17%) |
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 756460 381758 406993 820009 577496 681411 711576 722810 654331 668905 672518 643520 636836 811675 740235 738907 740485 747363 747383 722896 390908 407054 428583 498544 530718 518483 600276 619604 447545 449254 419794 102043 443380 185332 453555 474823 459231 737921 487514 385105 381740 816517 448684 551292 786356 801666 810842 800066 799635 484289 390950 418933 518328 507168 467273 527660 399352 418400 499656 558617 551321 563796 572016 575730 572010 653247 663381 594500 603096 603583 389516 503215 396013 450530 510244 573776 600607 618883 813228 469675 415189 285356 406433 516536 501720 511263 520599 489618 524003 749553 551388 385389 390215 421235 411012 469825 472212 682268 697178 800005 749522 634755 782003 409291 476366 411555 407507 412068 566848 560848 596908 402611 818390 821572 578437 672457 720458 663391 689323 603516 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.70%) |
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 102043 185332 285356 381740 381758 385105 385389 389516 390215 390908 390950 396013 399352 402611 406433 406993 407054 407507 409291 411012 411555 412068 415189 418400 418933 419794 421235 428583 443380 447545 448684 449254 450530 453555 459231 467273 469675 469825 472212 474823 476366 484289 487514 489618 498544 499656 501720 503215 507168 510244 511263 516536 518328 518483 520599 524003 527660 530718 551292 551321 551388 558617 560848 563796 566848 572010 572016 573776 575730 577496 578437 594500 596908 600276 600607 603096 603516 603583 618883 619604 634755 636836 643520 653247 654331 663381 663391 668905 672457 672518 681411 682268 689323 697178 711576 720458 722810 722896 737921 738907 740235 740485 747363 747383 749522 749553 756460 782003 786356 799635 800005 800066 801666 810842 811675 813228 816517 818390 820009 821572 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big massage"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие массаж"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.02%) |
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.