Query Metrics
7
Database Queries
7
Different statements
151.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.06 ms (82.31%) |
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 261144 390761 391380 393082 396759 400931 404192 404311 404596 410393 412790 419526 422194 424193 428583 429416 431314 434254 443890 457468 465385 465545 469283 472691 474776 478074 478377 480415 486834 487368 490419 493195 501497 516226 518807 519063 519465 519573 523835 524497 537195 542247 545365 546687 555340 573763 580319 585332 591067 591862 597047 600339 603662 604468 605337 612917 613432 619645 620233 626293 629886 641687 642753 644189 644257 644306 646279 649516 651636 666869 668537 669341 671465 671764 678734 683139 700760 701192 703051 703509 705277 706622 712940 718945 720614 723153 734373 742588 748326 756228 757312 759946 761127 765517 765554 765817 766896 770127 770149 775772 775858 777003 777732 783392 784804 785530 787047 788119 789253 796957 800510 800937 801299 801348 801880 806078 807641 809421 812979 813533 ] |
||||||||||||||||||||||||||||||
|
17.35 ms (11.42%) |
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 723153 718945 720614 626293 620233 796957 800937 756228 807641 812979 765517 757312 765554 604468 642753 800510 801299 390761 465545 396759 393082 404192 429416 487368 523835 742588 516226 501497 428583 465385 486834 490419 537195 524497 542247 555340 671764 671465 644257 600339 806078 784804 766896 759946 518807 519573 493195 573763 591067 641687 612917 478074 597047 701192 422194 519063 585332 651636 591862 734373 700760 404596 434254 419526 474776 519465 580319 703051 646279 666869 678734 703509 705277 712940 649516 668537 669341 683139 545365 546687 603662 619645 644189 629886 605337 785530 801348 775772 775858 777732 787047 809421 783392 788119 770127 770149 748326 761127 765817 613432 644306 706622 777003 789253 801880 813533 410393 412790 424193 457468 472691 404311 391380 400931 443890 469283 261144 431314 478377 480415 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.67%) |
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 261144 390761 391380 393082 396759 400931 404192 404311 404596 410393 412790 419526 422194 424193 428583 429416 431314 434254 443890 457468 465385 465545 469283 472691 474776 478074 478377 480415 486834 487368 490419 493195 501497 516226 518807 519063 519465 519573 523835 524497 537195 542247 545365 546687 555340 573763 580319 585332 591067 591862 597047 600339 603662 604468 605337 612917 613432 619645 620233 626293 629886 641687 642753 644189 644257 644306 646279 649516 651636 666869 668537 669341 671465 671764 678734 683139 700760 701192 703051 703509 705277 706622 712940 718945 720614 723153 734373 742588 748326 756228 757312 759946 761127 765517 765554 765817 766896 770127 770149 775772 775858 777003 777732 783392 784804 785530 787047 788119 789253 796957 800510 800937 801299 801348 801880 806078 807641 809421 812979 813533 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom anal sperm"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom анал сперм"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom анал сперм"
]
|
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.