Query Metrics
7
Database Queries
7
Different statements
213.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.46 ms (89.26%) |
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 511162 512318 513536 522210 526780 528283 543708 549787 551856 554998 558990 561253 561929 562122 562223 562905 562941 563191 565658 566360 568608 568973 569299 572358 575131 576096 576301 579613 580134 584832 587072 587890 589619 590500 591088 593485 595764 595791 597158 598186 598198 598214 598228 598749 599367 600049 601437 601868 601940 602001 602793 603970 603986 604120 606019 608464 609130 609133 609181 609271 609602 609723 609837 610390 611469 611484 613356 613415 614495 614701 614987 615658 615680 616909 617026 618825 619098 619180 619364 619515 619522 620040 620054 620072 620083 620264 621181 621224 621672 621973 624821 624936 624949 625382 626127 626405 627095 636257 636264 650028 651214 652213 654468 655541 659225 659295 659300 659427 661237 661281 662380 662594 663789 670617 676209 677387 678935 682719 685929 742279 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (5.88%) |
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 543708 742279 601868 561929 598749 636257 512318 528283 562223 565658 569299 562905 568608 659295 659300 670617 676209 652213 659225 685929 655541 661237 677387 682719 551856 554998 562122 563191 579613 584832 599367 603970 608464 609130 609837 616909 618825 619098 621973 626127 587890 598198 598228 603986 609723 614987 620072 621181 621672 624936 624949 590500 614701 615658 619515 620054 620083 589619 591088 604120 611484 614495 621224 624821 601940 602793 609271 609602 613415 619364 627095 636264 549787 600049 597158 526780 561253 566360 576096 651214 678935 511162 513536 522210 562941 576301 580134 558990 575131 659427 662380 662594 663789 650028 654468 661281 568973 572358 593485 595791 598214 602001 606019 620040 625382 595764 598186 609133 611469 613356 617026 620264 587072 601437 609181 615680 619180 619522 626405 610390 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (1.63%) |
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 511162 512318 513536 522210 526780 528283 543708 549787 551856 554998 558990 561253 561929 562122 562223 562905 562941 563191 565658 566360 568608 568973 569299 572358 575131 576096 576301 579613 580134 584832 587072 587890 589619 590500 591088 593485 595764 595791 597158 598186 598198 598214 598228 598749 599367 600049 601437 601868 601940 602001 602793 603970 603986 604120 606019 608464 609130 609133 609181 609271 609602 609723 609837 610390 611469 611484 613356 613415 614495 614701 614987 615658 615680 616909 617026 618825 619098 619180 619364 619515 619522 620040 620054 620072 620083 620264 621181 621224 621672 621973 624821 624936 624949 625382 626127 626405 627095 636257 636264 650028 651214 652213 654468 655541 659225 659295 659300 659427 661237 661281 662380 662594 663789 670617 676209 677387 678935 682719 685929 742279 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русски порно"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск порн"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.74%) |
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.