Query Metrics
7
Database Queries
7
Different statements
150.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.39 ms (85.56%) |
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 7286 33236 145660 146112 185334 257966 385000 387268 387270 394433 395703 395717 395759 395942 400672 401881 403988 411630 411715 411739 414498 423243 431566 434167 445058 455180 458051 473252 476306 477409 494352 508109 514470 515165 515171 515932 519152 520730 526111 549240 549296 549421 550651 556408 556796 557326 563876 572611 579922 581659 583872 589655 592648 598777 605469 619463 622198 622623 624238 624239 624334 650951 652252 663395 663509 665187 665213 665219 665419 665434 667294 667868 673567 677569 683536 684197 684364 685612 686054 687927 688677 696272 697289 699009 701118 702889 707282 712971 715724 716069 718499 719144 719342 724719 725613 727479 729743 740821 746095 754784 759660 780628 784669 788426 790977 791000 797735 803977 807689 814644 815845 815888 816214 816826 817064 818351 818421 821578 822172 823181 ] |
||||||||||||||||||||||||||||||
|
11.46 ms (7.64%) |
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 665213 667868 788426 550651 400672 817064 818351 815845 815888 514470 650951 652252 683536 685612 699009 719342 696272 572611 624238 803977 780628 797735 727479 759660 385000 589655 515165 520730 455180 394433 146112 387268 445058 598777 605469 494352 33236 476306 549240 665187 665219 718499 724719 784669 145660 387270 401881 581659 719144 725613 715724 434167 667294 395942 7286 816214 821578 822172 818421 684364 686054 701118 663395 677569 687927 697289 702889 716069 684197 688677 712971 549421 556796 557326 619463 624334 790977 791000 807689 729743 754784 740821 395717 622623 185334 395759 403988 423243 431566 411715 816826 508109 549296 414498 477409 395703 473252 526111 458051 519152 665419 257966 707282 673567 583872 624239 622198 515171 665434 746095 592648 663509 411630 411739 814644 823181 515932 579922 556408 563876 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.10%) |
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 7286 33236 145660 146112 185334 257966 385000 387268 387270 394433 395703 395717 395759 395942 400672 401881 403988 411630 411715 411739 414498 423243 431566 434167 445058 455180 458051 473252 476306 477409 494352 508109 514470 515165 515171 515932 519152 520730 526111 549240 549296 549421 550651 556408 556796 557326 563876 572611 579922 581659 583872 589655 592648 598777 605469 619463 622198 622623 624238 624239 624334 650951 652252 663395 663509 665187 665213 665219 665419 665434 667294 667868 673567 677569 683536 684197 684364 685612 686054 687927 688677 696272 697289 699009 701118 702889 707282 712971 715724 716069 718499 719144 719342 724719 725613 727479 729743 740821 746095 754784 759660 780628 784669 788426 790977 791000 797735 803977 807689 814644 815845 815888 816214 816826 817064 818351 818421 821578 822172 823181 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young hairy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young волосатая"
]
|
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.