Query Metrics
7
Database Queries
7
Different statements
228.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.83 ms (90.00%) |
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 480692 485990 509967 513935 527159 534677 535557 538880 546281 578759 583680 585583 588849 589325 594911 606996 609188 611782 615411 616137 618135 622944 627514 627772 628739 632503 633867 635726 636438 637364 638430 639078 639149 639394 641101 642900 644100 667796 669444 685391 698238 713449 715838 719635 721900 724971 726370 726929 728719 728735 729290 729669 732626 732725 732806 734247 735291 735489 735667 735885 736705 736765 736780 736886 737686 739280 739376 740749 740905 741023 741111 741766 742718 745142 745176 745584 745711 747762 748157 749679 753928 758321 759623 761014 761021 762009 769257 769429 770706 773830 777198 780876 781334 782334 782359 783567 785282 785302 787101 787235 787470 791936 791988 792804 793880 794368 794859 795122 795615 798865 802754 804307 804866 805334 806300 809147 809183 812407 812520 813743 ] |
||||||||||||||||||||||||||||||
|
12.22 ms (5.34%) |
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 546281 588849 611782 616137 632503 636438 637364 639078 641101 589325 594911 609188 615411 618135 622944 644100 627772 628739 606996 627514 639149 783567 785302 791988 793880 794859 795615 798865 802754 804307 805334 812407 781334 785282 791936 792804 809183 729290 734247 735489 735667 739280 739376 758321 769257 770706 787101 787235 795122 806300 812520 729669 735291 736765 736780 741111 759623 769429 724971 736705 737686 742718 745176 745584 745711 753928 762009 726370 732626 732725 745142 747762 773830 728735 735885 736886 740749 740905 741023 749679 761014 761021 635726 698238 721900 777198 782334 782359 804866 585583 732806 685391 639394 642900 633867 748157 715838 713449 638430 728719 726929 741766 583680 809147 719635 667796 669444 787470 578759 780876 794368 813743 480692 485990 509967 538880 513935 527159 534677 535557 ] |
||||||||||||||||||||||||||||||
|
3.59 ms (1.57%) |
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 480692 485990 509967 513935 527159 534677 535557 538880 546281 578759 583680 585583 588849 589325 594911 606996 609188 611782 615411 616137 618135 622944 627514 627772 628739 632503 633867 635726 636438 637364 638430 639078 639149 639394 641101 642900 644100 667796 669444 685391 698238 713449 715838 719635 721900 724971 726370 726929 728719 728735 729290 729669 732626 732725 732806 734247 735291 735489 735667 735885 736705 736765 736780 736886 737686 739280 739376 740749 740905 741023 741111 741766 742718 745142 745176 745584 745711 747762 748157 749679 753928 758321 759623 761014 761021 762009 769257 769429 770706 773830 777198 780876 781334 782334 782359 783567 785282 785302 787101 787235 787470 791936 791988 792804 793880 794368 794859 795122 795615 798865 802754 804307 804866 805334 806300 809147 809183 812407 812520 813743 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"шлюх жен"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"шлюхи жены"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"шлюх жен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.69%) |
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.