Query Metrics
7
Database Queries
7
Different statements
160.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.10 ms (84.70%) |
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 392279 395189 399607 400396 400488 416435 419280 423692 426737 434894 439159 441342 441759 447792 458385 459273 459600 462057 463227 470004 478745 493401 494587 505429 508803 508808 513862 514221 516229 520637 524363 525687 529384 541163 545899 551476 556192 558459 558583 567215 567856 572686 580899 585176 590091 594349 599330 606886 608372 616501 618247 620371 623216 623230 625895 635356 648483 659360 661538 663185 673896 677419 679506 697840 704036 705043 707233 707487 709739 714217 715750 716529 718022 723368 724477 727519 734731 736897 740051 741778 741788 747170 749167 753774 754054 757994 759348 760318 764266 765725 767611 767996 768246 771289 772788 772911 775580 780805 782571 783478 784966 784970 785465 785538 787708 787851 790498 791507 793560 794249 794274 794930 796374 807734 810091 811042 813481 817974 825328 ] |
||||||||||||||||||||||||||||||
|
15.19 ms (9.45%) |
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 784966 784970 785538 734731 740051 741778 741788 759348 753774 757994 724477 736897 765725 771289 772788 704036 718022 775580 780805 785465 811042 392279 419280 426737 416435 458385 423692 459600 520637 493401 399607 439159 787708 494587 525687 545899 551476 558459 572686 567856 580899 661538 705043 677419 663185 673896 714217 585176 606886 618247 635356 599330 616501 620371 623216 590091 767996 709739 508803 508808 395189 434894 825328 817974 447792 459273 462057 513862 514221 524363 516229 558583 567215 707233 715750 716529 679506 707487 659360 787851 807734 783478 790498 791507 794249 760318 793560 794274 796374 810091 813481 727519 772911 747170 749167 754054 764266 768246 723368 782571 794930 400396 478745 441342 529384 541163 556192 648483 697840 608372 623230 594349 767611 741836 625895 441759 470004 505429 463227 400488 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.64%) |
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 392279 395189 399607 400396 400488 416435 419280 423692 426737 434894 439159 441342 441759 447792 458385 459273 459600 462057 463227 470004 478745 493401 494587 505429 508803 508808 513862 514221 516229 520637 524363 525687 529384 541163 545899 551476 556192 558459 558583 567215 567856 572686 580899 585176 590091 594349 599330 606886 608372 616501 618247 620371 623216 623230 625895 635356 648483 659360 661538 663185 673896 677419 679506 697840 704036 705043 707233 707487 709739 714217 715750 716529 718022 723368 724477 727519 734731 736897 740051 741778 741788 747170 749167 753774 754054 757994 759348 760318 764266 765725 767611 767996 768246 771289 772788 772911 775580 780805 782571 783478 784966 784970 785465 785538 787708 787851 790498 791507 793560 794249 794274 794930 796374 807734 810091 811042 813481 817974 825328 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur morning"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск morning"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск morning"
]
|
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.