Query Metrics
7
Database Queries
7
Different statements
218.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.63 ms (89.13%) |
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 429026 434576 434885 435560 435601 441907 449675 451142 453481 455570 459005 464647 475770 478986 488277 492093 492774 493115 495525 497713 497719 497778 498311 502630 502660 503379 505328 505355 505902 507278 509762 511029 513908 514845 514986 516388 518014 520953 521521 523393 523640 524010 527478 528374 530952 532727 538565 541265 547522 551896 553843 554818 556004 556085 562195 562384 562449 569331 576170 577018 579145 580500 585261 585907 592970 593391 594053 595605 596778 598503 598512 604056 605393 608516 608605 609554 614059 629208 629500 631740 636426 641071 641128 650295 650511 652057 659004 659944 661421 662375 663190 680576 690682 691787 705999 706029 716103 734253 738446 738506 749520 753150 758335 767827 773063 776080 776085 786005 787438 788524 788691 788863 791857 792147 801764 806534 806640 807303 810640 811284 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (6.72%) |
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 528374 495525 497713 497719 505355 530952 538565 503379 516388 518014 527478 464647 475770 488277 547522 569331 577018 562384 541265 551896 554818 562195 562449 576170 579145 650295 652057 659004 662375 680576 691787 661421 706029 650511 659944 663190 690682 716103 553843 556085 580500 629208 592970 593391 594053 596778 598503 598512 608605 631740 585261 614059 636426 585907 595605 604056 605393 608516 609554 641071 641128 807303 810640 811284 776080 776085 787438 788524 801764 806534 734253 753150 758335 788691 791857 792147 749520 767827 773063 738446 738506 629500 705999 786005 788863 806640 434576 449675 429026 434885 441907 459005 435560 451142 453481 455570 478986 435601 502630 505902 511029 520953 521521 502660 507278 513908 514845 514986 492774 497778 498311 509762 523393 492093 493115 505328 523640 524010 532727 556004 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.22%) |
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 429026 434576 434885 435560 435601 441907 449675 451142 453481 455570 459005 464647 475770 478986 488277 492093 492774 493115 495525 497713 497719 497778 498311 502630 502660 503379 505328 505355 505902 507278 509762 511029 513908 514845 514986 516388 518014 520953 521521 523393 523640 524010 527478 528374 530952 532727 538565 541265 547522 551896 553843 554818 556004 556085 562195 562384 562449 569331 576170 577018 579145 580500 585261 585907 592970 593391 594053 595605 596778 598503 598512 604056 605393 608516 608605 609554 614059 629208 629500 631740 636426 641071 641128 650295 650511 652057 659004 659944 661421 662375 663190 680576 690682 691787 705999 706029 716103 734253 738446 738506 749520 753150 758335 767827 773063 776080 776085 786005 787438 788524 788691 788863 791857 792147 801764 806534 806640 807303 810640 811284 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло pussy мокрые"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло pussy мокрые"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo pussy wet"
]
|
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.