Query Metrics
7
Database Queries
7
Different statements
198.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.80 ms (86.60%) |
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 453194 457479 487555 489787 498907 498993 502298 503482 509144 509278 510364 516204 517130 517132 520526 521721 528498 528564 528765 529333 530169 531043 532510 535228 536134 536469 544023 545016 545232 546133 546484 546504 547031 549516 549653 550969 554248 554458 555036 555276 555352 555382 555568 557168 557962 559539 560891 561177 562970 563386 564912 568116 568908 569771 569783 571313 575570 576289 577271 579206 579433 579790 579857 580967 584440 585204 585680 586038 586254 586262 587395 588102 588234 588764 589580 589773 589954 592933 592983 593148 594100 594328 595017 595057 595674 599744 600404 601119 601399 601741 601835 605261 605649 610053 619555 621745 626112 626651 630104 639686 646721 646939 647129 650101 651803 664587 672873 681178 683047 687942 689002 690315 690894 707605 708297 721908 741769 759316 803740 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (7.77%) |
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 545232 546504 549653 563386 568116 575570 664587 721908 672873 681178 545016 579857 586038 586254 588102 457479 453194 509278 531043 521721 544023 546484 580967 584440 562970 646721 576289 595674 626112 593148 586262 589580 639686 498907 487555 579790 528498 528765 546133 568908 577271 690315 650101 564912 759316 741769 601119 510364 517132 520526 535228 536469 509144 532510 536134 503482 517130 528564 530169 489787 555382 559539 571313 547031 555352 557168 557962 707605 689002 690894 647129 683047 554248 579433 585680 610053 589954 599744 601741 605261 588764 601835 589773 600404 605649 803740 630104 529333 498993 516204 550969 555568 676582 560891 561177 585204 595057 601399 619555 592983 621745 594100 595017 587395 594328 626651 502298 555276 579206 549516 569771 554458 646939 687942 651803 708297 555036 569783 588234 592933 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (2.02%) |
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 453194 457479 487555 489787 498907 498993 502298 503482 509144 509278 510364 516204 517130 517132 520526 521721 528498 528564 528765 529333 530169 531043 532510 535228 536134 536469 544023 545016 545232 546133 546484 546504 547031 549516 549653 550969 554248 554458 555036 555276 555352 555382 555568 557168 557962 559539 560891 561177 562970 563386 564912 568116 568908 569771 569783 571313 575570 576289 577271 579206 579433 579790 579857 580967 584440 585204 585680 586038 586254 586262 587395 588102 588234 588764 589580 589773 589954 592933 592983 593148 594100 594328 595017 595057 595674 599744 600404 601119 601399 601741 601835 605261 605649 610053 619555 621745 626112 626651 630104 639686 646721 646939 647129 650101 651803 664587 672873 681178 683047 687942 689002 690315 690894 707605 708297 721908 741769 759316 803740 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"помогла дрочить ххх"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"помогл дрочк ххх"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.