Query Metrics
7
Database Queries
7
Different statements
167.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.49 ms (85.84%) |
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 385190 385754 421392 486461 490312 498947 507401 512695 515328 515844 535207 538191 540895 543697 544723 550965 554147 557587 560339 563249 571110 574293 577623 578807 579739 579871 583211 584346 585944 588819 591193 591211 591838 592099 593721 598913 601376 604148 610999 611093 618099 629443 629547 632092 633981 634912 635355 635522 636495 638157 638198 640254 643786 643854 649713 651441 656148 656167 656283 657162 657426 658669 669305 691229 691376 697661 700016 704425 705335 707079 708178 709357 712484 714294 717848 722694 722794 726186 728360 729312 730289 736083 736500 738587 739740 744161 748636 752295 753632 760266 761951 762580 763087 763428 765942 767332 769508 771367 771937 773509 773733 776364 777974 778758 780249 780585 783706 786084 786318 789553 790250 791469 797587 797716 799829 803742 806294 813182 813315 ] |
||||||||||||||||||||||||||||||
|
14.03 ms (8.39%) |
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 691376 707079 571110 583211 633981 640254 643786 618099 632092 635522 588819 591211 592099 629547 643854 776364 799829 803742 780585 783706 736083 744161 762580 773509 773733 786318 790250 797587 738587 760266 761951 765942 771937 736500 767332 769508 730289 748636 611093 634912 638157 709357 722794 777974 789553 797716 813315 486461 656148 598913 598769 780249 739740 515844 535207 543697 563249 577623 697661 708178 714294 651441 656283 657426 658669 669305 591838 604148 636495 806294 778758 763428 752295 638198 786084 813182 704425 700016 717848 538191 385754 385190 421392 490312 515328 498947 507401 512695 554147 579871 544723 579739 584346 540895 550965 557587 560339 574293 649713 657162 691229 705335 656167 712484 722694 578807 635355 601376 610999 591193 585944 593721 629443 729312 791469 753632 726186 728360 771367 763087 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.67%) |
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 385190 385754 421392 486461 490312 498947 507401 512695 515328 515844 535207 538191 540895 543697 544723 550965 554147 557587 560339 563249 571110 574293 577623 578807 579739 579871 583211 584346 585944 588819 591193 591211 591838 592099 593721 598913 601376 604148 610999 611093 618099 629443 629547 632092 633981 634912 635355 635522 636495 638157 638198 640254 643786 643854 649713 651441 656148 656167 656283 657162 657426 658669 669305 691229 691376 697661 700016 704425 705335 707079 708178 709357 712484 714294 717848 722694 722794 726186 728360 729312 730289 736083 736500 738587 739740 744161 748636 752295 753632 760266 761951 762580 763087 763428 765942 767332 769508 771367 771937 773509 773733 776364 777974 778758 780249 780585 783706 786084 786318 789553 790250 791469 797587 797716 799829 803742 806294 813182 813315 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"быстрая девушка"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"быстр девушк"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.86%) |
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.