Query Metrics
7
Database Queries
7
Different statements
265.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
237.27 ms (89.46%) |
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 398057 410267 416000 416446 422676 432970 437708 443248 446798 448257 448571 448572 449985 451651 454745 459334 462845 469602 470405 470414 471148 491183 495203 502559 527521 546202 562587 569633 586901 587298 589856 594340 597482 598272 598310 598814 600948 602627 604412 605874 609888 612070 614967 615983 628095 628097 628111 628850 634106 636183 637544 639762 641951 642042 643080 644498 646789 649517 664717 673257 674043 674885 680472 686406 695464 696594 696596 696607 699201 700471 708544 708562 711615 740409 740934 741252 744040 744046 745088 745106 745119 750947 751822 752610 752634 752645 752670 754902 755006 758780 764295 770210 770216 776527 777001 777847 782164 782515 782858 785552 785580 785589 785606 785868 788524 791385 792078 792897 796930 796950 799580 800507 800538 804638 806541 807244 808746 808787 809847 ] |
||||||||||||||||||||||||||||||
|
17.10 ms (6.45%) |
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 649517 686406 695464 696594 696607 699201 673257 674043 680472 696596 700471 711615 546202 600948 634106 636183 641951 642042 602627 604412 605874 615983 628097 587298 589856 594340 597482 598310 598814 614967 637544 586901 598272 609888 628111 643080 777847 785580 785589 796930 799580 804638 808787 776527 782849 785552 788524 792078 796950 800538 809847 740934 752610 758780 782515 785606 785868 806541 808746 740409 741252 745088 745106 751822 770216 770210 752634 752645 752670 754902 612070 644498 777001 791385 807244 448572 416446 422676 448571 459334 470405 491183 432970 471148 462845 628095 398057 469602 527521 664717 562587 744046 744040 755006 495203 470414 446798 449985 443248 437708 454745 502559 410267 639762 451651 416000 448257 708544 708562 646789 674885 569633 628850 792897 782858 800507 782164 750947 745119 764295 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.32%) |
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 398057 410267 416000 416446 422676 432970 437708 443248 446798 448257 448571 448572 449985 451651 454745 459334 462845 469602 470405 470414 471148 491183 495203 502559 527521 546202 562587 569633 586901 587298 589856 594340 597482 598272 598310 598814 600948 602627 604412 605874 609888 612070 614967 615983 628095 628097 628111 628850 634106 636183 637544 639762 641951 642042 643080 644498 646789 649517 664717 673257 674043 674885 680472 686406 695464 696594 696596 696607 699201 700471 708544 708562 711615 740409 740934 741252 744040 744046 745088 745106 745119 750947 751822 752610 752634 752645 752670 754902 755006 758780 764295 770210 770216 776527 777001 777847 782164 782515 782858 785552 785580 785589 785606 785868 788524 791385 792078 792897 796930 796950 799580 800507 800538 804638 806541 807244 808746 808787 809847 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo masturbation teen"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд мастурбац teen"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд мастурбац teen"
]
|
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.