Query Metrics
7
Database Queries
7
Different statements
355.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.57 ms (58.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs ass"
]
|
||||||||||||||||||||||||||||||
|
123.65 ms (34.76%) |
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 176969 280636 311520 384429 385010 385964 388714 408468 435479 442912 446016 447959 451216 451493 455436 457586 464429 475079 479719 479725 492120 500804 507812 510559 519829 521351 523036 525650 531668 532986 536569 548074 555952 557188 561999 566323 583341 584057 591023 606767 609939 610570 611268 618964 628030 628189 628295 628994 631314 634436 637458 662963 664542 686779 687571 687608 696314 699706 714518 722718 729241 732051 736459 738208 738648 739752 740172 742045 767140 770555 771336 775682 776850 781819 782636 785432 788478 797637 798543 800713 801412 801475 802464 805289 808424 811485 813409 814199 814702 816397 816525 817216 817312 817332 817881 818513 818922 818925 819723 819972 820056 820687 820714 823737 824198 824211 824409 825168 825249 825265 825446 825911 826381 826395 826465 826550 827880 828719 828826 828856 ] |
||||||||||||||||||||||||||||||
|
14.41 ms (4.05%) |
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 808424 740172 738208 739752 738648 742045 618964 714518 782636 388714 447959 435479 736459 451216 523036 525650 532986 500804 664542 507812 492120 732051 408468 825249 770555 519829 584057 451493 561999 566323 455436 384429 280636 826550 820714 823737 824409 817216 820056 824198 819723 457586 479725 686779 687571 687608 662963 699706 609939 628189 800713 798543 729241 767140 606767 442912 385964 825265 825446 818922 825911 816397 817312 548074 788478 805289 785432 802464 813409 634436 775682 176969 824211 814199 826381 826395 814702 820687 826465 817881 819972 825168 827880 828719 479719 591023 637458 628030 631314 781819 771336 610570 776850 801412 446016 797637 801475 555952 311520 817332 816525 818925 818513 828826 521351 531668 557188 696314 628295 811485 628994 385010 828856 536569 510559 464429 475079 583341 722718 611268 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (0.87%) |
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 176969 280636 311520 384429 385010 385964 388714 408468 435479 442912 446016 447959 451216 451493 455436 457586 464429 475079 479719 479725 492120 500804 507812 510559 519829 521351 523036 525650 531668 532986 536569 548074 555952 557188 561999 566323 583341 584057 591023 606767 609939 610570 611268 618964 628030 628189 628295 628994 631314 634436 637458 662963 664542 686779 687571 687608 696314 699706 714518 722718 729241 732051 736459 738208 738648 739752 740172 742045 767140 770555 771336 775682 776850 781819 782636 785432 788478 797637 798543 800713 801412 801475 802464 805289 808424 811485 813409 814199 814702 816397 816525 817216 817312 817332 817881 818513 818922 818925 819723 819972 820056 820687 820714 823737 824198 824211 824409 825168 825249 825265 825446 825911 826381 826395 826465 826550 827880 828719 828826 828856 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs жоп"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs жоп"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.45%) |
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.