Query Metrics
7
Database Queries
7
Different statements
183.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.69 ms (84.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 150405 357943 382906 383202 383660 389142 391036 401489 404474 404478 404644 406425 407552 409867 411012 415637 415882 418922 421105 427550 430698 430811 435688 435701 437437 444815 447882 459231 459241 459760 464474 465886 471410 475859 476301 481652 486924 493045 494771 496720 498605 499643 499656 504339 506147 506844 506944 510043 511930 518948 520599 520726 531416 538333 555384 557509 558383 559958 560108 560136 566321 569412 580742 584200 584726 584735 591115 593671 599572 608595 615883 623958 625452 625557 634842 643405 643731 659165 668549 686648 696192 702063 726398 726716 735684 737535 741290 743789 744467 744468 744469 758102 768115 776724 782408 782420 784270 789470 789745 792680 793495 793591 795376 796180 799598 800066 803966 804559 804688 810789 811662 814806 815756 815958 816038 816875 818725 820452 825204 828714 ] |
||||||||||||||||||||||||||||||
|
18.84 ms (10.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 476301 404474 471410 493045 557509 686648 696192 625557 415637 430698 511930 150405 486924 702063 799598 810789 795376 804688 811662 744468 744467 735684 726716 784270 818725 825204 659165 510043 520599 804559 518948 643731 538333 584726 816038 820452 643405 741290 357943 407552 444815 599572 406425 435701 593671 435688 499656 475859 615883 591115 625452 427550 401489 814806 481652 465886 504339 506147 555384 558383 569412 580742 634842 608595 758102 464474 437437 499643 404644 411012 459760 459231 383202 391036 409867 506944 796180 768115 792680 744469 782408 815756 828714 803966 531416 418922 816875 815958 498605 496720 776724 789745 800066 737535 421105 668549 520726 506844 789470 793495 584735 404478 559958 459241 726398 382906 743789 389142 560108 782420 793591 415882 383660 560136 584200 623958 566321 494771 430811 447882 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.58%) |
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 150405 357943 382906 383202 383660 389142 391036 401489 404474 404478 404644 406425 407552 409867 411012 415637 415882 418922 421105 427550 430698 430811 435688 435701 437437 444815 447882 459231 459241 459760 464474 465886 471410 475859 476301 481652 486924 493045 494771 496720 498605 499643 499656 504339 506147 506844 506944 510043 511930 518948 520599 520726 531416 538333 555384 557509 558383 559958 560108 560136 566321 569412 580742 584200 584726 584735 591115 593671 599572 608595 615883 623958 625452 625557 634842 643405 643731 659165 668549 686648 696192 702063 726398 726716 735684 737535 741290 743789 744467 744468 744469 758102 768115 776724 782408 782420 784270 789470 789745 792680 793495 793591 795376 796180 799598 800066 803966 804559 804688 810789 811662 814806 815756 815958 816038 816875 818725 820452 825204 828714 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother massage"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин массаж"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 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.