Query Metrics
7
Database Queries
7
Different statements
175.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.50 ms (83.94%) |
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 78976 381908 387649 389424 392604 392729 397431 405683 409795 412520 416585 416706 416708 416718 416746 417461 418868 422108 423540 423721 423736 427128 427658 432928 435795 442664 442665 443747 443957 445224 446086 446237 446256 452854 453884 455179 455621 456819 460512 461330 462022 465446 465728 466266 470193 471140 474489 475847 476433 476541 477176 477502 480870 484217 495709 505566 517477 518484 521285 522537 525342 525950 531626 537508 537620 540846 542779 543366 545366 547793 550451 556614 557472 558914 559580 563355 567399 579271 581220 581580 587847 589873 595894 606438 607772 612771 614738 617704 625553 636732 638955 643005 652683 663749 665916 672311 675127 675263 681785 694119 708176 717410 738471 740833 745309 745345 749899 762646 765516 766882 789566 791257 794632 806140 807595 808440 809381 809720 817805 826507 ] |
||||||||||||||||||||||||||||||
|
18.84 ms (10.72%) |
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 826507 817805 791257 381908 432928 78976 392729 389424 387649 405683 442665 445224 409795 423540 443957 416585 416706 416746 427128 427658 435795 442664 412520 416718 423721 423736 540846 453884 474489 475847 446086 446256 456819 476433 477502 484217 452854 455179 471140 476541 517477 518484 495709 521285 537508 505566 525342 525950 522537 531626 537620 460512 461330 465446 470193 542779 550451 559580 547793 558914 563355 581220 543366 556614 557472 579271 681785 652683 675263 694119 717410 663749 665916 672311 675127 708176 545366 567399 581580 589873 607772 636732 587847 606438 612771 595894 617704 625553 638955 643005 794632 806140 807595 808440 738471 745309 745345 762646 765516 766882 740833 749899 614738 789566 809381 809720 416708 417461 443747 446237 462022 392604 422108 455621 465728 466266 477176 480870 397431 418868 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.64%) |
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 78976 381908 387649 389424 392604 392729 397431 405683 409795 412520 416585 416706 416708 416718 416746 417461 418868 422108 423540 423721 423736 427128 427658 432928 435795 442664 442665 443747 443957 445224 446086 446237 446256 452854 453884 455179 455621 456819 460512 461330 462022 465446 465728 466266 470193 471140 474489 475847 476433 476541 477176 477502 480870 484217 495709 505566 517477 518484 521285 522537 525342 525950 531626 537508 537620 540846 542779 543366 545366 547793 550451 556614 557472 558914 559580 563355 567399 579271 581220 581580 587847 589873 595894 606438 607772 612771 614738 617704 625553 636732 638955 643005 652683 663749 665916 672311 675127 675263 681785 694119 708176 717410 738471 740833 745309 745345 749899 762646 765516 766882 789566 791257 794632 806140 807595 808440 809381 809720 817805 826507 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam blonde"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер беловолосая"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.76%) |
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.