Query Metrics
7
Database Queries
7
Different statements
195.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.55 ms (86.84%) |
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 74239 123011 412911 419702 424461 428898 429653 430542 435022 443506 445343 450522 452399 462935 465162 466186 469878 471592 473388 473938 474251 475165 483433 483934 484423 484600 490968 491902 493274 497588 503016 504036 504333 505235 506727 507394 508983 511600 511622 511983 518837 520052 522735 524944 525377 525547 540948 544568 550991 559645 581267 582779 607414 660103 664841 668865 675760 676509 687439 695838 698019 701928 706752 712181 714637 714966 715140 716275 723725 724225 726215 730659 731889 731913 733110 739616 743027 745035 745154 747819 749972 757262 764032 766574 768550 771778 772850 783427 783801 787321 789414 790007 793439 793611 794474 796600 797706 799512 799991 800183 800192 800203 802853 804113 807615 814327 815790 816697 817896 818811 819048 819142 820358 820453 824508 825002 826888 827099 828751 828835 ] |
||||||||||||||||||||||||||||||
|
15.66 ms (8.02%) |
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 469878 471592 473938 474251 412911 419702 424461 428898 435022 452399 462935 466186 475165 429653 430542 450522 465162 504333 508983 511622 511983 518837 522735 484600 503016 511600 520052 524944 525377 525547 484423 490968 483433 483934 491902 493274 497588 504036 505235 507394 74239 445343 443506 123011 817896 819048 819142 820358 825002 826888 827099 815790 816697 820453 824508 814327 818811 828751 828835 550991 581267 540948 544568 559645 668865 687439 701928 714966 675760 676509 706752 712181 716275 695838 582779 607414 783801 790007 793439 794474 799991 800192 807615 783427 793611 796600 800203 802853 724225 730659 731889 766574 787321 799512 739616 768550 723725 733110 745154 764032 726215 731913 745035 743027 749972 757262 771778 772850 698019 714637 715140 789414 797706 800183 804113 660103 747819 664841 506727 473388 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (1.85%) |
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 74239 123011 412911 419702 424461 428898 429653 430542 435022 443506 445343 450522 452399 462935 465162 466186 469878 471592 473388 473938 474251 475165 483433 483934 484423 484600 490968 491902 493274 497588 503016 504036 504333 505235 506727 507394 508983 511600 511622 511983 518837 520052 522735 524944 525377 525547 540948 544568 550991 559645 581267 582779 607414 660103 664841 668865 675760 676509 687439 695838 698019 701928 706752 712181 714637 714966 715140 716275 723725 724225 726215 730659 731889 731913 733110 739616 743027 745035 745154 747819 749972 757262 764032 766574 768550 771778 772850 783427 783801 787321 789414 790007 793439 793611 794474 796600 797706 799512 799991 800183 800192 800203 802853 804113 807615 814327 815790 816697 817896 818811 819048 819142 820358 820453 824508 825002 826888 827099 828751 828835 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"69 adorable"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поз adorable 69"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"поз adorable 69"
]
|
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.