Query Metrics
7
Database Queries
7
Different statements
165.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.82 ms (79.56%) |
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 401793 403006 404399 416624 418844 424765 436472 436639 439142 444371 446393 448450 450367 450669 450969 451222 452558 453844 454755 455174 456646 456722 457092 457310 458868 459032 459868 461787 462414 462997 463693 464096 467569 467661 469027 470082 470403 472438 472983 473515 473533 473867 475860 476330 477485 478216 479580 479611 488152 491316 495653 499177 500186 504185 507452 508071 508505 508620 510244 511542 511858 512154 512480 515791 516507 516511 517879 517897 521623 523236 524568 525448 526097 527987 528555 528770 528863 528884 529975 531351 532560 539029 541706 544438 544576 552706 558361 558645 560266 560746 561199 564955 568264 568425 574739 577391 581225 582687 584067 585328 587434 592785 601388 602594 608227 618514 622264 622971 625893 643542 645096 695164 737110 756698 783291 784417 806877 807590 808896 811271 ] |
||||||||||||||||||||||||||||||
|
24.61 ms (14.85%) |
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 643542 592785 601388 608227 618514 625893 784417 737110 806877 807590 811271 756698 783291 808896 403006 404399 436472 446393 462997 475860 478216 453844 459032 462414 472983 479611 418844 461787 473867 479580 436639 454755 456646 459868 463693 472438 439142 444371 448450 450367 451222 457092 464096 470082 473515 477485 504185 507452 517897 521623 523236 524568 541706 500186 508071 508505 512480 495653 512154 516507 525448 488152 499177 508620 622971 568425 602594 531351 401793 416624 424765 561199 458868 467661 470403 473533 491316 450669 457310 467569 450969 452558 455174 456722 469027 476330 511858 527987 528555 510244 515791 517879 529975 516511 528770 528863 511542 526097 528884 532560 539029 558361 560746 564955 544576 552706 574739 577391 584067 544438 560266 582687 695164 645096 558645 568264 581225 585328 622264 587434 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.45%) |
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 401793 403006 404399 416624 418844 424765 436472 436639 439142 444371 446393 448450 450367 450669 450969 451222 452558 453844 454755 455174 456646 456722 457092 457310 458868 459032 459868 461787 462414 462997 463693 464096 467569 467661 469027 470082 470403 472438 472983 473515 473533 473867 475860 476330 477485 478216 479580 479611 488152 491316 495653 499177 500186 504185 507452 508071 508505 508620 510244 511542 511858 512154 512480 515791 516507 516511 517879 517897 521623 523236 524568 525448 526097 527987 528555 528770 528863 528884 529975 531351 532560 539029 541706 544438 544576 552706 558361 558645 560266 560746 561199 564955 568264 568425 574739 577391 581225 582687 584067 585328 587434 592785 601388 602594 608227 618514 622264 622971 625893 643542 645096 695164 737110 756698 783291 784417 806877 807590 808896 811271 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"babe webcam"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"babe вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"babe вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.92%) |
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.