Query Metrics
7
Database Queries
7
Different statements
159.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.61 ms (84.94%) |
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 34146 361286 396349 399759 405070 408998 417738 418922 420516 422879 428664 429069 429424 431546 437573 437579 438844 440927 441696 446244 447895 448518 451549 455025 456584 457176 460608 462394 465194 468647 471961 472671 472833 474591 478573 481684 482101 484797 485082 485165 486789 491732 491733 491922 493319 495082 496302 496854 497369 497798 498657 509977 510686 510690 515663 516636 516666 519671 519701 520427 521154 522784 522997 524810 525821 526789 526828 528906 533499 535342 535919 536683 536759 536774 539029 542074 546580 549746 553314 555050 565347 566057 566064 566228 566933 567321 576445 579527 581269 588631 589756 591092 592413 593476 595037 596793 603187 608639 611700 625169 641140 642934 650780 681413 685578 687980 726997 727041 731442 733480 740804 759987 760837 762158 794362 810986 812061 817319 818998 820338 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (9.38%) |
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 478573 546580 625169 524810 820338 685578 650780 733480 762158 441696 817319 818998 565347 608639 794362 451549 485165 448518 465194 472671 446244 536683 760837 812061 440927 525821 491733 493319 34146 474591 496302 533499 468647 455025 497369 521154 731442 361286 536759 576445 566064 555050 603187 641140 589756 642934 740804 611700 495082 396349 457176 456584 471961 522997 549746 566228 566057 759987 417738 437579 462394 405070 497798 535919 486789 687980 810986 431546 509977 422879 526789 539029 485082 593476 428664 437573 460608 491732 498657 510686 510690 447895 481684 408998 536774 519701 726997 727041 520427 399759 516666 566933 542074 579527 591092 592413 516636 553314 596793 496854 420516 515663 522784 581269 567321 588631 429069 438844 528906 491922 472833 681413 595037 429424 482101 526828 418922 535342 484797 519671 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.83%) |
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 34146 361286 396349 399759 405070 408998 417738 418922 420516 422879 428664 429069 429424 431546 437573 437579 438844 440927 441696 446244 447895 448518 451549 455025 456584 457176 460608 462394 465194 468647 471961 472671 472833 474591 478573 481684 482101 484797 485082 485165 486789 491732 491733 491922 493319 495082 496302 496854 497369 497798 498657 509977 510686 510690 515663 516636 516666 519671 519701 520427 521154 522784 522997 524810 525821 526789 526828 528906 533499 535342 535919 536683 536759 536774 539029 542074 546580 549746 553314 555050 565347 566057 566064 566228 566933 567321 576445 579527 581269 588631 589756 591092 592413 593476 595037 596793 603187 608639 611700 625169 641140 642934 650780 681413 685578 687980 726997 727041 731442 733480 740804 759987 760837 762158 794362 810986 812061 817319 818998 820338 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big job"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие job"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие job"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.86%) |
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.