Query Metrics
7
Database Queries
7
Different statements
155.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.84 ms (84.33%) |
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 133235 199286 203645 305464 384786 401126 410688 414432 419334 423464 427738 435166 445106 445766 446805 450077 451001 454479 457966 458494 458533 458878 458899 459022 459415 460790 462937 463155 463305 463758 468267 469013 473342 473344 480924 480991 484329 486200 486643 487712 490070 490607 493006 495259 495324 496607 500638 502560 505202 505538 510244 515674 515707 516689 517864 518947 520903 523709 525453 525898 530423 531814 533325 537107 538021 547964 548740 551228 552604 555663 566081 568915 573416 582808 586366 598463 601721 609689 641554 642527 645138 655188 666496 669458 674474 686011 689561 691878 696126 707510 710403 715041 718788 725098 725477 725568 726701 731105 733142 738301 742059 747313 750308 750587 752108 754168 765870 769133 773553 774227 781150 784856 787284 787950 788887 790460 792080 792817 807247 812763 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (9.63%) |
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 505538 518947 691878 486200 707510 645138 641554 459022 457966 642527 486643 582808 552604 725477 750308 725098 555663 515674 525453 715041 784856 787284 807247 742059 765870 419334 790460 446805 551228 573416 788887 502560 496607 689561 696126 686011 459415 473344 463155 484329 454479 530423 750587 773553 747313 674474 666496 787950 774227 733142 726701 510244 601721 462937 458533 450077 568915 427738 460790 515707 384786 525898 451001 523709 500638 445766 480924 473342 490607 538021 423464 458899 458878 493006 533325 548740 203645 655188 516689 586366 792080 731105 812763 445106 752108 710403 401126 469013 537107 725568 792817 463758 495259 781150 609689 754168 468267 505202 520903 133235 410688 414432 487712 517864 566081 463305 495324 718788 305464 490070 480991 531814 547964 598463 738301 435166 199286 669458 769133 458494 ] |
||||||||||||||||||||||||||||||
|
3.09 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 133235 199286 203645 305464 384786 401126 410688 414432 419334 423464 427738 435166 445106 445766 446805 450077 451001 454479 457966 458494 458533 458878 458899 459022 459415 460790 462937 463155 463305 463758 468267 469013 473342 473344 480924 480991 484329 486200 486643 487712 490070 490607 493006 495259 495324 496607 500638 502560 505202 505538 510244 515674 515707 516689 517864 518947 520903 523709 525453 525898 530423 531814 533325 537107 538021 547964 548740 551228 552604 555663 566081 568915 573416 582808 586366 598463 601721 609689 641554 642527 645138 655188 666496 669458 674474 686011 689561 691878 696126 707510 710403 715041 718788 725098 725477 725568 726701 731105 733142 738301 742059 747313 750308 750587 752108 754168 765870 769133 773553 774227 781150 784856 787284 787950 788887 790460 792080 792817 807247 812763 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на дому"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.82%) |
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.