Query Metrics
7
Database Queries
7
Different statements
426.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.77 ms (49.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск mom shower"
]
|
||||||||||||||||||||||||||||||
|
189.80 ms (44.50%) |
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 391592 395750 409053 412618 421989 422147 427614 439743 441956 445790 447016 449079 450767 452215 452816 455273 457575 459783 460167 464915 465240 466129 466384 468982 472583 474891 477950 477989 478985 478986 478990 478991 479019 483394 483496 483654 487405 502729 506014 506833 509050 512555 516832 522231 523838 524626 524876 526527 538703 541561 541897 542289 542449 542742 563036 568465 568474 569015 569145 573739 580971 581566 581969 590730 592850 596189 602632 603890 604109 606625 606644 610587 618619 619204 621676 622667 633511 633923 654636 661976 677817 685579 689036 697909 702286 702966 726753 751567 756803 765821 768581 769487 771924 771961 772624 773255 773412 776462 776857 776940 778385 779610 783959 784922 785498 785856 787488 788184 789178 791501 791981 792343 799383 800936 801479 808633 809486 813249 816115 825762 ] |
||||||||||||||||||||||||||||||
|
16.58 ms (3.89%) |
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 765821 771961 778385 783959 799383 409053 474891 477950 621676 452215 465240 516832 460167 542289 563036 568474 606644 596189 633511 776857 787488 789178 791501 801479 772624 773255 809486 422147 441956 459783 478986 506014 483654 581566 756803 457575 427614 479019 697909 395750 702966 447016 606625 439743 483496 455273 522231 524626 541897 569015 541561 542449 661976 677817 592850 604109 618619 785856 792343 779610 751567 800936 813249 769487 773412 776462 477989 412618 464915 466129 523838 487405 502729 526527 808633 391592 816115 449079 452816 468982 466384 472583 568465 569145 580971 573739 581969 654636 702286 633923 602632 619204 784922 791981 726753 478985 478990 445790 509050 512555 524876 421989 685579 610587 622667 590730 483394 825762 478991 538703 506833 542742 689036 788184 768581 771924 603890 776940 785498 450767 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (0.81%) |
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 391592 395750 409053 412618 421989 422147 427614 439743 441956 445790 447016 449079 450767 452215 452816 455273 457575 459783 460167 464915 465240 466129 466384 468982 472583 474891 477950 477989 478985 478986 478990 478991 479019 483394 483496 483654 487405 502729 506014 506833 509050 512555 516832 522231 523838 524626 524876 526527 538703 541561 541897 542289 542449 542742 563036 568465 568474 569015 569145 573739 580971 581566 581969 590730 592850 596189 602632 603890 604109 606625 606644 610587 618619 619204 621676 622667 633511 633923 654636 661976 677817 685579 689036 697909 702286 702966 726753 751567 756803 765821 768581 769487 771924 771961 772624 773255 773412 776462 776857 776940 778385 779610 783959 784922 785498 785856 787488 788184 789178 791501 791981 792343 799383 800936 801479 808633 809486 813249 816115 825762 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade mom shower"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск mom shower"
]
|
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.