Query Metrics
7
Database Queries
7
Different statements
188.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.24 ms (85.92%) |
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 191356 390624 396600 400946 403162 405961 417965 418453 418873 421336 424695 428933 432310 435942 439516 439649 442358 444692 445706 450461 453000 453614 453900 454120 454293 457779 457781 457987 467043 471000 471364 472674 472775 472793 473807 474003 475965 484833 486377 486434 486476 486792 488728 492760 494430 497543 497560 497565 501414 508584 509816 510451 511021 519701 520213 520703 523295 523306 523982 524610 526060 526277 527678 528698 529612 530054 530385 530863 534204 540484 542056 546773 548733 552120 552643 553912 555133 560434 561351 562005 562263 562269 570719 570840 572042 574776 574833 575509 576019 579695 582068 582332 582680 582712 583331 586520 586652 590505 590623 591324 596437 604094 604409 609915 621658 624949 634475 637746 643935 644982 656862 659215 679038 690479 718788 768581 775819 780968 806078 820995 ] |
||||||||||||||||||||||||||||||
|
16.66 ms (8.82%) |
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 471364 445706 454293 501414 486377 400946 403162 439516 428933 644982 474003 457779 486476 526277 530385 530054 540484 510451 519701 575509 582068 548733 562263 570719 570840 572042 582680 582712 583331 679038 546773 555133 582332 604094 609915 590623 591324 775819 453000 432310 424695 405961 475965 509816 511021 494430 497560 523306 523982 497565 486792 492760 488728 421336 417965 820995 453900 520213 529612 508584 528698 530863 718788 656862 690479 553912 562005 579695 637746 643935 624949 586652 634475 586520 780968 806078 768581 453614 390624 191356 471000 450461 527678 484833 524610 526060 520703 523295 435942 457781 497543 562269 576019 596437 472775 473807 486434 457987 472793 467043 439649 418453 396600 442358 444692 418873 454120 472674 534204 542056 560434 552643 561351 574833 552120 574776 659215 590505 621658 604409 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.62%) |
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 191356 390624 396600 400946 403162 405961 417965 418453 418873 421336 424695 428933 432310 435942 439516 439649 442358 444692 445706 450461 453000 453614 453900 454120 454293 457779 457781 457987 467043 471000 471364 472674 472775 472793 473807 474003 475965 484833 486377 486434 486476 486792 488728 492760 494430 497543 497560 497565 501414 508584 509816 510451 511021 519701 520213 520703 523295 523306 523982 524610 526060 526277 527678 528698 529612 530054 530385 530863 534204 540484 542056 546773 548733 552120 552643 553912 555133 560434 561351 562005 562263 562269 570719 570840 572042 574776 574833 575509 576019 579695 582068 582332 582680 582712 583331 586520 586652 590505 590623 591324 596437 604094 604409 609915 621658 624949 634475 637746 643935 644982 656862 659215 679038 690479 718788 768581 775819 780968 806078 820995 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"party сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"party tits"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"party сиськ"
]
|
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.