Query Metrics
7
Database Queries
7
Different statements
178.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.88 ms (85.51%) |
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 66611 79765 187516 187759 187964 188552 233641 250695 315945 358507 383169 391517 392679 395998 397885 397911 398563 399075 406018 406073 407707 407708 408207 409935 411249 411351 411385 411716 411718 411739 411907 411960 418059 424421 443334 443771 454184 466816 466872 470215 474680 479119 479133 482374 486350 544466 546962 549799 557998 558002 558005 560383 560394 563058 563209 563421 598988 616594 620256 645891 665095 665890 667281 668181 696415 703448 710510 710531 714153 718549 721427 724086 724476 726984 727050 727754 731686 733315 735032 735484 736402 737169 741080 741904 746890 748163 748213 748226 748240 748245 750159 761326 761563 766597 770139 770152 770913 777250 780613 780706 781019 781759 781970 782183 789528 790813 794679 794689 794830 797358 803498 803522 808040 810769 818638 818660 824362 824584 825420 826655 ] |
||||||||||||||||||||||||||||||
|
14.84 ms (8.30%) |
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 424421 466872 411351 470215 383169 315945 408207 411907 824362 825420 818660 826655 665890 598988 616594 620256 782183 777250 746890 731686 741904 727754 761563 733315 714153 486350 411718 549799 443771 443334 474680 188552 407708 558005 645891 667281 668181 794830 803498 748213 748245 479133 409935 358507 406073 411960 818638 560383 665095 718549 789528 790813 770139 726984 727050 735032 735484 766597 761326 710531 780706 781019 808040 392679 233641 411385 479119 66611 187516 391517 250695 187964 399075 411739 482374 703448 781970 797358 794689 741080 724086 770913 737169 794679 411249 187759 397885 406018 395998 79765 398563 411716 407707 418059 824584 454184 466816 560394 544466 563058 563209 563421 546962 557998 558002 696415 710510 721427 781759 803522 748226 724476 736402 750159 748163 770152 748240 780613 810769 397911 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.83%) |
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 66611 79765 187516 187759 187964 188552 233641 250695 315945 358507 383169 391517 392679 395998 397885 397911 398563 399075 406018 406073 407707 407708 408207 409935 411249 411351 411385 411716 411718 411739 411907 411960 418059 424421 443334 443771 454184 466816 466872 470215 474680 479119 479133 482374 486350 544466 546962 549799 557998 558002 558005 560383 560394 563058 563209 563421 598988 616594 620256 645891 665095 665890 667281 668181 696415 703448 710510 710531 714153 718549 721427 724086 724476 726984 727050 727754 731686 733315 735032 735484 736402 737169 741080 741904 746890 748163 748213 748226 748240 748245 750159 761326 761563 766597 770139 770152 770913 777250 780613 780706 781019 781759 781970 782183 789528 790813 794679 794689 794830 797358 803498 803522 808040 810769 818638 818660 824362 824584 825420 826655 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck mature"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс mature"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс mature"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.95%) |
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.