Query Metrics
7
Database Queries
7
Different statements
382.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.61 ms (55.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск шлюх"
]
|
||||||||||||||||||||||||||||||
|
148.41 ms (38.78%) |
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 391910 426725 479293 482882 482892 504464 507411 510309 527159 543680 545029 546907 555067 562299 563405 563583 570260 570371 579979 598445 601271 603961 610396 613433 618773 621400 621519 621671 622887 626862 626878 627059 629072 630737 640236 660074 678722 681355 682726 685391 686383 692288 692449 698238 701992 705360 705472 706542 709190 713323 713940 724891 727111 732725 732806 734052 736886 736975 736985 740597 741080 741766 742818 743030 743464 744890 746229 746699 752732 754052 754060 757613 757630 758035 762746 765941 766076 766717 769072 769952 770567 773830 777264 777663 778075 778088 778149 778932 779863 781512 781666 782120 782262 786620 787106 787496 788431 788866 789926 790075 790817 792438 793241 793765 796726 800003 800644 802554 804389 804896 805352 807290 807484 808794 809613 810532 810722 812131 813283 ] |
||||||||||||||||||||||||||||||
|
14.01 ms (3.66%) |
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 732725 773830 727111 736886 744890 629072 698238 777264 778088 781666 787106 800003 809613 482892 570371 563405 426725 479293 527159 504464 507411 510309 555067 543680 713323 686383 705360 713940 660074 678722 681355 682726 685391 692449 610396 627059 603961 626878 630737 778075 778149 786620 807484 808794 810722 778932 790075 792438 807290 787496 793241 804896 812131 754052 754060 769952 746229 757613 743030 746699 734052 743464 757630 758035 766717 706542 782120 800644 805352 692288 598445 740597 613433 391910 570260 742818 482882 546907 562299 545029 563583 701992 705472 709190 579979 598922 626862 640236 601271 622887 618773 621400 621519 621671 777663 788431 790817 793765 810532 779863 782262 788866 796726 802554 804389 724891 736975 752732 762746 769072 770567 781512 789926 813283 741080 765941 766076 732806 736985 741766 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (1.12%) |
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 391910 426725 479293 482882 482892 504464 507411 510309 527159 543680 545029 546907 555067 562299 563405 563583 570260 570371 579979 598445 601271 603961 610396 613433 618773 621400 621519 621671 622887 626862 626878 627059 629072 630737 640236 660074 678722 681355 682726 685391 686383 692288 692449 698238 701992 705360 705472 706542 709190 713323 713940 724891 727111 732725 732806 734052 736886 736975 736985 740597 741080 741766 742818 743030 743464 744890 746229 746699 752732 754052 754060 757613 757630 758035 762746 765941 766076 766717 769072 769952 770567 773830 777264 777663 778075 778088 778149 778932 779863 781512 781666 782120 782262 786620 787106 787496 788431 788866 789926 790075 790817 792438 793241 793765 796726 800003 800644 802554 804389 804896 805352 807290 807484 808794 809613 810532 810722 812131 813283 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русская шлюх"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск шлюх"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.35%) |
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.