Query Metrics
7
Database Queries
7
Different statements
156.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.30 ms (82.50%) |
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 7286 282006 382405 393531 395706 397130 399853 399922 400982 401343 401989 402676 402680 404633 407617 416172 416185 417135 443729 448930 451749 510687 512879 519725 525778 530632 530697 533049 543720 544749 556033 556334 566516 574870 574960 580241 581661 595458 596586 596991 597518 598444 598471 598675 605335 620300 624282 630266 630490 633474 649569 657070 657336 657536 659392 664808 671316 671340 671626 671810 673817 678726 682494 682918 683880 684197 684812 685617 686059 687490 687927 688668 688677 691250 693528 696219 697289 699772 701118 701526 702439 702633 706311 707276 708457 711273 712971 713617 715209 716027 717892 720009 721298 721325 722443 722492 722751 725112 725409 740596 741539 742422 758496 760963 775962 808266 810316 810701 811669 812361 813599 814133 814364 817623 817688 821628 822172 822718 824920 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (10.47%) |
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 808266 810316 393531 399853 400982 401989 416172 443729 417135 814364 451749 530697 512879 530632 510687 533049 566516 556334 543720 671626 685617 696219 649569 659392 722751 716027 574870 598675 630490 633474 595458 598444 597518 596991 598471 605335 620300 624282 810701 775962 811669 725409 758496 725112 741539 760963 740596 742422 630266 721298 721325 812361 402676 282006 395706 402680 416185 448930 399922 401343 519725 596586 382405 7286 397130 404633 407617 821628 813599 822172 814133 817623 817688 824920 822718 525778 531288 580241 574960 556033 664808 671340 673817 678726 682494 682918 684812 686059 691250 699772 701118 702439 702633 707276 708457 713617 657070 671810 687490 687927 688668 697289 701526 711273 715209 717892 657336 657536 671316 683880 684197 688677 693528 706311 712971 720009 722443 722492 544749 581661 ] |
||||||||||||||||||||||||||||||
|
2.81 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 7286 282006 382405 393531 395706 397130 399853 399922 400982 401343 401989 402676 402680 404633 407617 416172 416185 417135 443729 448930 451749 510687 512879 519725 525778 530632 530697 533049 543720 544749 556033 556334 566516 574870 574960 580241 581661 595458 596586 596991 597518 598444 598471 598675 605335 620300 624282 630266 630490 633474 649569 657070 657336 657536 659392 664808 671316 671340 671626 671810 673817 678726 682494 682918 683880 684197 684812 685617 686059 687490 687927 688668 688677 691250 693528 696219 697289 699772 701118 701526 702439 702633 706311 707276 708457 711273 712971 713617 715209 716027 717892 720009 721298 721325 722443 722492 722751 725112 725409 740596 741539 742422 758496 760963 775962 808266 810316 810701 811669 812361 813599 814133 814364 817623 817688 821628 822172 822718 824920 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old teen"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old teen"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old teen"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
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.