Query Metrics
7
Database Queries
7
Different statements
150.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.42 ms (83.36%) |
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 411828 418601 423626 434430 435968 437474 443061 447865 449385 451854 456040 457059 463426 463678 463834 464952 467744 470856 471314 471690 474383 480430 484084 485197 487588 495769 505318 505885 508983 509899 512116 513872 514955 514966 514982 515542 515554 517710 518118 518635 520244 520686 521525 522459 522998 523974 524084 527681 528846 529306 530756 533455 542266 542757 544576 544753 552286 554207 558148 559430 559564 560837 561877 562853 562892 564417 565978 566653 567272 567331 569198 571138 575339 576384 577160 577391 578116 579624 581662 582889 586600 587751 589407 589900 589972 594893 596412 601142 601200 604045 605735 605941 612074 613871 615170 618741 621055 622392 622394 622400 623494 623613 623805 623822 624897 626597 629363 630527 644098 650748 655582 661365 676535 684658 691335 720871 727667 771517 780406 780419 ] |
||||||||||||||||||||||||||||||
|
15.77 ms (10.48%) |
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 578116 582889 542266 542757 544576 544753 558148 559564 571138 577391 552286 554207 655582 676535 684658 650748 661365 691335 720871 561877 564417 566653 567272 567331 575339 589407 589972 615170 622400 623805 626597 630527 586600 594893 605735 622394 623494 624897 589900 596412 601142 612074 618741 623822 601200 604045 605941 621055 644098 780419 727667 771517 613871 622392 623613 629363 780406 411828 443061 464952 434430 451854 457059 463834 474383 423626 463678 471314 418601 435968 470856 480430 463426 505885 508983 513872 518635 514966 515554 520686 522459 528846 495769 509899 512116 514955 485197 514982 515542 523974 565978 437474 467744 484084 449385 456040 447865 471690 487588 521525 527681 505318 520244 524084 530756 517710 518118 522998 529306 533455 562853 576384 581662 560837 569198 579624 559430 562892 577160 587751 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.79%) |
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 411828 418601 423626 434430 435968 437474 443061 447865 449385 451854 456040 457059 463426 463678 463834 464952 467744 470856 471314 471690 474383 480430 484084 485197 487588 495769 505318 505885 508983 509899 512116 513872 514955 514966 514982 515542 515554 517710 518118 518635 520244 520686 521525 522459 522998 523974 524084 527681 528846 529306 530756 533455 542266 542757 544576 544753 552286 554207 558148 559430 559564 560837 561877 562853 562892 564417 565978 566653 567272 567331 569198 571138 575339 576384 577160 577391 578116 579624 581662 582889 586600 587751 589407 589900 589972 594893 596412 601142 601200 604045 605735 605941 612074 613871 615170 618741 621055 622392 622394 622400 623494 623613 623805 623822 624897 626597 629363 630527 644098 650748 655582 661365 676535 684658 691335 720871 727667 771517 780406 780419 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"body with hair"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"body hair"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"body hair"
]
|
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.