Query Metrics
7
Database Queries
7
Different statements
394.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.85 ms (51.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
162.10 ms (41.12%) |
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 12792 396628 401966 407760 408365 408413 411704 453559 453712 464456 469910 472223 510586 519683 529284 546120 558320 566981 588581 595451 596585 600384 606277 608352 609780 610174 611813 614849 620399 620912 621418 622622 623473 626539 630015 631980 635228 644194 644660 644698 645980 646939 648504 649161 662222 663321 663934 664274 664840 665476 666754 666848 667015 667525 668524 669593 671640 673607 674055 675424 678947 686792 693322 694188 694436 705263 709369 712810 714142 715423 717646 718416 721120 721496 726743 726789 727634 728451 729024 731035 732873 733324 733570 735872 743371 746667 746890 748392 758295 759609 760991 761576 763887 765996 766026 774508 775139 779135 781708 788573 788735 789603 790858 794829 796967 800708 802649 802836 803295 806246 807733 808015 815713 815778 816455 816784 820346 821560 823436 825054 ] |
||||||||||||||||||||||||||||||
|
18.03 ms (4.57%) |
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 566981 665476 705263 718416 646939 663934 666848 669593 673607 678947 694436 712810 714142 715423 721496 645980 648504 664274 666754 667015 674055 686792 693322 694188 717646 721120 546120 588581 606277 609780 620399 623473 644194 635228 644660 608352 621418 630015 614849 620912 774508 775139 779135 788735 794829 789603 796967 800708 802649 806246 808015 726743 727634 729024 733570 746667 746890 758295 765996 766026 781708 802836 761576 731035 726789 728451 759609 732873 733324 735872 748392 760991 763887 709369 790858 803295 807733 401966 469910 453712 396628 788573 743371 411704 12792 408413 407760 408365 815778 821560 825054 816784 820346 815713 816455 823436 453559 464456 519683 529284 510586 472223 558320 649161 663321 667525 662222 664840 671640 675424 668524 610174 611813 596585 626539 631980 644698 595451 600384 622622 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (0.64%) |
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 12792 396628 401966 407760 408365 408413 411704 453559 453712 464456 469910 472223 510586 519683 529284 546120 558320 566981 588581 595451 596585 600384 606277 608352 609780 610174 611813 614849 620399 620912 621418 622622 623473 626539 630015 631980 635228 644194 644660 644698 645980 646939 648504 649161 662222 663321 663934 664274 664840 665476 666754 666848 667015 667525 668524 669593 671640 673607 674055 675424 678947 686792 693322 694188 694436 705263 709369 712810 714142 715423 717646 718416 721120 721496 726743 726789 727634 728451 729024 731035 732873 733324 733570 735872 743371 746667 746890 748392 758295 759609 760991 761576 763887 765996 766026 774508 775139 779135 781708 788573 788735 789603 790858 794829 796967 800708 802649 802836 803295 806246 807733 808015 815713 815778 816455 816784 820346 821560 823436 825054 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп young"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп young"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass young"
]
|
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.