Query Metrics
7
Database Queries
7
Different statements
196.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.69 ms (85.54%) |
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 106162 325936 388681 405705 411526 411693 423306 431593 436693 436942 437244 438091 444348 447064 452963 461526 461862 468889 472409 477147 479963 487131 487372 489355 491371 491513 491671 496160 496164 497585 500222 502895 506765 508107 508826 508833 508850 508866 509491 511713 512819 513272 513284 517332 518605 522590 522755 523971 528837 543756 548671 548678 552357 556504 560794 561640 561658 561707 561710 568359 569103 570029 570114 573790 574810 575757 576102 576165 577433 578858 585993 599140 601871 602782 610376 664437 667942 672842 679037 679040 688967 701049 704153 706851 709578 713918 719461 732873 733672 739089 741203 742096 742643 751539 758030 765845 767329 768462 768739 769017 769452 771289 773703 777770 778119 778986 781665 783836 787488 787973 792232 795983 799725 803035 807478 809868 810465 814330 814401 816168 ] |
||||||||||||||||||||||||||||||
|
17.94 ms (9.15%) |
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 768462 751539 767329 768739 732873 769017 771289 787973 799725 431593 388681 436693 472409 508833 814330 816168 575757 548671 556504 570114 576165 701049 679037 679040 688967 569103 601871 585993 610376 803035 807478 809868 742643 769452 733672 758030 778986 437244 325936 523971 452963 509491 497585 461862 552357 560794 667942 561710 576102 599140 405705 444348 411526 517332 489355 500222 508826 512819 518605 487131 496164 513272 577433 814401 487372 561640 568359 548678 561658 561707 570029 574810 664437 706851 709578 713918 672842 704153 719461 573790 578858 602782 777770 787488 792232 795983 810465 741203 742096 773703 781665 783836 765845 739089 778119 106162 447064 468889 461526 411693 423306 438091 479963 436942 511713 522590 522755 502895 508107 508866 528837 491371 506765 508850 513284 491513 491671 496160 543756 477147 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.37%) |
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 106162 325936 388681 405705 411526 411693 423306 431593 436693 436942 437244 438091 444348 447064 452963 461526 461862 468889 472409 477147 479963 487131 487372 489355 491371 491513 491671 496160 496164 497585 500222 502895 506765 508107 508826 508833 508850 508866 509491 511713 512819 513272 513284 517332 518605 522590 522755 523971 528837 543756 548671 548678 552357 556504 560794 561640 561658 561707 561710 568359 569103 570029 570114 573790 574810 575757 576102 576165 577433 578858 585993 599140 601871 602782 610376 664437 667942 672842 679037 679040 688967 701049 704153 706851 709578 713918 719461 732873 733672 739089 741203 742096 742643 751539 758030 765845 767329 768462 768739 769017 769452 771289 773703 777770 778119 778986 781665 783836 787488 787973 792232 795983 799725 803035 807478 809868 810465 814330 814401 816168 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian dirty"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск dirty"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск dirty"
]
|
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.