Query Metrics
7
Database Queries
7
Different statements
157.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.71 ms (79.75%) |
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 418714 420816 423784 425948 437188 437624 439312 439322 439427 440644 442234 442285 442307 442735 442783 443171 444913 445810 446695 447158 448140 448464 449173 450071 450255 451316 452373 452567 452843 456131 460016 463090 463693 463824 463976 464550 466439 466474 468232 475226 476314 476318 478022 478806 480234 483732 484743 489338 495984 497696 503712 506688 507935 508378 508713 508895 510783 510950 511640 512440 513808 513972 515034 517003 517496 521244 523762 525699 526556 527360 530437 534049 534839 539370 541409 541484 547468 549794 549800 568519 575601 579484 584806 587434 588608 598083 599485 601137 602317 602999 603251 604286 606154 608334 608491 614532 614549 614673 615835 620731 623333 636643 642403 646872 658907 660416 666355 666859 669038 674181 750121 752506 769150 772573 779840 802734 803046 810772 825864 ] |
||||||||||||||||||||||||||||||
|
22.01 ms (13.97%) |
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 423784 425948 452567 463090 437188 437624 463693 480234 478022 478806 508378 484743 508713 510950 517003 495984 539370 447158 440644 439312 442307 443171 439427 439322 450071 452373 460016 463824 466439 446695 449173 451316 475226 448140 507935 515034 517496 525699 530437 534839 541409 549794 568519 575601 579484 541484 547468 669038 658907 666859 646872 660416 666355 674181 549800 584806 614549 615835 587434 588608 602317 599485 608491 614532 598083 602999 604286 623333 642403 810772 779840 750121 769150 772573 752506 603251 620731 636643 802734 803046 444913 442234 442783 466474 476318 418714 463976 464550 442285 450255 521244 526556 527360 511640 523762 483732 510783 503712 601137 608334 420816 442735 825864 606154 614673 445810 452843 456131 448464 468232 489338 476314 497689 497696 512440 508895 513972 506688 513808 534049 ] |
||||||||||||||||||||||||||||||
|
2.40 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 418714 420816 423784 425948 437188 437624 439312 439322 439427 440644 442234 442285 442307 442735 442783 443171 444913 445810 446695 447158 448140 448464 449173 450071 450255 451316 452373 452567 452843 456131 460016 463090 463693 463824 463976 464550 466439 466474 468232 475226 476314 476318 478022 478806 480234 483732 484743 489338 495984 497696 503712 506688 507935 508378 508713 508895 510783 510950 511640 512440 513808 513972 515034 517003 517496 521244 523762 525699 526556 527360 530437 534049 534839 539370 541409 541484 547468 549794 549800 568519 575601 579484 584806 587434 588608 598083 599485 601137 602317 602999 603251 604286 606154 608334 608491 614532 614549 614673 615835 620731 623333 636643 642403 646872 658907 660416 666355 666859 669038 674181 750121 752506 769150 772573 779840 802734 803046 810772 825864 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo red hair"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло red hair"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло red hair"
]
|
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.