Query Metrics
7
Database Queries
7
Different statements
235.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.16 ms (86.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 34697 191199 385562 387860 389442 390323 390927 398652 403891 405224 407708 407756 407812 418817 422012 425935 434544 442943 445531 446729 448237 448641 448885 448899 449461 449473 455343 456109 458996 461046 461201 462630 463083 465207 467705 467852 467858 469036 469769 472007 472629 472654 476207 477225 477611 479979 484540 486708 499551 500459 502061 510675 511380 515413 519701 519815 521267 522701 525373 525413 525777 528683 550380 563104 563425 563550 566057 579290 581471 591032 591701 591918 594076 600377 604645 605841 607369 608444 608827 615761 620391 620467 622016 635178 660464 660582 692288 712332 714378 716112 717199 717981 722519 725613 737473 755157 776599 779609 779647 780006 787339 788812 789559 790188 792813 796640 797449 797680 801182 806086 807860 808236 808679 809381 810988 811005 817010 817469 820072 824258 ] |
||||||||||||||||||||||||||||||
|
21.38 ms (9.06%) |
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 472629 525413 502061 484540 717981 712332 722519 776599 801182 779609 810988 808236 787339 467858 477611 405224 387860 486708 191199 34697 389442 390323 434544 407708 820072 817010 472654 461201 528683 469036 550380 563425 563104 692288 660464 716112 714378 594076 608444 608827 591032 591701 620391 620467 780006 808679 792813 737473 807860 755157 788812 789559 790188 797449 398652 448641 467852 469769 425935 448885 448237 519815 455343 519701 407756 407812 824258 817469 458996 476207 462630 472007 477225 465207 521267 522701 717199 563550 635178 605841 622016 604645 615761 796640 797680 806086 725613 809381 811005 422012 390927 418817 446729 479979 442943 456109 525373 525777 403891 467705 445531 449461 449473 463083 500459 511380 515413 581471 566057 579290 660582 591918 600377 607369 779647 448899 385562 461046 510675 499551 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.04%) |
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 34697 191199 385562 387860 389442 390323 390927 398652 403891 405224 407708 407756 407812 418817 422012 425935 434544 442943 445531 446729 448237 448641 448885 448899 449461 449473 455343 456109 458996 461046 461201 462630 463083 465207 467705 467852 467858 469036 469769 472007 472629 472654 476207 477225 477611 479979 484540 486708 499551 500459 502061 510675 511380 515413 519701 519815 521267 522701 525373 525413 525777 528683 550380 563104 563425 563550 566057 579290 581471 591032 591701 591918 594076 600377 604645 605841 607369 608444 608827 615761 620391 620467 622016 635178 660464 660582 692288 712332 714378 716112 717199 717981 722519 725613 737473 755157 776599 779609 779647 780006 787339 788812 789559 790188 792813 796640 797449 797680 801182 806086 807860 808236 808679 809381 810988 811005 817010 817469 820072 824258 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"super boobs"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"super boobs"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"super boobs"
]
|
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.