Query Metrics
7
Database Queries
7
Different statements
146.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.40 ms (80.68%) |
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 448587 448930 451749 503468 510687 512879 519725 525778 529034 530632 530697 533049 543720 552171 552210 553889 556033 556334 566516 570131 574125 574870 580241 595458 596586 596991 597518 598444 598471 598638 598675 605335 620300 624282 630266 630490 633474 637139 649569 651588 659392 664808 671340 671626 671656 673817 678726 682494 682918 684812 685617 686059 691250 696219 698610 699772 701118 702439 702633 706343 707276 708457 716027 721298 721325 722751 725112 725409 732094 737413 739934 740596 741539 742422 750344 755553 758496 759660 760963 765442 775709 775962 780881 807537 808266 810316 810667 810701 811669 812361 813599 814133 814364 817623 817626 817688 821628 822172 822718 824920 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (11.61%) |
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 750344 765442 810667 732094 739934 755553 759660 737413 698610 706343 775709 780881 807537 808266 810316 393531 399853 400982 401989 416172 443729 417135 814364 451749 530697 512879 530632 510687 533049 566516 556334 543720 671626 685617 696219 649569 659392 671656 722751 716027 574870 598638 598675 630490 633474 595458 598444 637139 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 448587 503468 529034 519725 596586 382405 7286 397130 404633 407617 821628 813599 822172 814133 817623 817626 817688 824920 822718 525778 531288 553889 574125 580241 570131 552171 552210 556033 651588 664808 671340 673817 678726 682494 682918 684812 686059 691250 699772 701118 702439 702633 707276 708457 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.06%) |
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 448587 448930 451749 503468 510687 512879 519725 525778 529034 530632 530697 533049 543720 552171 552210 553889 556033 556334 566516 570131 574125 574870 580241 595458 596586 596991 597518 598444 598471 598638 598675 605335 620300 624282 630266 630490 633474 637139 649569 651588 659392 664808 671340 671626 671656 673817 678726 682494 682918 684812 685617 686059 691250 696219 698610 699772 701118 702439 702633 706343 707276 708457 716027 721298 721325 722751 725112 725409 732094 737413 739934 740596 741539 742422 750344 755553 758496 759660 760963 765442 775709 775962 780881 807537 808266 810316 810667 810701 811669 812361 813599 814133 814364 817623 817626 817688 821628 822172 822718 824920 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen and old"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen old"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen old"
]
|
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.