Query Metrics
7
Database Queries
7
Different statements
375.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.57 ms (56.33%) |
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 73571 183401 256371 384315 388312 388322 398444 441798 480593 490324 496709 512217 545735 561488 566459 567737 574090 574524 579507 580361 589604 590441 591780 598592 613710 617115 617968 621412 627052 627961 628340 635133 638949 650669 652734 668023 670815 680650 683679 689399 697587 697763 698233 700860 701059 703255 711918 715291 715469 717697 720900 724806 724920 730967 732247 735481 739186 740082 742540 743188 744713 746624 747273 748107 752112 752912 753304 753327 753405 754654 759051 761918 763524 768699 770729 770820 771606 771873 773596 773809 776823 777835 778600 779132 780412 782025 786069 788477 791657 791676 793674 793826 794623 795885 796937 797606 799398 800648 801398 801859 801881 805106 805394 807380 810655 814723 815848 818465 818927 819978 820534 820561 823605 823977 824958 825916 826017 826988 827167 828398 ] |
||||||||||||||||||||||||||||||
|
142.39 ms (37.91%) |
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 73571 183401 256371 384315 388312 388322 398444 441798 480593 490324 496709 512217 545735 561488 566459 567737 574090 574524 579507 580361 589604 590441 591780 598592 613710 617115 617968 621412 627052 627961 628340 635133 638949 650669 652734 668023 670815 680650 683679 689399 697587 697763 698233 700860 701059 703255 711918 715291 715469 717697 720900 724806 724920 730967 732247 735481 739186 740082 742540 743188 744713 746624 747273 748107 752112 752912 753304 753327 753405 754654 759051 761918 763524 768699 770729 770820 771606 771873 773596 773809 776823 777835 778600 779132 780412 782025 786069 788477 791657 791676 793674 793826 794623 795885 796937 797606 799398 800648 801398 801859 801881 805106 805394 807380 810655 814723 815848 818465 818927 819978 820534 820561 823605 823977 824958 825916 826017 826988 827167 828398 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (3.80%) |
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 759051 773596 730967 746624 742540 753405 795885 797606 810655 73571 598592 388312 398444 815848 814723 818465 580361 650669 680650 715291 590441 617968 782025 793826 788477 793674 801881 724920 735481 441798 388322 490324 512217 561488 566459 617115 621412 384315 256371 183401 820561 825916 826017 819978 820534 823977 826988 827167 818927 823605 828398 824958 496709 480593 545735 579507 574090 683679 697763 701059 668023 689399 715469 720900 652734 670815 698233 700860 717697 567737 574524 635133 638949 591780 613710 627961 589604 628340 777835 778600 779132 780412 794623 796937 799398 776823 786069 791676 801398 801859 805106 805394 807380 791657 800648 753304 753327 761918 771606 743188 747273 752112 754654 732247 739186 763524 768699 771873 724806 740082 744713 748107 752912 770729 770820 773809 627052 697587 703255 711918 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy hot"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy hot"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy hot"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.43%) |
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.