Query Metrics
7
Database Queries
7
Different statements
376.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
345.61 ms (91.82%) |
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 25021 34049 37495 310671 382050 389560 403891 412662 413075 414212 417662 420494 420675 424420 426155 426771 429369 432366 432929 433787 436829 438349 442478 443946 444533 444924 444963 445932 447896 448317 448445 451012 451598 452786 453046 453552 453869 454174 454636 457963 460133 464188 464619 465360 466262 466682 468341 470829 471812 474989 476476 476962 478394 480908 482083 485703 486869 487666 496564 500562 500776 502578 502592 502884 503419 509904 510272 511850 512012 512604 513738 514062 514640 515922 517700 518934 521739 524915 525595 525925 527229 543387 545046 545543 555979 556808 557926 560123 560834 560836 561582 562247 563414 564073 567429 568078 570928 570954 570998 573751 574715 578782 579194 580921 583723 584786 589041 594253 597119 598953 600586 616905 617117 619107 620714 621327 623684 626448 626978 673578 ] |
||||||||||||||||||||||||||||||
|
21.75 ms (5.78%) |
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 617117 453046 560836 476962 412662 502884 583723 621327 432929 470829 563414 444963 511850 420494 34049 453552 453869 451598 594253 438349 426155 502578 515922 420675 521739 570928 514640 414212 600586 448445 487666 556808 382050 417662 468341 545046 426771 502592 570954 454174 444924 560834 476476 310671 496564 460133 445932 568078 509904 573751 457963 466262 513738 503419 471812 543387 561582 598953 626448 524915 578782 500562 465360 514062 433787 555979 616905 403891 560123 452786 512012 517700 25021 389560 413075 500776 451012 480908 37495 525925 444533 564073 567429 579194 562247 597119 510272 486869 447896 464619 589041 442478 482083 626978 620714 432366 478394 525595 512604 527229 464188 557926 570998 619107 623684 673578 448317 518934 574715 485703 466682 474989 545543 580921 436829 443946 424420 584786 454636 429369 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (0.69%) |
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 25021 34049 37495 310671 382050 389560 403891 412662 413075 414212 417662 420494 420675 424420 426155 426771 429369 432366 432929 433787 436829 438349 442478 443946 444533 444924 444963 445932 447896 448317 448445 451012 451598 452786 453046 453552 453869 454174 454636 457963 460133 464188 464619 465360 466262 466682 468341 470829 471812 474989 476476 476962 478394 480908 482083 485703 486869 487666 496564 500562 500776 502578 502592 502884 503419 509904 510272 511850 512012 512604 513738 514062 514640 515922 517700 518934 521739 524915 525595 525925 527229 543387 545046 545543 555979 556808 557926 560123 560834 560836 561582 562247 563414 564073 567429 568078 570928 570954 570998 573751 574715 578782 579194 580921 583723 584786 589041 594253 597119 598953 600586 616905 617117 619107 620714 621327 623684 626448 626978 673578 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass bra"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп бюстгалтер нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.35%) |
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.