Query Metrics
7
Database Queries
7
Different statements
362.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.68 ms (58.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double teen анал"
]
|
||||||||||||||||||||||||||||||
|
125.95 ms (34.72%) |
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 96231 96269 96524 390437 395646 398317 402546 404800 404804 407290 409615 410934 410940 413376 413398 414048 414259 420559 426390 429805 431805 434443 440698 447470 448100 448560 449404 449450 460889 462742 470541 472431 473387 481145 482194 495397 498963 499111 510394 513696 526162 530497 532916 533003 533743 533949 535466 535747 536785 537206 537776 537887 547242 550198 558124 565245 565249 583699 589071 590741 591804 598057 613516 615459 627409 629243 632593 632658 633807 636293 637432 640777 644310 648836 648862 650794 651620 672999 676097 679770 679775 684048 686658 696950 700282 702164 704256 706652 715790 719001 721846 723560 727833 730329 731198 732053 733106 748950 749990 751435 761231 764295 770396 770405 775744 775893 777012 782556 787500 792583 801931 801942 808116 809439 809928 811425 814888 817328 823721 827523 ] |
||||||||||||||||||||||||||||||
|
17.76 ms (4.90%) |
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 526162 589071 395646 409615 429805 704256 823721 727833 749990 96524 449450 537887 770396 533949 537206 565249 702164 598057 410940 447470 510394 700282 499111 629243 583699 764295 731198 547242 676097 410934 420559 390437 448560 449404 537776 498963 535466 513696 472431 706652 719001 650794 679770 651620 637432 632658 640777 770405 748950 751435 633807 413376 96231 426390 723560 827523 460889 533003 532916 686658 672999 615459 590741 801931 811425 775744 777012 801942 809439 732053 782556 808116 809928 733106 627409 644310 696950 715790 775893 787500 792583 404804 407290 398317 448100 636293 434443 565245 632593 817328 550198 648836 591804 473387 721846 730329 495397 402546 404800 440698 414048 814888 470541 481145 530497 535747 533743 536785 462742 684048 648862 679775 558124 613516 761231 413398 414259 431805 96269 482194 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (0.77%) |
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 96231 96269 96524 390437 395646 398317 402546 404800 404804 407290 409615 410934 410940 413376 413398 414048 414259 420559 426390 429805 431805 434443 440698 447470 448100 448560 449404 449450 460889 462742 470541 472431 473387 481145 482194 495397 498963 499111 510394 513696 526162 530497 532916 533003 533743 533949 535466 535747 536785 537206 537776 537887 547242 550198 558124 565245 565249 583699 589071 590741 591804 598057 613516 615459 627409 629243 632593 632658 633807 636293 637432 640777 644310 648836 648862 650794 651620 672999 676097 679770 679775 684048 686658 696950 700282 702164 704256 706652 715790 719001 721846 723560 727833 730329 731198 732053 733106 748950 749990 751435 761231 764295 770396 770405 775744 775893 777012 782556 787500 792583 801931 801942 808116 809439 809928 811425 814888 817328 823721 827523 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.44%) |
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.