Query Metrics
7
Database Queries
7
Different statements
164.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.79 ms (85.51%) |
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 411849 417773 420517 422654 425076 426393 428753 443572 444213 468119 468274 472447 480523 489035 499734 502292 512427 513051 513568 520066 529664 530254 531650 534077 534763 539280 545731 549075 550164 552170 556549 572869 574193 579495 588221 592261 593725 597227 607417 610928 616315 616592 617080 624184 627778 628591 630297 633446 634482 636889 640149 657565 659247 675393 682223 690304 696139 700649 700711 701267 702397 708762 709880 714090 716001 716529 720193 724372 724898 726249 727399 731695 733090 734400 739517 747873 750436 750951 751728 751801 752615 752960 754086 755925 756989 757955 759675 760597 761995 762986 763145 764020 764947 766102 768462 768497 768914 769779 772026 772650 778448 782828 783617 784393 785731 785816 790955 791133 791851 793395 793586 795571 797088 797773 801078 802870 806277 812132 819780 ] |
||||||||||||||||||||||||||||||
|
13.85 ms (8.41%) |
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 624184 739517 480523 468119 468274 444213 417773 428753 489035 513051 502292 534077 572869 552170 597227 633446 819780 531650 530254 549075 574193 550164 700649 657565 682223 696139 700711 556549 592261 610928 628591 640149 616592 607417 617080 785816 793395 790955 756989 760597 763145 783617 785731 791133 797773 802870 806277 726249 733090 747873 761893 768497 772026 734400 751728 754086 724372 764020 752960 702397 797088 812132 422654 443572 411849 472447 579495 616315 425076 420517 539280 513568 499734 512427 634482 630297 426393 534763 520066 529664 545731 690304 714090 716529 701267 708762 716001 720193 659247 675393 593725 627778 636889 588221 778448 782828 791851 795571 724898 727399 750951 751801 766102 772650 784393 793586 801078 761995 764947 731695 752615 755925 768462 769779 757955 759675 762986 768914 750436 709880 ] |
||||||||||||||||||||||||||||||
|
3.15 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 411849 417773 420517 422654 425076 426393 428753 443572 444213 468119 468274 472447 480523 489035 499734 502292 512427 513051 513568 520066 529664 530254 531650 534077 534763 539280 545731 549075 550164 552170 556549 572869 574193 579495 588221 592261 593725 597227 607417 610928 616315 616592 617080 624184 627778 628591 630297 633446 634482 636889 640149 657565 659247 675393 682223 690304 696139 700649 700711 701267 702397 708762 709880 714090 716001 716529 720193 724372 724898 726249 727399 731695 733090 734400 739517 747873 750436 750951 751728 751801 752615 752960 754086 755925 756989 757955 759675 760597 761995 762986 763145 764020 764947 766102 768462 768497 768914 769779 772026 772650 778448 782828 783617 784393 785731 785816 790955 791133 791851 793395 793586 795571 797088 797773 801078 802870 806277 812132 819780 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small little xxx"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая little xxx"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая little xxx"
]
|
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.