Query Metrics
7
Database Queries
7
Different statements
195.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.62 ms (85.10%) |
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 196316 322815 384574 386810 395423 395567 396538 396560 398740 399354 399396 399408 399705 401704 401728 401762 402546 408443 413078 414342 420459 421077 425493 425512 428104 428502 428535 428723 428834 429766 429799 437118 444771 446555 446972 449679 450390 452094 452606 453333 453335 457847 460129 460328 460606 462742 462788 464171 464346 464604 465095 466635 467699 468041 468797 469619 470848 471140 472263 479698 479857 485159 485175 486383 491387 495444 504900 515559 518015 519819 522172 522359 523951 524193 526669 529209 529432 530482 530784 531907 532839 533477 533480 536579 536590 536653 536863 537773 540070 543860 566035 570726 584230 585328 592197 593279 595200 600269 605569 607667 615636 617424 619734 632269 633421 645230 654273 663168 676636 680100 692050 721106 745384 789692 803317 805429 805439 816547 821043 821409 ] |
||||||||||||||||||||||||||||||
|
19.81 ms (10.12%) |
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 789692 469619 395567 466635 504900 518015 485159 529209 522172 414342 429766 524193 532839 536590 530482 536653 530784 745384 537773 566035 617424 680100 429799 536579 452606 479857 543860 676636 632269 384574 196316 395423 322815 399408 399396 398740 399705 401762 425493 428834 444771 425512 437118 413078 821409 816547 821043 449679 452094 453335 472263 479698 446972 450390 453333 460129 465095 486383 457847 468797 471140 531907 515559 533480 495444 540070 462788 464346 467699 468041 645230 654273 692050 721106 607667 592197 600269 605569 619734 803317 386810 401704 420459 428104 428502 421077 428723 464604 396538 401728 408443 460606 428535 446555 491387 523951 522359 529432 536863 396560 399354 402546 595200 460328 470848 464171 485175 533477 519819 526669 462742 570726 584230 663168 585328 593279 615636 805429 805439 633421 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.30%) |
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 196316 322815 384574 386810 395423 395567 396538 396560 398740 399354 399396 399408 399705 401704 401728 401762 402546 408443 413078 414342 420459 421077 425493 425512 428104 428502 428535 428723 428834 429766 429799 437118 444771 446555 446972 449679 450390 452094 452606 453333 453335 457847 460129 460328 460606 462742 462788 464171 464346 464604 465095 466635 467699 468041 468797 469619 470848 471140 472263 479698 479857 485159 485175 486383 491387 495444 504900 515559 518015 519819 522172 522359 523951 524193 526669 529209 529432 530482 530784 531907 532839 533477 533480 536579 536590 536653 536863 537773 540070 543860 566035 570726 584230 585328 592197 593279 595200 600269 605569 607667 615636 617424 619734 632269 633421 645230 654273 663168 676636 680100 692050 721106 745384 789692 803317 805429 805439 816547 821043 821409 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные cock межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge cock interracial"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные cock межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.