Query Metrics
7
Database Queries
7
Different statements
187.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.27 ms (84.90%) |
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 188560 310715 385334 387480 389442 389765 389980 393082 393650 396778 407768 412609 438334 447309 448554 448755 449602 458722 459597 462944 467835 471823 472813 474351 476356 478573 479845 481307 482848 482933 485694 486531 488618 504321 512286 513466 521877 521894 524001 524514 525025 533352 537776 539225 544841 548788 552967 556657 559820 561260 562233 562239 562245 568667 570287 570324 570328 570339 570587 571927 572156 572416 572516 574878 575724 576420 580345 582143 592465 594938 597796 598773 604151 606460 623519 629940 635946 637679 641148 644289 644310 649569 663449 671639 671757 672240 676973 684560 688220 703089 708714 709765 717034 719055 728437 730409 732104 732930 733364 733877 741733 748231 748365 761736 769923 775928 785530 793471 800190 803069 804469 810668 811454 814665 814799 814885 815427 815559 815705 816803 ] |
||||||||||||||||||||||||||||||
|
17.57 ms (9.37%) |
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 393082 188560 389442 472813 485694 570328 570339 561260 688220 732930 676973 810668 458722 448755 671757 641148 644310 815705 544841 556657 568667 803069 730409 644289 717034 389765 407768 663449 604151 728437 733877 748231 769923 811454 393650 447309 476356 539225 572156 598773 793471 804469 438334 389980 479845 449602 533352 575724 580345 559820 570587 671639 592465 594938 597796 629940 448554 504321 513466 482848 385334 814885 815559 478573 708714 572416 606460 635946 623519 800190 462944 481307 512286 482933 396778 552967 576420 562233 562239 570287 571927 732104 761736 741733 412609 488618 387480 570324 672240 785530 733364 474351 521894 310715 548788 775928 814799 525025 572516 524514 815427 486531 562245 684560 709765 467835 816803 471823 582143 719055 574878 637679 748365 703089 459597 521877 814665 537776 524001 649569 ] |
||||||||||||||||||||||||||||||
|
3.59 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 188560 310715 385334 387480 389442 389765 389980 393082 393650 396778 407768 412609 438334 447309 448554 448755 449602 458722 459597 462944 467835 471823 472813 474351 476356 478573 479845 481307 482848 482933 485694 486531 488618 504321 512286 513466 521877 521894 524001 524514 525025 533352 537776 539225 544841 548788 552967 556657 559820 561260 562233 562239 562245 568667 570287 570324 570328 570339 570587 571927 572156 572416 572516 574878 575724 576420 580345 582143 592465 594938 597796 598773 604151 606460 623519 629940 635946 637679 641148 644289 644310 649569 663449 671639 671757 672240 676973 684560 688220 703089 708714 709765 717034 719055 728437 730409 732104 732930 733364 733877 741733 748231 748365 761736 769923 775928 785530 793471 800190 803069 804469 810668 811454 814665 814799 814885 815427 815559 815705 816803 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex wild"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс wild"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс wild"
]
|
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.