Query Metrics
7
Database Queries
7
Different statements
430.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.20 ms (49.24%) |
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 394760 398004 399522 417562 422019 424575 424641 424996 426779 428515 432532 432711 433742 435020 435437 436447 436627 437156 437580 437613 438114 438349 441215 442402 442416 442477 443310 444067 444429 447818 448295 448978 451382 453018 453416 454876 455574 455620 455797 455819 456453 457413 457542 459187 459866 459872 460439 460570 463530 463584 463585 463594 463654 464370 465738 468025 468968 470284 472145 473626 473636 477414 477815 478060 478400 478743 480654 483040 483056 484213 485455 486633 488616 489370 489633 490452 491332 491573 492911 492975 499757 500010 505952 506098 506565 508141 508309 508549 511588 512394 514432 516438 516918 517634 519275 520560 520615 521979 521984 522793 522993 524094 524598 525615 525932 528110 528908 529161 562043 584741 585323 587171 591154 600982 615438 620491 620741 620742 766734 ] |
||||||||||||||||||||||||||||||
|
193.66 ms (44.94%) |
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 394760 398004 399522 417562 422019 424575 424641 424996 426779 428515 432532 432711 433742 435020 435437 436447 436627 437156 437580 437613 438114 438349 441215 442402 442416 442477 443310 444067 444429 447818 448295 448978 451382 453018 453416 454876 455574 455620 455797 455819 456453 457413 457542 459187 459866 459872 460439 460570 463530 463584 463585 463594 463654 464370 465738 468025 468968 470284 472145 473626 473636 477414 477815 478060 478400 478743 480654 483040 483056 484213 485455 486633 488616 489370 489633 490452 491332 491573 492911 492975 499757 500010 505952 506098 506565 508141 508309 508549 511588 512394 514432 516438 516918 517634 519275 520560 520615 521979 521984 522793 522993 524094 524598 525615 525932 528110 528908 529161 562043 584741 585323 587171 591154 600982 615438 620491 620741 620742 766734 ] |
||||||||||||||||||||||||||||||
|
17.42 ms (4.04%) |
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 442402 485455 499757 398004 441215 432711 428515 473636 524094 477414 585323 587171 620491 591154 615438 766734 436447 438349 442477 451382 438114 435020 463654 433742 442416 457413 489633 490452 506098 508309 508549 491573 394760 424996 417562 422019 436627 525932 448295 455574 455797 459187 477815 447818 448978 453018 455620 463530 463584 478060 480654 453416 468968 522993 525615 506565 516918 524598 529161 516438 517634 463594 470284 484213 488616 562043 584741 620741 600982 620742 424575 437613 457542 463585 435437 455819 459872 460439 399522 432532 437156 437580 443310 444067 454876 456453 464370 426779 444429 459866 459987 465738 473626 478400 424641 460570 468025 472145 478743 500010 511588 512394 522793 489370 491332 492911 492975 505952 508141 514432 519275 520560 520615 521979 521984 528110 528908 483040 483056 486633 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big step sister"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие step sister"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие step sister"
]
|
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.