Query Metrics
7
Database Queries
7
Different statements
141.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.50 ms (83.25%) |
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 399813 403833 411682 424402 434913 455059 456957 460489 463148 467777 468903 469099 470706 473555 474325 476041 480178 484158 484247 486031 487773 488834 489068 492210 494658 498759 501977 504359 505311 506504 506901 509633 514468 522372 522402 522547 527556 527897 530045 531602 531611 538905 543069 545768 546076 546592 548239 548323 548407 548675 548693 549445 550427 550941 551529 551554 551562 552471 552714 552821 553167 554669 555203 555234 555296 559115 561253 561260 565352 566332 566987 567686 567698 571528 572650 572756 572808 574380 574949 577052 579739 580140 580307 580976 583100 584014 587735 588879 589362 592152 592665 592963 598218 601513 602545 606255 606818 609653 615947 618101 618795 629717 630063 631395 638459 650537 651142 661562 664562 664833 665128 670892 720444 749797 754060 766488 780871 789721 789772 797598 ] |
||||||||||||||||||||||||||||||
|
12.33 ms (8.74%) |
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 522372 574949 548407 631395 601513 505311 606818 572756 579739 548693 754060 780871 797598 399813 566987 527556 553167 577052 566332 550427 565352 552821 555296 574380 587735 588879 487773 488834 551554 720444 789721 469099 467777 580140 664562 498759 552714 567686 434913 484158 492210 548323 554669 572808 549445 555234 650537 615947 589362 592665 592963 455059 473555 474325 514468 550941 551529 766488 749797 456957 522547 506901 571528 546592 638459 602545 480178 489068 484247 509633 530045 506504 527897 531602 531611 538905 494658 501977 463148 548675 561253 551562 580976 583100 543069 545768 548239 561260 572650 661562 546076 555203 559115 567698 580307 584014 592152 598218 609653 606255 618795 629717 630063 460489 504359 486031 789772 424402 476041 618101 403833 411682 468903 470706 522402 552471 651142 664833 665128 670892 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (2.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поле природ"
]
|
||||||||||||||||||||||||||||||
|
2.53 ms (1.79%) |
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 399813 403833 411682 424402 434913 455059 456957 460489 463148 467777 468903 469099 470706 473555 474325 476041 480178 484158 484247 486031 487773 488834 489068 492210 494658 498759 501977 504359 505311 506504 506901 509633 514468 522372 522402 522547 527556 527897 530045 531602 531611 538905 543069 545768 546076 546592 548239 548323 548407 548675 548693 549445 550427 550941 551529 551554 551562 552471 552714 552821 553167 554669 555203 555234 555296 559115 561253 561260 565352 566332 566987 567686 567698 571528 572650 572756 572808 574380 574949 577052 579739 580140 580307 580976 583100 584014 587735 588879 589362 592152 592665 592963 598218 601513 602545 606255 606818 609653 615947 618101 618795 629717 630063 631395 638459 650537 651142 661562 664562 664833 665128 670892 720444 749797 754060 766488 780871 789721 789772 797598 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"поле"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.14%) |
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.