Query Metrics
7
Database Queries
7
Different statements
154.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.50 ms (83.00%) |
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 150488 191106 400470 400519 409310 413111 418073 421820 421835 421853 421873 422197 423929 424121 428855 433281 447793 448718 448932 449929 453293 454472 455809 456831 458727 465201 465276 466683 468920 479112 482230 484615 493187 496218 497161 502717 508230 517823 518944 527147 545644 547833 549656 552758 562957 562960 563003 569411 571044 577179 586104 598891 618908 618960 619540 620307 621746 623649 624286 629830 636039 660006 662213 663768 670748 685034 689373 698235 704925 712335 712683 712951 714860 714884 716299 718048 720603 720604 721580 725352 726815 726873 747094 759012 761134 761756 770478 778010 785426 786428 788281 788588 788608 788875 788885 794106 796044 797015 798529 799076 799960 801527 801775 802256 803776 804965 805367 805497 807401 808452 810062 813628 813916 816476 816695 817692 819919 824585 824673 826015 ] |
||||||||||||||||||||||||||||||
|
17.27 ms (11.16%) |
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 458727 466683 455809 518944 571044 562960 563003 569411 670748 714884 660006 620307 598891 618960 778010 794106 801527 803776 804965 805367 747094 698235 716299 720603 786428 788281 447793 453293 496218 816476 824585 456831 712335 400470 813916 826015 465201 468920 493187 718048 689373 704925 720604 623649 624286 788875 807401 726873 770478 726815 785426 788588 788885 400519 482230 508230 502717 423929 421835 424121 448932 449929 497161 527147 562957 663768 552758 618908 802256 788608 798529 799960 805497 761134 761756 801775 413111 433281 421873 418073 422197 428855 421853 636039 808452 725352 813628 819919 816695 817692 824673 586104 796044 797015 799076 759012 629830 810062 479112 421820 409310 484615 150488 191106 454472 465276 448718 517823 545644 547833 549656 577179 685034 721580 662213 712683 712951 714860 619540 621746 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.29%) |
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 150488 191106 400470 400519 409310 413111 418073 421820 421835 421853 421873 422197 423929 424121 428855 433281 447793 448718 448932 449929 453293 454472 455809 456831 458727 465201 465276 466683 468920 479112 482230 484615 493187 496218 497161 502717 508230 517823 518944 527147 545644 547833 549656 552758 562957 562960 563003 569411 571044 577179 586104 598891 618908 618960 619540 620307 621746 623649 624286 629830 636039 660006 662213 663768 670748 685034 689373 698235 704925 712335 712683 712951 714860 714884 716299 718048 720603 720604 721580 725352 726815 726873 747094 759012 761134 761756 770478 778010 785426 786428 788281 788588 788608 788875 788885 794106 796044 797015 798529 799076 799960 801527 801775 802256 803776 804965 805367 805497 807401 808452 810062 813628 813916 816476 816695 817692 819919 824585 824673 826015 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother stepson"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин stepson"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин stepson"
]
|
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.