Query Metrics
7
Database Queries
7
Different statements
690.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
424.49 ms (61.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
246.47 ms (35.68%) |
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 385596 386371 389733 417028 417947 419221 419839 431471 447683 450939 452599 456649 456807 458781 464252 465471 467333 473474 474864 485035 490665 491347 496854 516534 519504 519624 520688 523897 527119 543246 551209 551602 556949 561753 561755 563177 565205 583314 595950 603612 612534 613263 617692 641418 646915 671492 678989 681122 683428 686088 699166 709639 711327 716247 720564 724430 724475 724609 725063 726582 727473 727541 730249 730849 731752 733274 733813 734363 734364 734397 736402 738020 738830 743047 744149 744829 748997 750576 756458 759693 761883 764507 768896 768988 780376 783818 784356 785722 788811 788877 790383 792892 793218 794182 794490 795095 796560 800360 801881 803267 803677 808690 814289 814378 815698 817229 818455 818592 819388 821360 821541 823634 823643 823754 824414 824541 824845 825054 825204 826350 ] |
||||||||||||||||||||||||||||||
|
11.52 ms (1.67%) |
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 385596 821541 817229 824541 823643 551602 699166 556949 583314 795095 733813 744149 794182 738020 761883 780376 815698 491347 551209 565205 794490 801881 756458 819388 386371 814378 523897 681122 790383 803677 748997 750576 724475 764507 796560 419839 727473 465471 527119 490665 516534 683428 612534 641418 467333 646915 730849 520688 716247 730249 736402 726582 768988 823754 603612 744829 561755 788877 824414 824845 543246 711327 671492 678989 720564 783818 800360 724430 725063 759693 727541 743047 768896 617692 709639 784356 793218 431471 450939 458781 496854 826350 419221 823634 821360 447683 485035 464252 803267 734397 417947 452599 519624 389733 417028 818455 825054 814289 456807 474864 792892 724609 733274 785722 788811 734364 738830 808690 456649 473474 825204 563177 731752 561753 734363 519504 818592 613263 595950 686088 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (0.41%) |
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 385596 386371 389733 417028 417947 419221 419839 431471 447683 450939 452599 456649 456807 458781 464252 465471 467333 473474 474864 485035 490665 491347 496854 516534 519504 519624 520688 523897 527119 543246 551209 551602 556949 561753 561755 563177 565205 583314 595950 603612 612534 613263 617692 641418 646915 671492 678989 681122 683428 686088 699166 709639 711327 716247 720564 724430 724475 724609 725063 726582 727473 727541 730249 730849 731752 733274 733813 734363 734364 734397 736402 738020 738830 743047 744149 744829 748997 750576 756458 759693 761883 764507 768896 768988 780376 783818 784356 785722 788811 788877 790383 792892 793218 794182 794490 795095 796560 800360 801881 803267 803677 808690 814289 814378 815698 817229 818455 818592 819388 821360 821541 823634 823643 823754 824414 824541 824845 825054 825204 826350 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие pussy лиза"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big pussy lick"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.22%) |
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.