Query Metrics
7
Database Queries
7
Different statements
189.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.98 ms (87.18%) |
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 87363 106483 145285 146414 147148 383544 385428 385599 386345 388226 394448 402949 427029 453871 457040 490144 492411 515270 547340 547532 550944 552756 559853 560150 560910 560913 569105 570850 588942 589178 591232 592069 593317 593342 593398 593493 593521 605392 606809 607733 616379 616920 619908 620975 622646 628291 628309 632340 637740 649484 663271 664670 664964 668654 668679 669587 670354 670450 671977 672826 674116 675514 680640 683932 685633 685680 688064 690771 691197 694148 695682 701691 711000 715068 716483 720341 723637 728290 728376 730073 748317 752533 752535 755942 755949 755950 755956 759861 761536 764628 791151 792724 795528 798864 803768 806098 807700 807702 807704 807705 807724 808174 808175 808567 809185 809704 811149 814060 814064 815546 815590 815629 815668 815998 816583 817035 818360 820957 827313 828833 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (7.24%) |
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 664670 670354 670450 674116 680640 547340 569105 593521 616379 628291 591232 593317 593342 593398 619908 606809 807724 809185 811149 798864 748317 752535 755942 755950 791151 807702 807704 807705 808175 728290 728376 752533 755956 730073 755949 759861 761536 764628 607733 622646 711000 806098 808174 809704 427029 87363 394448 146414 385428 385599 386345 383544 106483 145285 147148 388226 402949 815629 818360 723637 814064 815546 815668 815590 816583 817035 820957 814060 815998 828833 827313 453871 457040 490144 492411 515270 550944 552756 560150 560910 547532 559853 560913 570850 663271 664964 669587 675514 691197 649484 672826 685680 690771 695682 716483 668654 668679 671977 683932 685633 688064 694148 701691 715068 720341 589178 592069 632340 588942 616920 620975 637740 593493 605392 628309 803768 807700 808567 792724 795528 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.49%) |
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 87363 106483 145285 146414 147148 383544 385428 385599 386345 388226 394448 402949 427029 453871 457040 490144 492411 515270 547340 547532 550944 552756 559853 560150 560910 560913 569105 570850 588942 589178 591232 592069 593317 593342 593398 593493 593521 605392 606809 607733 616379 616920 619908 620975 622646 628291 628309 632340 637740 649484 663271 664670 664964 668654 668679 669587 670354 670450 671977 672826 674116 675514 680640 683932 685633 685680 688064 690771 691197 694148 695682 701691 711000 715068 716483 720341 723637 728290 728376 730073 748317 752533 752535 755942 755949 755950 755956 759861 761536 764628 791151 792724 795528 798864 803768 806098 807700 807702 807704 807705 807724 808174 808175 808567 809185 809704 811149 814060 814064 815546 815590 815629 815668 815998 816583 817035 818360 820957 827313 828833 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с медсёстрами"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"медицин"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
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.