Query Metrics
7
Database Queries
7
Different statements
408.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.11 ms (51.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк оргазм"
]
|
||||||||||||||||||||||||||||||
|
172.45 ms (42.21%) |
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 69589 147369 182206 396173 402792 409454 415736 417440 418068 422380 423707 428280 433433 434293 435552 435553 435560 437518 437970 439243 441489 441556 456127 456161 460441 464951 475503 477244 482643 486065 490198 492695 493352 500321 501061 502770 506688 511376 518638 519679 528770 529997 532655 537392 541501 545001 545372 545469 545605 554818 555297 556530 556664 562224 564686 565767 573206 582558 582567 584133 584434 584623 588048 588212 593994 600268 602793 604061 605673 607991 615065 616978 618326 624164 627466 629819 633083 639767 640400 641806 644986 648241 649921 653503 656318 656502 666880 666894 669884 669893 674430 682902 707391 710802 729265 746457 747061 747264 751587 757152 768116 773148 775186 775530 776022 783312 787482 790649 791457 791734 792442 792470 792922 797727 797730 801442 809702 810324 815759 817115 ] |
||||||||||||||||||||||||||||||
|
16.03 ms (3.92%) |
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 604061 564686 502770 541501 554818 674430 669893 640400 615065 791457 809702 729265 757152 751587 633083 776022 475503 182206 402792 439243 428280 460441 482643 528770 518638 565767 556530 624164 602793 423707 656318 69589 441556 529997 501061 437970 493352 747264 768116 644986 532655 545605 707391 648241 666880 666894 545372 545469 639767 747061 618326 588212 147369 477244 456127 537392 500321 464951 486065 582558 584623 584133 545001 641806 627466 435553 435560 409454 435552 456161 417440 492695 629819 422380 490198 519679 556664 600268 418068 790649 797730 787482 792442 797727 801442 415736 710802 810324 746457 775530 792470 792922 433433 506688 555297 573206 616978 593994 434293 511376 791734 773148 396173 437518 817115 815759 582567 584434 562224 653503 682902 656502 649921 669884 588048 605673 607991 775186 783312 441489 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (0.73%) |
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 69589 147369 182206 396173 402792 409454 415736 417440 418068 422380 423707 428280 433433 434293 435552 435553 435560 437518 437970 439243 441489 441556 456127 456161 460441 464951 475503 477244 482643 486065 490198 492695 493352 500321 501061 502770 506688 511376 518638 519679 528770 529997 532655 537392 541501 545001 545372 545469 545605 554818 555297 556530 556664 562224 564686 565767 573206 582558 582567 584133 584434 584623 588048 588212 593994 600268 602793 604061 605673 607991 615065 616978 618326 624164 627466 629819 633083 639767 640400 641806 644986 648241 649921 653503 656318 656502 666880 666894 669884 669893 674430 682902 707391 710802 729265 746457 747061 747264 751587 757152 768116 773148 775186 775530 776022 783312 787482 790649 791457 791734 792442 792470 792922 797727 797730 801442 809702 810324 815759 817115 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дрочка оргазм"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.