Query Metrics
7
Database Queries
7
Different statements
213.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.73 ms (86.44%) |
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 271197 391386 395780 424247 426627 429146 437986 450149 451279 452660 460288 461180 461809 462822 469710 471845 475571 486881 526398 530378 530479 531088 531097 531136 533064 533370 533373 534988 536143 537114 537182 537584 540398 540410 545341 545373 545771 557809 564125 569922 580559 592034 599863 599867 599965 600019 600029 600271 600296 600337 600363 600415 601583 601613 608645 615716 628382 632707 633123 633126 633451 633491 633718 633742 633770 633792 634472 634543 634774 635258 636293 636294 636295 636574 637729 638181 639292 639783 641698 641700 641975 646841 646930 647830 647859 647936 647952 648853 648854 651148 654652 666892 666902 667371 674975 678469 683264 696582 705302 709148 710805 715824 721207 742987 750349 751573 763892 767769 767771 770378 777591 778810 779767 783689 787479 798631 809484 810531 814663 827590 ] |
||||||||||||||||||||||||||||||
|
18.57 ms (8.69%) |
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 709148 580559 750349 770378 721207 783689 450149 715824 710805 798631 810531 767769 461809 600271 635258 636574 437986 471845 461180 452660 460288 530378 648853 651148 639783 615716 639292 536143 742987 426627 779767 763892 767771 777591 271197 564125 638181 486881 526398 634543 814663 667371 537584 533064 647952 641975 678469 827590 533370 545341 557809 654652 451279 531088 534988 646930 647936 696582 683264 705302 646841 647830 648854 666892 674975 641698 600415 632707 633770 599965 600337 636295 633126 633792 787479 608645 391386 531136 537114 600363 395780 475571 540398 540410 533373 531097 545373 647859 666902 569922 592034 599867 600029 600296 633718 634472 641700 599863 633491 633742 636294 633123 633451 637729 600019 601583 601613 628382 636293 429146 537182 751573 809484 545771 778810 462822 530479 469710 424247 634774 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.48%) |
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 271197 391386 395780 424247 426627 429146 437986 450149 451279 452660 460288 461180 461809 462822 469710 471845 475571 486881 526398 530378 530479 531088 531097 531136 533064 533370 533373 534988 536143 537114 537182 537584 540398 540410 545341 545373 545771 557809 564125 569922 580559 592034 599863 599867 599965 600019 600029 600271 600296 600337 600363 600415 601583 601613 608645 615716 628382 632707 633123 633126 633451 633491 633718 633742 633770 633792 634472 634543 634774 635258 636293 636294 636295 636574 637729 638181 639292 639783 641698 641700 641975 646841 646930 647830 647859 647936 647952 648853 648854 651148 654652 666892 666902 667371 674975 678469 683264 696582 705302 709148 710805 715824 721207 742987 750349 751573 763892 767769 767771 770378 777591 778810 779767 783689 787479 798631 809484 810531 814663 827590 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс глота домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deepthroat swallow homemade"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"глубокийминет минет оральн секс глота домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.71%) |
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.