Query Metrics
7
Database Queries
7
Different statements
159.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.82 ms (82.89%) |
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 386456 403588 414135 417493 417660 417839 418572 432699 432707 434829 436235 438067 443987 444194 452251 452659 453875 455804 457818 460388 464193 464857 466230 466739 476887 478238 478707 487605 492239 496813 498345 500758 501682 504692 507876 508796 509058 510404 510498 510769 511791 519319 519322 519349 519610 520632 521637 521785 522383 522506 522975 523430 525190 525349 525612 526118 526492 526908 526912 527706 527738 528445 528652 532644 541776 542094 545038 550587 552991 555024 555127 566047 566122 567053 567062 567756 568283 569431 584511 590526 590670 591394 592382 594830 596497 597282 598644 599950 602006 603911 614673 618534 622035 627139 627632 628273 633047 643517 659216 661510 699409 714468 744704 766141 ] |
||||||||||||||||||||||||||||||
|
16.82 ms (10.58%) |
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 522506 528652 414135 457818 519349 504692 542094 567062 545038 555024 592382 622035 417839 460388 509058 519610 519322 492239 766141 552991 602006 453875 643517 599950 443987 522383 598644 526908 528445 744704 455804 418572 508796 525612 527738 478238 519319 466739 498345 507876 432707 478707 523430 417660 417493 476887 452659 501682 526492 541776 569431 555127 699409 525190 527706 487605 496813 618534 714468 444194 432699 614673 566047 436235 510769 466230 550587 438067 464193 511791 464857 568283 434829 386456 525349 596497 661510 526118 521637 500758 584511 403588 633047 566122 567756 452251 510404 590526 522975 521785 510498 627632 591394 603911 526912 520632 567053 590670 627139 628273 597282 659216 594830 532644 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.92%) |
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 386456 403588 414135 417493 417660 417839 418572 432699 432707 434829 436235 438067 443987 444194 452251 452659 453875 455804 457818 460388 464193 464857 466230 466739 476887 478238 478707 487605 492239 496813 498345 500758 501682 504692 507876 508796 509058 510404 510498 510769 511791 519319 519322 519349 519610 520632 521637 521785 522383 522506 522975 523430 525190 525349 525612 526118 526492 526908 526912 527706 527738 528445 528652 532644 541776 542094 545038 550587 552991 555024 555127 566047 566122 567053 567062 567756 568283 569431 584511 590526 590670 591394 592382 594830 596497 597282 598644 599950 602006 603911 614673 618534 622035 627139 627632 628273 633047 643517 659216 661510 699409 714468 744704 766141 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"camera sex"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"camera секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"camera секс"
]
|
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.