Query Metrics
7
Database Queries
7
Different statements
155.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.37 ms (84.90%) |
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 384142 387394 390970 392498 393330 401628 401674 403582 412790 413685 416689 419832 419834 421437 428171 428177 434491 435421 440045 443498 443916 447159 447703 447734 449531 452777 452922 455494 456190 457329 458867 459203 461713 463325 464837 466098 468348 468375 469741 470373 470471 474596 476164 476728 476786 477245 479662 480206 486841 489876 494210 497731 500908 505109 505387 507956 508564 510781 511005 511869 514430 523761 525281 531571 531838 545669 554852 555804 566767 590192 601479 605730 605829 616598 623440 627358 629756 631106 643126 648538 652954 677147 680312 690892 694347 712576 716123 724523 728262 729291 756666 756677 765723 765792 769038 769040 771607 776001 778133 778215 778928 778951 781331 781339 781364 781621 784209 786493 788899 790446 791215 792989 796156 800576 802025 806617 810320 817287 824613 827362 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (9.10%) |
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 476164 712576 510781 590192 781621 469741 457329 476728 497731 514430 443498 452922 403582 419834 470373 631106 390970 778928 810320 474596 555804 463325 523761 489876 500908 566767 765792 505109 827362 778133 778951 792989 806617 756666 769038 724523 769040 771607 778215 781331 776001 435421 623440 643126 393330 716123 788899 479662 531571 545669 680312 694347 648538 601479 605829 616598 447734 511005 511869 508564 477245 428171 507956 494210 629756 652954 531838 468375 401628 401674 690892 459203 554852 729291 765723 756677 781364 802025 796156 525281 434491 447703 447159 461713 464837 480206 443916 458867 476786 455494 466098 486841 384142 817287 824613 781339 786493 790446 784209 728262 605730 627358 791215 800576 387394 392498 413685 416689 421437 428177 452777 468348 470471 505387 677147 412790 456190 419832 440045 449531 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.66%) |
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 384142 387394 390970 392498 393330 401628 401674 403582 412790 413685 416689 419832 419834 421437 428171 428177 434491 435421 440045 443498 443916 447159 447703 447734 449531 452777 452922 455494 456190 457329 458867 459203 461713 463325 464837 466098 468348 468375 469741 470373 470471 474596 476164 476728 476786 477245 479662 480206 486841 489876 494210 497731 500908 505109 505387 507956 508564 510781 511005 511869 514430 523761 525281 531571 531838 545669 554852 555804 566767 590192 601479 605730 605829 616598 623440 627358 629756 631106 643126 648538 652954 677147 680312 690892 694347 712576 716123 724523 728262 729291 756666 756677 765723 765792 769038 769040 771607 776001 778133 778215 778928 778951 781331 781339 781364 781621 784209 786493 788899 790446 791215 792989 796156 800576 802025 806617 810320 817287 824613 827362 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal webcam amateur"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал вебкамер любительск"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.94%) |
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.