Query Metrics
7
Database Queries
7
Different statements
194.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.67 ms (86.31%) |
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 391911 391986 414122 415857 416988 429879 432348 434309 446786 452274 452421 452881 455631 456377 456601 457294 458002 458007 458765 463832 465562 466510 467075 468142 469027 469127 469327 471876 473429 473533 474454 475679 476082 484152 484910 499383 499548 500421 508778 513199 513630 513649 513650 515970 516006 516807 517808 518199 518203 520835 524331 524655 525884 526099 545455 555039 555983 558176 561021 561505 561803 573197 575198 576943 582314 582444 584621 589701 590425 591013 592671 592970 601729 602293 602793 604908 604925 604933 605247 606503 607638 609885 613800 614957 614968 616234 628617 632121 633119 637456 643287 669362 690020 705890 714307 718678 720139 730338 738827 742286 743792 747310 749090 751510 757550 757883 758364 761429 770191 772573 776217 793037 794229 796441 797241 800735 800752 804007 804434 812531 ] |
||||||||||||||||||||||||||||||
|
16.91 ms (8.71%) |
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 582314 604908 606503 607638 589701 592970 637456 592671 601729 604925 602293 605247 794229 800735 776217 796441 742286 749090 770191 812531 730338 757550 757883 758364 747310 751510 743792 633119 720139 800752 804007 804434 429879 517808 513649 513650 513199 513630 524655 452881 475679 469027 499548 467075 669362 705890 609885 616234 613800 761429 738827 772573 632121 434309 463832 446786 508778 558176 518199 555039 561803 584621 476082 416988 591013 456377 516807 555983 391986 455631 518203 499383 573197 714307 561021 458007 469327 561505 582444 614968 525884 516006 452421 590425 515970 484152 465562 628617 643287 793037 604933 469127 526099 473533 690020 602793 415857 391911 414122 457294 468142 575198 718678 614957 797241 458765 432348 456601 484910 452274 458002 471876 474454 466510 500421 520835 524331 473429 545455 576943 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.34%) |
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 391911 391986 414122 415857 416988 429879 432348 434309 446786 452274 452421 452881 455631 456377 456601 457294 458002 458007 458765 463832 465562 466510 467075 468142 469027 469127 469327 471876 473429 473533 474454 475679 476082 484152 484910 499383 499548 500421 508778 513199 513630 513649 513650 515970 516006 516807 517808 518199 518203 520835 524331 524655 525884 526099 545455 555039 555983 558176 561021 561505 561803 573197 575198 576943 582314 582444 584621 589701 590425 591013 592671 592970 601729 602293 602793 604908 604925 604933 605247 606503 607638 609885 613800 614957 614968 616234 628617 632121 633119 637456 643287 669362 690020 705890 714307 718678 720139 730338 738827 742286 743792 747310 749090 751510 757550 757883 758364 761429 770191 772573 776217 793037 794229 796441 797241 800735 800752 804007 804434 812531 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature panties solo"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature трусик нижн бел соло"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature трусик нижн бел соло"
]
|
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.