Query Metrics
7
Database Queries
7
Different statements
144.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.42 ms (83.45%) |
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 9732 80629 385713 387005 388027 388080 397958 405151 409941 413257 423533 423584 425167 429291 429742 432453 432897 441483 456527 456877 457218 458945 460006 461755 461892 463755 468769 475721 488299 488557 495039 495117 497739 497846 499815 499937 500953 507128 510377 510564 510678 513169 516044 519807 520469 522693 523497 524889 524984 525149 526342 526758 528421 528497 530112 530600 531265 532200 533212 534724 536015 538767 543219 555559 564912 576976 577025 579518 586763 589657 594832 597637 599735 600518 600957 605009 605667 608652 609076 610490 612801 613994 615422 616429 616508 617710 618190 620255 622562 631066 632129 636636 643835 688277 689034 693153 723326 732562 735094 736392 739085 749627 750909 767791 767839 769173 769928 777124 781204 785239 787593 789983 791998 793682 793922 794927 799811 802271 809004 814282 ] |
||||||||||||||||||||||||||||||
|
13.83 ms (9.58%) |
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 688277 689034 693153 555559 564912 576976 577025 579518 589657 594832 608652 622562 632129 600518 600957 610490 612801 615422 616429 616508 618190 620255 597637 605667 586763 599735 605009 613994 794927 799811 802271 789983 791998 793682 785239 787593 793922 809004 732562 736392 739085 769173 769928 750909 767839 735094 749627 767791 609076 617710 631066 636636 643835 723326 777124 781204 388027 432897 460006 9732 423533 429742 432453 397958 413257 488557 488299 499815 385713 80629 387005 388080 405151 409941 423584 425167 441483 429291 814282 456527 458945 457218 461892 463755 468769 456877 497846 499937 507128 510377 526342 530112 531265 536015 495117 510564 513169 516044 520469 524889 524984 497739 519807 522693 526758 528421 532200 538767 495039 500953 510678 523497 525149 528497 530600 533212 534724 461755 475721 543219 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.91%) |
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 9732 80629 385713 387005 388027 388080 397958 405151 409941 413257 423533 423584 425167 429291 429742 432453 432897 441483 456527 456877 457218 458945 460006 461755 461892 463755 468769 475721 488299 488557 495039 495117 497739 497846 499815 499937 500953 507128 510377 510564 510678 513169 516044 519807 520469 522693 523497 524889 524984 525149 526342 526758 528421 528497 530112 530600 531265 532200 533212 534724 536015 538767 543219 555559 564912 576976 577025 579518 586763 589657 594832 597637 599735 600518 600957 605009 605667 608652 609076 610490 612801 613994 615422 616429 616508 617710 618190 620255 622562 631066 632129 636636 643835 688277 689034 693153 723326 732562 735094 736392 739085 749627 750909 767791 767839 769173 769928 777124 781204 785239 787593 789983 791998 793682 793922 794927 799811 802271 809004 814282 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"за яйца"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"яйц"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.15%) |
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.