Query Metrics
7
Database Queries
7
Different statements
165.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.20 ms (83.92%) |
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 359260 394804 398491 417015 417840 417930 426881 432703 455400 456104 459914 461667 462813 464078 464636 466805 474172 482217 488393 490692 492465 494918 505664 507083 510008 511349 517773 521182 522685 525766 528881 532283 537182 537857 541322 545330 545394 549519 554021 554772 557363 558342 562158 580361 584430 584743 590619 592948 599604 608083 612415 614833 624008 624073 624186 624293 628679 634729 654621 656320 660048 662133 667147 671679 673118 674388 676412 686508 686749 687141 692681 695891 696485 698096 698726 706689 707483 708638 713067 716170 716308 720509 724564 725688 726975 727421 728478 737146 737877 742632 742722 747174 749294 758108 760965 761995 762005 765092 766199 768851 769405 769437 770511 770959 780944 781530 784088 785202 793810 795250 795271 796230 797072 798565 800579 802568 803955 808432 810049 815784 ] |
||||||||||||||||||||||||||||||
|
16.55 ms (9.98%) |
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 488393 537182 525766 532283 462813 545330 562158 545394 580361 654621 662133 667147 692681 695891 708638 716308 720509 590619 614833 592948 599604 624293 793810 803955 800579 724564 781530 784088 798565 727421 761995 742632 765092 725688 737877 747174 766199 728478 768851 769437 770511 608083 612415 780944 795250 795271 797072 432703 464078 398491 417015 492465 474172 456104 494918 505664 510008 517773 464636 558342 554021 554772 676412 716170 686749 687141 696485 698096 706689 713067 624186 624073 628679 624008 808432 810049 770959 785202 796230 802568 749294 762005 726975 737146 758108 742722 760965 769405 634729 359260 417840 466805 394804 426881 417930 815784 482217 455400 459914 490692 521182 522685 537857 511349 507083 528881 461667 557363 584743 541322 549519 584430 656320 660048 673118 674388 686508 698726 707483 671679 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (1.97%) |
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 359260 394804 398491 417015 417840 417930 426881 432703 455400 456104 459914 461667 462813 464078 464636 466805 474172 482217 488393 490692 492465 494918 505664 507083 510008 511349 517773 521182 522685 525766 528881 532283 537182 537857 541322 545330 545394 549519 554021 554772 557363 558342 562158 580361 584430 584743 590619 592948 599604 608083 612415 614833 624008 624073 624186 624293 628679 634729 654621 656320 660048 662133 667147 671679 673118 674388 676412 686508 686749 687141 692681 695891 696485 698096 698726 706689 707483 708638 713067 716170 716308 720509 724564 725688 726975 727421 728478 737146 737877 742632 742722 747174 749294 758108 760965 761995 762005 765092 766199 768851 769405 769437 770511 770959 780944 781530 784088 785202 793810 795250 795271 796230 797072 798565 800579 802568 803955 808432 810049 815784 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milk 2017"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milk"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milk"
]
|
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.