Query Metrics
7
Database Queries
7
Different statements
176.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.33 ms (85.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 382669 393558 412632 423498 426911 427172 433594 448078 448412 460407 466297 466327 479162 487982 491290 495063 499066 500634 507780 514662 517620 522392 525576 527769 527786 528199 529870 531264 531574 532536 533498 533539 542042 542520 544783 547730 547848 547852 549119 553000 558958 573246 576131 576360 578002 588798 591503 603707 611119 647003 695849 695882 703687 713970 714409 723019 727423 728735 729058 733230 738009 739871 740484 741874 742875 746993 751431 752502 758459 759243 760696 761484 762710 764485 769119 772216 773045 773320 775711 777355 778788 779747 779884 782755 782776 784394 784724 784735 788093 791305 792126 793104 793722 793724 794945 795354 796064 796199 796728 796769 796968 798704 799448 799477 802931 803194 805334 806864 807203 807868 811806 813805 814269 814312 817126 817145 817727 817750 818522 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (9.04%) |
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 814312 817145 818522 460407 487982 466327 499066 527769 533498 578002 573246 714409 695849 591503 791305 792126 793104 793722 803194 805334 811806 782776 796064 796728 798704 802931 761484 764485 782755 806864 764783 727423 746993 728735 738009 713970 784724 799477 807868 423498 448078 529870 531574 544783 647003 576131 588798 426911 507780 382669 794945 576360 553000 817750 813805 817126 817727 814269 517620 525576 527786 531264 533539 532536 514662 547848 695882 703687 723019 547852 549119 603707 775711 784394 793724 779884 784735 796199 796968 799448 729058 733230 760696 772216 788093 796769 740484 741874 758459 769119 773045 773320 742875 752502 762710 739871 751431 611119 777355 778788 779747 795354 807203 393558 433594 466297 427172 479162 528199 448412 500634 759243 412632 491290 495063 522392 542520 547730 558958 542042 ] |
||||||||||||||||||||||||||||||
|
2.93 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 382669 393558 412632 423498 426911 427172 433594 448078 448412 460407 466297 466327 479162 487982 491290 495063 499066 500634 507780 514662 517620 522392 525576 527769 527786 528199 529870 531264 531574 532536 533498 533539 542042 542520 544783 547730 547848 547852 549119 553000 558958 573246 576131 576360 578002 588798 591503 603707 611119 647003 695849 695882 703687 713970 714409 723019 727423 728735 729058 733230 738009 739871 740484 741874 742875 746993 751431 752502 758459 759243 760696 761484 762710 764485 769119 772216 773045 773320 775711 777355 778788 779747 779884 782755 782776 784394 784724 784735 788093 791305 792126 793104 793722 793724 794945 795354 796064 796199 796728 796769 796968 798704 799448 799477 802931 803194 805334 806864 807203 807868 811806 813805 814269 814312 817126 817145 817727 817750 818522 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade bondage"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.81%) |
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.