Query Metrics
7
Database Queries
7
Different statements
166.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.53 ms (83.84%) |
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 87974 154257 226082 278236 382282 382314 382359 382670 396784 421582 467584 469125 470405 471656 471674 471682 473213 477076 487425 494530 494534 494535 497693 500263 505094 505137 506268 519379 526943 529311 529325 529634 530423 530698 531834 531869 531888 532803 534546 534563 536182 536206 539470 540531 542142 545395 545459 545550 556892 559783 568258 574379 574391 576479 576503 580069 580130 580973 583712 586995 588514 594143 599477 600144 609920 624197 627233 628097 632823 635833 639024 642058 642073 648710 655242 656924 660364 660367 660380 662129 662813 664166 666490 668292 669357 670356 671008 672944 673257 692421 715244 718772 722388 728567 735555 735703 739119 740409 742359 744033 745088 745100 749090 751609 752634 752645 752648 752670 754902 770269 770814 787510 788863 790154 796650 796703 797001 797003 805701 810501 ] |
||||||||||||||||||||||||||||||
|
16.32 ms (9.81%) |
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 471656 471682 477076 467584 473213 505094 530423 532803 500263 519379 529311 529325 531834 531888 534546 539470 494534 494535 526943 529634 530698 534563 536206 540531 497693 505137 531869 536182 471674 487425 576503 583712 545459 545550 576479 542142 545395 556892 559783 568258 574379 574391 580973 648710 660367 660380 662129 669357 672944 718772 660364 666490 668292 670356 671008 655242 656924 662813 664166 673257 692421 715244 580069 580130 639024 642073 624197 627233 628097 632823 642058 588514 599477 609920 635833 586995 594143 600144 796650 796703 810501 787510 790154 797003 744033 749090 770814 805701 728567 739119 740409 745088 745100 735555 735703 751609 770269 742359 752634 752645 752648 752670 754902 722388 788863 797001 87974 469125 278236 382282 382359 421582 154257 396784 226082 382314 382670 470405 494530 506268 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.90%) |
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 87974 154257 226082 278236 382282 382314 382359 382670 396784 421582 467584 469125 470405 471656 471674 471682 473213 477076 487425 494530 494534 494535 497693 500263 505094 505137 506268 519379 526943 529311 529325 529634 530423 530698 531834 531869 531888 532803 534546 534563 536182 536206 539470 540531 542142 545395 545459 545550 556892 559783 568258 574379 574391 576479 576503 580069 580130 580973 583712 586995 588514 594143 599477 600144 609920 624197 627233 628097 632823 635833 639024 642058 642073 648710 655242 656924 660364 660367 660380 662129 662813 664166 666490 668292 669357 670356 671008 672944 673257 692421 715244 718772 722388 728567 735555 735703 739119 740409 742359 744033 745088 745100 749090 751609 752634 752645 752648 752670 754902 770269 770814 787510 788863 790154 796650 796703 797001 797003 805701 810501 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hardcore riding"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор riding"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор riding"
]
|
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.