Query Metrics
7
Database Queries
7
Different statements
352.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.99 ms (58.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy mature ffm"
]
|
||||||||||||||||||||||||||||||
|
119.76 ms (34.01%) |
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 384016 395818 401318 403879 406206 406298 412433 413901 417631 418934 419370 419783 420270 420925 424703 428477 429143 430210 430357 430422 430451 430556 430633 430836 430845 430846 430853 431111 431112 431117 431352 431376 442281 442332 442726 445396 445436 445471 447182 448669 448807 450318 452513 454147 454975 460669 464139 464328 468630 469017 471629 473204 474120 477744 481163 484519 484727 485454 487717 487746 489082 489950 490265 492128 492323 492602 497866 508662 512891 513155 517008 519087 519933 522556 522914 523537 524977 527000 527006 528089 530507 530513 530884 531072 531413 531425 531441 531468 531511 533957 541614 541667 541698 543868 550571 550976 563093 566243 568480 573765 576630 576713 577371 582234 583533 588211 603642 607293 608358 615012 617137 625342 643364 649953 660747 673965 682153 724305 727812 809930 ] |
||||||||||||||||||||||||||||||
|
17.49 ms (4.97%) |
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 531072 430357 527006 442726 474120 445396 513155 468630 582234 568480 531441 531511 517008 445471 395818 473204 418934 531413 484727 481163 550571 530513 492128 660747 430210 384016 809930 406206 477744 454975 430846 497866 524977 430845 588211 419783 454147 403879 430836 492323 420925 471629 412433 522914 550976 573765 576713 566243 576630 673965 469017 420270 452513 431111 430853 430633 417631 428477 530507 603642 424703 431376 442281 448669 519087 489082 442332 431117 450318 447182 530884 577371 531468 607293 527000 460669 522556 487717 490265 541614 643364 401318 492602 445436 649953 419370 413901 528089 489950 464328 448807 484519 533957 519933 464139 485454 487746 543868 430451 406298 430422 608358 541667 431112 523537 541698 615012 431352 430556 508662 531425 682153 617137 724305 512891 429143 563093 583533 625342 727812 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (0.86%) |
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 384016 395818 401318 403879 406206 406298 412433 413901 417631 418934 419370 419783 420270 420925 424703 428477 429143 430210 430357 430422 430451 430556 430633 430836 430845 430846 430853 431111 431112 431117 431352 431376 442281 442332 442726 445396 445436 445471 447182 448669 448807 450318 452513 454147 454975 460669 464139 464328 468630 469017 471629 473204 474120 477744 481163 484519 484727 485454 487717 487746 489082 489950 490265 492128 492323 492602 497866 508662 512891 513155 517008 519087 519933 522556 522914 523537 524977 527000 527006 528089 530507 530513 530884 531072 531413 531425 531441 531468 531511 533957 541614 541667 541698 543868 550571 550976 563093 566243 568480 573765 576630 576713 577371 582234 583533 588211 603642 607293 608358 615012 617137 625342 643364 649953 660747 673965 682153 724305 727812 809930 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая mature жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая mature жмж секс втро"
]
|
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.