Query Metrics
7
Database Queries
7
Different statements
182.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.22 ms (86.78%) |
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 86926 387230 396021 397423 401794 425535 436845 456890 466728 470420 472635 472876 473564 481840 487062 491092 494278 496430 496808 500701 501977 502376 504609 505176 506068 506563 507158 507757 508219 508279 509501 509565 511038 512618 512675 513855 515303 515322 517835 520075 521496 521577 521714 522505 522602 527535 527819 528225 528667 530120 530247 530252 531395 532018 533997 534052 534800 535532 535847 537954 538576 539338 539524 540429 546010 546833 554479 554740 555938 557085 561600 562499 564533 566895 568096 571069 571993 573447 574186 576558 577082 579575 580402 585104 586636 586763 588896 588949 589648 590917 591128 593087 594976 595115 599135 599805 600487 600767 601960 602480 603072 605289 605638 606839 607238 610074 615510 617710 619845 625283 626287 631107 635697 645922 651244 655728 655983 658692 661921 662476 ] |
||||||||||||||||||||||||||||||
|
11.59 ms (6.36%) |
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 573447 662476 651244 546833 555938 561600 568096 600767 610074 588896 594976 602480 590917 600487 626287 635697 595115 599135 607238 425535 562499 625283 86926 396021 401794 466728 456890 507158 515303 515322 511038 513855 535847 502376 506563 530120 507757 508279 512618 530252 532018 491092 564533 566895 574186 580402 557085 571069 577082 546010 579575 655728 655983 661921 658692 645922 554479 554740 571993 576558 589648 605638 588949 605289 586636 593087 586763 591128 599805 603072 619845 601960 606839 615510 617710 631107 397423 436845 387230 585104 473564 481840 470420 472876 472635 487062 496808 506068 509501 512675 521577 522602 535532 537954 539338 539524 540429 500701 504609 508219 517835 521714 527535 528225 528667 531395 533997 496430 505176 509565 520075 521496 522505 527819 530247 534052 534800 538576 494278 501977 ] |
||||||||||||||||||||||||||||||
|
4.79 ms (2.63%) |
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 86926 387230 396021 397423 401794 425535 436845 456890 466728 470420 472635 472876 473564 481840 487062 491092 494278 496430 496808 500701 501977 502376 504609 505176 506068 506563 507158 507757 508219 508279 509501 509565 511038 512618 512675 513855 515303 515322 517835 520075 521496 521577 521714 522505 522602 527535 527819 528225 528667 530120 530247 530252 531395 532018 533997 534052 534800 535532 535847 537954 538576 539338 539524 540429 546010 546833 554479 554740 555938 557085 561600 562499 564533 566895 568096 571069 571993 573447 574186 576558 577082 579575 580402 585104 586636 586763 588896 588949 589648 590917 591128 593087 594976 595115 599135 599805 600487 600767 601960 602480 603072 605289 605638 606839 607238 610074 615510 617710 619845 625283 626287 631107 635697 645922 651244 655728 655983 658692 661921 662476 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в заглот"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в заглот"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.87%) |
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.