Query Metrics
7
Database Queries
7
Different statements
162.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.06 ms (87.48%) |
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 388108 391187 397197 414957 422475 426440 428968 429375 429406 436691 437657 438979 441745 441798 441822 441841 443056 443602 448053 448412 449081 449267 452226 453007 454547 457593 458241 459579 464149 467833 470128 473101 478515 479082 479280 479530 480091 482547 482554 482588 482609 482922 485088 488452 488951 489712 499159 499875 500528 503535 503786 507188 508884 510841 511019 514609 516912 519110 519777 521092 522082 522139 522582 523726 523738 524138 525811 526627 527061 527196 528853 533818 534462 542373 544975 544992 545204 547546 569579 579941 592763 599981 602438 604014 605670 615392 650206 651903 658216 660354 693410 700682 710421 714851 719794 725624 728861 731944 736470 739866 740409 747137 749282 758510 761095 780086 784652 785467 793712 795352 798775 803837 804913 806541 809825 810715 811362 814418 814691 814712 ] |
||||||||||||||||||||||||||||||
|
11.68 ms (7.19%) |
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 503786 519777 524138 725624 795352 437657 426440 489712 499159 422475 436691 448053 454547 480091 482554 448412 510841 660354 710421 592763 810715 761095 441798 457593 467833 527196 533818 749282 731944 453007 599981 804913 458241 482588 522582 499875 534462 658216 700682 747137 785467 758510 388108 479530 391187 459579 488452 522139 508884 714851 604014 793712 500528 479082 397197 443602 814712 478515 452226 464149 511019 545204 579941 602438 806541 811362 473101 485088 523738 443056 429406 814418 814691 482547 470128 488951 522082 519110 527061 542373 544975 651903 650206 719794 784652 728861 798775 809825 438979 449267 503535 516912 525811 521092 482922 544992 441745 441841 449081 507188 528853 547546 693410 569579 615392 605670 780086 803837 740409 736470 739866 429375 479280 414957 523726 514609 526627 428968 441822 482609 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.60%) |
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 388108 391187 397197 414957 422475 426440 428968 429375 429406 436691 437657 438979 441745 441798 441822 441841 443056 443602 448053 448412 449081 449267 452226 453007 454547 457593 458241 459579 464149 467833 470128 473101 478515 479082 479280 479530 480091 482547 482554 482588 482609 482922 485088 488452 488951 489712 499159 499875 500528 503535 503786 507188 508884 510841 511019 514609 516912 519110 519777 521092 522082 522139 522582 523726 523738 524138 525811 526627 527061 527196 528853 533818 534462 542373 544975 544992 545204 547546 569579 579941 592763 599981 602438 604014 605670 615392 650206 651903 658216 660354 693410 700682 710421 714851 719794 725624 728861 731944 736470 739866 740409 747137 749282 758510 761095 780086 784652 785467 793712 795352 798775 803837 804913 806541 809825 810715 811362 814418 814691 814712 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam bondage sex"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер бдсм секс"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.27 ms (0.78%) |
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.