Query Metrics
7
Database Queries
7
Different statements
152.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.31 ms (86.37%) |
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 73413 185435 233274 370957 381747 383971 386331 387179 395427 398704 402822 413770 423781 423799 427813 428141 432429 434242 437564 441691 447250 447711 448253 449854 449862 453661 453944 455391 458109 458534 459077 461286 472074 475607 477605 479296 485062 485605 486053 486423 487316 488931 489269 495322 498247 498557 499719 506755 507030 508223 521736 525304 527461 529507 531442 535241 535846 535905 538218 552208 555750 556174 557223 557963 563190 566842 568964 569803 570276 573413 573592 574626 577486 580270 581186 581511 582383 584869 586687 587061 587134 588415 591286 591563 592073 592323 594510 595554 595664 597126 597767 597946 607299 608900 616916 616936 624514 625217 644626 648202 651548 651563 652623 652784 653460 656744 662823 664836 665889 673704 677862 677906 695924 699449 700915 707082 740577 748042 791186 813467 ] |
||||||||||||||||||||||||||||||
|
10.95 ms (7.20%) |
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 506755 580270 700915 387179 644626 586687 485062 563190 459077 597946 597126 383971 185435 398704 423781 427813 413770 441691 437564 447711 449862 458109 475607 449854 477605 488931 447250 448253 453944 458534 461286 472074 495322 507030 525304 527461 499719 535905 521736 535241 535846 486053 557963 581186 556174 569803 573413 552208 557223 566842 570276 574626 581511 584869 651548 651563 699449 648202 662823 677862 707082 652623 652784 653460 656744 677906 568964 577486 595554 595664 597767 607299 608900 588415 591563 616936 587061 587134 616916 624514 592073 592323 594510 791186 813467 748042 740577 625217 386331 453661 455391 479296 381747 432429 233274 402822 423799 434242 487316 498557 508223 538218 485605 486423 489269 498247 529507 73413 395427 370957 428141 531442 582383 555750 573592 665889 673704 664836 695924 591286 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.57%) |
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 73413 185435 233274 370957 381747 383971 386331 387179 395427 398704 402822 413770 423781 423799 427813 428141 432429 434242 437564 441691 447250 447711 448253 449854 449862 453661 453944 455391 458109 458534 459077 461286 472074 475607 477605 479296 485062 485605 486053 486423 487316 488931 489269 495322 498247 498557 499719 506755 507030 508223 521736 525304 527461 529507 531442 535241 535846 535905 538218 552208 555750 556174 557223 557963 563190 566842 568964 569803 570276 573413 573592 574626 577486 580270 581186 581511 582383 584869 586687 587061 587134 588415 591286 591563 592073 592323 594510 595554 595664 597126 597767 597946 607299 608900 616916 616936 624514 625217 644626 648202 651548 651563 652623 652784 653460 656744 662823 664836 665889 673704 677862 677906 695924 699449 700915 707082 740577 748042 791186 813467 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"наездниц поз молодые"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сверху молодые"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"наездниц поз молодые"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.00%) |
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.