Query Metrics
7
Database Queries
7
Different statements
162.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.25 ms (82.80%) |
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 382355 417830 419101 427173 439588 447504 451141 451247 451816 454442 456703 457186 465345 466350 469580 470449 472493 472569 475870 487633 494312 494487 496674 500758 505806 507865 511793 512574 513699 513705 516651 522235 525204 525760 527377 528699 535426 538498 540252 549769 552971 553720 556326 565313 566862 570764 575932 580229 582920 587047 588661 589661 589696 589703 592095 593018 621729 624456 625873 625893 633468 639102 641624 648370 666583 682273 691820 696969 712475 712675 714147 726475 726478 726484 726505 726513 726528 726529 726534 726552 726673 726688 726699 726713 729930 729950 730986 737188 740101 741190 742860 746162 747591 753138 755030 755522 756703 757502 759738 766869 769160 782259 785096 789002 790795 795757 796088 796109 803106 805179 806884 810864 810906 810967 811963 812361 814210 814501 817917 825054 ] |
||||||||||||||||||||||||||||||
|
16.79 ms (10.35%) |
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 753138 427173 825054 580229 666583 746162 759738 756703 740101 538498 624456 729930 696969 714147 588661 639102 790795 810906 726534 747591 755522 769160 796088 806884 810864 726484 726552 726529 730986 742860 757502 782259 803106 419101 712475 726513 766869 456703 447504 535426 648370 691820 755030 417830 810967 811963 729950 814501 814210 817917 451247 457186 487633 511793 540252 556326 682273 712675 575932 625893 795757 796109 726505 726688 726478 737188 741190 466350 512574 513699 505806 472569 507865 726475 785096 472493 525204 587047 451141 454442 552971 570764 582920 589703 641624 592095 805179 726713 475870 513705 522235 525760 469580 549769 494487 516651 527377 528699 593018 633468 500758 565313 589696 726528 726699 726673 621729 789002 382355 439588 451816 470449 496674 566862 812361 494312 465345 553720 589661 625873 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.04%) |
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 382355 417830 419101 427173 439588 447504 451141 451247 451816 454442 456703 457186 465345 466350 469580 470449 472493 472569 475870 487633 494312 494487 496674 500758 505806 507865 511793 512574 513699 513705 516651 522235 525204 525760 527377 528699 535426 538498 540252 549769 552971 553720 556326 565313 566862 570764 575932 580229 582920 587047 588661 589661 589696 589703 592095 593018 621729 624456 625873 625893 633468 639102 641624 648370 666583 682273 691820 696969 712475 712675 714147 726475 726478 726484 726505 726513 726528 726529 726534 726552 726673 726688 726699 726713 729930 729950 730986 737188 740101 741190 742860 746162 747591 753138 755030 755522 756703 757502 759738 766869 769160 782259 785096 789002 790795 795757 796088 796109 803106 805179 806884 810864 810906 810967 811963 812361 814210 814501 817917 825054 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"delicious of ass"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"delicious жоп"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"delicious жоп"
]
|
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.