Query Metrics
7
Database Queries
7
Different statements
185.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.83 ms (84.73%) |
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 383500 384139 386531 391686 393050 393233 395946 395989 396552 396724 401367 403293 403703 408765 410118 410267 413432 414365 415534 417726 418867 425942 426658 428786 429071 433273 441622 444726 444768 445051 445682 447692 451588 452424 452740 453047 453223 453228 456555 456588 460107 463008 467728 467968 468610 471852 473127 474963 484717 488724 491877 492288 494121 497874 504790 505250 512102 516684 517905 527915 528496 529432 531913 535644 535651 536579 536783 536931 543501 556932 557722 561313 566635 566736 574377 582741 593079 609888 612467 612779 614967 633458 633611 639279 640813 641951 642042 647839 660367 662026 668305 669446 670224 682755 687248 689456 693291 694612 696593 701309 718983 722638 723589 725038 740409 745092 745106 756078 761468 775184 777052 785589 791296 792726 805900 808746 814487 823173 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (9.08%) |
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 401367 429071 417726 425942 428786 445051 444726 444768 823173 453223 484717 456588 460107 528496 531913 504790 574377 647839 660367 593079 641951 642042 594372 612779 614967 609888 785589 791296 725038 756078 808746 740409 745106 639279 775184 393050 393233 453047 474963 456555 471852 403703 395946 473127 445682 517905 527915 497874 391686 403293 723589 814487 452424 452740 535651 557722 669446 682755 689456 693291 722638 687248 696593 662026 668305 694612 701309 556932 633611 805900 777052 745092 792726 718983 383500 396724 395989 396552 566736 640813 516684 410118 415534 492288 453228 561313 612467 386531 463008 536931 536783 488724 633458 451588 494121 441622 447692 433273 467968 467728 512102 505250 384139 408765 414365 468610 491877 543501 670224 566635 582741 761468 418867 426658 512847 529432 410267 413432 536579 535644 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.88%) |
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 383500 384139 386531 391686 393050 393233 395946 395989 396552 396724 401367 403293 403703 408765 410118 410267 413432 414365 415534 417726 418867 425942 426658 428786 429071 433273 441622 444726 444768 445051 445682 447692 451588 452424 452740 453047 453223 453228 456555 456588 460107 463008 467728 467968 468610 471852 473127 474963 484717 488724 491877 492288 494121 497874 504790 505250 512102 516684 517905 527915 528496 529432 531913 535644 535651 536579 536783 536931 543501 556932 557722 561313 566635 566736 574377 582741 593079 609888 612467 612779 614967 633458 633611 639279 640813 641951 642042 647839 660367 662026 668305 669446 670224 682755 687248 689456 693291 694612 696593 701309 718983 722638 723589 725038 740409 745092 745106 756078 761468 775184 777052 785589 791296 792726 805900 808746 814487 823173 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen huge big"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen огромные большие"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen огромные большие"
]
|
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.