Query Metrics
7
Database Queries
7
Different statements
173.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.07 ms (80.83%) |
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 233135 398409 420540 422349 425394 426553 428229 428576 431463 432249 434321 439981 443817 443945 445623 448483 450653 450948 452480 452556 454869 455560 455879 462525 466028 468858 471452 471969 472389 476320 476791 479106 480764 482975 486303 487824 488812 491014 492054 492652 493108 493381 500090 506028 508989 509422 511388 511833 516152 517579 518802 520935 521022 522092 522226 523066 523266 524449 525471 526070 527476 527836 529055 529358 537810 546460 546950 556921 557377 557378 557993 558494 561382 561991 562043 565213 565347 569188 569603 570845 570860 572022 574237 576230 580751 582784 583645 583861 585515 586649 587849 591004 592390 592514 593063 595789 596373 596730 596927 597947 599029 601399 603256 604304 605613 607552 610626 612171 616973 619123 623284 633853 640687 643109 650539 652007 658042 670274 677106 690822 ] |
||||||||||||||||||||||||||||||
|
22.99 ms (13.27%) |
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 488812 561382 591004 592514 603256 640687 426553 432249 428576 439981 445623 480764 491014 455879 518802 521022 529055 529358 537810 522092 523266 562043 565213 565347 570845 583861 582784 546460 556921 557377 557993 569188 570860 574237 583645 652007 690822 670274 677106 546950 557378 558494 561991 580751 587849 592390 601399 605613 616973 623284 599029 612171 619123 633853 586649 593063 595789 596373 596730 610626 596927 420540 434321 443817 450948 462525 466028 468858 471452 476791 425394 448483 450653 454869 398409 431463 471969 479106 422349 472389 522226 492054 493108 511388 520935 523066 525471 527836 487824 492652 506028 508989 482975 509422 572022 455560 233135 493381 486303 576230 643109 585515 607552 516152 524449 526070 569603 650539 597947 604304 443945 428229 452556 476320 658042 452480 527476 500090 511833 517579 ] |
||||||||||||||||||||||||||||||
|
2.94 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 233135 398409 420540 422349 425394 426553 428229 428576 431463 432249 434321 439981 443817 443945 445623 448483 450653 450948 452480 452556 454869 455560 455879 462525 466028 468858 471452 471969 472389 476320 476791 479106 480764 482975 486303 487824 488812 491014 492054 492652 493108 493381 500090 506028 508989 509422 511388 511833 516152 517579 518802 520935 521022 522092 522226 523066 523266 524449 525471 526070 527476 527836 529055 529358 537810 546460 546950 556921 557377 557378 557993 558494 561382 561991 562043 565213 565347 569188 569603 570845 570860 572022 574237 576230 580751 582784 583645 583861 585515 586649 587849 591004 592390 592514 593063 595789 596373 596730 596927 597947 599029 601399 603256 604304 605613 607552 610626 612171 616973 619123 623284 633853 640687 643109 650539 652007 658042 670274 677106 690822 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"чулки ноги"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел ног"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел ног"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.