Query Metrics
7
Database Queries
7
Different statements
379.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.83 ms (55.28%) |
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 329912 340613 381805 392319 397655 400534 411043 416037 418564 418594 418607 418793 422302 425268 425895 428082 432656 438952 441952 446780 448678 452318 454083 454311 454533 454641 454767 457098 457950 465680 469561 470427 471707 473398 474425 477519 479972 480359 483466 484952 486949 490067 494491 494911 495561 499746 500620 512920 515465 526289 527067 527427 528077 528871 529617 529860 548185 560804 577340 584193 586421 628065 644206 650213 668685 669574 677259 749646 793376 793425 798888 800051 802600 806257 808274 809046 810366 813639 813825 813862 814472 814532 814540 816614 817378 817384 818166 818255 818540 818879 818976 818979 819656 819661 819663 819761 820022 820084 820085 820098 820124 820308 824041 824306 824583 824683 824699 824896 824989 825020 825219 825261 825376 825440 825448 826054 826244 826815 827553 827741 ] |
||||||||||||||||||||||||||||||
|
144.99 ms (38.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 329912 340613 381805 392319 397655 400534 411043 416037 418564 418594 418607 418793 422302 425268 425895 428082 432656 438952 441952 446780 448678 452318 454083 454311 454533 454641 454767 457098 457950 465680 469561 470427 471707 473398 474425 477519 479972 480359 483466 484952 486949 490067 494491 494911 495561 499746 500620 512920 515465 526289 527067 527427 528077 528871 529617 529860 548185 560804 577340 584193 586421 628065 644206 650213 668685 669574 677259 749646 793376 793425 798888 800051 802600 806257 808274 809046 810366 813639 813825 813862 814472 814532 814540 816614 817378 817384 818166 818255 818540 818879 818976 818979 819656 819661 819663 819761 820022 820084 820085 820098 820124 820308 824041 824306 824583 824683 824699 824896 824989 825020 825219 825261 825376 825440 825448 826054 826244 826815 827553 827741 ] |
||||||||||||||||||||||||||||||
|
18.23 ms (4.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 798888 800051 802600 806257 808274 810366 381805 457098 479972 446780 512920 529860 548185 340613 454083 483466 329912 397655 422302 432656 441952 428082 418564 454533 470427 486949 473398 484952 448678 454311 528077 494911 500620 529617 469561 480359 584193 586421 644206 809046 465680 477519 425895 438952 411043 471707 515465 527427 527067 526289 418594 452318 474425 494491 668685 669574 677259 628065 793376 793425 749646 418607 457950 490067 560804 418793 454641 454767 528871 577340 650213 416037 499746 495561 392319 400534 425268 814532 818255 818540 818976 824041 825020 813639 825376 826054 813862 814540 818166 818879 819663 820022 820084 820124 820308 824306 824989 825219 826244 826815 827553 827741 813825 814472 816614 817378 817384 818979 819656 819661 820085 824896 819761 820098 824583 824683 824699 825261 825440 825448 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina webcam"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.38%) |
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.