Query Metrics
7
Database Queries
7
Different statements
462.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
227.19 ms (49.09%) |
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 34830 384193 384813 388122 388254 396052 396891 402217 402219 402536 412238 416320 422343 422524 425839 426886 441229 447180 447411 451551 452380 472449 475602 480315 487214 496571 502439 503825 503907 505042 506216 510048 510127 510639 510806 513719 513865 522044 536662 543249 548766 549866 552784 554795 561647 574477 587761 592736 593106 593171 599045 599729 602575 604307 607314 619310 619652 622546 624857 626734 648519 659218 659428 660475 663098 670076 670342 675499 675839 676528 676976 676982 677028 678010 682882 684554 696970 697130 701504 708802 716414 716563 716583 716659 718656 722258 722274 722478 722812 722843 727639 732145 739423 741434 744291 747407 747640 748668 750025 753782 756808 759543 760252 773609 775825 778623 781802 790560 792180 794547 797091 797915 802252 807527 810271 818023 819860 820617 821433 821854 ] |
||||||||||||||||||||||||||||||
|
212.93 ms (46.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cutie blowjob"
]
|
||||||||||||||||||||||||||||||
|
13.82 ms (2.99%) |
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 592736 797091 744291 756808 447180 821433 818023 447411 554795 676528 701504 781802 802252 748668 708802 790560 820617 663098 425839 682882 536662 587761 549866 510806 676982 505042 396052 660475 659428 718656 388122 384813 697130 716583 722274 622546 604307 747640 753782 759543 747407 513865 819860 659218 593171 626734 794547 648519 510127 722843 422524 548766 593106 792180 451551 503825 510639 716414 716563 670076 675839 678010 696970 619310 624857 810271 732145 760252 741434 422343 396891 475602 502439 722478 402536 684554 388254 506216 775825 821854 543249 722258 807527 416320 487214 552784 561647 750025 402219 402217 480315 510048 503907 496571 677028 739423 778623 34830 472449 670342 607314 727639 716659 384193 452380 441229 412238 722812 797915 574477 599045 602575 513719 522044 676976 619652 426886 675499 599729 773609 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (0.65%) |
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 34830 384193 384813 388122 388254 396052 396891 402217 402219 402536 412238 416320 422343 422524 425839 426886 441229 447180 447411 451551 452380 472449 475602 480315 487214 496571 502439 503825 503907 505042 506216 510048 510127 510639 510806 513719 513865 522044 536662 543249 548766 549866 552784 554795 561647 574477 587761 592736 593106 593171 599045 599729 602575 604307 607314 619310 619652 622546 624857 626734 648519 659218 659428 660475 663098 670076 670342 675499 675839 676528 676976 676982 677028 678010 682882 684554 696970 697130 701504 708802 716414 716563 716583 716659 718656 722258 722274 722478 722812 722843 727639 732145 739423 741434 744291 747407 747640 748668 750025 753782 756808 759543 760252 773609 775825 778623 781802 790560 792180 794547 797091 797915 802252 807527 810271 818023 819860 820617 821433 821854 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cutie минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cutie минет оральн секс"
]
|
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.