Query Metrics
7
Database Queries
7
Different statements
169.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.09 ms (84.38%) |
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 225591 382115 397420 398057 409274 414104 414269 414430 415878 416571 423814 423819 439584 443340 445107 446778 447553 451863 454052 456312 460451 473719 478985 479867 480788 485966 493849 494216 509019 514254 514339 515060 520911 522295 525204 527866 531638 535319 546028 553215 555599 561961 562587 563419 568864 576128 577105 580176 580182 583796 584355 586563 586975 587244 588436 588449 589522 602467 602627 604412 607142 618329 636183 642048 643451 651008 658907 658952 661653 663968 668628 689036 690666 692718 695464 697878 699963 706410 706446 706705 712184 719461 722273 736581 740694 742409 744046 759114 761246 762222 762673 773605 777668 780357 780412 786932 787716 790109 791385 794669 795389 796509 799161 801374 801576 806010 806468 807244 808335 808971 809811 812542 813819 814459 817875 821634 823009 823884 823887 824102 ] |
||||||||||||||||||||||||||||||
|
16.51 ms (9.73%) |
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 643451 618329 780357 808335 806010 712184 485966 563419 668628 522295 493849 414104 415878 561961 588436 602467 478985 382115 479867 515060 661653 397420 409274 577105 692718 787716 740694 809811 447553 473719 509019 821634 651008 697878 736581 773605 801374 423819 814459 535319 580176 568864 695464 706446 719461 555599 636183 586975 602627 604412 607142 812542 794669 796509 799161 762222 762673 791385 807244 514339 824102 584355 589522 806468 786932 642048 706705 777668 451863 398057 823884 494216 562587 744046 576128 658952 416571 446778 658907 689036 553215 588449 443340 586563 454052 445107 525204 527866 813819 823009 699963 706410 587244 780412 761246 790109 414430 583796 690666 795389 801576 742409 759114 460451 663968 480788 439584 456312 823887 531638 722273 808971 225591 520911 414269 423814 817875 514254 580182 546028 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.60%) |
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 225591 382115 397420 398057 409274 414104 414269 414430 415878 416571 423814 423819 439584 443340 445107 446778 447553 451863 454052 456312 460451 473719 478985 479867 480788 485966 493849 494216 509019 514254 514339 515060 520911 522295 525204 527866 531638 535319 546028 553215 555599 561961 562587 563419 568864 576128 577105 580176 580182 583796 584355 586563 586975 587244 588436 588449 589522 602467 602627 604412 607142 618329 636183 642048 643451 651008 658907 658952 661653 663968 668628 689036 690666 692718 695464 697878 699963 706410 706446 706705 712184 719461 722273 736581 740694 742409 744046 759114 761246 762222 762673 773605 777668 780357 780412 786932 787716 790109 791385 794669 795389 796509 799161 801374 801576 806010 806468 807244 808335 808971 809811 812542 813819 814459 817875 821634 823009 823884 823887 824102 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo in bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд ван"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.