Query Metrics
7
Database Queries
7
Different statements
254.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
226.14 ms (88.80%) |
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 29656 135183 382083 388849 391113 401369 414301 421363 425356 425719 428276 428769 445499 453327 461744 464899 475477 477494 479021 482388 482764 485158 485161 485165 489263 489361 490577 496368 507804 510674 520738 533795 533975 533979 534875 535705 535877 537799 540948 542582 542618 543864 545962 550421 560168 561772 575197 575411 575655 581408 585439 589544 589976 598402 603601 616009 617163 621632 621648 628850 629641 637870 641647 644101 645780 646630 647213 647406 648284 648433 650913 650993 666675 700845 700892 709554 710321 711864 712102 715281 717443 720018 725621 734805 737330 737719 738147 738390 738430 739055 739877 741436 741617 744451 745014 747916 748004 748413 748794 753229 758604 768184 775182 780668 780939 784460 784492 784508 794115 800271 802574 805641 806000 806038 807811 809365 820500 822254 827835 ] |
||||||||||||||||||||||||||||||
|
18.31 ms (7.19%) |
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 806038 737719 391113 388849 445499 425719 485165 507804 520738 575197 589544 135183 29656 820500 822254 827835 475477 477494 533795 533975 534875 535877 533979 537799 535705 542618 550421 575655 581408 540948 545962 561772 647213 647406 650913 650993 720018 645780 646630 666675 700845 700892 700933 648284 648433 709554 710321 711864 712102 616009 628850 629641 641647 621632 637870 644101 585439 603601 589976 780939 784460 784508 805641 737330 738147 741617 748004 753229 784492 794115 806000 807811 739055 744451 725621 734805 738390 745014 747916 748413 748794 758604 738430 739877 741436 768184 617163 715281 717443 780668 800271 802574 809365 425356 428276 401369 482388 421363 461744 414301 489263 382083 428769 482764 485161 489361 453327 464899 485158 496368 510674 479021 490577 560168 542582 543864 575411 598402 621648 775182 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.17%) |
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 29656 135183 382083 388849 391113 401369 414301 421363 425356 425719 428276 428769 445499 453327 461744 464899 475477 477494 479021 482388 482764 485158 485161 485165 489263 489361 490577 496368 507804 510674 520738 533795 533975 533979 534875 535705 535877 537799 540948 542582 542618 543864 545962 550421 560168 561772 575197 575411 575655 581408 585439 589544 589976 598402 603601 616009 617163 621632 621648 628850 629641 637870 641647 644101 645780 646630 647213 647406 648284 648433 650913 650993 666675 700845 700892 709554 710321 711864 712102 715281 717443 720018 725621 734805 737330 737719 738147 738390 738430 739055 739877 741436 741617 744451 745014 747916 748004 748413 748794 753229 758604 768184 775182 780668 780939 784460 784492 784508 794115 800271 802574 805641 806000 806038 807811 809365 820500 822254 827835 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чернокожая teens"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ebony teens"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.63%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.24 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чернокожая teens"
]
|
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.