Query Metrics
7
Database Queries
7
Different statements
192.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.58 ms (85.17%) |
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 421860 421864 421894 422204 428026 428860 429602 436510 439682 439710 439724 439770 441519 442814 444870 445707 447549 449173 451316 457442 460016 462014 462350 466603 468219 470095 472149 472679 472891 476556 483644 496040 518577 523824 524849 526523 530016 530737 531535 532897 532941 544860 546211 548158 549848 550942 551870 555094 560946 563009 563640 565270 565800 566834 573266 579379 579704 590741 593604 599677 604383 609825 614968 615517 618449 619397 620900 628414 630857 632626 633147 641140 641684 649636 654165 662909 663168 669012 670949 671749 674181 675858 675866 679711 703080 711960 717249 733587 739900 741151 744947 751428 757365 761756 761854 767021 767183 775684 775982 777306 784358 786007 788776 790338 793697 799093 799146 800266 800590 801957 808063 809839 810401 814055 814246 814783 815608 816094 817298 824486 ] |
||||||||||||||||||||||||||||||
|
18.30 ms (9.53%) |
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 566834 544860 551870 560946 573266 669012 549848 620900 628414 618449 799146 614968 421860 428026 439724 421864 421894 439682 439710 444870 447549 457442 466603 476556 422204 439770 442814 445707 462350 472679 472149 472891 526523 523824 483644 496040 441519 429602 815608 817298 814246 814783 816094 530737 532941 524849 531535 468219 550942 555094 563009 675866 671749 703080 649636 670949 675858 679711 711960 548158 619397 641684 615517 630857 590741 641140 599677 632626 775684 777306 784358 790338 808063 810401 786007 793697 801957 809839 751428 788776 799093 744947 761756 767021 733587 767183 741151 757365 739900 761854 604383 609825 633147 775982 800266 800590 428860 593604 824486 814055 662909 717249 436510 460016 470095 449173 451316 462014 518577 530016 532897 579379 565270 546211 565800 654165 663168 674181 563640 579704 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.71%) |
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 421860 421864 421894 422204 428026 428860 429602 436510 439682 439710 439724 439770 441519 442814 444870 445707 447549 449173 451316 457442 460016 462014 462350 466603 468219 470095 472149 472679 472891 476556 483644 496040 518577 523824 524849 526523 530016 530737 531535 532897 532941 544860 546211 548158 549848 550942 551870 555094 560946 563009 563640 565270 565800 566834 573266 579379 579704 590741 593604 599677 604383 609825 614968 615517 618449 619397 620900 628414 630857 632626 633147 641140 641684 649636 654165 662909 663168 669012 670949 671749 674181 675858 675866 679711 703080 711960 717249 733587 739900 741151 744947 751428 757365 761756 761854 767021 767183 775684 775982 777306 784358 786007 788776 790338 793697 799093 799146 800266 800590 801957 808063 809839 810401 814055 814246 814783 815608 816094 817298 824486 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red hair anal"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red hair анал"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red hair анал"
]
|
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.