Query Metrics
7
Database Queries
7
Different statements
148.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.29 ms (79.47%) |
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 101056 315513 384368 398966 400892 403357 403496 406918 408411 411844 413097 415753 415805 417232 421976 422172 427218 428132 428728 428805 429568 429595 432348 432421 440691 440917 441733 441839 442010 442482 443403 443581 444419 444423 445089 445096 445843 447882 448578 449093 452377 452620 454387 454459 454965 454966 455068 456219 457372 457551 458760 459195 459657 462876 464987 465005 465589 465727 466510 466924 473334 473476 473771 474778 475293 475311 476300 476715 476911 479032 482951 483885 484016 484019 485737 485745 485949 486553 488782 490420 491767 491792 492288 492989 495016 496831 498768 499467 500574 501003 502023 503993 504774 505725 507280 507858 509244 509494 510838 510888 511022 511118 511515 513340 515654 515964 517298 517436 517458 517494 518465 518536 520295 520680 524813 526191 526924 531483 539075 540500 ] |
||||||||||||||||||||||||||||||
|
18.03 ms (12.11%) |
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 483885 490420 492989 496831 499467 502023 504774 505725 511022 517494 520295 498768 507280 511118 513340 517298 517436 518536 526924 384368 101056 315513 400892 398966 403357 403496 406918 413097 417232 429568 429595 432348 443581 445096 411844 428728 428805 432421 440691 444419 408411 422172 427218 428132 440917 442010 445089 415805 421976 443403 444423 415753 441733 441839 442482 449093 454459 454965 454966 457372 464987 465005 465727 466924 475293 484019 485949 492288 445843 448578 452377 452620 456219 458760 459195 462876 465589 473334 473771 479032 482951 485737 485745 491767 491792 447882 454387 455068 457551 459657 466510 473476 474778 475311 476300 476715 476911 484016 486553 488782 495016 500574 503993 509244 510888 511515 517458 518465 539075 501003 515654 515964 520680 524813 531483 510838 526191 540500 507858 509494 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (2.54%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вес"
]
|
||||||||||||||||||||||||||||||
|
3.07 ms (2.06%) |
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 101056 315513 384368 398966 400892 403357 403496 406918 408411 411844 413097 415753 415805 417232 421976 422172 427218 428132 428728 428805 429568 429595 432348 432421 440691 440917 441733 441839 442010 442482 443403 443581 444419 444423 445089 445096 445843 447882 448578 449093 452377 452620 454387 454459 454965 454966 455068 456219 457372 457551 458760 459195 459657 462876 464987 465005 465589 465727 466510 466924 473334 473476 473771 474778 475293 475311 476300 476715 476911 479032 482951 483885 484016 484019 485737 485745 485949 486553 488782 490420 491767 491792 492288 492989 495016 496831 498768 499467 500574 501003 502023 503993 504774 505725 507280 507858 509244 509494 510838 510888 511022 511118 511515 513340 515654 515964 517298 517436 517458 517494 518465 518536 520295 520680 524813 526191 526924 531483 539075 540500 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вес"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"весу"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.