Query Metrics
7
Database Queries
7
Different statements
171.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.24 ms (85.39%) |
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 188379 194530 233147 388604 394552 395661 396428 397174 397217 397896 398568 403464 403651 407458 407550 407779 407867 408179 408239 409374 411415 413090 420334 430411 433234 440979 443668 443946 448356 448996 449038 453138 453702 454214 454222 455955 458714 460728 461051 462489 464386 464478 464549 466213 470196 474162 474784 475919 476263 477723 478935 479040 480929 487339 490262 490409 490894 493117 493210 493224 496540 505304 511160 512873 515914 521121 524778 525498 533425 536306 539157 547912 547920 547930 549844 557991 558021 562907 563125 563143 563196 565147 581614 595309 640892 665276 665492 669448 673791 678744 707476 710485 714199 714886 716787 724233 743803 745028 746636 747284 748210 756468 761103 765306 770127 771490 782230 785431 786167 788292 788767 789016 789526 792533 803461 807454 811491 816771 820726 827861 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (8.81%) |
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 466213 477723 470196 480929 411415 479040 511160 490262 490894 493224 515914 407550 820726 827861 536306 788292 789016 782230 761103 194530 420334 487339 493210 474784 490409 394552 397174 403651 443668 409374 433234 539157 547912 665276 669448 714886 747284 765306 771490 786167 807454 396428 233147 398568 397217 816771 505304 707476 714199 746636 789526 811491 770127 724233 743803 745028 448996 397896 454222 475919 521121 524778 188379 388604 407779 430411 408179 408239 448356 453702 458714 464549 478935 453138 455955 461051 476263 496540 525498 512873 533425 474162 493117 549844 558021 563125 562907 563196 547930 665492 673791 678744 716787 710485 547920 557991 563143 565147 581614 595309 640892 748210 785431 803461 756468 788767 792533 395661 407458 407867 460728 462489 464386 464478 403464 413090 440979 443946 449038 454214 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.59%) |
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 188379 194530 233147 388604 394552 395661 396428 397174 397217 397896 398568 403464 403651 407458 407550 407779 407867 408179 408239 409374 411415 413090 420334 430411 433234 440979 443668 443946 448356 448996 449038 453138 453702 454214 454222 455955 458714 460728 461051 462489 464386 464478 464549 466213 470196 474162 474784 475919 476263 477723 478935 479040 480929 487339 490262 490409 490894 493117 493210 493224 496540 505304 511160 512873 515914 521121 524778 525498 533425 536306 539157 547912 547920 547930 549844 557991 558021 562907 563125 563143 563196 565147 581614 595309 640892 665276 665492 669448 673791 678744 707476 710485 714199 714886 716787 724233 743803 745028 746636 747284 748210 756468 761103 765306 770127 771490 782230 785431 786167 788292 788767 789016 789526 792533 803461 807454 811491 816771 820726 827861 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy mature mom"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен mature mom"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен mature mom"
]
|
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.