Query Metrics
7
Database Queries
7
Different statements
629.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.47 ms (33.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая большие cock"
]
|
||||||||||||||||||||||||||||||
|
208.76 ms (33.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
184.26 ms (29.26%) |
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 78620 388673 548610 550418 552187 552251 552691 553154 554746 556328 557632 558911 559179 559721 560653 562779 563336 563834 566845 568517 569849 570041 570289 570380 570384 571092 571546 571592 571894 572488 572522 572538 572801 573385 573544 573616 573792 573848 573895 575075 575344 576836 580271 581699 582980 584723 585263 586562 589712 590378 591652 595424 595478 595907 600311 604145 606764 607053 608765 616346 618532 621081 621967 622400 622510 623004 624296 630527 632860 633687 645934 645944 650126 651875 652949 654094 654481 654490 654574 655346 655628 655994 656677 657370 657571 657649 657674 657729 657996 658035 658335 658616 659329 659504 659584 659589 659605 660316 660515 660942 670064 671665 681343 682211 690032 695515 699678 714472 714478 714532 716559 717719 720339 720822 721600 721736 723604 746155 761459 820471 ] |
||||||||||||||||||||||||||||||
|
20.48 ms (3.25%) |
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 746155 580271 622400 630527 608765 595907 552251 761459 78620 388673 723604 820471 548610 552691 570380 571894 572488 572538 573385 573792 575344 552187 556328 557632 559179 560653 563834 570289 572801 584723 550418 566845 568517 570384 571546 571592 573616 573848 576836 581699 582980 645934 650126 651875 652949 654094 654481 654574 655628 655994 657571 658616 659589 660515 660942 671665 699678 714472 720822 721736 645944 654490 657370 657649 657729 657996 658035 658335 659504 659605 660316 670064 695515 714478 716559 720339 721600 655346 656677 657674 659329 659584 681343 682211 690032 714532 717719 553154 554746 558911 559721 562779 563336 569849 570041 571092 572522 573544 573895 575075 589712 606764 607053 616346 618532 623004 585263 590378 595424 595478 600311 621967 624296 586562 591652 604145 621081 622510 632860 633687 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (0.43%) |
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 78620 388673 548610 550418 552187 552251 552691 553154 554746 556328 557632 558911 559179 559721 560653 562779 563336 563834 566845 568517 569849 570041 570289 570380 570384 571092 571546 571592 571894 572488 572522 572538 572801 573385 573544 573616 573792 573848 573895 575075 575344 576836 580271 581699 582980 584723 585263 586562 589712 590378 591652 595424 595478 595907 600311 604145 606764 607053 608765 616346 618532 621081 621967 622400 622510 623004 624296 630527 632860 633687 645934 645944 650126 651875 652949 654094 654481 654490 654574 655346 655628 655994 656677 657370 657571 657649 657674 657729 657996 658035 658335 658616 659329 659504 659584 659589 659605 660316 660515 660942 670064 671665 681343 682211 690032 695515 699678 714472 714478 714532 716559 717719 720339 720822 721600 721736 723604 746155 761459 820471 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small big cock"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая большие cock"
]
|
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.