Query Metrics
7
Database Queries
7
Different statements
154.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.78 ms (85.97%) |
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 413958 417255 417278 417340 418155 418558 420257 420460 421113 421618 422030 422280 426374 432641 433635 441535 445583 445798 450994 451213 455639 455649 455929 457060 459686 463469 465784 468073 469897 471997 476066 477098 481054 481101 481129 485415 485818 485995 493034 493841 495008 497843 500805 502255 507432 508773 510931 518510 523059 525443 529056 534520 536119 537214 539340 543931 547702 551698 551777 552638 553253 556078 556113 557580 557836 559935 563736 563762 564238 564844 576145 577586 578760 583536 583575 584088 584958 585167 585521 585781 587967 592944 598762 610078 612693 614833 616983 622286 628644 631047 633851 641226 642045 660994 677203 677624 690278 695562 696333 736600 765655 772336 778543 778937 783735 788003 788606 789544 790083 792643 793899 794898 796395 796539 797204 798572 798725 809993 820981 821562 ] |
||||||||||||||||||||||||||||||
|
11.99 ms (7.76%) |
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 598762 788003 445583 422030 463469 418155 465784 563736 696333 585521 736600 485415 455649 432641 418558 420460 433635 471997 455639 497843 518510 534520 523059 481129 551698 551777 557836 577586 556078 564238 584958 556113 563762 578760 614833 631047 610078 641226 789544 809993 778543 793899 445798 459686 476066 481054 422280 457060 455929 469897 502255 507432 557580 585167 493841 525443 495008 417340 477098 510931 543931 529056 539340 583536 553253 592944 536119 583575 628644 417255 420257 421618 441535 413958 421113 426374 417278 821562 820981 450994 451213 485995 485818 468073 500805 508773 537214 481101 493034 547702 564844 584088 559935 677624 690278 695562 660994 677203 552638 576145 585781 616983 633851 612693 622286 587967 642045 778937 790083 798572 798725 783735 794898 796395 797204 765655 772336 788606 792643 796539 ] |
||||||||||||||||||||||||||||||
|
2.76 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 413958 417255 417278 417340 418155 418558 420257 420460 421113 421618 422030 422280 426374 432641 433635 441535 445583 445798 450994 451213 455639 455649 455929 457060 459686 463469 465784 468073 469897 471997 476066 477098 481054 481101 481129 485415 485818 485995 493034 493841 495008 497843 500805 502255 507432 508773 510931 518510 523059 525443 529056 534520 536119 537214 539340 543931 547702 551698 551777 552638 553253 556078 556113 557580 557836 559935 563736 563762 564238 564844 576145 577586 578760 583536 583575 584088 584958 585167 585521 585781 587967 592944 598762 610078 612693 614833 616983 622286 628644 631047 633851 641226 642045 660994 677203 677624 690278 695562 696333 736600 765655 772336 778543 778937 783735 788003 788606 789544 790083 792643 793899 794898 796395 796539 797204 798572 798725 809993 820981 821562 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov vagina"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов вагин"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.