Query Metrics
7
Database Queries
7
Different statements
196.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.35 ms (86.53%) |
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 391326 395270 406172 406764 411802 415530 415735 415941 417723 417725 418846 420301 420543 424933 430142 430310 431120 440634 446614 447469 447738 448704 453934 468691 474604 474691 482104 482671 486161 486447 543271 550413 572045 582779 585133 593243 596238 598116 601116 605314 620329 630487 635142 637801 641647 642797 645956 648572 653517 661092 662030 662963 663357 663520 665585 665897 667392 671178 671383 672377 674120 690429 690443 691547 694134 696472 701094 701158 701821 704273 705121 705352 705961 709079 711668 711875 715187 716562 717025 718253 718283 719095 720439 722455 723434 724165 724659 726832 728792 730977 731838 733597 733614 736003 737081 737389 740323 740515 740598 740784 741120 741303 741961 741978 742225 743986 744645 745411 747388 750550 752112 752714 755440 757088 760413 765973 796854 798423 804775 808152 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (7.92%) |
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 543271 572045 661092 671178 672377 696472 701821 705121 711875 716562 717025 722455 645956 648572 662030 663357 663520 665585 667392 671383 674120 690443 705961 709079 715187 718283 653517 662963 665897 690429 691547 694134 705352 711668 723434 550413 582779 620329 630487 641647 637801 642797 593243 596238 601116 635142 598116 605314 796854 804775 736003 740598 740784 741978 742225 747388 752714 757088 798423 808152 728792 740515 741961 750550 760413 724659 733597 733614 737389 740323 745411 752112 724165 730977 731838 737081 741120 741303 743986 744645 755440 726832 765973 701094 701158 704273 718253 719095 720439 395270 391326 406172 406764 417723 417725 431120 411802 415530 415735 420543 424933 430142 430310 415941 418846 420301 440634 585133 482671 447469 482104 486161 486447 447738 448704 453934 468691 474604 474691 446614 ] |
||||||||||||||||||||||||||||||
|
3.91 ms (1.99%) |
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 391326 395270 406172 406764 411802 415530 415735 415941 417723 417725 418846 420301 420543 424933 430142 430310 431120 440634 446614 447469 447738 448704 453934 468691 474604 474691 482104 482671 486161 486447 543271 550413 572045 582779 585133 593243 596238 598116 601116 605314 620329 630487 635142 637801 641647 642797 645956 648572 653517 661092 662030 662963 663357 663520 665585 665897 667392 671178 671383 672377 674120 690429 690443 691547 694134 696472 701094 701158 701821 704273 705121 705352 705961 709079 711668 711875 715187 716562 717025 718253 718283 719095 720439 722455 723434 724165 724659 726832 728792 730977 731838 733597 733614 736003 737081 737389 740323 740515 740598 740784 741120 741303 741961 741978 742225 743986 744645 745411 747388 750550 752112 752714 755440 757088 760413 765973 796854 798423 804775 808152 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting cock"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг cock"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг cock"
]
|
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.