Query Metrics
7
Database Queries
7
Different statements
186.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.28 ms (85.50%) |
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 384811 391624 391936 405612 419045 420014 443373 444253 445600 445811 446648 448688 452372 454431 456509 462585 463197 468519 469548 471154 471603 472055 472815 472816 475161 477894 478972 479659 479941 481273 483444 484150 484969 488905 490524 490653 491612 498912 499389 501268 502982 503072 504790 505420 505864 508984 510138 514452 515652 520346 520959 522810 524101 524457 525982 527984 528325 528684 532952 540743 542926 543341 544511 545609 546335 546704 551491 552247 552368 552369 552577 555011 556419 558103 558382 560366 561639 566958 568076 568590 569848 570257 570490 570607 571907 571919 572048 572476 573566 573946 580874 584193 586144 588613 591144 592735 594981 595646 598923 600636 602967 606397 607185 612425 616012 621999 636442 650789 653513 698108 701260 736017 759325 764654 772190 773822 797888 805772 809346 810757 ] |
||||||||||||||||||||||||||||||
|
14.96 ms (8.03%) |
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 586144 503072 520346 478972 546335 592735 797888 736017 443373 477894 490653 528325 445811 528684 552368 555011 810757 391624 569848 504790 508984 570607 580874 552577 653513 588613 594981 420014 445600 484150 510138 490524 456509 475161 472815 532952 570490 572048 650789 571919 621999 773822 446648 462585 444253 514452 515652 527984 545609 452372 522810 525982 484969 544511 568076 558103 568590 570257 598923 759325 463197 471603 540743 505864 571907 384811 454431 499389 501268 542926 572476 558382 584193 698108 556419 764654 701260 472816 502982 483444 520959 606397 524457 488905 573946 573566 636442 471154 479941 419045 524101 607185 405612 498912 552247 560366 600636 805772 448688 472055 479659 551491 566958 595646 616012 602967 809346 772190 481273 468519 469548 491612 543341 546704 552369 561639 591144 612425 391936 505420 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (1.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на балкон"
]
|
||||||||||||||||||||||||||||||
|
3.08 ms (1.65%) |
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 384811 391624 391936 405612 419045 420014 443373 444253 445600 445811 446648 448688 452372 454431 456509 462585 463197 468519 469548 471154 471603 472055 472815 472816 475161 477894 478972 479659 479941 481273 483444 484150 484969 488905 490524 490653 491612 498912 499389 501268 502982 503072 504790 505420 505864 508984 510138 514452 515652 520346 520959 522810 524101 524457 525982 527984 528325 528684 532952 540743 542926 543341 544511 545609 546335 546704 551491 552247 552368 552369 552577 555011 556419 558103 558382 560366 561639 566958 568076 568590 569848 570257 570490 570607 571907 571919 572048 572476 573566 573946 580874 584193 586144 588613 591144 592735 594981 595646 598923 600636 602967 606397 607185 612425 616012 621999 636442 650789 653513 698108 701260 736017 759325 764654 772190 773822 797888 805772 809346 810757 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на балкон"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.