Query Metrics
7
Database Queries
7
Different statements
179.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.03 ms (86.98%) |
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 3576 6694 32549 73289 131517 145757 187759 187974 188462 370905 382284 382385 385690 388776 394433 395938 397889 398567 400728 401303 405191 406616 407531 407586 407938 409016 409702 409882 411630 411729 423455 433685 446634 453105 453157 456019 459633 460003 461320 463295 465597 466914 471011 476306 477975 479351 480481 483675 490637 497859 499844 499919 504028 519152 535319 536986 544468 544492 549240 552688 558019 560409 562420 567615 577419 577576 578158 581345 599737 605313 610038 621682 650146 660807 665187 665224 665372 665416 665419 681179 700804 710856 715420 718498 718570 722155 723961 724719 724748 725136 725199 726262 728381 728958 729058 731789 733266 736138 740457 742280 745997 748431 753244 755414 758799 759015 781771 794684 795341 795918 796343 800661 800737 802048 809907 809993 810100 824320 824587 827249 ] |
||||||||||||||||||||||||||||||
|
14.13 ms (7.88%) |
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 715420 681179 794684 453105 800661 544492 724719 728958 740457 497859 795918 188462 73289 433685 577419 665372 423455 827249 731789 544468 461320 567615 725199 745997 802048 411729 476306 465597 733266 409702 519152 718498 718570 755414 809907 499844 6694 560409 456019 742280 32549 409882 536986 499919 535319 578158 599737 759015 723961 131517 407938 397889 549240 665187 382385 795341 605313 446634 145757 471011 407531 406616 187759 394433 824587 650146 665419 710856 729058 810100 728381 700804 800737 504028 552688 577576 665416 665224 758799 409016 479351 405191 370905 187974 490637 824320 483675 463295 809993 796343 725136 748431 781771 753244 388776 621682 724748 460003 562420 722155 726262 3576 610038 401303 459633 660807 581345 395938 398567 411630 736138 382284 558019 453157 477975 407586 400728 385690 480481 466914 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.53%) |
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 3576 6694 32549 73289 131517 145757 187759 187974 188462 370905 382284 382385 385690 388776 394433 395938 397889 398567 400728 401303 405191 406616 407531 407586 407938 409016 409702 409882 411630 411729 423455 433685 446634 453105 453157 456019 459633 460003 461320 463295 465597 466914 471011 476306 477975 479351 480481 483675 490637 497859 499844 499919 504028 519152 535319 536986 544468 544492 549240 552688 558019 560409 562420 567615 577419 577576 578158 581345 599737 605313 610038 621682 650146 660807 665187 665224 665372 665416 665419 681179 700804 710856 715420 718498 718570 722155 723961 724719 724748 725136 725199 726262 728381 728958 729058 731789 733266 736138 740457 742280 745997 748431 753244 755414 758799 759015 781771 794684 795341 795918 796343 800661 800737 802048 809907 809993 810100 824320 824587 827249 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебля волосатых женщин…"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс волосатая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.27 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.