Query Metrics
7
Database Queries
7
Different statements
388.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.12 ms (53.82%) |
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 17066 389770 392104 394103 401724 406059 417368 422237 423459 429362 447909 451488 451620 452567 455657 465103 471801 473057 473778 477953 477981 482174 483369 484587 485301 485899 487156 489691 489714 491503 497958 503621 507241 508809 508852 508874 510950 511058 515170 515175 516837 518581 519588 525821 525918 525919 532912 535729 538054 542951 544493 550067 550418 552273 553173 553516 556839 557940 567372 568061 569233 570873 574210 574833 575603 578082 579362 590549 590796 591612 591819 592645 596230 601569 613465 615928 620900 631768 631965 641095 645381 645934 646846 651941 660531 667309 676951 699678 729436 742878 744261 751970 753142 765726 768940 783452 784393 791362 800988 804719 806097 807037 807391 811028 811073 813553 814220 814558 817335 818245 818784 819107 822292 822979 825231 826736 827163 828365 ] |
||||||||||||||||||||||||||||||
|
155.64 ms (40.06%) |
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 17066 389770 392104 394103 401724 406059 417368 422237 423459 429362 447909 451488 451620 452567 455657 465103 471801 473057 473778 477953 477981 482174 483369 484587 485301 485899 487156 489691 489714 491503 497958 503621 507241 508809 508852 508874 510950 511058 515170 515175 516837 518581 519588 525821 525918 525919 532912 535729 538054 542951 544493 550067 550418 552273 553173 553516 556839 557940 567372 568061 569233 570873 574210 574833 575603 578082 579362 590549 590796 591612 591819 592645 596230 601569 613465 615928 620900 631768 631965 641095 645381 645934 646846 651941 660531 667309 676951 699678 729436 742878 744261 751970 753142 765726 768940 783452 784393 791362 800988 804719 806097 807037 807391 811028 811073 813553 814220 814558 817335 818245 818784 819107 822292 822979 825231 826736 827163 828365 ] |
||||||||||||||||||||||||||||||
|
16.33 ms (4.20%) |
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 783452 807037 477981 484587 511058 489691 508809 818245 645381 667309 800988 814220 451620 532912 544493 592645 491503 515170 574833 817335 553173 651941 553516 596230 538054 569233 422237 17066 556839 601569 620900 818784 784393 765726 465103 615928 569904 477953 392104 590796 575603 660531 744261 806097 822530 827163 535729 518581 401724 429362 455657 471801 473057 567372 676951 646846 557940 590549 641095 791362 804719 742878 417368 473778 394103 452567 508852 508874 516837 525821 483369 503621 510950 485301 525918 525919 507241 515175 497958 485899 579362 406059 487156 550067 552273 631965 570873 489714 751970 591612 826736 819107 825231 814558 822292 822979 828365 574210 811073 753142 729436 768940 447909 451488 811028 807391 813553 550418 645934 699678 631768 423459 389770 613465 542951 578082 591819 568061 519588 482174 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"redhead small tits"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рыжая маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рыжая маленькая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.