Query Metrics
7
Database Queries
7
Different statements
159.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.20 ms (83.96%) |
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 70082 404175 404459 405178 418759 428603 432574 432799 443232 447143 452114 452206 454802 455984 458125 462829 464133 464644 468826 470848 475273 476138 476901 486674 489167 492134 493801 494349 499890 501255 503241 503683 506024 506034 507824 513894 513910 514676 518176 520766 520841 525777 527091 529166 530497 534650 534961 535672 536569 536699 536869 537673 538653 542224 542859 543393 543875 547865 549858 550834 557102 557526 557546 561309 561451 565418 566059 575863 579138 579425 579761 586244 596200 597753 599637 603038 606599 610284 613452 614020 619392 623180 623962 623973 630575 630870 631199 633113 636275 637085 640686 643046 651668 666538 676090 678201 711554 711565 711568 711569 715615 715630 720291 720340 720394 723986 727692 730216 732331 738030 738047 738050 753077 753211 760068 761432 790853 814798 814816 823303 ] |
||||||||||||||||||||||||||||||
|
16.69 ms (10.44%) |
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 579761 542859 547865 579138 543393 549858 557546 561451 711568 715615 720340 678201 711554 711569 651668 711565 715630 720394 550834 561309 640686 586244 596200 599637 603038 623180 633113 643046 636275 753077 760068 730216 723986 753211 727692 732331 738050 761432 738030 613452 790853 447143 464644 475273 464133 536869 489167 494349 507824 525777 535672 676090 557526 452114 520766 405178 418759 823303 814798 814816 470848 455984 486674 452206 513910 530497 536699 538653 506024 513894 514676 520841 536569 537673 503241 503683 506034 529166 534961 476138 542224 543875 557102 579425 565418 566059 575863 606599 630575 630870 610284 623973 637085 614020 623962 597753 631199 738047 619392 720291 428603 462829 518176 493801 454802 666538 499890 70082 404175 404459 432799 443232 432574 458125 468826 476901 492134 501255 527091 534650 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.77%) |
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 70082 404175 404459 405178 418759 428603 432574 432799 443232 447143 452114 452206 454802 455984 458125 462829 464133 464644 468826 470848 475273 476138 476901 486674 489167 492134 493801 494349 499890 501255 503241 503683 506024 506034 507824 513894 513910 514676 518176 520766 520841 525777 527091 529166 530497 534650 534961 535672 536569 536699 536869 537673 538653 542224 542859 543393 543875 547865 549858 550834 557102 557526 557546 561309 561451 565418 566059 575863 579138 579425 579761 586244 596200 597753 599637 603038 606599 610284 613452 614020 619392 623180 623962 623973 630575 630870 631199 633113 636275 637085 640686 643046 651668 666538 676090 678201 711554 711565 711568 711569 715615 715630 720291 720340 720394 723986 727692 730216 732331 738030 738047 738050 753077 753211 760068 761432 790853 814798 814816 823303 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina bbc"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская bbc"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская bbc"
]
|
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.