Query Metrics
7
Database Queries
7
Different statements
360.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.37 ms (59.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс first"
]
|
||||||||||||||||||||||||||||||
|
125.31 ms (34.74%) |
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 382727 385680 387174 388855 396726 399379 401520 409615 411258 414783 423766 436820 436857 444343 445411 447567 447834 448148 454101 457893 461124 461716 462468 462947 466802 472501 472785 478492 486161 488852 496244 497934 500795 501406 511043 512676 524006 534996 536271 539830 540967 548607 564894 571121 580648 583554 584230 585939 588898 589152 590360 597241 597849 598805 601962 604185 610522 616561 618156 618672 618954 621288 624359 625660 628310 637054 637106 639295 649140 649254 649511 659404 665717 668646 670208 680204 681108 698880 704161 708673 717974 719235 720096 722499 722501 722529 722594 725141 727852 732423 732425 733560 736440 741279 741537 742818 744850 744856 747656 751597 763490 771682 772708 774176 780597 783356 784054 789845 797817 804117 804562 806614 807554 809184 809315 809342 810028 811093 812084 ] |
||||||||||||||||||||||||||||||
|
12.85 ms (3.56%) |
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 461124 681108 722501 628310 597849 637106 725141 774176 447567 454101 488852 496244 436820 401520 472501 584230 388855 447834 511043 536271 649511 722594 668646 719235 680204 583554 598805 610522 588898 590360 597241 639295 806614 742818 784054 797817 809342 727852 736440 751597 763490 637054 698880 717974 783356 387174 423766 411258 564894 540967 704161 722529 722499 585939 771682 732423 811093 589152 500795 486161 445411 399379 409615 604185 618672 472785 501406 497934 618156 444343 457893 624359 448148 772708 744850 741537 747656 385680 571121 524006 382727 396726 548607 812084 809315 466802 539830 512676 649254 670208 720096 708673 618954 616561 621288 789845 804562 784828 804117 732425 733560 810028 534996 414783 462468 580648 601962 625660 436857 461716 462947 478492 649140 659404 665717 780597 807554 741279 809184 744856 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (0.70%) |
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 382727 385680 387174 388855 396726 399379 401520 409615 411258 414783 423766 436820 436857 444343 445411 447567 447834 448148 454101 457893 461124 461716 462468 462947 466802 472501 472785 478492 486161 488852 496244 497934 500795 501406 511043 512676 524006 534996 536271 539830 540967 548607 564894 571121 580648 583554 584230 585939 588898 589152 590360 597241 597849 598805 601962 604185 610522 616561 618156 618672 618954 621288 624359 625660 628310 637054 637106 639295 649140 649254 649511 659404 665717 668646 670208 680204 681108 698880 704161 708673 717974 719235 720096 722499 722501 722529 722594 725141 727852 732423 732425 733560 736440 741279 741537 742818 744850 744856 747656 751597 763490 771682 772708 774176 780597 783356 784054 789845 797817 804117 804562 806614 807554 809184 809315 809342 810028 811093 812084 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob first"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс first"
]
|
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.