Query Metrics
7
Database Queries
7
Different statements
191.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.83 ms (87.30%) |
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 89346 340613 384063 409189 412857 413123 418894 419292 442709 453160 454741 456019 457993 465068 465725 466863 468509 470747 471026 471027 471032 471981 484221 486096 490592 490622 495550 499345 499715 502544 503372 504016 510900 510916 510921 510944 510947 517485 517881 527624 537463 576484 576618 577008 584383 591161 591904 592966 598321 613002 614222 621382 625209 628563 629773 630436 634640 641571 650610 666078 666680 698916 700804 707542 709746 710182 712140 726459 728989 729058 729069 730841 736044 738292 740912 749478 749493 749593 750656 753182 759701 760170 773621 774663 778481 781771 789477 789704 793521 793565 794460 794676 796397 800737 801398 802219 803136 803363 804028 804251 804257 804738 805743 806719 807415 807827 807850 809907 810136 810504 811443 819409 824154 824587 824859 824886 824893 825064 825341 826892 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (6.60%) |
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 630436 634640 641571 778481 793565 810504 811443 803136 804257 804738 806719 781771 796397 802219 807850 728989 730841 729069 749493 736044 749593 707542 709746 710182 793521 794460 807827 468509 384063 819409 749478 750656 409189 510944 591161 629773 517485 465725 442709 471026 457993 340613 499345 807415 805743 825064 824886 824154 753182 517881 413123 484221 510947 801398 789477 490592 825341 490622 486096 502544 510900 510921 503372 537463 471027 576484 584383 650610 666680 698916 666078 712140 576618 614222 625209 613002 621382 628563 591904 789704 794676 774663 729058 738292 803363 804251 759701 726459 760170 740912 773621 700804 800737 804028 809907 810136 412857 89346 466863 598321 419292 454741 471981 471032 465068 499715 504016 470747 418894 453160 456019 510916 495550 527624 826892 824587 824859 824893 577008 592966 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.50%) |
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 89346 340613 384063 409189 412857 413123 418894 419292 442709 453160 454741 456019 457993 465068 465725 466863 468509 470747 471026 471027 471032 471981 484221 486096 490592 490622 495550 499345 499715 502544 503372 504016 510900 510916 510921 510944 510947 517485 517881 527624 537463 576484 576618 577008 584383 591161 591904 592966 598321 613002 614222 621382 625209 628563 629773 630436 634640 641571 650610 666078 666680 698916 700804 707542 709746 710182 712140 726459 728989 729058 729069 730841 736044 738292 740912 749478 749493 749593 750656 753182 759701 760170 773621 774663 778481 781771 789477 789704 793521 793565 794460 794676 796397 800737 801398 802219 803136 803363 804028 804251 804257 804738 805743 806719 807415 807827 807850 809907 810136 810504 811443 819409 824154 824587 824859 824886 824893 825064 825341 826892 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер волосатая"
]
|
||||||||||||||||||||||||||||||
|
2.26 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер волосатая"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam hairy"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.01%) |
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.