Query Metrics
7
Database Queries
7
Different statements
152.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.32 ms (82.61%) |
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 385809 442555 465549 475121 481760 487144 488639 489866 489979 492364 494622 500799 501289 501710 505392 505460 508882 513126 516411 517788 518736 520729 521810 522095 522398 522605 522785 523402 524047 525082 525883 525921 526130 527078 528719 530741 530745 531417 531511 532943 533073 533207 533623 534842 536898 538281 538729 539498 542519 542524 543518 543884 545782 546332 548254 553489 554144 554163 558194 560048 560190 561573 562391 564563 564643 566641 568399 569124 569154 569417 569548 573926 578300 578398 579359 580368 580574 581148 582932 583936 585558 585965 586007 587681 592354 592728 595799 597813 600503 600736 601053 601669 602519 603252 605372 605831 606267 606798 607113 608395 608820 609165 610235 612087 613936 615878 619995 622953 634070 653492 663381 665205 668394 669307 670745 671667 673097 674132 688575 691196 ] |
||||||||||||||||||||||||||||||
|
16.26 ms (10.63%) |
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 465549 489979 492364 526130 539498 500799 508882 538281 505460 518736 533207 536898 494622 521810 524047 525082 533073 558194 562391 568399 569548 578398 583936 542519 560048 569154 579359 580368 580574 581148 548254 573926 668394 691196 670745 564643 602519 612087 587681 619995 600503 605372 585558 606267 606798 613936 615878 603252 442555 481760 516411 538729 501289 531417 546332 554144 554163 566641 553489 569124 582932 665205 673097 663381 674132 669307 605831 610235 585965 489866 522785 533623 530741 528719 522398 530745 475121 688575 653492 545782 569417 592354 600736 622953 634070 597813 586007 385809 488639 525883 487144 595799 520729 534842 513126 522605 527078 505392 517788 523402 543884 543518 561573 542524 564563 671667 560190 578300 601053 607113 608820 592728 609165 601669 608395 531511 525921 532943 501710 522095 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.28%) |
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 385809 442555 465549 475121 481760 487144 488639 489866 489979 492364 494622 500799 501289 501710 505392 505460 508882 513126 516411 517788 518736 520729 521810 522095 522398 522605 522785 523402 524047 525082 525883 525921 526130 527078 528719 530741 530745 531417 531511 532943 533073 533207 533623 534842 536898 538281 538729 539498 542519 542524 543518 543884 545782 546332 548254 553489 554144 554163 558194 560048 560190 561573 562391 564563 564643 566641 568399 569124 569154 569417 569548 573926 578300 578398 579359 580368 580574 581148 582932 583936 585558 585965 586007 587681 592354 592728 595799 597813 600503 600736 601053 601669 602519 603252 605372 605831 606267 606798 607113 608395 608820 609165 610235 612087 613936 615878 619995 622953 634070 653492 663381 665205 668394 669307 670745 671667 673097 674132 688575 691196 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tattoo piercing"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"татуированные пирсинг"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.90%) |
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.