Query Metrics
7
Database Queries
7
Different statements
390.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.96 ms (54.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж массаж"
]
|
||||||||||||||||||||||||||||||
|
155.82 ms (39.86%) |
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 23670 118316 205205 322773 381740 382768 385105 389165 390219 390318 390907 395554 398872 401281 402596 411609 416144 426775 441742 444446 446860 448357 448684 449218 457451 464616 466940 469820 471916 483781 490165 496720 498605 507161 513172 551292 551354 551435 557266 561667 564627 580764 593174 600602 602725 605411 612926 621105 622178 622986 634756 636520 643406 644509 644512 648587 651882 651883 653253 654148 655418 656270 661148 661759 663014 663098 663515 665277 668532 668765 672528 672540 672547 672561 676513 676518 677039 681024 682888 689299 689325 689523 690147 695292 701487 721091 738220 748752 749003 751918 760933 761422 762556 773073 773174 774090 776724 784270 786356 789745 797221 797698 799635 800066 800114 801366 801666 807475 807777 807806 815259 815403 815824 815958 816023 816429 816517 816875 821542 824724 ] |
||||||||||||||||||||||||||||||
|
13.49 ms (3.45%) |
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 748752 784270 800114 807806 322773 390318 205205 464616 390219 395554 483781 816875 815824 815259 815403 816023 816429 821542 648587 656270 661759 668532 681024 701487 721091 651882 661148 663098 663515 665277 676513 655418 663014 676518 677039 682888 689523 561667 636520 605411 593174 622178 643406 797221 760933 762556 797698 738220 749003 751918 773073 644509 807475 807777 389165 471916 449218 466940 118316 444446 382768 23670 402596 507161 490165 551354 564627 690147 612926 621105 644512 390907 448357 426775 441742 580764 513172 385105 381740 398872 401281 416144 411609 824724 816517 815958 457451 448684 446860 498605 496720 469820 557266 551292 653253 654148 672540 689325 695292 651883 668765 672528 672547 672561 689299 551435 600602 634756 622986 602725 786356 801666 776724 789745 800066 761422 773174 774090 799635 801366 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (0.97%) |
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 23670 118316 205205 322773 381740 382768 385105 389165 390219 390318 390907 395554 398872 401281 402596 411609 416144 426775 441742 444446 446860 448357 448684 449218 457451 464616 466940 469820 471916 483781 490165 496720 498605 507161 513172 551292 551354 551435 557266 561667 564627 580764 593174 600602 602725 605411 612926 621105 622178 622986 634756 636520 643406 644509 644512 648587 651882 651883 653253 654148 655418 656270 661148 661759 663014 663098 663515 665277 668532 668765 672528 672540 672547 672561 676513 676518 677039 681024 682888 689299 689325 689523 690147 695292 701487 721091 738220 748752 749003 751918 760933 761422 762556 773073 773174 774090 776724 784270 786356 789745 797221 797698 799635 800066 800114 801366 801666 807475 807777 807806 815259 815403 815824 815958 816023 816429 816517 816875 821542 824724 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage in massage"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж массаж"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.