Query Metrics
7
Database Queries
7
Different statements
153.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.65 ms (84.01%) |
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 2651 398461 398815 404178 413789 417900 418533 423804 426889 429079 429777 433684 437092 440312 446062 449407 456639 458163 461493 462304 463852 466854 466881 469904 470689 473068 473985 475871 477420 477934 478415 481319 481686 485933 492668 494561 496420 501169 504181 504748 508799 509511 509863 511043 512122 515337 519984 520090 521374 522834 525814 526803 526878 528332 535007 535915 538400 538411 538972 541268 545876 546659 546660 547886 547910 548703 548771 552079 559034 559042 562308 562687 563056 564069 565406 568332 569842 570374 571636 572441 573563 573623 573675 573720 582040 582678 585175 587617 591201 597441 597667 597673 598381 600966 623947 649867 651702 672321 675807 691330 695908 717517 723539 726078 727535 729566 737632 741921 742288 742642 744251 744665 745585 759738 762743 790055 791186 794858 811960 812125 ] |
||||||||||||||||||||||||||||||
|
14.34 ms (9.36%) |
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 446062 440312 496420 509863 492668 528332 485933 723539 811960 726078 727535 745585 429079 481319 398461 413789 545876 812125 744251 437092 509511 462304 521374 562308 568332 546659 562687 582040 571636 585175 404178 469904 494561 522834 463852 511043 559034 548703 548771 570374 573675 547910 597673 456639 538411 429777 466881 512122 573720 582678 564069 651702 675807 597667 791186 794858 742288 737632 433684 398815 417900 477934 538400 504181 535915 695908 449407 759738 466854 2651 418533 538972 649867 691330 563056 572441 573623 600966 587617 597441 623947 741921 742642 473985 426889 458163 525814 526878 508799 520090 501169 526803 515337 569842 573563 672321 729566 473068 481686 423804 470689 504748 535007 559042 541268 546660 547886 552079 565406 717517 591201 598381 790055 762743 744665 477420 478415 461493 475871 519984 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.86%) |
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 2651 398461 398815 404178 413789 417900 418533 423804 426889 429079 429777 433684 437092 440312 446062 449407 456639 458163 461493 462304 463852 466854 466881 469904 470689 473068 473985 475871 477420 477934 478415 481319 481686 485933 492668 494561 496420 501169 504181 504748 508799 509511 509863 511043 512122 515337 519984 520090 521374 522834 525814 526803 526878 528332 535007 535915 538400 538411 538972 541268 545876 546659 546660 547886 547910 548703 548771 552079 559034 559042 562308 562687 563056 564069 565406 568332 569842 570374 571636 572441 573563 573623 573675 573720 582040 582678 585175 587617 591201 597441 597667 597673 598381 600966 623947 649867 651702 672321 675807 691330 695908 717517 723539 726078 727535 729566 737632 741921 742288 742642 744251 744665 745585 759738 762743 790055 791186 794858 811960 812125 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐüðÁð║Ðü ð╝ð©ÐüÐüð©ð¥ð¢ðÁÐÇÐüð║ð©ð╣ Ðü ÐÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс миссионерск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.99%) |
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.