Query Metrics
7
Database Queries
7
Different statements
166.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.58 ms (83.97%) |
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 109041 223442 360205 364718 382383 386316 398794 401940 405725 412332 413007 413801 417709 420426 422398 422488 425745 426389 427214 428423 429261 446761 450646 451583 451606 452225 455565 455850 456261 456607 457561 458114 458584 458686 458830 460098 460100 460395 461174 462352 466671 470224 472344 472799 473647 475179 475574 478106 478212 478261 479952 480673 482882 486494 487133 487159 488877 493288 494046 497166 499706 502318 503041 504613 504833 506571 514296 523944 523968 524002 525650 527044 527456 528416 528715 528993 529015 529058 529918 544299 544614 545352 546446 549101 549222 551227 555440 557895 560014 560170 562804 568790 569865 570356 570609 571598 578133 579456 580327 586381 589357 593122 599623 599792 601580 606647 615082 617647 626911 628004 630749 668025 709452 719915 729357 793992 818657 821065 822815 825580 ] |
||||||||||||||||||||||||||||||
|
16.90 ms (10.16%) |
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 545352 460098 422488 472799 527456 479952 586381 793992 486494 466671 223442 428423 413801 626911 417709 401940 455565 529015 719915 599792 493288 382383 628004 544614 506571 502318 487133 452225 528715 475179 560170 568790 473647 360205 497166 528416 109041 729357 504613 425745 446761 593122 462352 412332 450646 405725 523968 458686 398794 487159 514296 458114 461174 451583 524002 818657 570609 557895 426389 460395 599623 458584 413007 460100 601580 528993 457561 525650 569865 478106 475574 482882 709452 606647 456607 546446 364718 578133 488877 549222 562804 503041 529918 668025 615082 825580 571598 579456 480673 499706 422398 458830 470224 551227 580327 630749 527044 523944 386316 822815 821065 570356 420426 429261 456261 451606 478261 617647 455850 427214 478212 472344 494046 504833 529058 589357 560014 544299 555440 549101 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.95%) |
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 109041 223442 360205 364718 382383 386316 398794 401940 405725 412332 413007 413801 417709 420426 422398 422488 425745 426389 427214 428423 429261 446761 450646 451583 451606 452225 455565 455850 456261 456607 457561 458114 458584 458686 458830 460098 460100 460395 461174 462352 466671 470224 472344 472799 473647 475179 475574 478106 478212 478261 479952 480673 482882 486494 487133 487159 488877 493288 494046 497166 499706 502318 503041 504613 504833 506571 514296 523944 523968 524002 525650 527044 527456 528416 528715 528993 529015 529058 529918 544299 544614 545352 546446 549101 549222 551227 555440 557895 560014 560170 562804 568790 569865 570356 570609 571598 578133 579456 580327 586381 589357 593122 599623 599792 601580 606647 615082 617647 626911 628004 630749 668025 709452 719915 729357 793992 818657 821065 822815 825580 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public park"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц парк природ"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.84%) |
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.