Query Metrics
7
Database Queries
7
Different statements
151.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.20 ms (83.85%) |
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 181122 198458 381890 382791 385107 389602 391108 391487 391985 392002 392981 395362 398928 400050 409078 421569 422324 423944 428793 432374 432503 433402 433792 436538 438638 439600 442463 458701 459022 459532 460319 465926 472683 480671 481960 483821 486493 489322 509673 510819 516543 519591 528228 528322 529618 534017 536415 539114 544791 547657 553684 555652 557563 560048 586040 588357 589587 592968 592994 593387 605694 607519 607607 619151 619894 620992 640210 660301 662926 673204 675060 675438 675702 680322 688166 695359 695719 702367 707642 709911 716207 717668 724809 725786 727239 728380 741343 741724 742703 744968 750568 753507 754321 757480 763913 765413 766113 767690 768582 782493 791020 791449 792009 794405 800068 800920 809352 810815 813950 817585 824234 825737 826034 826113 828438 828445 828654 828662 828787 ] |
||||||||||||||||||||||||||||||
|
14.37 ms (9.47%) |
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 465926 421569 809352 400050 398928 460319 432503 607519 528228 826034 828438 433792 528322 409078 472683 481960 489322 593387 675060 423944 510819 519591 560048 619894 724809 381890 391487 768582 824234 825737 828445 828654 534017 438638 432374 385107 198458 395362 391985 544791 553684 555652 688166 716207 662926 673204 680322 702367 709911 588357 640210 589587 607607 620992 586040 791449 794405 728380 741343 763913 725786 765413 757480 766113 727239 742703 753507 707642 792009 800920 529618 800068 754321 391108 828787 459022 459532 539114 813950 826113 695359 823734 817585 828662 536415 717668 782493 767690 810815 428793 480671 392002 422324 660301 675438 675702 547657 592968 433402 439600 486493 392981 389602 483821 695719 557563 619151 605694 741724 750568 791020 458701 516543 181122 436538 442463 592994 509673 744968 382791 ] |
||||||||||||||||||||||||||||||
|
3.63 ms (2.39%) |
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 181122 198458 381890 382791 385107 389602 391108 391487 391985 392002 392981 395362 398928 400050 409078 421569 422324 423944 428793 432374 432503 433402 433792 436538 438638 439600 442463 458701 459022 459532 460319 465926 472683 480671 481960 483821 486493 489322 509673 510819 516543 519591 528228 528322 529618 534017 536415 539114 544791 547657 553684 555652 557563 560048 586040 588357 589587 592968 592994 593387 605694 607519 607607 619151 619894 620992 640210 660301 662926 673204 675060 675438 675702 680322 688166 695359 695719 702367 707642 709911 716207 717668 724809 725786 727239 728380 741343 741724 742703 744968 750568 753507 754321 757480 763913 765413 766113 767690 768582 782493 791020 791449 792009 794405 800068 800920 809352 810815 813950 817585 824234 825737 826034 826113 828438 828445 828654 828662 828787 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife stockings"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.92%) |
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.