Query Metrics
7
Database Queries
7
Different statements
288.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
259.04 ms (89.76%) |
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 118920 387394 396740 412814 414042 416568 416611 416613 416682 416689 416691 416708 416737 427539 432283 439056 440041 441078 441149 443097 443198 444281 446797 449070 450572 450697 452885 454304 456238 456240 456244 457483 459203 462377 465144 466475 466633 466636 466991 468680 469224 470428 470479 471693 473213 477149 480206 487428 488713 488820 493691 493715 497667 497691 497693 497697 500327 500336 502287 505137 505143 505800 507956 508882 508916 510797 511862 511864 514849 519722 525603 527926 529638 530953 534772 539030 541278 542704 542709 548157 550800 550922 575589 576444 583665 591604 595145 597160 597534 598141 616850 623187 630564 653954 655011 656826 656944 657182 662046 675375 680801 680816 716086 722378 725608 725628 735152 745114 745139 745142 751428 752584 752605 752657 752677 780650 785591 788529 792729 816094 ] |
||||||||||||||||||||||||||||||
|
20.44 ms (7.08%) |
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 427539 439056 466991 473213 500327 505143 519722 497693 505137 550922 630564 595145 752605 449070 471693 514849 505800 507956 541278 454304 508882 510797 387394 511862 752677 725608 118920 444281 446797 462377 440041 456240 456244 497667 680816 591604 653954 459203 488713 414042 542704 716086 722378 655011 656826 752584 788529 792729 745114 752657 725628 745139 735152 416737 616850 443198 443097 457483 525603 527926 548157 583665 576444 597160 597534 780650 751428 466475 477149 450572 450697 488820 432283 575589 542709 468680 493715 469224 529638 539030 680801 550800 745142 657182 396740 412814 416611 416689 416613 530953 534772 598141 785591 441078 416691 441149 416682 816094 470479 493691 470428 508916 502287 511864 497691 497697 500336 466633 466636 480206 662046 675375 623187 416708 416568 465144 452885 456238 487428 656944 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (0.93%) |
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 118920 387394 396740 412814 414042 416568 416611 416613 416682 416689 416691 416708 416737 427539 432283 439056 440041 441078 441149 443097 443198 444281 446797 449070 450572 450697 452885 454304 456238 456240 456244 457483 459203 462377 465144 466475 466633 466636 466991 468680 469224 470428 470479 471693 473213 477149 480206 487428 488713 488820 493691 493715 497667 497691 497693 497697 500327 500336 502287 505137 505143 505800 507956 508882 508916 510797 511862 511864 514849 519722 525603 527926 529638 530953 534772 539030 541278 542704 542709 548157 550800 550922 575589 576444 583665 591604 595145 597160 597534 598141 616850 623187 630564 653954 655011 656826 656944 657182 662046 675375 680801 680816 716086 722378 725608 725628 735152 745114 745139 745142 751428 752584 752605 752657 752677 780650 785591 788529 792729 816094 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.59%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг teen любительск"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фистинг teen любительск"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting teen amateur"
]
|
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.