Query Metrics
7
Database Queries
7
Different statements
154.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.45 ms (79.69%) |
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 396740 396786 397478 408460 411212 413685 415303 416694 416820 418035 421152 423783 424593 425820 427716 435624 441080 441101 449070 456219 461924 469221 477762 478055 482940 483704 493696 495747 508430 512931 512939 512994 513562 525700 530026 531285 531868 534777 538963 540269 540868 541099 541755 545465 546987 564686 575445 579457 583665 586587 592576 595428 599966 600337 604061 613860 614029 619167 619367 624942 627409 627472 628363 630280 630533 630764 634157 635258 639760 642060 647854 647895 647905 647936 647942 666880 666902 666904 668305 672850 693502 702629 708714 713163 715818 720103 720756 731692 735776 738817 744021 744896 748965 749924 750148 750426 750582 752623 752652 752752 759340 762714 765484 770253 770254 771623 778230 786872 790219 791012 793588 797006 801275 801722 805642 806924 808327 808641 826475 ] |
||||||||||||||||||||||||||||||
|
19.06 ms (12.30%) |
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 595428 715818 627472 418035 672850 770254 801722 619167 513562 541755 668305 778230 759340 738817 627409 534777 708714 770253 791012 771623 531285 647854 797006 493696 525700 397478 702629 540868 441101 449070 541099 808327 461924 530026 546987 545465 750582 630533 628363 600337 495747 752752 411212 619367 396786 456219 634157 750148 808641 483704 508430 538963 720756 786872 540269 793588 586587 647942 647936 613860 564686 614029 604061 630280 416694 512939 477762 647895 666904 423783 415303 482940 512931 512994 735776 762714 413685 693502 421152 531868 806924 666880 750426 592576 749924 731692 478055 647905 666902 635258 579457 713163 752652 744021 416820 435624 624942 642060 807580 427716 396740 826475 720103 765484 583665 424593 752623 805642 469221 441080 801275 790219 599966 630764 639760 575445 744896 748965 425820 408460 ] |
||||||||||||||||||||||||||||||
|
4.14 ms (2.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 396740 396786 397478 408460 411212 413685 415303 416694 416820 418035 421152 423783 424593 425820 427716 435624 441080 441101 449070 456219 461924 469221 477762 478055 482940 483704 493696 495747 508430 512931 512939 512994 513562 525700 530026 531285 531868 534777 538963 540269 540868 541099 541755 545465 546987 564686 575445 579457 583665 586587 592576 595428 599966 600337 604061 613860 614029 619167 619367 624942 627409 627472 628363 630280 630533 630764 634157 635258 639760 642060 647854 647895 647905 647936 647942 666880 666902 666904 668305 672850 693502 702629 708714 713163 715818 720103 720756 731692 735776 738817 744021 744896 748965 749924 750148 750426 750582 752623 752652 752752 759340 762714 765484 770253 770254 771623 778230 786872 790219 791012 793588 797006 801275 801722 805642 806924 808327 808641 826475 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen extreme squirt"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen хардкор сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen хардкор сквирт оргазм"
]
|
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.