Query Metrics
7
Database Queries
7
Different statements
187.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.17 ms (81.34%) |
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 233187 386493 389616 393453 395577 395897 396344 396768 397483 398555 398803 402266 404503 405082 405107 407783 408207 409784 411397 411690 411702 411704 411717 411781 413303 413454 413455 413476 414651 415847 422853 422876 422970 423129 424429 426152 430748 437804 443177 443408 443756 453162 456638 460759 465395 465397 466350 466821 467034 468756 470792 470977 471078 471355 471710 474399 474478 474499 477985 484462 484560 485706 485764 487360 487933 490013 490187 492572 493093 494426 499774 502718 504036 504546 506665 514730 516811 517264 520733 525998 526701 526733 532052 541332 544479 550774 557932 558297 563148 563875 565994 590303 598979 606749 608345 608358 649527 663503 667021 667898 668901 669753 674683 678766 698428 698941 702158 716078 725578 744232 744475 748467 780724 788756 806291 808180 810102 816822 818045 824588 ] |
||||||||||||||||||||||||||||||
|
24.47 ms (13.08%) |
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 456638 468756 402266 405082 405107 409784 411704 422853 422876 422970 437804 465395 470792 430748 474478 506665 516811 484462 504546 520733 485764 494426 541332 504036 517264 466821 398555 716078 499774 414651 426152 453162 492572 550774 563875 467034 393453 395577 395897 389616 397483 398803 408207 413476 423129 413455 816822 818045 824588 525998 532052 565994 544479 667021 668901 669753 698941 674683 678766 698428 702158 649527 608345 606749 788756 744232 744475 806291 808180 810102 725578 748467 477985 396768 411397 471078 413454 514730 386493 233187 407783 411781 413303 415847 411690 411702 443177 490187 471710 526701 474499 490013 558297 563148 557932 590303 780724 424429 443756 460759 396344 404503 443408 465397 466350 471355 470977 474399 485706 484560 502718 608358 411717 487360 663503 667898 598979 487933 493093 526733 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.52%) |
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 233187 386493 389616 393453 395577 395897 396344 396768 397483 398555 398803 402266 404503 405082 405107 407783 408207 409784 411397 411690 411702 411704 411717 411781 413303 413454 413455 413476 414651 415847 422853 422876 422970 423129 424429 426152 430748 437804 443177 443408 443756 453162 456638 460759 465395 465397 466350 466821 467034 468756 470792 470977 471078 471355 471710 474399 474478 474499 477985 484462 484560 485706 485764 487360 487933 490013 490187 492572 493093 494426 499774 502718 504036 504546 506665 514730 516811 517264 520733 525998 526701 526733 532052 541332 544479 550774 557932 558297 563148 563875 565994 590303 598979 606749 608345 608358 649527 663503 667021 667898 668901 669753 674683 678766 698428 698941 702158 716078 725578 744232 744475 748467 780724 788756 806291 808180 810102 816822 818045 824588 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy old young"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая old young"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая old young"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.94%) |
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.