Query Metrics
7
Database Queries
7
Different statements
479.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
238.91 ms (49.88%) |
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 183044 395564 400465 409894 413929 424314 424321 424366 425959 432782 432831 441326 441462 441631 441640 444977 446300 446909 447947 452242 452286 452492 453044 453826 454944 455411 457566 460603 471088 471635 474490 474493 475374 475860 478756 479637 481766 483103 483461 484459 485374 485674 486574 486858 486869 486873 487547 488389 489139 489985 490769 491251 491380 495114 498352 498420 498428 498786 501733 503154 504186 507168 507797 509074 509229 509261 509411 510199 510275 512848 515331 515374 516505 516605 517275 517554 517779 518603 518753 519325 519339 519556 521042 522186 523012 523056 524075 526819 527881 527923 528838 528927 532351 544420 545616 545718 546637 549730 549735 555864 556854 567135 567405 567549 569532 584635 584667 596649 598225 603831 605222 605442 615907 621445 625770 636245 647328 651285 716540 801917 ] |
||||||||||||||||||||||||||||||
|
211.94 ms (44.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"busty минет оральн секс любительск"
]
|
||||||||||||||||||||||||||||||
|
19.17 ms (4.00%) |
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 546637 651285 478756 452242 636245 400465 483461 801917 625770 441462 485674 489985 486858 605222 474490 519339 487547 498420 413929 517779 621445 471088 441640 457566 519325 516505 509411 409894 441326 605442 503154 509229 523056 483103 517275 516605 567405 489139 432831 424321 424366 491251 460603 510199 504186 425959 567549 183044 447947 528838 549730 596649 515331 488389 455411 545718 527881 556854 615907 522186 485374 521042 528927 486574 446300 481766 424314 532351 544420 498428 490769 475860 484459 475374 507168 518603 567135 584635 471635 519556 446909 498352 444977 432782 479637 507797 452492 526819 486869 515374 495114 517554 491380 569532 524075 509261 453044 509074 647328 452286 598225 395564 441631 474493 545616 510275 486873 454944 518753 603831 523012 584667 501733 555864 527923 549735 498786 512848 716540 453826 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (0.67%) |
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 183044 395564 400465 409894 413929 424314 424321 424366 425959 432782 432831 441326 441462 441631 441640 444977 446300 446909 447947 452242 452286 452492 453044 453826 454944 455411 457566 460603 471088 471635 474490 474493 475374 475860 478756 479637 481766 483103 483461 484459 485374 485674 486574 486858 486869 486873 487547 488389 489139 489985 490769 491251 491380 495114 498352 498420 498428 498786 501733 503154 504186 507168 507797 509074 509229 509261 509411 510199 510275 512848 515331 515374 516505 516605 517275 517554 517779 518603 518753 519325 519339 519556 521042 522186 523012 523056 524075 526819 527881 527923 528838 528927 532351 544420 545616 545718 546637 549730 549735 555864 556854 567135 567405 567549 569532 584635 584667 596649 598225 603831 605222 605442 615907 621445 625770 636245 647328 651285 716540 801917 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"busty blowjob amateur"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"busty минет оральн секс любительск"
]
|
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.