Query Metrics
7
Database Queries
7
Different statements
149.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.92 ms (83.70%) |
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 3561 76836 88410 131602 133695 386798 397775 414337 416742 416751 418215 418380 419144 420358 421121 423814 428280 436230 437867 437925 438464 440571 444197 444684 445666 452773 453901 457341 464186 465629 466907 469100 469198 469437 473298 478976 480438 481807 486856 489338 495757 499163 502369 504474 507094 508800 509983 511674 512975 516035 518622 521481 526501 529003 530021 531866 532576 533030 534257 537091 552069 554889 568449 569168 574049 575404 578180 590478 590696 596288 597482 598310 601026 602614 613000 618256 636236 639108 640222 650408 651601 696594 696597 707361 710918 710945 716695 722388 728469 730415 730860 735977 737473 740409 750067 752275 756212 757484 759345 764556 765479 765668 776398 777688 783460 784149 785069 785470 786876 788463 790219 793520 796372 796659 798685 798706 800658 802600 803129 803393 ] |
||||||||||||||||||||||||||||||
|
13.26 ms (8.89%) |
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 502369 419144 504474 445666 531866 784149 416742 508800 552069 710945 803393 735977 750067 76836 788463 757484 133695 469437 530021 534257 554889 568449 696594 596288 613000 597482 598310 796372 800658 737473 740409 722388 480438 416751 452773 414337 473298 418380 437925 507094 526501 532576 574049 777688 776398 783460 765479 765668 636236 785470 418215 486856 464186 478976 793520 88410 444197 469198 710918 707361 785069 802600 489338 511674 512975 602614 509983 386798 575404 569168 651601 3561 529003 590478 436230 420358 518622 421121 730415 516035 423814 444684 537091 696597 639108 590696 798685 728469 618256 786876 790219 533030 521481 131602 397775 465629 716695 650408 601026 798706 764556 796659 730860 759345 752275 438464 428280 437867 466907 495757 499163 578180 640222 803129 756212 440571 453901 469100 481807 457341 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (2.08%) |
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 3561 76836 88410 131602 133695 386798 397775 414337 416742 416751 418215 418380 419144 420358 421121 423814 428280 436230 437867 437925 438464 440571 444197 444684 445666 452773 453901 457341 464186 465629 466907 469100 469198 469437 473298 478976 480438 481807 486856 489338 495757 499163 502369 504474 507094 508800 509983 511674 512975 516035 518622 521481 526501 529003 530021 531866 532576 533030 534257 537091 552069 554889 568449 569168 574049 575404 578180 590478 590696 596288 597482 598310 601026 602614 613000 618256 636236 639108 640222 650408 651601 696594 696597 707361 710918 710945 716695 722388 728469 730415 730860 735977 737473 740409 750067 752275 756212 757484 759345 764556 765479 765668 776398 777688 783460 784149 785069 785470 786876 788463 790219 793520 796372 796659 798685 798706 800658 802600 803129 803393 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo compilation"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд подборк"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.