Query Metrics
7
Database Queries
7
Different statements
168.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.51 ms (86.41%) |
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 76268 185401 185873 382297 383005 383486 384986 385057 389110 389147 390908 405903 406288 406404 408043 408172 408489 409305 409630 409646 420032 427037 441804 447020 452212 459126 488558 496559 499815 507171 509675 531725 541092 560108 569824 577161 577496 577818 588852 602857 605384 606809 608071 610365 614726 618938 621418 622039 630823 636522 636836 641663 643443 643835 644486 644666 654331 662033 668905 669130 672518 677041 681411 684572 690148 701449 705720 711057 711576 714471 716753 722810 722896 727394 727454 728067 732379 738907 738925 740007 740235 740485 744460 744469 744470 744475 744580 744631 747363 747372 747383 749528 749551 757977 768115 770007 773084 781677 782420 784702 789908 792680 793591 794425 796180 797499 799956 800069 800296 803595 805398 805961 811675 813949 816818 818326 820009 824788 825749 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (7.80%) |
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 636522 610365 630823 605384 618938 796180 800296 805961 805398 768115 784702 792680 744460 744469 744631 770007 773084 608071 643835 644666 705720 781677 427037 409630 447020 499815 825749 789908 385057 405903 441804 541092 614726 382297 420032 409646 408489 488558 744580 496559 389110 509675 383005 820009 818326 577161 577496 681411 711576 716753 722810 654331 668905 690148 669130 672518 602857 636836 644486 606809 811675 727394 740007 738925 740235 749551 738907 738923 749528 740485 747363 747372 747383 722896 794425 390908 185873 76268 409305 383486 185401 406404 408043 408172 813949 816818 452212 560108 577818 569824 677041 684572 711057 662033 714471 622039 588852 621418 643443 782420 797499 803595 744475 732379 744470 757977 728067 727454 641663 793591 799956 800069 459126 389147 384986 507171 531725 824788 701449 406288 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.57%) |
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 76268 185401 185873 382297 383005 383486 384986 385057 389110 389147 390908 405903 406288 406404 408043 408172 408489 409305 409630 409646 420032 427037 441804 447020 452212 459126 488558 496559 499815 507171 509675 531725 541092 560108 569824 577161 577496 577818 588852 602857 605384 606809 608071 610365 614726 618938 621418 622039 630823 636522 636836 641663 643443 643835 644486 644666 654331 662033 668905 669130 672518 677041 681411 684572 690148 701449 705720 711057 711576 714471 716753 722810 722896 727394 727454 728067 732379 738907 738925 740007 740235 740485 744460 744469 744470 744475 744580 744631 747363 747372 747383 749528 749551 757977 768115 770007 773084 781677 782420 784702 789908 792680 793591 794425 796180 797499 799956 800069 800296 803595 805398 805961 811675 813949 816818 818326 820009 824788 825749 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oil and massage"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл массаж"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.94%) |
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.