Query Metrics
7
Database Queries
7
Different statements
225.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.67 ms (86.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 233143 295874 357595 382280 384241 388582 388878 389004 389798 395921 396524 397027 397896 403556 406312 407223 409949 411560 417848 423783 429405 430695 437114 446244 446666 449667 451450 453016 456591 464722 467216 467536 470221 470964 472852 472872 472920 472939 472941 480579 480604 480764 481669 482474 487648 490887 503481 512813 514129 515911 516475 522234 522375 525249 525896 533740 536683 537240 542921 543062 546942 552345 553281 553937 554040 554600 556799 556867 556996 560903 561453 566311 569318 569980 570975 578670 585366 588611 591003 591208 596694 596815 596851 596856 596891 596901 596935 596970 598949 606587 607950 609610 610666 616973 636333 642835 642841 643018 643324 670098 692658 696318 700724 702130 705878 708276 711685 719001 723075 724846 742010 749651 759033 764206 771401 773399 784756 786451 807504 828651 ] |
||||||||||||||||||||||||||||||
|
19.16 ms (8.51%) |
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 670098 596815 451450 724846 467216 388878 472941 596851 696318 472939 711685 610666 525249 609610 487648 423783 453016 481669 537240 578670 723075 616973 407223 411560 295874 472920 482474 512813 533740 554600 556867 560903 553281 692658 702130 700724 553937 570975 596970 636333 643018 596935 642835 807504 764206 773399 470221 389004 389798 397027 536683 569980 542921 585366 591208 742010 446666 357595 396524 409949 759033 749651 480764 446244 515911 522375 480579 546942 705878 552345 566311 642841 643324 596694 771401 388582 480604 233143 464722 397896 449667 470964 503481 522234 596901 596856 828651 543062 556799 719001 606587 403556 429405 516475 554040 569318 556996 591003 588611 596891 598949 607950 784756 382280 395921 437114 467536 472872 456591 430695 490887 384241 786451 406312 514129 417848 525896 472852 708276 561453 ] |
||||||||||||||||||||||||||||||
|
4.17 ms (1.85%) |
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 233143 295874 357595 382280 384241 388582 388878 389004 389798 395921 396524 397027 397896 403556 406312 407223 409949 411560 417848 423783 429405 430695 437114 446244 446666 449667 451450 453016 456591 464722 467216 467536 470221 470964 472852 472872 472920 472939 472941 480579 480604 480764 481669 482474 487648 490887 503481 512813 514129 515911 516475 522234 522375 525249 525896 533740 536683 537240 542921 543062 546942 552345 553281 553937 554040 554600 556799 556867 556996 560903 561453 566311 569318 569980 570975 578670 585366 588611 591003 591208 596694 596815 596851 596856 596891 596901 596935 596970 598949 606587 607950 609610 610666 616973 636333 642835 642841 643018 643324 670098 692658 696318 700724 702130 705878 708276 711685 719001 723075 724846 742010 749651 759033 764206 771401 773399 784756 786451 807504 828651 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex maid"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс горничн"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс горничн"
]
|
||||||||||||||||||||||||||||||
|
1.61 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.