Query Metrics
7
Database Queries
7
Different statements
158.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.53 ms (84.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 152234 388233 422603 422638 422926 422960 446267 447426 455245 455975 456629 456630 458437 459329 459594 460327 465051 465527 467760 491195 496887 497425 500594 500600 501564 511268 511809 512500 514199 527756 537113 538223 539858 539947 545539 547089 550882 560198 568614 568617 568618 568625 568629 568631 568638 571812 579359 580053 583851 588577 590066 594400 596336 600502 600535 600577 600581 600610 600805 602575 603929 606709 616080 616637 619125 621353 626432 629667 631019 631214 633855 637515 639783 644595 647162 648937 665906 668451 668459 668467 670425 680618 684326 687490 698109 707566 708224 708263 709117 709961 714339 714578 721557 729751 734146 737121 738936 740344 742370 744711 746942 754865 756279 767436 772970 789067 794951 804677 807521 808818 809157 810176 813110 ] |
||||||||||||||||||||||||||||||
|
14.53 ms (9.17%) |
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 746942 422926 446267 422638 388233 644595 422960 497425 511268 537113 539947 467760 684326 714339 629667 616637 808818 740344 767436 545539 560198 539858 737121 422603 511809 512500 465051 665906 687490 807521 754865 742370 616080 459594 456629 465527 809157 708224 714578 600805 637515 633855 456630 152234 594400 459329 709117 579359 626432 729751 707566 568625 810176 603929 631214 772970 738936 668467 734146 639783 668459 501564 568618 680618 588577 756279 698109 600535 789067 447426 568614 568629 580053 583851 568631 670425 709961 668451 708263 590066 596336 606709 619125 744711 491195 538223 602575 631019 794951 600502 813110 514199 804677 547089 568617 568638 648937 721557 600610 571812 455975 647162 600581 500594 621353 550882 600577 458437 527756 500600 460327 496887 455245 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.71%) |
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 152234 388233 422603 422638 422926 422960 446267 447426 455245 455975 456629 456630 458437 459329 459594 460327 465051 465527 467760 491195 496887 497425 500594 500600 501564 511268 511809 512500 514199 527756 537113 538223 539858 539947 545539 547089 550882 560198 568614 568617 568618 568625 568629 568631 568638 571812 579359 580053 583851 588577 590066 594400 596336 600502 600535 600577 600581 600610 600805 602575 603929 606709 616080 616637 619125 621353 626432 629667 631019 631214 633855 637515 639783 644595 647162 648937 665906 668451 668459 668467 670425 680618 684326 687490 698109 707566 708224 708263 709117 709961 714339 714578 721557 729751 734146 737121 738936 740344 742370 744711 746942 754865 756279 767436 772970 789067 794951 804677 807521 808818 809157 810176 813110 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тайк азиатк большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"thai big cock"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"тайк азиатк большие cock"
]
|
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.