Query Metrics
7
Database Queries
7
Different statements
170.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.87 ms (87.33%) |
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 102043 122425 156525 185606 319841 386072 389147 391025 394738 404053 405505 405534 406237 407646 409291 409646 415637 418400 430989 434281 436859 441758 445233 447004 447244 447350 447548 449254 459231 464195 465789 469675 471410 475859 476366 489110 498544 498816 499834 501805 503215 506702 510037 515779 516406 517998 518767 524003 531471 538365 543791 551292 551319 551334 551409 551422 554777 557337 558617 560396 563796 564621 564631 568129 569822 572010 573930 595837 598112 600577 603516 603583 606809 610226 618883 624436 625557 628989 634755 640699 643731 644486 653247 653251 663381 663391 663494 663566 664324 669130 670270 683288 690148 696102 696192 716753 720458 727394 735530 741290 744601 747372 747376 750782 758102 762567 771354 773098 796205 806226 810842 813478 814758 814806 816038 817734 818390 820452 821572 824724 ] |
||||||||||||||||||||||||||||||
|
12.86 ms (7.54%) |
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 418400 663381 436859 515779 516406 554777 551422 445233 489110 501805 664324 663494 122425 568129 814806 814758 543791 551409 696102 610226 750782 744601 518767 405534 447350 447548 716753 598112 606809 394738 102043 628989 560396 618883 469675 524003 551319 625557 464195 551334 389147 471410 391025 430989 595837 406237 517998 459231 551292 810842 824724 600577 415637 818390 821572 720458 663391 603516 747376 735530 564631 690148 669130 644486 727394 806226 747372 156525 185606 319841 441758 538365 653251 796205 773098 758102 771354 499834 498816 506702 634755 409291 476366 816038 820452 498544 449254 569822 696192 447244 447004 683288 409646 643731 670270 404053 817734 813478 741290 573930 663566 624436 640699 434281 386072 762567 557337 531471 558617 563796 572010 653247 603583 503215 405505 475859 465789 510037 407646 564621 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.38%) |
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 102043 122425 156525 185606 319841 386072 389147 391025 394738 404053 405505 405534 406237 407646 409291 409646 415637 418400 430989 434281 436859 441758 445233 447004 447244 447350 447548 449254 459231 464195 465789 469675 471410 475859 476366 489110 498544 498816 499834 501805 503215 506702 510037 515779 516406 517998 518767 524003 531471 538365 543791 551292 551319 551334 551409 551422 554777 557337 558617 560396 563796 564621 564631 568129 569822 572010 573930 595837 598112 600577 603516 603583 606809 610226 618883 624436 625557 628989 634755 640699 643731 644486 653247 653251 663381 663391 663494 663566 664324 669130 670270 683288 690148 696102 696192 716753 720458 727394 735530 741290 744601 747372 747376 750782 758102 762567 771354 773098 796205 806226 810842 813478 814758 814806 816038 817734 818390 820452 821572 824724 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits massage"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ массаж"
]
|
||||||||||||||||||||||||||||||
|
1.36 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.