Query Metrics
7
Database Queries
7
Different statements
413.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.30 ms (52.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скачет"
]
|
||||||||||||||||||||||||||||||
|
173.80 ms (42.02%) |
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 467701 469810 471477 476891 482154 485191 490386 495334 497682 502544 503851 507401 510346 512632 516816 520242 527743 530315 534489 534901 534983 535082 535613 538671 538880 539583 539858 540865 542131 542296 543961 547300 548274 548408 549060 549381 549419 549953 550537 553889 556384 556761 556930 557723 559709 560251 560351 560369 561496 562611 562630 564364 567430 567940 568280 569379 570772 572301 572475 576542 576774 580802 584003 584047 585840 586216 587026 587044 587060 589702 591994 592271 594170 594639 595110 595266 595469 595705 596995 597544 598017 599508 599619 600119 600912 604034 608344 608780 615265 622354 635055 649023 652722 654031 656874 656879 657104 657426 658669 659221 659587 660022 660384 660650 661258 663941 665235 665290 665352 665408 667312 667339 670584 670645 679000 688407 689325 813713 814133 814955 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (3.64%) |
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 540865 814133 813713 814955 467701 469810 471477 476891 485191 497682 502544 503851 539583 507401 516816 520242 530315 534983 535613 538880 495334 527743 534489 534901 538671 510346 512632 535082 539858 482154 490386 542131 549060 553889 557723 560351 562611 567940 568280 576542 580802 584047 542296 547300 549381 550537 556384 556930 559709 560369 562630 572301 572475 543961 548274 548408 549953 560251 561496 567430 569379 570772 576774 654031 656874 659587 660384 660650 661258 665408 688407 689325 649023 652722 656879 657104 657426 658669 663941 665235 665352 670584 659221 660022 665290 667312 667339 670645 679000 549419 556761 564364 584003 586216 589702 594639 598017 599619 600912 608780 615265 622354 635055 587026 587044 591994 595110 595469 595705 608344 587060 592271 596995 599508 600119 604034 585840 594170 595266 597544 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.73%) |
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 467701 469810 471477 476891 482154 485191 490386 495334 497682 502544 503851 507401 510346 512632 516816 520242 527743 530315 534489 534901 534983 535082 535613 538671 538880 539583 539858 540865 542131 542296 543961 547300 548274 548408 549060 549381 549419 549953 550537 553889 556384 556761 556930 557723 559709 560251 560351 560369 561496 562611 562630 564364 567430 567940 568280 569379 570772 572301 572475 576542 576774 580802 584003 584047 585840 586216 587026 587044 587060 589702 591994 592271 594170 594639 595110 595266 595469 595705 596995 597544 598017 599508 599619 600119 600912 604034 608344 608780 615265 622354 635055 649023 652722 654031 656874 656879 657104 657426 658669 659221 659587 660022 660384 660650 661258 663941 665235 665290 665352 665408 667312 667339 670584 670645 679000 688407 689325 813713 814133 814955 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хорошо скачет"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.36%) |
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.