Query Metrics
7
Database Queries
7
Different statements
201.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.27 ms (84.50%) |
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 9734 9974 33974 34593 61726 125809 206386 383407 383541 386638 386866 388200 388228 389657 396139 407746 415780 422284 422345 425124 427373 435472 444242 444776 450821 451115 453277 453348 453402 454701 456722 458882 459483 462183 465923 466314 468216 470834 470951 475108 475467 475568 476624 478450 480497 481254 482092 482301 483237 489667 490414 490452 491468 493332 496293 497253 498384 506514 506946 508242 508243 509867 511086 513360 516469 517112 517547 519480 520366 523513 524070 525232 525450 526264 534430 539539 549730 549842 555810 556002 559513 561328 570936 577120 584395 585385 586634 589708 590868 591977 606294 607432 619490 651810 660569 662428 701545 706785 713675 720168 725514 726788 727959 732500 745880 745962 750531 755627 758224 758379 764044 783136 784695 790912 796695 804467 814986 828259 828493 ] |
||||||||||||||||||||||||||||||
|
19.92 ms (9.89%) |
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 589708 386866 534430 706785 585385 796695 790912 516469 549730 453402 511086 513360 444776 814986 465923 462183 466314 584395 662428 555810 556002 570936 586634 725514 758224 804467 422284 422345 453348 470834 478450 480497 482092 475568 490452 493332 125809 9974 539539 745880 396139 523513 651810 606294 828259 828493 206386 450821 453277 454701 660569 758379 764044 33974 427373 481254 388228 407746 475467 755627 476624 498384 483237 561328 750531 415780 435472 458882 468216 456722 482301 509867 607432 727959 425124 519480 489667 506946 517112 524070 526264 491468 459483 490414 506514 525232 508242 517547 34593 388200 475108 720168 383407 61726 9734 496293 389657 713675 783136 784695 619490 590868 745962 386638 701545 383541 444242 783461 732500 508243 520366 497253 726788 470951 525450 451115 577120 559513 549842 591977 ] |
||||||||||||||||||||||||||||||
|
3.94 ms (1.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.32%) |
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 9734 9974 33974 34593 61726 125809 206386 383407 383541 386638 386866 388200 388228 389657 396139 407746 415780 422284 422345 425124 427373 435472 444242 444776 450821 451115 453277 453348 453402 454701 456722 458882 459483 462183 465923 466314 468216 470834 470951 475108 475467 475568 476624 478450 480497 481254 482092 482301 483237 489667 490414 490452 491468 493332 496293 497253 498384 506514 506946 508242 508243 509867 511086 513360 516469 517112 517547 519480 520366 523513 524070 525232 525450 526264 534430 539539 549730 549842 555810 556002 559513 561328 570936 577120 584395 585385 586634 589708 590868 591977 606294 607432 619490 651810 660569 662428 701545 706785 713675 720168 725514 726788 727959 732500 745880 745962 750531 755627 758224 758379 764044 783136 784695 790912 796695 804467 814986 828259 828493 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy big tits"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.66%) |
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.