Query Metrics
7
Database Queries
7
Different statements
189.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.46 ms (84.53%) |
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 318892 384509 393749 402027 413249 414635 414783 418422 418852 420629 422523 422637 426461 429974 433553 439868 439877 445726 446252 446254 447809 451015 452906 453228 456251 456909 459801 460769 460770 462117 462123 464177 464277 465127 465177 466588 466645 471359 472592 473062 473087 473756 474380 474585 476421 480329 484592 484956 485163 487038 489050 489499 489566 490694 491195 494499 497039 497067 499782 502678 504152 504900 505108 505952 507397 508043 508902 509457 514718 517367 518427 518982 527791 540305 540334 540601 541099 548744 552162 558457 559855 559912 560639 562256 562324 563573 571037 571465 572314 574607 575059 575078 575421 575765 576039 576098 585366 592692 594093 597251 600559 621389 629792 639804 641682 680202 693325 705624 709919 714491 716450 722625 722891 725640 742434 790239 792722 792767 813904 817451 ] |
||||||||||||||||||||||||||||||
|
18.54 ms (9.76%) |
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 792722 439877 473087 456251 497039 576039 680202 572314 725640 722625 790239 460769 471359 418422 318892 422637 504900 426461 453228 466588 540334 562256 563573 558457 571465 575059 575765 559855 594093 592692 722891 476421 422523 464177 508043 489566 517367 489499 504152 414783 439868 420629 817451 445726 446252 491195 460770 518982 552162 576098 575078 548744 693325 574607 575421 621389 641682 585366 597251 629792 639804 742434 414635 446254 447809 456909 474380 393749 462123 499782 505952 484956 490694 813904 518427 508902 473756 571037 714491 716450 705624 709919 562324 600559 792767 462117 473062 402027 452906 465127 466645 433553 459801 480329 465177 494499 484592 509457 502678 527791 540601 384509 429974 413249 507397 418852 451015 514718 464277 487038 474585 505108 540305 497067 472592 485163 489050 541099 560639 559912 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (1.95%) |
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 318892 384509 393749 402027 413249 414635 414783 418422 418852 420629 422523 422637 426461 429974 433553 439868 439877 445726 446252 446254 447809 451015 452906 453228 456251 456909 459801 460769 460770 462117 462123 464177 464277 465127 465177 466588 466645 471359 472592 473062 473087 473756 474380 474585 476421 480329 484592 484956 485163 487038 489050 489499 489566 490694 491195 494499 497039 497067 499782 502678 504152 504900 505108 505952 507397 508043 508902 509457 514718 517367 518427 518982 527791 540305 540334 540601 541099 548744 552162 558457 559855 559912 560639 562256 562324 563573 571037 571465 572314 574607 575059 575078 575421 575765 576039 576098 585366 592692 594093 597251 600559 621389 629792 639804 641682 680202 693325 705624 709919 714491 716450 722625 722891 725640 742434 790239 792722 792767 813904 817451 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck skinny"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс худые"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
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.