Query Metrics
7
Database Queries
7
Different statements
168.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.64 ms (85.10%) |
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 12118 13202 69440 79959 382818 386370 387195 388391 390366 390790 391328 396920 397777 397835 398746 401834 413898 416273 422302 432436 437758 444570 450868 457079 457216 457614 457862 458088 475943 485640 488771 494164 500194 506144 516604 519670 528647 532059 533419 533818 533970 537347 541549 542341 542668 555121 557151 567688 581067 590367 606655 616209 627635 629446 635726 635788 645880 702680 704435 719854 721690 724331 724935 726047 726392 733316 733958 734214 734858 737968 742718 745933 747807 748458 749563 754833 755166 756579 758743 761408 763228 763244 763877 763889 764485 764640 765022 767398 767517 767524 767766 772280 777454 777898 777990 780057 780426 781361 782882 783318 783510 783763 784319 784698 785988 789763 790152 790263 791031 791156 791397 793394 798445 801705 806864 808247 811637 825177 825222 ] |
||||||||||||||||||||||||||||||
|
15.35 ms (9.09%) |
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 782882 783510 784698 789763 790263 791031 726047 733958 734214 755166 762977 763228 764485 767398 767517 784319 791397 801705 806864 808247 734858 749563 754833 765022 767766 726392 742718 745933 758743 764640 733316 747807 748458 756579 763877 767524 724935 761408 763244 635726 704435 719854 721690 777454 777898 777990 780426 783318 785988 790152 791156 798445 811637 69440 79959 401834 397777 645880 635788 793394 13202 825222 825177 737968 542341 567688 780057 616209 724331 702680 444570 12118 541549 627635 606655 382818 387195 488771 500194 528647 581067 432436 475943 519670 494164 397835 398746 763889 422302 457079 457216 533818 555121 557151 542668 629446 590367 783763 532059 781361 772280 386370 388391 391328 390366 390790 396920 416273 437758 413898 457614 458088 457862 450868 485640 533419 516604 533970 537347 506144 ] |
||||||||||||||||||||||||||||||
|
3.14 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 12118 13202 69440 79959 382818 386370 387195 388391 390366 390790 391328 396920 397777 397835 398746 401834 413898 416273 422302 432436 437758 444570 450868 457079 457216 457614 457862 458088 475943 485640 488771 494164 500194 506144 516604 519670 528647 532059 533419 533818 533970 537347 541549 542341 542668 555121 557151 567688 581067 590367 606655 616209 627635 629446 635726 635788 645880 702680 704435 719854 721690 724331 724935 726047 726392 733316 733958 734214 734858 737968 742718 745933 747807 748458 749563 754833 755166 756579 758743 761408 763228 763244 763877 763889 764485 764640 765022 767398 767517 767524 767766 772280 777454 777898 777990 780057 780426 781361 782882 783318 783510 783763 784319 784698 785988 789763 790152 790263 791031 791156 791397 793394 798445 801705 806864 808247 811637 825177 825222 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет 2024"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.