Query Metrics
7
Database Queries
7
Different statements
267.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
241.42 ms (90.23%) |
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 188462 317898 382207 382502 382816 389840 392004 392019 392565 397889 398263 398522 400493 400892 403321 415753 422284 422345 424032 424248 424449 425997 427907 428738 433042 438579 440639 441280 441359 445397 446865 447105 448000 452931 453348 454399 454459 454962 462183 463835 464031 465727 466314 466904 468269 472007 473476 478450 480497 484951 493470 495444 502194 530474 549836 554466 558902 567609 584395 591833 605904 663866 665205 665366 669776 700837 724092 725247 725251 725488 725495 725497 725514 725539 726502 726802 728680 729295 729974 731088 735925 736381 738376 739576 740632 740886 741569 741765 744388 745373 745554 746111 746639 746646 746712 747056 747245 748369 748936 750117 750155 750169 755583 759685 761072 761234 762177 765654 766709 769460 789451 794855 795482 797350 800918 801652 803773 807016 808241 814111 ] |
||||||||||||||||||||||||||||||
|
15.51 ms (5.80%) |
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 807016 725247 725251 725488 729295 731088 735925 745373 746111 747245 794855 800918 736381 738376 759685 762177 725497 739576 740632 741569 741765 744388 745554 747056 750169 755583 724092 725495 725539 726802 728680 740886 746639 746646 746712 748369 748936 761234 765654 769460 750117 750155 761072 700837 789451 795482 797350 801652 803773 392565 317898 382816 398522 392019 382207 397889 398263 400892 438579 441359 425997 441280 415753 424248 427907 440639 814111 454399 454459 465727 446865 468269 472007 448000 452931 473476 530474 502194 495444 462183 466314 466904 484951 493470 584395 663866 665205 665366 669776 549836 554466 558902 567609 605904 591833 808241 726502 729974 725514 766709 403321 422284 422345 424032 424449 445397 453348 463835 464031 188462 382502 428738 447105 454962 478450 480497 389840 392004 400493 433042 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.07%) |
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 188462 317898 382207 382502 382816 389840 392004 392019 392565 397889 398263 398522 400493 400892 403321 415753 422284 422345 424032 424248 424449 425997 427907 428738 433042 438579 440639 441280 441359 445397 446865 447105 448000 452931 453348 454399 454459 454962 462183 463835 464031 465727 466314 466904 468269 472007 473476 478450 480497 484951 493470 495444 502194 530474 549836 554466 558902 567609 584395 591833 605904 663866 665205 665366 669776 700837 724092 725247 725251 725488 725495 725497 725514 725539 726502 726802 728680 729295 729974 731088 735925 736381 738376 739576 740632 740886 741569 741765 744388 745373 745554 746111 746639 746646 746712 747056 747245 748369 748936 750117 750155 750169 755583 759685 761072 761234 762177 765654 766709 769460 789451 794855 795482 797350 800918 801652 803773 807016 808241 814111 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy chubby"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак chubby"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак chubby"
]
|
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.