Query Metrics
7
Database Queries
7
Different statements
229.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.16 ms (86.65%) |
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 8028 33443 88661 154123 154512 154535 155198 382014 382121 383920 401816 402631 407436 410310 412149 416173 419579 422208 426592 427027 439641 440995 443233 443251 443299 444924 446016 448632 448821 454215 462845 466316 467451 469690 470622 470944 471165 473869 473923 474559 475169 476158 480719 482377 504133 508547 511313 511856 513794 513962 513977 515726 515916 518597 518599 518611 521438 529485 532530 535432 536248 542012 548538 550536 550571 557872 558158 560408 565539 569258 577520 580782 583997 586690 587208 590408 590809 590884 592773 593039 593296 594230 597148 598859 600915 602329 607706 612091 620323 620620 622375 630054 633445 636730 639024 641807 648649 663956 667397 668292 683297 695869 705007 720927 735778 738475 739127 740167 745874 754994 784147 788594 788931 792600 796640 797341 800543 803009 803608 808265 ] |
||||||||||||||||||||||||||||||
|
19.56 ms (8.51%) |
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 469690 440995 473869 590809 475169 422208 565539 513962 474559 583997 663956 482377 515726 720927 426592 419579 470944 470622 467451 466316 633445 515916 439641 521438 542012 535432 508547 536248 473923 448632 454215 622375 448821 529485 560408 548538 550571 504133 590884 444924 480719 443299 511313 586690 735778 518597 598859 518599 597148 471165 620620 590408 788594 33443 792600 803009 154123 784147 641807 401816 513794 600915 602329 797341 740167 800543 382121 754994 154512 410310 668292 592773 639024 383920 580782 593296 739127 648649 402631 745874 667397 443233 607706 412149 462845 382014 513977 407436 593039 8028 587208 155198 416173 427027 511856 620323 443251 636730 532530 558158 683297 695869 796640 808265 557872 612091 154535 803608 88661 738475 788931 569258 577520 550536 518611 705007 630054 594230 476158 446016 ] |
||||||||||||||||||||||||||||||
|
3.95 ms (1.72%) |
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 8028 33443 88661 154123 154512 154535 155198 382014 382121 383920 401816 402631 407436 410310 412149 416173 419579 422208 426592 427027 439641 440995 443233 443251 443299 444924 446016 448632 448821 454215 462845 466316 467451 469690 470622 470944 471165 473869 473923 474559 475169 476158 480719 482377 504133 508547 511313 511856 513794 513962 513977 515726 515916 518597 518599 518611 521438 529485 532530 535432 536248 542012 548538 550536 550571 557872 558158 560408 565539 569258 577520 580782 583997 586690 587208 590408 590809 590884 592773 593039 593296 594230 597148 598859 600915 602329 607706 612091 620323 620620 622375 630054 633445 636730 639024 641807 648649 663956 667397 668292 683297 695869 705007 720927 735778 738475 739127 740167 745874 754994 784147 788594 788931 792600 796640 797341 800543 803009 803608 808265 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo big tits"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.68%) |
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.