Query Metrics
7
Database Queries
7
Different statements
183.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.36 ms (85.16%) |
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 397437 416020 419454 420120 427543 433507 440441 441124 441829 444533 446030 459204 463866 470683 473437 473446 478641 494447 497869 500734 504450 508196 510413 515441 517816 519766 523123 527871 530425 531370 531866 531878 534529 534540 534544 535638 536956 542624 543846 543983 545220 545342 545438 545516 546152 547420 547464 547854 548162 550925 552593 555220 555242 558897 559781 560867 571266 571759 586021 593274 602283 604138 605483 605725 628112 642075 655153 656548 656895 658819 664226 665976 669016 669370 670364 671002 673983 686119 686188 690875 692714 692732 695621 696108 697354 699390 705391 713189 713504 714622 716294 720582 723461 730335 739151 742430 748391 752659 765835 781320 782657 784225 788187 788494 796880 801175 801288 801928 805266 808819 810305 810899 814471 815459 815484 816596 816637 821795 825255 826135 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (9.25%) |
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 419454 527871 497869 510413 416020 433507 440441 571266 558897 560867 605483 810899 788494 571759 814471 815459 816637 821795 825255 815484 816596 826135 473437 530425 531878 531370 508196 535638 545220 542624 555242 686119 695621 696108 699390 716294 665976 705391 546152 586021 801175 801928 808819 784225 805266 801288 810305 739151 765835 748391 752659 742430 730335 628112 713189 713504 714622 781320 796880 444533 500734 605725 420120 427543 504450 446030 517816 397437 441124 441829 463866 459204 470683 478641 473446 515441 519766 531866 534529 536956 494447 523123 534540 534544 545342 547420 547464 548162 543846 545516 543983 545438 547854 550925 670364 671002 686188 690875 692714 697354 720582 723461 655153 656548 656895 658819 664226 669016 669370 692732 673983 552593 555220 559781 593274 602283 604138 642075 782657 788187 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.66%) |
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 397437 416020 419454 420120 427543 433507 440441 441124 441829 444533 446030 459204 463866 470683 473437 473446 478641 494447 497869 500734 504450 508196 510413 515441 517816 519766 523123 527871 530425 531370 531866 531878 534529 534540 534544 535638 536956 542624 543846 543983 545220 545342 545438 545516 546152 547420 547464 547854 548162 550925 552593 555220 555242 558897 559781 560867 571266 571759 586021 593274 602283 604138 605483 605725 628112 642075 655153 656548 656895 658819 664226 665976 669016 669370 670364 671002 673983 686119 686188 690875 692714 692732 695621 696108 697354 699390 705391 713189 713504 714622 716294 720582 723461 730335 739151 742430 748391 752659 765835 781320 782657 784225 788187 788494 796880 801175 801288 801928 805266 808819 810305 810899 814471 815459 815484 816596 816637 821795 825255 826135 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал дырк milf"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal hole milf"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал дырк milf"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.