Query Metrics
7
Database Queries
7
Different statements
144.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.40 ms (82.72%) |
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 396280 400341 418389 432715 437996 457642 458231 458248 462994 487768 491015 503075 507890 507906 509949 509967 510895 523473 529134 549495 554718 555971 561158 567185 573391 574937 581237 590095 592432 595463 601940 611448 612520 613942 614821 615265 617684 618603 618738 621356 621721 623299 625088 626375 636977 646135 650059 650062 651809 652926 667014 672820 675418 678272 685384 689492 689514 690726 692818 697853 699166 709320 713362 716929 716942 716951 716980 718050 719813 721575 722084 725540 728192 729711 745256 745872 757519 761609 762304 762647 764121 764736 765219 766484 768244 768340 771071 773356 775312 778054 778469 778639 778758 779162 779421 779890 785946 787417 787821 788340 788550 789755 791838 792328 796426 796576 800643 803308 804506 806217 808042 809964 810326 811399 813518 814499 818077 820181 821827 827883 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (9.82%) |
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 621721 722084 775312 778639 779421 787821 788340 418389 487768 685384 646135 725540 592432 814499 818077 510895 716929 803308 811399 789755 792328 804506 806217 808042 813518 796426 810326 757519 765219 771071 762304 762647 764736 745872 768244 773356 800643 809964 457642 779162 745256 728192 396280 561158 768340 761609 601940 621356 625088 507906 827883 554718 574937 650059 650062 651809 652926 667014 672820 678272 689492 697853 699166 690726 709320 692818 595463 614821 615265 623299 613942 618603 636977 590095 612520 626375 617684 611448 432715 462994 507890 523473 529134 555971 567185 573391 716980 458231 437996 503075 458248 675418 721575 764121 791838 400341 821827 820181 491015 509949 509967 549495 581237 716951 719813 689514 713362 716942 718050 618738 778054 778469 779890 778758 785946 796576 729711 766484 787417 788550 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.86%) |
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 396280 400341 418389 432715 437996 457642 458231 458248 462994 487768 491015 503075 507890 507906 509949 509967 510895 523473 529134 549495 554718 555971 561158 567185 573391 574937 581237 590095 592432 595463 601940 611448 612520 613942 614821 615265 617684 618603 618738 621356 621721 623299 625088 626375 636977 646135 650059 650062 651809 652926 667014 672820 675418 678272 685384 689492 689514 690726 692818 697853 699166 709320 713362 716929 716942 716951 716980 718050 719813 721575 722084 725540 728192 729711 745256 745872 757519 761609 762304 762647 764121 764736 765219 766484 768244 768340 771071 773356 775312 778054 778469 778639 778758 779162 779421 779890 785946 787417 787821 788340 788550 789755 791838 792328 796426 796576 800643 803308 804506 806217 808042 809964 810326 811399 813518 814499 818077 820181 821827 827883 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister homemade"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step sister домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step sister домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.26%) |
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.