Query Metrics
7
Database Queries
7
Different statements
185.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.87 ms (82.86%) |
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 411438 419844 420060 422403 425544 428443 430430 431825 432778 435020 436490 436577 436608 438738 440691 444439 445905 447749 449722 451162 451172 453710 453802 454540 457551 458061 461065 467646 469500 473127 473320 473893 477053 477414 477774 483687 484502 490758 490763 491796 495808 499860 499959 502755 504669 505917 505960 505987 507519 509570 511358 512846 513843 518388 519062 521761 522458 524040 524368 525085 525200 526247 526324 526605 527992 528099 528122 528425 534816 538280 556508 556817 559791 560261 560690 561177 561441 562938 563890 564056 567311 571203 573499 578733 580160 583786 587661 587894 590537 595361 595577 609214 609827 614520 615707 623358 623928 626330 627307 631871 663318 665325 693076 697892 709618 723175 726621 726703 726882 728009 736265 742839 756703 777734 785945 787966 791425 793770 794183 811906 ] |
||||||||||||||||||||||||||||||
|
20.64 ms (11.12%) |
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 626330 590537 595577 623928 627307 631871 811906 726703 736265 742839 785945 793770 794183 726621 756703 623358 777734 791425 411438 430430 467646 432778 473127 477774 419844 499959 505987 526605 528122 507519 526247 505960 513843 524368 453710 512846 528099 490763 556508 440691 436490 436608 451172 469500 451162 457551 504669 527992 499860 538280 477414 484502 556817 560261 573499 561441 564056 697892 663318 561177 571203 615707 587661 595361 587894 609214 609827 787966 728009 726882 614520 438738 447749 458061 477053 453802 473320 473893 422403 435020 518388 495808 519062 522458 534816 502755 483687 490758 425544 431825 420060 444439 428443 436577 461065 449722 491796 445905 454540 524040 525085 511358 526324 505917 528425 509570 521761 525200 563890 567311 559791 583786 560690 578733 580160 723175 665325 693076 709618 562938 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (1.99%) |
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 411438 419844 420060 422403 425544 428443 430430 431825 432778 435020 436490 436577 436608 438738 440691 444439 445905 447749 449722 451162 451172 453710 453802 454540 457551 458061 461065 467646 469500 473127 473320 473893 477053 477414 477774 483687 484502 490758 490763 491796 495808 499860 499959 502755 504669 505917 505960 505987 507519 509570 511358 512846 513843 518388 519062 521761 522458 524040 524368 525085 525200 526247 526324 526605 527992 528099 528122 528425 534816 538280 556508 556817 559791 560261 560690 561177 561441 562938 563890 564056 567311 571203 573499 578733 580160 583786 587661 587894 590537 595361 595577 609214 609827 614520 615707 623358 623928 626330 627307 631871 663318 665325 693076 697892 709618 723175 726621 726703 726882 728009 736265 742839 756703 777734 785945 787966 791425 793770 794183 811906 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum on sleep"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum спящ"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum спящ"
]
|
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.