Query Metrics
7
Database Queries
7
Different statements
240.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.17 ms (88.52%) |
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 187918 215337 332778 386645 386798 387510 387711 388722 388729 390571 390713 398511 403324 417015 419535 429863 440947 460171 469575 471105 471696 472688 475842 480472 485207 493182 494141 510907 513201 531058 531268 531866 534083 534559 539372 541618 546258 546988 547464 555082 560943 571123 604514 606576 615516 624788 630423 637503 648761 660365 669010 669023 669072 700997 710559 712296 712580 714698 715473 720622 724023 724252 726469 726896 728146 728385 729907 731759 731763 731808 731823 733541 734062 735872 738330 740744 741716 741742 741764 742390 742409 744807 746683 748522 754462 755369 755952 755960 759987 765340 765699 766606 769908 770904 772549 781646 781775 785072 788517 795867 799016 799360 800573 801977 802446 803023 803393 811221 813712 817189 817394 818824 819235 819602 824101 824442 824835 826388 826489 827399 ] |
||||||||||||||||||||||||||||||
|
17.62 ms (7.32%) |
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 748522 755369 770904 724023 742409 772549 731759 735872 715473 781646 460171 440947 387510 215337 824835 531268 534083 546258 571123 546988 803393 729907 744807 769908 785072 803023 734062 731823 726469 731808 738330 754462 712296 781775 802446 493182 388729 398511 417015 817394 818824 819235 824442 471696 531866 534559 480472 485207 547464 555082 541618 669010 669072 714698 720622 660365 669023 712580 604514 624788 630423 795867 801977 811221 788517 800573 741716 741742 755952 755960 766606 731763 733541 726896 742390 765340 746683 765699 728146 740744 615516 637503 700997 710559 799016 187918 387711 386798 390713 471105 494141 648761 606576 759987 429863 475842 510907 539372 469575 560943 724252 741764 728385 799360 472688 403324 388722 419535 513201 390571 386645 332778 817189 819602 826489 826388 827399 813712 824101 531058 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.11%) |
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 187918 215337 332778 386645 386798 387510 387711 388722 388729 390571 390713 398511 403324 417015 419535 429863 440947 460171 469575 471105 471696 472688 475842 480472 485207 493182 494141 510907 513201 531058 531268 531866 534083 534559 539372 541618 546258 546988 547464 555082 560943 571123 604514 606576 615516 624788 630423 637503 648761 660365 669010 669023 669072 700997 710559 712296 712580 714698 715473 720622 724023 724252 726469 726896 728146 728385 729907 731759 731763 731808 731823 733541 734062 735872 738330 740744 741716 741742 741764 742390 742409 744807 746683 748522 754462 755369 755952 755960 759987 765340 765699 766606 769908 770904 772549 781646 781775 785072 788517 795867 799016 799360 800573 801977 802446 803023 803393 811221 813712 817189 817394 818824 819235 819602 824101 824442 824835 826388 826489 827399 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature toys"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature toys"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature toys"
]
|
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.