Query Metrics
7
Database Queries
7
Different statements
176.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.87 ms (86.71%) |
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 12887 44900 187450 193462 205715 381956 382280 385779 389639 391954 393705 394212 396287 400361 407703 409032 413709 417438 419530 420652 422347 424003 424474 425981 426877 428723 429886 429899 444104 445630 453072 453415 462565 467052 468377 468858 468934 468965 472007 474865 475660 476321 479979 481956 485681 488812 490996 491431 503476 506057 509244 510107 513339 518846 526201 536426 545004 549222 557989 559346 564795 577290 578298 581251 589694 592636 593063 597099 607599 607632 609071 610626 614361 621404 629781 640687 644000 644382 651029 663881 664217 666480 689689 694505 697185 698617 704907 728231 728469 732385 735886 735901 744087 744992 747052 769463 770203 772106 776745 780691 781765 788753 795478 797014 798607 799077 801030 802352 804400 807996 808055 808070 809215 817333 817343 819959 820141 823441 824285 825973 ] |
||||||||||||||||||||||||||||||
|
13.10 ms (7.43%) |
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 728469 607599 704907 799077 809215 382280 420652 506057 513339 518846 413709 193462 44900 820141 824285 817343 819959 817333 823441 825973 564795 581251 578298 545004 694505 663881 697185 651029 664217 666480 698617 614361 644000 597099 776745 780691 795478 801030 802352 807996 808055 781765 788753 798607 772106 747052 769463 732385 735886 735901 744087 770203 728231 744992 621404 644382 797014 804400 808070 385779 187450 424474 488812 629781 640687 429899 419530 445630 490996 577290 468965 491431 417438 468934 476321 510107 526201 475660 549222 381956 422347 503476 205715 393705 12887 396287 407703 409032 425981 444104 453415 462565 474865 453072 468377 472007 485681 509244 536426 557989 559346 689689 609071 589694 592636 593063 607632 610626 391954 467052 481956 389639 394212 400361 424003 429886 468858 426877 428723 479979 ] |
||||||||||||||||||||||||||||||
|
3.35 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 12887 44900 187450 193462 205715 381956 382280 385779 389639 391954 393705 394212 396287 400361 407703 409032 413709 417438 419530 420652 422347 424003 424474 425981 426877 428723 429886 429899 444104 445630 453072 453415 462565 467052 468377 468858 468934 468965 472007 474865 475660 476321 479979 481956 485681 488812 490996 491431 503476 506057 509244 510107 513339 518846 526201 536426 545004 549222 557989 559346 564795 577290 578298 581251 589694 592636 593063 597099 607599 607632 609071 610626 614361 621404 629781 640687 644000 644382 651029 663881 664217 666480 689689 694505 697185 698617 704907 728231 728469 732385 735886 735901 744087 744992 747052 769463 770203 772106 776745 780691 781765 788753 795478 797014 798607 799077 801030 802352 804400 807996 808055 808070 809215 817333 817343 819959 820141 823441 824285 825973 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пышка чулках"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"полная чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.83%) |
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.