Query Metrics
7
Database Queries
7
Different statements
194.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.33 ms (88.19%) |
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 30783 143302 382226 383496 384193 386156 387544 389026 399520 410304 424929 425319 426361 426696 426810 426917 427497 428034 429009 429629 432274 435811 441050 444279 447325 447510 448526 449400 450434 450573 450657 454679 455042 458810 458869 461442 462026 462517 463945 463952 464614 464679 464791 467065 471716 471774 472466 472737 473886 479452 481449 481598 482621 491041 492414 499982 502424 503958 509162 511374 512762 514873 515339 518360 521608 521840 523082 523357 525148 525180 525807 527177 527565 527939 535747 536847 537962 541417 546055 546371 546777 548565 552009 552745 552990 553271 554582 555797 560034 561344 561880 562164 562393 566342 567006 569666 575554 581188 584549 585308 585330 588608 589756 595436 596578 597583 600889 602317 602593 604059 605936 606652 607021 608667 609639 618833 622371 626138 685004 722825 ] |
||||||||||||||||||||||||||||||
|
13.75 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 626138 585330 589756 600889 618833 426696 454679 458810 143302 383496 384193 426917 389026 410304 425319 448526 458869 461442 472466 479452 441050 447325 447510 462026 509162 525148 525807 502424 503958 511374 499982 491041 512762 382226 30783 387544 432274 482621 450434 450573 455042 492414 464614 464679 481598 523082 535747 514873 518360 521608 523357 537962 527177 527939 536847 515339 521840 525180 527565 471774 541417 546777 552009 552990 553271 554582 561344 575554 546371 548565 552745 561880 562164 562393 566342 569666 581188 546055 555797 567006 685004 560034 584549 585308 605936 608667 588608 595436 602317 602593 622371 597583 604059 606652 609639 596578 607021 722825 424929 427497 429009 462517 464791 481449 426810 463952 467065 471716 472737 386156 399520 428034 444279 450657 426361 449400 463945 473886 429629 435811 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.45%) |
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 30783 143302 382226 383496 384193 386156 387544 389026 399520 410304 424929 425319 426361 426696 426810 426917 427497 428034 429009 429629 432274 435811 441050 444279 447325 447510 448526 449400 450434 450573 450657 454679 455042 458810 458869 461442 462026 462517 463945 463952 464614 464679 464791 467065 471716 471774 472466 472737 473886 479452 481449 481598 482621 491041 492414 499982 502424 503958 509162 511374 512762 514873 515339 518360 521608 521840 523082 523357 525148 525180 525807 527177 527565 527939 535747 536847 537962 541417 546055 546371 546777 548565 552009 552745 552990 553271 554582 555797 560034 561344 561880 562164 562393 566342 567006 569666 575554 581188 584549 585308 585330 588608 589756 595436 596578 597583 600889 602317 602593 604059 605936 606652 607021 608667 609639 618833 622371 626138 685004 722825 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"гольфах"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"гольф"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.69%) |
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.