Query Metrics
7
Database Queries
7
Different statements
174.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.04 ms (85.76%) |
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 362588 382141 403618 405831 411488 414077 415874 415877 415961 416508 416600 416648 416681 416696 416703 419832 420630 424107 426301 427027 428375 428753 430262 430350 430366 431960 432681 443340 444180 444531 445077 446986 447352 449985 452574 454745 455980 458115 467568 471987 475189 475419 476699 476784 477246 479544 481231 481952 482280 482283 483705 493825 493849 497609 498200 498483 498915 500525 502559 505630 506092 508891 512550 513015 515330 516035 517304 520907 521831 525399 525738 526163 529069 536236 543856 545677 548873 552699 552706 559191 561977 565298 566545 569594 569603 569613 570911 571222 572774 576128 598406 598971 601696 618931 623268 623281 623870 645889 668297 700259 718678 722405 750565 751509 766174 767255 782054 783044 790461 793146 803615 805120 806636 808468 810962 817185 820787 821554 822571 824929 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (8.96%) |
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 552699 424107 476699 449985 545677 570911 623870 428375 481231 432681 454745 506092 497609 498200 502559 751509 445077 521831 598406 415874 427027 362588 500525 515330 476784 561977 565298 569594 571222 598971 475419 405831 455980 411488 419832 428753 444180 446986 493849 513015 525738 403618 821554 505630 543856 566545 420630 430262 416681 508891 576128 718678 569613 482283 414077 430366 477246 806636 793146 766174 767255 572774 512550 808468 618931 430350 416703 416648 444531 415877 416696 467568 482280 483705 458115 493825 517304 529069 479544 559191 548873 552706 601696 805120 382141 416508 443340 475189 426301 415961 447352 498483 498915 569603 810962 416600 452574 431960 481952 520907 525399 516035 471987 722405 700259 783044 782054 803615 750565 790461 824929 820787 822571 817185 536236 526163 668297 645889 623268 623281 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.50%) |
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 362588 382141 403618 405831 411488 414077 415874 415877 415961 416508 416600 416648 416681 416696 416703 419832 420630 424107 426301 427027 428375 428753 430262 430350 430366 431960 432681 443340 444180 444531 445077 446986 447352 449985 452574 454745 455980 458115 467568 471987 475189 475419 476699 476784 477246 479544 481231 481952 482280 482283 483705 493825 493849 497609 498200 498483 498915 500525 502559 505630 506092 508891 512550 513015 515330 516035 517304 520907 521831 525399 525738 526163 529069 536236 543856 545677 548873 552699 552706 559191 561977 565298 566545 569594 569603 569613 570911 571222 572774 576128 598406 598971 601696 618931 623268 623281 623870 645889 668297 700259 718678 722405 750565 751509 766174 767255 782054 783044 790461 793146 803615 805120 806636 808468 810962 817185 820787 821554 822571 824929 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful masturbation dildo"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая мастурбац дилд"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.71%) |
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.