Query Metrics
7
Database Queries
7
Different statements
179.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.74 ms (83.94%) |
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 126450 236863 383338 398561 400237 407156 407566 422504 422523 422546 422567 422588 422626 422638 422643 422648 422844 422933 422957 423000 423027 424740 428726 443600 448516 448640 456630 458561 471628 482824 491678 492414 500706 525193 526090 527116 529855 530663 532255 534833 536970 540186 540199 541879 543905 545607 546654 546777 549977 550615 550744 552004 552319 554004 554790 556405 557512 559910 564213 565265 565566 565998 566047 566789 568041 575716 579359 586015 588138 590966 598834 601051 605430 605432 614603 619372 619439 623615 623809 623814 624814 628167 628175 637689 638327 644697 647945 649163 649601 666415 673030 680251 688342 691899 695565 713520 713532 713547 713549 713569 713834 719628 722632 736421 736826 742484 745663 747966 750876 761585 774000 789999 790884 790957 807716 810995 811340 814223 816260 821745 ] |
||||||||||||||||||||||||||||||
|
17.64 ms (9.82%) |
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 552319 579359 456630 588138 565998 680251 619372 422588 536970 525193 422643 458561 500706 527116 647945 598834 605432 810995 736421 742484 638327 407566 628167 236863 540186 554790 761585 713834 126450 422504 422523 575716 628175 424740 448640 605430 400237 422844 673030 541879 422648 821745 559910 713549 691899 688342 586015 624814 623814 811340 807716 745663 747966 774000 644697 649601 422626 530663 422638 790884 554004 552004 423027 443600 423000 565265 422957 532255 614603 619439 722632 422933 448516 546777 546654 565566 422567 601051 550744 814223 649163 566789 422546 529855 482824 428726 492414 526090 549977 383338 398561 557512 623615 550615 590966 556405 491678 816260 534833 543905 564213 713520 713569 713532 623809 637689 790957 750876 713547 471628 566047 407156 695565 789999 540199 666415 736826 719628 545607 568041 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (1.88%) |
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 126450 236863 383338 398561 400237 407156 407566 422504 422523 422546 422567 422588 422626 422638 422643 422648 422844 422933 422957 423000 423027 424740 428726 443600 448516 448640 456630 458561 471628 482824 491678 492414 500706 525193 526090 527116 529855 530663 532255 534833 536970 540186 540199 541879 543905 545607 546654 546777 549977 550615 550744 552004 552319 554004 554790 556405 557512 559910 564213 565265 565566 565998 566047 566789 568041 575716 579359 586015 588138 590966 598834 601051 605430 605432 614603 619372 619439 623615 623809 623814 624814 628167 628175 637689 638327 644697 647945 649163 649601 666415 673030 680251 688342 691899 695565 713520 713532 713547 713549 713569 713834 719628 722632 736421 736826 742484 745663 747966 750876 761585 774000 789999 790884 790957 807716 810995 811340 814223 816260 821745 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 young asian"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 young азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 young азиатк"
]
|
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.