Query Metrics
7
Database Queries
7
Different statements
201.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.25 ms (88.34%) |
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 290150 391585 409613 415816 417350 423820 437316 439487 440947 441342 442896 451540 453418 453595 459073 459102 460251 460319 460841 461750 462728 462733 462899 462941 463196 463774 469863 470153 476992 477904 481238 485343 485948 489807 490309 492673 494564 499088 500534 504312 505429 505578 511995 520577 521376 523007 531747 539467 539533 546746 548064 551224 553621 562570 562629 566924 567600 569497 575286 585846 594451 595831 598827 604861 622856 623385 624520 626334 641201 652555 670836 677088 693227 697527 701917 707233 708718 710377 714187 717853 719781 722070 722991 723820 726157 737189 738025 738046 738053 738056 748920 753047 753102 757849 764023 764715 769039 773501 777456 779982 781283 784885 786717 789466 790136 791809 792409 794680 800028 801619 804303 804877 809359 811749 812299 813239 824690 825907 ] |
||||||||||||||||||||||||||||||
|
13.56 ms (6.72%) |
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 693227 701917 670836 714187 562629 567600 595831 598827 779982 781283 769039 790136 737189 753047 773501 738025 738046 738053 738056 753102 641201 697527 442896 521376 490309 494564 504312 824690 489807 511995 707233 717853 652555 708718 811749 789466 800028 809359 813239 723820 763469 748920 757849 764715 726157 623385 290150 440947 451540 505578 391585 462899 777456 441342 460841 461750 539467 551224 677088 710377 585846 786717 792409 801619 804877 764023 463196 462941 462733 505429 470153 485343 437316 453418 722070 791809 417350 423820 439487 825907 459073 460319 520577 523007 539533 499088 531747 500534 460251 485948 566924 546746 548064 553621 569497 604861 626334 784885 804303 812299 794680 462728 469863 409613 459102 477904 481238 415816 476992 453595 492673 622856 722991 463774 562570 575286 719781 626899 594451 624520 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.60%) |
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 290150 391585 409613 415816 417350 423820 437316 439487 440947 441342 442896 451540 453418 453595 459073 459102 460251 460319 460841 461750 462728 462733 462899 462941 463196 463774 469863 470153 476992 477904 481238 485343 485948 489807 490309 492673 494564 499088 500534 504312 505429 505578 511995 520577 521376 523007 531747 539467 539533 546746 548064 551224 553621 562570 562629 566924 567600 569497 575286 585846 594451 595831 598827 604861 622856 623385 624520 626334 641201 652555 670836 677088 693227 697527 701917 707233 708718 710377 714187 717853 719781 722070 722991 723820 726157 737189 738025 738046 738053 738056 748920 753047 753102 757849 764023 764715 769039 773501 777456 779982 781283 784885 786717 789466 790136 791809 792409 794680 800028 801619 804303 804877 809359 811749 812299 813239 824690 825907 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"couple homemade"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"couple домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"couple домашн любительск"
]
|
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.