Query Metrics
7
Database Queries
7
Different statements
186.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.95 ms (86.46%) |
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 6666 382426 396378 398425 400617 417975 424746 428621 428882 429685 443463 445837 448042 454272 465297 466963 469840 469915 472334 474553 474735 476023 476749 484550 490649 492061 494499 502290 504280 507366 509358 510467 523709 538415 538429 546977 548628 548706 548773 549982 551249 552124 552681 552684 558853 562237 562277 562310 564461 565314 566475 567411 569686 569842 569846 570021 570038 570043 570045 570271 570460 570483 570525 570531 570570 570603 570669 571582 571596 572503 573021 573560 573563 573568 573678 573712 573773 573967 573987 574539 574611 575106 575214 575452 575485 577407 578158 592493 594225 595403 600472 601090 605050 609140 619416 621091 653821 656339 658013 658278 659118 659670 660560 665256 671125 673455 675028 679131 716035 740252 743394 753300 768286 768307 772105 789049 791302 793607 803453 810691 ] |
||||||||||||||||||||||||||||||
|
15.35 ms (8.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 659118 659670 660560 675028 653821 656339 658013 658278 665256 671125 673455 679131 716035 549982 570570 619416 592493 601090 789049 793607 810691 791302 753300 772105 768286 768307 740252 743394 803453 382426 6666 396378 417975 428621 465297 445837 490649 502290 546977 562277 562310 565314 570043 570483 571582 573021 573773 575485 577407 578158 548628 548706 552681 562237 569842 569846 570045 570271 570460 570525 571596 573560 573678 573712 573967 573987 574539 575106 551249 564461 566475 570603 570669 573563 573568 575214 575452 548773 552124 552684 558853 567411 570021 570038 570531 572503 574611 595403 600472 605050 594225 398425 400617 429685 454272 472334 476023 476749 443463 448042 469840 428882 509358 494499 504280 507366 484550 492061 510467 538429 523709 538415 424746 569686 621091 466963 609140 474553 474735 469915 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.68%) |
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 6666 382426 396378 398425 400617 417975 424746 428621 428882 429685 443463 445837 448042 454272 465297 466963 469840 469915 472334 474553 474735 476023 476749 484550 490649 492061 494499 502290 504280 507366 509358 510467 523709 538415 538429 546977 548628 548706 548773 549982 551249 552124 552681 552684 558853 562237 562277 562310 564461 565314 566475 567411 569686 569842 569846 570021 570038 570043 570045 570271 570460 570483 570525 570531 570570 570603 570669 571582 571596 572503 573021 573560 573563 573568 573678 573712 573773 573967 573987 574539 574611 575106 575214 575452 575485 577407 578158 592493 594225 595403 600472 601090 605050 609140 619416 621091 653821 656339 658013 658278 659118 659670 660560 665256 671125 673455 675028 679131 716035 740252 743394 753300 768286 768307 772105 789049 791302 793607 803453 810691 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"худая взасос"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая поцел"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.81%) |
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.