Query Metrics
7
Database Queries
7
Different statements
146.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.38 ms (80.88%) |
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 75811 378272 382600 398690 400589 440892 441192 450955 451154 474805 485822 528741 552315 563691 591133 592400 593466 594220 601422 603546 603741 607981 612162 615503 617259 622678 631044 641707 668579 670460 672664 672919 677232 683784 702188 702247 702980 709560 714289 720541 720558 722465 723928 730199 732752 734342 734706 735385 739288 740119 741503 744095 744157 744571 744822 747482 751943 753949 757284 757930 758008 762580 767870 769099 775051 775564 775590 775608 775624 777113 779915 780323 780974 782762 785835 787669 789007 791307 791478 791631 792210 792235 793517 793713 794524 795004 795070 795950 796589 797028 800094 800133 802716 804130 804709 806913 808778 812307 812313 812429 816778 817689 817707 818831 818976 819002 819207 819297 819754 820022 820095 824306 824803 825056 825129 825991 826054 826561 826843 828228 ] |
||||||||||||||||||||||||||||||
|
18.65 ms (12.74%) |
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 378272 400589 398690 440892 817707 818976 819002 819754 824803 825056 826054 826561 818831 820022 824306 826843 816778 819207 819297 825991 817689 820095 825129 828228 485822 563691 552315 670460 677232 683784 702188 672664 668579 672919 709560 720541 720558 722465 594220 601422 603741 612162 591133 592400 593466 775564 777113 782762 787669 791307 792235 793713 775608 780974 789007 791631 792210 797028 800133 804709 806913 812313 723928 730199 741503 744157 744822 751943 757284 758008 762580 769099 785835 794524 795004 795950 804130 808778 812307 734706 739288 744571 767870 735385 747482 757930 732752 740119 753949 607981 615503 617259 622678 641707 702247 702980 775051 775590 775624 779915 780323 791478 793517 795070 796589 800094 75811 382600 441192 450955 451154 474805 528741 714289 631044 802716 734342 744095 603546 812429 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.89%) |
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 75811 378272 382600 398690 400589 440892 441192 450955 451154 474805 485822 528741 552315 563691 591133 592400 593466 594220 601422 603546 603741 607981 612162 615503 617259 622678 631044 641707 668579 670460 672664 672919 677232 683784 702188 702247 702980 709560 714289 720541 720558 722465 723928 730199 732752 734342 734706 735385 739288 740119 741503 744095 744157 744571 744822 747482 751943 753949 757284 757930 758008 762580 767870 769099 775051 775564 775590 775608 775624 777113 779915 780323 780974 782762 785835 787669 789007 791307 791478 791631 792210 792235 793517 793713 794524 795004 795070 795950 796589 797028 800094 800133 802716 804130 804709 806913 808778 812307 812313 812429 816778 817689 817707 818831 818976 819002 819207 819297 819754 820022 820095 824306 824803 825056 825129 825991 826054 826561 826843 828228 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy shaving"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy shaving"
]
|
||||||||||||||||||||||||||||||
|
1.14 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy shaving"
]
|
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.