Query Metrics
7
Database Queries
7
Different statements
160.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.01 ms (83.13%) |
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 383217 383500 385618 389703 390615 393836 401367 401810 403973 412721 414099 415879 416157 416174 416537 424765 427132 431439 438880 442337 443260 444064 444537 444896 448791 449921 452800 454368 454590 455080 456117 460765 469737 476656 476658 483730 498720 500338 505356 518508 518550 524215 526180 529617 529713 530402 531834 531877 532634 534447 534545 534563 534574 536129 540868 545439 545459 548153 552069 561019 564289 568501 574375 574377 574391 580130 583472 586402 586507 589185 592773 594619 595149 598692 609920 616454 616850 624682 628095 628105 628106 640052 648704 648705 648716 648784 660369 660380 662448 670360 671002 672952 676689 681196 708577 712268 715244 721257 728635 735703 739119 739123 749090 750426 751609 752679 758343 759324 770386 788863 791132 792712 792726 794303 806834 806938 814140 814151 ] |
||||||||||||||||||||||||||||||
|
15.54 ms (9.72%) |
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 598692 415879 443260 438880 424765 444537 452800 455080 448791 460765 469737 483730 505356 534574 500338 662448 648716 586402 416157 427132 518550 401367 412721 431439 416174 414099 540868 476656 454590 534545 531834 531877 532634 529617 534563 536129 530402 574375 574377 583472 545459 561019 574391 660380 660369 670360 672952 715244 580130 592773 589185 594619 624682 628105 609920 616454 749090 806938 739119 750426 752679 735703 751609 758343 628106 788863 456117 403973 524215 588152 628095 444896 721257 739123 766362 759324 548153 545439 518508 526180 393836 444064 385618 401810 728635 712268 794303 416537 442337 814140 814151 449921 476658 529713 568501 671002 648704 708577 564289 792726 770386 791132 792712 806834 383500 390615 389703 454368 498720 534447 616850 552069 383217 648784 648705 676689 681196 586507 640052 595149 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (2.32%) |
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 383217 383500 385618 389703 390615 393836 401367 401810 403973 412721 414099 415879 416157 416174 416537 424765 427132 431439 438880 442337 443260 444064 444537 444896 448791 449921 452800 454368 454590 455080 456117 460765 469737 476656 476658 483730 498720 500338 505356 518508 518550 524215 526180 529617 529713 530402 531834 531877 532634 534447 534545 534563 534574 536129 540868 545439 545459 548153 552069 561019 564289 568501 574375 574377 574391 580130 583472 586402 586507 589185 592773 594619 595149 598692 609920 616454 616850 624682 628095 628105 628106 640052 648704 648705 648716 648784 660369 660380 662448 670360 671002 672952 676689 681196 708577 712268 715244 721257 728635 735703 739119 739123 749090 750426 751609 752679 758343 759324 770386 788863 791132 792712 792726 794303 806834 806938 814140 814151 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur dildo"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск дилд"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.10%) |
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.