Query Metrics
7
Database Queries
7
Different statements
369.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.80 ms (56.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер рыжая milf"
]
|
||||||||||||||||||||||||||||||
|
135.21 ms (36.55%) |
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 397903 405699 418714 420320 423771 442836 451505 452358 454193 458034 459413 462396 462508 464652 468219 471472 483738 484247 485096 487600 491855 492779 492969 498250 499188 503201 503535 504246 512440 512459 516385 518910 520692 520846 523361 523607 527306 531426 533483 535745 537354 539572 541478 541481 542161 542280 542767 543604 544977 548057 548076 550032 557097 558512 558537 560506 562974 563152 567054 567136 572008 574404 577021 577313 583476 585261 586124 586307 590102 594534 596189 596684 603365 604265 607438 612864 614193 618332 625807 636507 646413 646796 664108 686334 686807 696890 706006 726317 728458 728487 728497 733554 734509 739926 743510 748799 761756 763942 766637 766647 781861 781873 782427 783312 791457 792185 802001 804380 804765 807821 809075 809782 810297 811054 812102 812751 814729 819511 824870 826015 ] |
||||||||||||||||||||||||||||||
|
15.73 ms (4.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 810297 418714 503201 405699 824870 814729 826015 451505 452358 484247 539572 498250 520846 523361 518910 537354 516385 531426 535745 487600 541478 542767 562974 572008 577021 541481 548076 558512 577313 583476 686334 686807 706006 646413 557097 560506 603365 607438 604265 585261 596189 594534 781873 811054 781861 804380 726317 791457 802001 807821 812102 812751 766637 728487 748799 743510 733554 766647 614193 782427 397903 423771 454193 464652 462508 458034 503535 491855 492969 504246 512440 520692 590102 574404 492779 420320 459413 543604 442836 819511 462396 471472 483738 523607 499188 512459 527306 533483 468219 485096 542161 544977 567054 567136 542280 550032 558537 646796 664108 696890 548057 563152 596684 618332 636507 586307 612864 586124 625807 804765 809075 792185 809782 734509 783312 728497 739926 761756 763942 728458 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (0.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 397903 405699 418714 420320 423771 442836 451505 452358 454193 458034 459413 462396 462508 464652 468219 471472 483738 484247 485096 487600 491855 492779 492969 498250 499188 503201 503535 504246 512440 512459 516385 518910 520692 520846 523361 523607 527306 531426 533483 535745 537354 539572 541478 541481 542161 542280 542767 543604 544977 548057 548076 550032 557097 558512 558537 560506 562974 563152 567054 567136 572008 574404 577021 577313 583476 585261 586124 586307 590102 594534 596189 596684 603365 604265 607438 612864 614193 618332 625807 636507 646413 646796 664108 686334 686807 696890 706006 726317 728458 728487 728497 733554 734509 739926 743510 748799 761756 763942 766637 766647 781861 781873 782427 783312 791457 792185 802001 804380 804765 807821 809075 809782 810297 811054 812102 812751 814729 819511 824870 826015 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер рыжая milf"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"вебкам redhead milf"
]
|
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.