Query Metrics
7
Database Queries
7
Different statements
219.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.59 ms (87.23%) |
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 382816 429614 443366 464775 493007 493561 497840 509724 523515 526425 537007 538439 539350 540193 544622 547143 558729 564669 567312 577112 580462 590656 591796 593697 597931 600710 601177 604512 609536 612152 613154 613277 613440 615514 616887 616926 624304 625065 632395 635787 636873 636981 641490 642917 642949 645794 649034 650572 652494 653661 656816 666421 669692 672800 672867 673872 688805 693366 697456 705306 707297 708170 708915 709528 710949 711620 713051 713710 713724 720024 724003 724795 725275 726055 727309 731268 732728 735640 737265 740298 744361 746877 747003 747793 753203 754638 761239 765920 765930 767249 768228 778074 782436 784658 786885 787985 789257 789498 790261 791287 791422 792821 793302 794740 796016 796335 796477 796597 801510 804911 805641 809273 809365 817603 818112 818847 819180 820371 823653 826646 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (6.91%) |
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 801510 805641 791287 793302 804911 731268 761239 765930 809365 817603 669692 708170 782436 753203 747793 724003 744361 740298 754638 796597 540193 564669 613277 635787 523515 497840 645794 653661 693366 697456 711620 713710 713724 650572 652494 672867 705306 707297 709528 673872 688805 615514 591796 593697 600710 613154 597931 601177 616887 636873 636981 590656 632395 641490 642917 642949 786885 724795 727309 604512 612152 613440 493007 649034 624304 737265 537007 547143 580462 708915 429614 818112 823653 493561 539350 544622 567312 558729 796016 796335 746877 790261 726055 732728 747003 767249 710949 382816 809273 616926 787985 826646 820371 509724 526425 720024 794740 784658 768228 791422 443366 464775 538439 656816 796477 789257 789498 725275 765920 735640 778074 666421 672800 713051 609536 625065 819180 577112 818847 792821 ] |
||||||||||||||||||||||||||||||
|
4.58 ms (2.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur condom sex"
]
|
||||||||||||||||||||||||||||||
|
3.52 ms (1.60%) |
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 382816 429614 443366 464775 493007 493561 497840 509724 523515 526425 537007 538439 539350 540193 544622 547143 558729 564669 567312 577112 580462 590656 591796 593697 597931 600710 601177 604512 609536 612152 613154 613277 613440 615514 616887 616926 624304 625065 632395 635787 636873 636981 641490 642917 642949 645794 649034 650572 652494 653661 656816 666421 669692 672800 672867 673872 688805 693366 697456 705306 707297 708170 708915 709528 710949 711620 713051 713710 713724 720024 724003 724795 725275 726055 727309 731268 732728 735640 737265 740298 744361 746877 747003 747793 753203 754638 761239 765920 765930 767249 768228 778074 782436 784658 786885 787985 789257 789498 790261 791287 791422 792821 793302 794740 796016 796335 796477 796597 801510 804911 805641 809273 809365 817603 818112 818847 819180 820371 823653 826646 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск condom секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск condom секс"
]
|
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.