Query Metrics
7
Database Queries
7
Different statements
153.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.93 ms (84.23%) |
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 382654 385705 388567 397712 453523 487268 492109 492991 493476 503482 506063 519737 530445 539679 543427 547604 549515 558629 561798 564098 566231 576780 589623 596381 605754 613373 624974 630051 631985 633065 633706 635371 635459 640997 641434 643146 643553 646858 652196 658901 664994 666121 679235 681344 682373 689713 693789 697212 701056 702546 704598 705732 712573 714032 716455 722068 724821 726097 726438 726750 726797 727685 728978 730508 730706 732158 733307 733392 733403 733409 733422 733437 733648 734101 734110 734247 734251 734497 734537 739695 739700 740548 742045 744697 744783 747899 748000 749399 749414 749507 753744 755113 755215 755396 756385 756513 757123 759814 762900 764213 768636 772391 796779 799302 801055 802005 804485 808700 810266 815537 816994 818780 821555 823810 823827 824179 824413 826600 827981 828644 ] |
||||||||||||||||||||||||||||||
|
14.36 ms (9.38%) |
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 641434 506063 734101 530445 492109 701056 816994 815537 679235 810266 728978 624974 733437 643553 753744 749414 385705 561798 734497 722068 724821 732158 726797 613373 756385 487268 566231 539679 666121 646858 605754 799302 733648 697212 712573 716455 589623 755215 768636 689713 755113 682373 734251 739695 824413 734247 733392 749399 804485 742045 453523 558629 808700 733409 826600 397712 714032 730706 388567 749507 747899 733403 652196 727685 643146 734537 726438 734110 739700 635459 519737 801055 576780 772391 756513 762900 630051 828644 730508 631985 382654 633706 503482 493476 733307 633065 823810 543427 755396 547604 635371 802005 764213 796779 744697 564098 658901 681344 640997 733422 726097 740548 759814 726750 757123 824179 664994 744783 704598 705732 492991 821555 827981 549515 596381 748000 823827 693789 818780 702546 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.92%) |
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 382654 385705 388567 397712 453523 487268 492109 492991 493476 503482 506063 519737 530445 539679 543427 547604 549515 558629 561798 564098 566231 576780 589623 596381 605754 613373 624974 630051 631985 633065 633706 635371 635459 640997 641434 643146 643553 646858 652196 658901 664994 666121 679235 681344 682373 689713 693789 697212 701056 702546 704598 705732 712573 714032 716455 722068 724821 726097 726438 726750 726797 727685 728978 730508 730706 732158 733307 733392 733403 733409 733422 733437 733648 734101 734110 734247 734251 734497 734537 739695 739700 740548 742045 744697 744783 747899 748000 749399 749414 749507 753744 755113 755215 755396 756385 756513 757123 759814 762900 764213 768636 772391 796779 799302 801055 802005 804485 808700 810266 815537 816994 818780 821555 823810 823827 824179 824413 826600 827981 828644 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.