Query Metrics
7
Database Queries
7
Different statements
146.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.54 ms (82.82%) |
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 396983 398412 403229 411750 414302 418354 421695 423462 423833 425069 425684 431452 434327 434344 434360 435221 442847 444791 446972 447183 449078 449096 451244 454039 454049 458449 460833 462799 466640 469274 470612 474447 474813 475270 479817 488628 489160 493057 504669 511927 519972 520830 525374 536056 536089 541582 544037 545860 547423 550759 550762 553808 555426 557730 563637 566743 578574 579377 581401 583866 592064 593288 594443 596359 596429 596522 601174 604361 605706 607610 610233 613011 614769 614773 614831 615685 617698 618249 619597 625181 630461 635694 640260 654290 664186 666695 669276 689436 707545 714515 714626 716246 720438 729629 730098 732029 745980 746093 747036 755448 758590 759712 761293 773794 782518 792173 792634 792775 793671 794166 800209 800906 802291 802606 803458 807842 812105 815347 815755 824826 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (10.51%) |
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 596429 596522 604361 617698 618249 619597 792173 802291 793671 807842 745980 782518 792775 802606 803458 812105 759712 758590 773794 746093 605706 607610 614769 707545 714515 714626 794166 800906 423833 398412 403229 414302 421695 470612 434327 434344 479817 547423 581401 824826 434360 396983 411750 435221 418354 423462 425069 444791 815755 815347 460833 493057 446972 449078 449096 454049 458449 489160 447183 462799 488628 511927 525374 504669 520830 536089 519972 536056 469274 553808 557730 563637 579377 555426 583866 541582 544037 550762 664186 666695 689436 716246 669276 654290 720438 545860 550759 566743 578574 593288 596359 613011 592064 610233 635694 601174 625181 630461 594443 640260 800209 747036 761293 729629 732029 755448 730098 614773 614831 615685 792634 425684 431452 475270 442847 451244 454039 466640 474447 474813 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (2.01%) |
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 396983 398412 403229 411750 414302 418354 421695 423462 423833 425069 425684 431452 434327 434344 434360 435221 442847 444791 446972 447183 449078 449096 451244 454039 454049 458449 460833 462799 466640 469274 470612 474447 474813 475270 479817 488628 489160 493057 504669 511927 519972 520830 525374 536056 536089 541582 544037 545860 547423 550759 550762 553808 555426 557730 563637 566743 578574 579377 581401 583866 592064 593288 594443 596359 596429 596522 601174 604361 605706 607610 610233 613011 614769 614773 614831 615685 617698 618249 619597 625181 630461 635694 640260 654290 664186 666695 669276 689436 707545 714515 714626 716246 720438 729629 730098 732029 745980 746093 747036 755448 758590 759712 761293 773794 782518 792173 792634 792775 793671 794166 800209 800906 802291 802606 803458 807842 812105 815347 815755 824826 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum hairy"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum волосатая"
]
|
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.