Query Metrics
7
Database Queries
7
Different statements
148.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.08 ms (84.86%) |
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 381952 389966 411325 424169 424214 424624 426908 436178 436230 439558 439584 440995 442155 443491 451149 454264 458051 463815 465918 465970 467763 470219 472418 473237 479106 495559 497536 498279 505242 506928 507638 508800 509078 514399 516719 521343 522689 524306 528452 532954 533732 535622 553480 554582 555127 562282 578834 582377 582697 599347 601058 613530 619935 629596 649528 651841 666446 666968 667011 667986 672825 681523 689498 693390 695096 695338 695477 697834 704020 705075 708130 719532 723204 729852 735250 740901 740912 741685 742409 745466 746135 747902 749929 751434 754184 754289 754843 755874 765158 765815 768240 774855 778273 779595 779870 780136 781429 782148 782272 784596 784792 786368 790648 791405 794700 799217 800727 800753 800767 802897 805643 806973 808319 808342 809689 810896 814980 825700 827723 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (9.68%) |
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 599347 629596 774855 782272 794700 740901 754184 729852 735250 765158 755874 768240 740912 747902 705075 723204 778273 782148 381952 827723 814980 533732 672825 704020 693390 695338 800767 746135 749929 781429 808342 742409 745466 754289 779595 779870 465918 442155 498279 443491 528452 532954 562282 389966 436230 800727 802897 582697 424214 495559 426908 463815 411325 508800 667986 554582 582377 689498 651841 578834 619935 613530 467763 524306 522689 439558 436178 505242 555127 451149 514399 513476 516719 506928 507638 521343 666968 472418 424169 465970 439584 470219 473237 479106 497536 535622 719532 681523 695477 697834 784792 786368 790648 810896 765815 751434 791405 799217 805643 809689 509078 424624 458051 440995 553480 454264 825700 667011 695096 649528 666446 708130 601058 784596 800753 806973 808319 741685 754843 780136 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.55%) |
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 381952 389966 411325 424169 424214 424624 426908 436178 436230 439558 439584 440995 442155 443491 451149 454264 458051 463815 465918 465970 467763 470219 472418 473237 479106 495559 497536 498279 505242 506928 507638 508800 509078 514399 516719 521343 522689 524306 528452 532954 533732 535622 553480 554582 555127 562282 578834 582377 582697 599347 601058 613530 619935 629596 649528 651841 666446 666968 667011 667986 672825 681523 689498 693390 695096 695338 695477 697834 704020 705075 708130 719532 723204 729852 735250 740901 740912 741685 742409 745466 746135 747902 749929 751434 754184 754289 754843 755874 765158 765815 768240 774855 778273 779595 779870 780136 781429 782148 782272 784596 784792 786368 790648 791405 794700 799217 800727 800753 800767 802897 805643 806973 808319 808342 809689 810896 814980 825700 827723 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие дилд русск"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие дилд русск"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dildo russian"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.84%) |
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.