Query Metrics
7
Database Queries
7
Different statements
199.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.25 ms (85.64%) |
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 358453 394136 395778 400923 404051 423764 443634 454797 456280 457748 477970 490525 492568 494553 494662 498867 500494 506321 507853 511821 512087 513101 514847 515553 517236 518907 522432 526981 529638 533527 534742 535286 535313 537630 539030 539283 539328 539429 541050 541198 541544 542080 542720 544515 546659 547274 547606 547990 548888 549435 550771 551878 552756 553263 553674 553932 553949 554841 557251 559450 559875 560413 560723 561244 562595 564702 568966 570858 570875 571304 571753 578002 578778 579886 581149 589141 593913 602505 603779 605013 606947 622090 622505 624017 632401 648648 668741 668887 679564 695551 718874 723575 733211 735790 738032 761603 764190 773174 782179 796958 803658 811721 812265 814150 814303 818753 819302 820666 823252 823272 823676 824157 825021 825557 826469 826624 827912 827952 827963 828853 ] |
||||||||||||||||||||||||||||||
|
16.62 ms (8.31%) |
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 494662 539429 578778 589141 738032 606947 423764 456280 568966 782179 761603 514847 553949 400923 544515 818753 492568 526981 559875 562595 695551 718874 679564 564702 593913 622505 773174 733211 550771 668887 605013 735790 811721 553674 648648 513101 443634 506321 547606 542080 546659 547274 560413 624017 764190 812265 494553 511821 518907 533527 571753 579886 668741 602505 622090 632401 603779 796958 803658 512087 394136 395778 358453 404051 814150 820666 823676 825021 723575 826469 814303 819302 823252 823272 825557 827912 828853 827952 827963 824157 826624 454797 457748 490525 507853 529638 498867 522432 535286 537630 539328 515553 517236 534742 535313 539030 500494 539283 477970 541050 542720 547990 549435 551878 552756 553263 557251 560723 561244 570858 570875 571304 578002 581149 541198 541544 548888 553932 554841 559450 ] |
||||||||||||||||||||||||||||||
|
4.17 ms (2.08%) |
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 358453 394136 395778 400923 404051 423764 443634 454797 456280 457748 477970 490525 492568 494553 494662 498867 500494 506321 507853 511821 512087 513101 514847 515553 517236 518907 522432 526981 529638 533527 534742 535286 535313 537630 539030 539283 539328 539429 541050 541198 541544 542080 542720 544515 546659 547274 547606 547990 548888 549435 550771 551878 552756 553263 553674 553932 553949 554841 557251 559450 559875 560413 560723 561244 562595 564702 568966 570858 570875 571304 571753 578002 578778 579886 581149 589141 593913 602505 603779 605013 606947 622090 622505 624017 632401 648648 668741 668887 679564 695551 718874 723575 733211 735790 738032 761603 764190 773174 782179 796958 803658 811721 812265 814150 814303 818753 819302 820666 823252 823272 823676 824157 825021 825557 826469 826624 827912 827952 827963 828853 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые жен"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny wife"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.86%) |
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.