Query Metrics
7
Database Queries
7
Different statements
188.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.13 ms (86.05%) |
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 114360 384963 388115 390981 395881 399194 401979 403067 413254 415640 429079 429527 445911 449911 451025 453124 454680 457119 462559 468398 470712 472427 473711 474403 485867 486697 486708 486823 489862 498199 498808 506427 509621 510045 510405 512956 516569 525497 526272 527194 528349 531296 540176 540512 546392 546588 547881 560375 560643 562516 562959 563801 564583 565524 569881 586473 587609 599230 599405 600204 605928 618404 619556 621733 630825 634804 635141 649082 652519 653494 660435 679383 686069 688554 705428 709228 709612 710548 720126 720380 720384 726686 727970 732153 732406 733847 734835 734981 738056 740965 744997 745364 751646 760836 764003 770408 775816 775952 776174 785832 787287 789659 801274 802610 802947 809712 809891 809937 810214 810680 810682 812081 813816 814041 815429 815929 817238 820042 821149 821560 ] |
||||||||||||||||||||||||||||||
|
16.81 ms (8.92%) |
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 453124 473711 486697 457119 486823 525497 498199 506427 540176 512956 569881 546588 560643 562959 686069 688554 705428 710548 720380 649082 652519 653494 709612 720126 660435 679383 709228 720384 546392 586473 621733 618404 630825 599230 599405 600204 605928 619556 587609 634804 776174 785832 787287 789659 801274 810214 802610 809712 810680 812081 764003 802947 732153 733847 734835 745364 760836 726686 727970 734981 744997 732406 751646 738056 740965 770408 635141 775816 775952 809891 809937 810682 399194 413254 429527 462559 384963 390981 472427 429079 470712 485867 486708 489862 114360 395881 388115 401979 403067 415640 814041 821149 815929 821560 815429 817238 820042 813816 445911 454680 449911 451025 468398 498808 510045 526272 531296 509621 510405 516569 527194 528349 540512 474403 547881 560375 562516 563801 564583 565524 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.43%) |
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 114360 384963 388115 390981 395881 399194 401979 403067 413254 415640 429079 429527 445911 449911 451025 453124 454680 457119 462559 468398 470712 472427 473711 474403 485867 486697 486708 486823 489862 498199 498808 506427 509621 510045 510405 512956 516569 525497 526272 527194 528349 531296 540176 540512 546392 546588 547881 560375 560643 562516 562959 563801 564583 565524 569881 586473 587609 599230 599405 600204 605928 618404 619556 621733 630825 634804 635141 649082 652519 653494 660435 679383 686069 688554 705428 709228 709612 710548 720126 720380 720384 726686 727970 732153 732406 733847 734835 734981 738056 740965 744997 745364 751646 760836 764003 770408 775816 775952 776174 785832 787287 789659 801274 802610 802947 809712 809891 809937 810214 810680 810682 812081 813816 814041 815429 815929 817238 820042 821149 821560 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard lick"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard лиза"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard лиза"
]
|
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.