Query Metrics
7
Database Queries
7
Different statements
379.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.40 ms (54.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
143.42 ms (37.78%) |
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 28708 96259 163135 381863 382382 383440 387603 389236 392696 399525 399908 401352 413163 414229 418827 418991 421759 423241 431463 436071 446170 452848 454741 454749 458689 459032 464618 473107 474911 476711 479722 486891 494305 495385 495547 498378 500743 505540 509978 522158 528965 529149 531806 536139 540285 541122 543024 547775 547922 554888 559199 561981 563345 571985 578194 581514 582745 583648 591948 592872 593214 593993 598251 599476 607102 609585 612508 615781 618376 619675 626559 634796 641516 642097 642112 645508 651236 670461 676717 704262 715377 736159 736172 740507 742131 745590 746230 747366 753714 754697 754715 754758 754776 756388 756785 758977 759811 772651 772683 773604 774198 777272 777276 777314 777529 778101 780164 785360 785365 788045 792212 793495 796867 803133 803734 808412 810354 812410 813697 817993 ] |
||||||||||||||||||||||||||||||
|
19.60 ms (5.16%) |
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 772651 740507 754715 754776 615781 704262 785360 793495 389236 399525 774198 421759 418827 505540 559199 581514 599476 756388 454741 529149 495547 28708 464618 476711 547922 582745 676717 583648 593993 778101 785365 473107 96259 387603 399908 381863 414229 454749 401352 452848 458689 498378 522158 541122 670461 547775 591948 607102 642097 642112 777314 803734 773604 423241 436071 382382 474911 528965 618376 817993 813697 531806 540285 536139 578194 554888 645508 651236 715377 592872 612508 619675 593214 598251 609585 641516 777276 777529 792212 803133 808412 754697 796867 736159 736172 742131 754758 759811 772683 756785 758977 745590 747366 746230 634796 780164 788045 810354 812410 163135 383440 777272 418991 459032 431463 509978 626559 753714 392696 413163 446170 486891 479722 494305 500743 495385 563345 543024 561981 571985 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (0.94%) |
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 28708 96259 163135 381863 382382 383440 387603 389236 392696 399525 399908 401352 413163 414229 418827 418991 421759 423241 431463 436071 446170 452848 454741 454749 458689 459032 464618 473107 474911 476711 479722 486891 494305 495385 495547 498378 500743 505540 509978 522158 528965 529149 531806 536139 540285 541122 543024 547775 547922 554888 559199 561981 563345 571985 578194 581514 582745 583648 591948 592872 593214 593993 598251 599476 607102 609585 612508 615781 618376 619675 626559 634796 641516 642097 642112 645508 651236 670461 676717 704262 715377 736159 736172 740507 742131 745590 746230 747366 753714 754697 754715 754758 754776 756388 756785 758977 759811 772651 772683 773604 774198 777272 777276 777314 777529 778101 780164 785360 785365 788045 792212 793495 796867 803133 803734 808412 810354 812410 813697 817993 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац красивая"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.42%) |
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.