Query Metrics
7
Database Queries
7
Different statements
216.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.00 ms (88.20%) |
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 235834 382456 391302 391949 392729 397329 411715 417461 424023 428475 443178 443370 449125 453624 462506 462690 463771 464283 464303 466187 467767 473252 474842 477409 477958 480957 491200 504764 506445 507772 509077 511889 512044 515201 515203 523680 526390 527116 530578 534126 541250 542942 543694 551157 552534 562114 568440 580276 583210 584666 586789 591418 595654 598696 605841 606258 609712 615622 617603 622509 624508 628811 645965 648729 672744 673260 675424 684096 686082 692337 693341 694154 701508 702320 707881 710001 726556 732775 733295 736866 740489 743009 744711 747954 750205 750782 753548 753677 757278 758723 761592 761862 762559 766687 770444 775284 775630 786715 787950 788948 789837 789870 790101 794974 800275 800305 800377 801305 803144 803244 803261 807663 811866 813660 816764 817482 821870 825260 825694 827328 ] |
||||||||||||||||||||||||||||||
|
13.91 ms (6.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 541250 391949 480957 462690 534126 598696 512044 392729 701508 684096 686082 586789 811866 428475 761592 543694 788948 726556 750205 515203 491200 515201 443370 817482 821870 825694 827328 816764 463771 474842 464283 467767 507772 509077 523680 542942 562114 568440 583210 584666 552534 693341 707881 675424 710001 617603 606258 609712 624508 595654 775630 789870 794974 786715 790101 801305 803144 803261 770444 787950 800305 800377 736866 740489 750782 732775 743009 753548 761862 762559 753677 744711 747954 702320 775284 800275 803244 807663 424023 466187 477409 477958 462506 235834 473252 443178 453624 758723 417461 530578 526390 506445 825260 551157 628811 382456 673260 391302 813660 645965 789837 648729 766687 504764 511889 580276 672744 692337 605841 615622 622509 591418 733295 757278 449125 464303 411715 397329 527116 694154 ] |
||||||||||||||||||||||||||||||
|
4.02 ms (1.85%) |
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 235834 382456 391302 391949 392729 397329 411715 417461 424023 428475 443178 443370 449125 453624 462506 462690 463771 464283 464303 466187 467767 473252 474842 477409 477958 480957 491200 504764 506445 507772 509077 511889 512044 515201 515203 523680 526390 527116 530578 534126 541250 542942 543694 551157 552534 562114 568440 580276 583210 584666 586789 591418 595654 598696 605841 606258 609712 615622 617603 622509 624508 628811 645965 648729 672744 673260 675424 684096 686082 692337 693341 694154 701508 702320 707881 710001 726556 732775 733295 736866 740489 743009 744711 747954 750205 750782 753548 753677 757278 758723 761592 761862 762559 766687 770444 775284 775630 786715 787950 788948 789837 789870 790101 794974 800275 800305 800377 801305 803144 803244 803261 807663 811866 813660 816764 817482 821870 825260 825694 827328 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young old homemade"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young old домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young old домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.73%) |
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.