Query Metrics
7
Database Queries
7
Different statements
184.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.27 ms (84.25%) |
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 233683 411350 411362 415246 422273 422354 422394 424042 427135 439589 439633 442441 442989 446902 448288 451495 459190 459636 459715 461814 462172 463469 464526 465362 465909 466343 466357 466761 467818 469117 469680 470654 473793 475200 475621 475942 476419 477088 477974 479606 480689 480912 481430 483306 484147 484646 489022 490952 492644 493193 494587 495326 495732 497044 504721 506039 507412 508610 508801 508871 509159 509264 509747 509761 512424 513377 514000 514041 517299 520107 520810 520897 522337 523978 525412 525455 528321 534494 544099 545493 546664 546897 549570 549576 553023 561990 563299 581072 590392 595396 595421 596648 597584 598457 609714 610260 612514 614983 623031 626969 637589 659986 674278 695401 700926 718551 730970 736928 742657 745474 753497 755013 757112 780852 784189 785811 794153 794874 795654 806242 ] |
||||||||||||||||||||||||||||||
|
17.05 ms (9.25%) |
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 549570 581072 546664 549576 597584 590392 596648 598457 595421 614983 427135 233683 473793 442989 465909 466343 506039 517299 509761 422394 442441 544099 553023 610260 612514 780852 794874 745474 795654 626969 475200 718551 785811 411362 415246 439589 465362 477974 439633 464526 480689 470654 509747 493193 520897 484646 495326 467818 475621 494587 509159 545493 637589 459190 462172 469117 480912 451495 466761 475942 479606 424042 459636 459715 469680 481430 461814 477088 509264 523978 483306 484147 492644 508610 508801 513377 525412 525455 497044 508871 512424 514041 520107 522337 528321 489022 490952 495732 507412 514000 520810 700926 674278 695401 609714 794153 753497 755013 784189 742657 806242 736928 563299 466357 463469 504721 546897 561990 422354 411350 730970 757112 534494 659986 623031 595396 422273 446902 476419 448288 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (1.74%) |
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 233683 411350 411362 415246 422273 422354 422394 424042 427135 439589 439633 442441 442989 446902 448288 451495 459190 459636 459715 461814 462172 463469 464526 465362 465909 466343 466357 466761 467818 469117 469680 470654 473793 475200 475621 475942 476419 477088 477974 479606 480689 480912 481430 483306 484147 484646 489022 490952 492644 493193 494587 495326 495732 497044 504721 506039 507412 508610 508801 508871 509159 509264 509747 509761 512424 513377 514000 514041 517299 520107 520810 520897 522337 523978 525412 525455 528321 534494 544099 545493 546664 546897 549570 549576 553023 561990 563299 581072 590392 595396 595421 596648 597584 598457 609714 610260 612514 614983 623031 626969 637589 659986 674278 695401 700926 718551 730970 736928 742657 745474 753497 755013 757112 780852 784189 785811 794153 794874 795654 806242 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ukrainian ass"
]
|
||||||||||||||||||||||||||||||
|
2.36 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие русск жоп"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие русск жоп"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.81%) |
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.