Query Metrics
7
Database Queries
7
Different statements
190.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.80 ms (85.97%) |
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 86684 384769 388325 389364 397849 408439 411838 419351 426481 427946 428826 433584 439467 442336 442750 443847 444955 445771 446577 447604 450814 455510 456487 457026 457974 459191 461359 465006 465475 465609 468154 470067 471378 472244 475977 478471 482219 482379 483184 483236 486883 487753 491659 491719 492977 495818 502278 504132 506260 510253 510619 511422 513289 514935 515749 516230 517143 518238 519213 519914 524365 525186 525496 528061 528751 532898 533477 535707 536885 536916 542525 543356 548297 549729 561344 562005 562331 563722 563880 565687 565843 566032 567563 573074 573587 573689 574599 576687 576695 576712 576718 577386 579648 582920 583887 585156 586483 587459 591694 601170 605310 612839 614715 623962 623973 633140 645939 673537 679461 679653 721895 748236 750060 767025 771845 774178 799360 810685 817430 817448 ] |
||||||||||||||||||||||||||||||
|
16.68 ms (8.76%) |
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 456487 465006 472244 482219 502278 486883 549729 579648 573689 542525 566032 582920 774178 86684 457974 446577 447604 455510 457026 444955 478471 483184 528061 491659 510619 525496 483236 492977 515749 384769 389364 426481 411838 445771 475977 482379 533477 536885 535707 514935 532898 495818 506260 517143 465475 468154 567563 574599 576687 576695 576718 543356 563722 573074 573587 673537 721895 577386 585156 612839 623973 601170 614715 623962 587459 605310 748236 750060 442750 471378 428826 470067 491719 528751 524365 525186 516230 427946 397849 439467 817448 817430 459191 465609 513289 536916 504132 487753 548297 562331 563880 645939 679461 679653 562005 565687 565843 576712 591694 633140 586483 810685 771845 799360 408439 419351 433584 443847 442336 511422 519213 518238 510253 519914 388325 561344 583887 767025 461359 450814 ] |
||||||||||||||||||||||||||||||
|
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 86684 384769 388325 389364 397849 408439 411838 419351 426481 427946 428826 433584 439467 442336 442750 443847 444955 445771 446577 447604 450814 455510 456487 457026 457974 459191 461359 465006 465475 465609 468154 470067 471378 472244 475977 478471 482219 482379 483184 483236 486883 487753 491659 491719 492977 495818 502278 504132 506260 510253 510619 511422 513289 514935 515749 516230 517143 518238 519213 519914 524365 525186 525496 528061 528751 532898 533477 535707 536885 536916 542525 543356 548297 549729 561344 562005 562331 563722 563880 565687 565843 566032 567563 573074 573587 573689 574599 576687 576695 576712 576718 577386 579648 582920 583887 585156 586483 587459 591694 601170 605310 612839 614715 623962 623973 633140 645939 673537 679461 679653 721895 748236 750060 767025 771845 774178 799360 810685 817430 817448 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"porn big boobs"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"porn большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"porn большие boobs"
]
|
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.