Query Metrics
7
Database Queries
7
Different statements
161.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.48 ms (84.48%) |
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 383356 386303 391567 393775 395381 395622 401517 403127 412852 416305 417828 417949 418654 418862 423426 424387 427361 439448 439854 441611 443877 452847 454732 456630 458138 458544 459360 459629 466599 468406 470129 473038 479190 485899 486568 490304 501148 508660 512257 513280 514796 514805 515202 517184 518547 519646 521763 523453 524273 525043 526267 530582 536377 538750 540891 540894 541713 545517 545531 547366 547974 550601 574522 574808 574824 579368 584234 586294 586491 589232 598490 598569 599454 603294 603900 606721 611001 614058 614718 618347 634962 652760 657467 657489 660059 660439 662080 663785 668083 668525 672275 674220 680633 685055 689949 692127 692130 699487 708473 716030 717832 717853 720096 720197 720836 729905 745457 751710 773878 790036 790754 793343 795836 796423 796699 801709 803105 805254 814212 826182 ] |
||||||||||||||||||||||||||||||
|
15.20 ms (9.41%) |
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 424387 512257 514796 383356 393775 547366 720836 545517 716030 439854 525043 540891 454732 689949 796699 803105 751710 773878 745457 717832 458138 589232 418654 458544 508660 545531 672275 692130 657489 660059 663785 518547 418862 674220 717853 795836 796423 391567 417828 459360 501148 526267 579368 586491 611001 790754 790036 466599 479190 395622 386303 486568 574808 550601 680633 598490 708473 523453 401517 443877 403127 720197 513280 530582 515202 473038 395381 427361 524273 634962 729905 417949 519646 514805 618347 668525 521763 826182 584234 657467 668083 692127 652760 598569 599454 603294 606721 805254 490304 485899 547974 660439 603900 614058 456630 517184 439448 459629 699487 720096 574522 793343 801709 574824 685055 614718 441611 541713 412852 423426 416305 814212 468406 452847 470129 538750 536377 540894 662080 586294 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.90%) |
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 383356 386303 391567 393775 395381 395622 401517 403127 412852 416305 417828 417949 418654 418862 423426 424387 427361 439448 439854 441611 443877 452847 454732 456630 458138 458544 459360 459629 466599 468406 470129 473038 479190 485899 486568 490304 501148 508660 512257 513280 514796 514805 515202 517184 518547 519646 521763 523453 524273 525043 526267 530582 536377 538750 540891 540894 541713 545517 545531 547366 547974 550601 574522 574808 574824 579368 584234 586294 586491 589232 598490 598569 599454 603294 603900 606721 611001 614058 614718 618347 634962 652760 657467 657489 660059 660439 662080 663785 668083 668525 672275 674220 680633 685055 689949 692127 692130 699487 708473 716030 717832 717853 720096 720197 720836 729905 745457 751710 773878 790036 790754 793343 795836 796423 796699 801709 803105 805254 814212 826182 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teen homemade"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young teen домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young teen домашн любительск"
]
|
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.