Query Metrics
7
Database Queries
7
Different statements
150.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.34 ms (77.94%) |
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 96371 382165 388460 397437 398113 401857 402618 402649 407423 410682 413277 414374 414929 419628 430350 432288 441027 443085 443086 444533 444538 449210 451774 452875 455132 457293 468678 469223 471676 475056 476191 476658 480502 481904 483745 485638 487774 495273 495747 498112 508150 511857 512224 512938 515051 516551 517928 518766 519317 520850 531201 532791 533375 533382 534536 534560 541442 544498 545982 547464 552699 566148 580193 586999 590370 590411 599875 601535 604351 609889 614743 614957 615913 618280 627147 628104 629806 632046 632588 632636 632657 633748 634100 636948 639784 641126 648832 662072 669010 669023 669565 673441 680183 695866 710644 718678 735144 737578 741499 742849 745082 747155 749087 749255 752643 752682 752711 756233 757445 777052 777055 782236 782839 784149 803506 806591 807568 807834 ] |
||||||||||||||||||||||||||||||
|
22.09 ms (14.67%) |
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 541442 648832 718678 614957 627147 630427 777055 742849 806591 749087 782236 498112 414929 444533 512224 476191 471676 532791 512938 382165 397437 398113 402618 480502 476658 534536 534560 547464 580193 669010 710644 662072 669565 669023 673441 695866 590370 586999 634100 628104 629806 636948 784149 803506 777052 782839 807568 756233 807834 741499 752643 752682 752711 737578 745082 747155 757445 735144 749255 609889 618280 410682 545982 566148 432288 96371 388460 443085 441027 449210 475056 495747 485638 544498 552699 615913 407423 443086 451774 444538 468678 402649 413277 452875 457293 455132 469223 515051 483745 516551 524677 511857 518766 414374 419628 531201 430350 614743 481904 533382 533375 517928 680183 639784 632657 599875 632588 632636 632046 601535 633748 641126 604351 401857 495273 487774 519317 590411 520850 508150 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.82%) |
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 96371 382165 388460 397437 398113 401857 402618 402649 407423 410682 413277 414374 414929 419628 430350 432288 441027 443085 443086 444533 444538 449210 451774 452875 455132 457293 468678 469223 471676 475056 476191 476658 480502 481904 483745 485638 487774 495273 495747 498112 508150 511857 512224 512938 515051 516551 517928 518766 519317 520850 531201 532791 533375 533382 534536 534560 541442 544498 545982 547464 552699 566148 580193 586999 590370 590411 599875 601535 604351 609889 614743 614957 615913 618280 627147 628104 629806 632046 632588 632636 632657 633748 634100 636948 639784 641126 648832 662072 669010 669023 669565 673441 680183 695866 710644 718678 735144 737578 741499 742849 745082 747155 749087 749255 752643 752682 752711 756233 757445 777052 777055 782236 782839 784149 803506 806591 807568 807834 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fisting stockings"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фистинг чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.30%) |
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.