Query Metrics
7
Database Queries
7
Different statements
230.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
203.05 ms (88.18%) |
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 7196 102702 144252 357457 383011 383285 384238 384310 384524 385953 386024 387946 390024 393408 395659 397662 399876 401737 413047 414004 414047 416200 417045 418337 418389 418538 419751 420462 421260 423633 425004 425137 426413 429592 433966 440680 442702 443203 443241 443510 445626 447387 448108 451875 457584 461760 462218 462222 464162 467110 471926 472295 472881 473500 474641 484547 484785 484797 485159 485175 494720 499812 508429 516451 517915 520734 525039 525822 530063 530159 532484 534685 536927 540381 545475 550091 569160 579364 580582 583724 584576 597766 597853 598872 604455 604526 614053 639967 651594 670430 676608 698286 716140 719938 719950 720015 720667 729890 729937 737669 737686 737733 743299 746892 754170 755222 757349 784702 787738 792591 801058 810252 810455 815658 820903 821739 822180 822550 823396 823419 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (6.98%) |
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 426413 525822 651594 579364 445626 583724 433966 719950 720015 414047 598872 413047 384310 822180 393408 429592 474641 472295 517915 485159 494720 698286 443510 484547 471926 144252 448108 792591 395659 597766 462218 784702 525039 417045 383285 737733 550091 508429 670430 390024 754170 822550 743299 757349 746892 737669 7196 420462 397662 676608 102702 419751 485175 416200 423633 534685 425004 421260 584576 443203 447387 384238 580582 472881 719938 820903 569160 484785 720667 386024 801058 755222 815658 464162 520734 425137 440680 414004 716140 729937 540381 383011 499812 810455 737686 418389 823419 387946 530063 461760 729890 530159 545475 473500 451875 532484 597853 357457 443241 536927 810252 604455 385953 614053 384524 484797 399876 467110 516451 787738 604526 401737 462222 418538 823396 457584 639967 821739 418337 442702 ] |
||||||||||||||||||||||||||||||
|
3.87 ms (1.68%) |
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 7196 102702 144252 357457 383011 383285 384238 384310 384524 385953 386024 387946 390024 393408 395659 397662 399876 401737 413047 414004 414047 416200 417045 418337 418389 418538 419751 420462 421260 423633 425004 425137 426413 429592 433966 440680 442702 443203 443241 443510 445626 447387 448108 451875 457584 461760 462218 462222 464162 467110 471926 472295 472881 473500 474641 484547 484785 484797 485159 485175 494720 499812 508429 516451 517915 520734 525039 525822 530063 530159 532484 534685 536927 540381 545475 550091 569160 579364 580582 583724 584576 597766 597853 598872 604455 604526 614053 639967 651594 670430 676608 698286 716140 719938 719950 720015 720667 729890 729937 737669 737686 737733 743299 746892 754170 755222 757349 784702 787738 792591 801058 810252 810455 815658 820903 821739 822180 822550 823396 823419 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ebony girl sex"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожая девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.74%) |
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.