Query Metrics
7
Database Queries
7
Different statements
381.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.05 ms (54.34%) |
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 222010 386732 388393 397660 426099 433406 436899 493423 504524 512032 518431 530245 533398 540099 541301 541722 543534 545688 553932 557580 560181 564098 571257 575382 578171 578546 578906 583347 583775 585167 585235 585520 585586 585909 586197 595035 602034 603839 605380 607030 621674 628053 628626 629774 631871 639229 640034 665012 666628 674136 676673 679689 683698 684468 691584 697668 705220 713174 713892 724785 729322 737286 746708 756518 757831 761959 764371 766388 766513 767695 768155 768708 769137 769464 771413 771725 776361 777633 777691 778272 778518 778927 779903 782381 782782 784283 787687 790848 791047 791509 791811 792082 794541 794611 794931 795094 795902 797477 800806 802048 802622 802788 803870 808433 809877 810324 813518 817181 819548 819737 820839 821555 821644 822062 823506 823757 824890 825348 825512 827970 ] |
||||||||||||||||||||||||||||||
|
149.19 ms (39.16%) |
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 222010 386732 388393 397660 426099 433406 436899 493423 504524 512032 518431 530245 533398 540099 541301 541722 543534 545688 553932 557580 560181 564098 571257 575382 578171 578546 578906 583347 583775 585167 585235 585520 585586 585909 586197 595035 602034 603839 605380 607030 621674 628053 628626 629774 631871 639229 640034 665012 666628 674136 676673 679689 683698 684468 691584 697668 705220 713174 713892 724785 729322 737286 746708 756518 757831 761959 764371 766388 766513 767695 768155 768708 769137 769464 771413 771725 776361 777633 777691 778272 778518 778927 779903 782381 782782 784283 787687 790848 791047 791509 791811 792082 794541 794611 794931 795094 795902 797477 800806 802048 802622 802788 803870 808433 809877 810324 813518 817181 819548 819737 820839 821555 821644 822062 823506 823757 824890 825348 825512 827970 ] |
||||||||||||||||||||||||||||||
|
17.71 ms (4.65%) |
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 639229 705220 776361 784283 794611 802048 802788 809877 386732 397660 436899 679689 388393 518431 583347 713174 585235 504524 512032 665012 557580 585586 595035 585167 605380 607030 631871 792082 757831 571257 222010 560181 583775 433406 426099 820839 824890 817181 819737 821644 823757 825348 819548 821555 822062 823506 825512 827970 493423 530245 540099 533398 578171 578546 541301 543534 553932 541722 564098 575382 684468 674136 683698 666628 676673 691584 697668 713892 545688 578906 621674 640034 585520 585909 603839 586197 629774 778518 778927 782381 791811 794931 800806 777633 777691 778272 782782 791047 795094 803870 813518 729322 764371 767695 769137 771413 787687 790848 791509 794541 795902 797477 802622 808433 810324 761959 766388 766513 769464 724785 737286 746708 771725 756518 768708 768155 602034 628053 628626 779903 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женск пов"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женское пов"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.44%) |
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.