Query Metrics
7
Database Queries
7
Different statements
166.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.39 ms (83.77%) |
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 185223 282864 382073 398021 403635 420318 426014 435351 438062 442248 444607 445670 447252 452314 453269 453295 455463 455761 456795 457004 459092 459313 461204 464776 465098 465310 469185 471161 476769 478663 479135 480025 483275 483472 483825 485043 485347 486139 487899 489784 489800 490826 491576 492707 493273 493439 494418 495100 495248 496688 497228 497257 497391 497402 499379 501841 503018 503513 503796 503844 506232 506886 507921 509060 510083 510120 510350 511077 512172 512619 513801 514456 515711 516553 517120 517773 519535 520358 522793 522962 523597 523647 524407 525122 525799 527601 528187 528269 528653 529148 529702 529776 530108 530221 534589 535948 537779 540384 543903 548058 561167 574667 584660 585015 586043 595674 598637 618752 630072 671074 693847 699551 709915 714654 741132 746131 746471 788146 828468 828683 ] |
||||||||||||||||||||||||||||||
|
16.93 ms (10.18%) |
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 478663 464776 510350 522793 523597 524407 487899 493273 497228 503513 510083 511077 522962 525799 483275 485347 509060 527601 489784 492707 494418 495248 497257 497402 510120 512172 515711 517120 528653 442248 479135 503844 506232 523647 537779 501841 525122 529776 574667 598637 586043 528187 528269 493439 520358 514456 828468 828683 530108 529702 530221 543903 693847 788146 741132 746131 185223 282864 382073 398021 403635 435351 420318 438062 585015 447252 453269 459313 476769 483825 445670 453295 457004 471161 489800 491576 455761 456795 469185 486139 490826 512619 517773 495100 497391 499379 503796 507921 516553 519535 540384 529148 535948 496688 503018 506886 513801 534589 461204 483472 485043 548058 561167 584660 671074 714654 709915 595674 746471 618752 630072 699551 455463 426014 444607 452314 459092 465098 465310 480025 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.66%) |
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 185223 282864 382073 398021 403635 420318 426014 435351 438062 442248 444607 445670 447252 452314 453269 453295 455463 455761 456795 457004 459092 459313 461204 464776 465098 465310 469185 471161 476769 478663 479135 480025 483275 483472 483825 485043 485347 486139 487899 489784 489800 490826 491576 492707 493273 493439 494418 495100 495248 496688 497228 497257 497391 497402 499379 501841 503018 503513 503796 503844 506232 506886 507921 509060 510083 510120 510350 511077 512172 512619 513801 514456 515711 516553 517120 517773 519535 520358 522793 522962 523597 523647 524407 525122 525799 527601 528187 528269 528653 529148 529702 529776 530108 530221 534589 535948 537779 540384 543903 548058 561167 574667 584660 585015 586043 595674 598637 618752 630072 671074 693847 699551 709915 714654 741132 746131 746471 788146 828468 828683 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хуи"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 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.