Query Metrics
7
Database Queries
7
Different statements
245.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.39 ms (87.89%) |
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 387155 397316 403042 403052 406800 408832 410950 416066 416151 417102 417773 418286 420386 422401 423490 426250 428920 429910 435973 437476 441677 443300 443619 445109 446328 451726 453505 453694 453802 457679 457869 462865 463118 464874 465293 465873 468025 468119 468274 474583 475076 477776 480201 482937 485414 487172 487654 489035 490758 491170 494482 494814 496454 506595 508534 509180 509494 513051 516883 521488 521650 523157 523760 523788 527203 529492 533566 535699 539293 549149 560970 561313 571474 574240 577896 583313 583536 585437 586965 597260 618129 618364 618544 619994 624273 630576 647357 649511 652126 652131 652513 652519 685889 686210 686749 700846 705791 714469 716076 717297 717906 720755 722585 727611 735593 735704 738679 740399 740407 740689 744290 747451 751512 755584 776988 777306 784608 794906 810702 822660 ] |
||||||||||||||||||||||||||||||
|
17.80 ms (7.26%) |
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 720755 647357 652126 714469 560970 583313 586965 618364 624273 776988 784608 740399 740407 422401 397316 777306 387155 521488 408832 508534 523157 496454 685889 652513 597260 619994 618544 735593 453505 465873 406800 416066 416151 445109 513051 403042 418286 423490 822660 480201 494482 583536 649511 652131 686210 705791 716076 722585 652519 700846 717297 686749 618129 727611 740689 738679 744290 755584 810702 403052 506595 410950 426250 428920 451726 457679 474583 446328 457869 516883 539293 577896 574240 585437 794906 435973 429910 453802 468274 462865 417773 437476 468025 521650 489035 491170 487654 509180 490758 494814 420386 443300 443619 441677 417102 453694 463118 464874 465293 482937 487172 523760 533566 535699 509494 523788 527203 529492 477776 485414 549149 561313 571474 630576 735704 747451 751512 717906 475076 468119 ] |
||||||||||||||||||||||||||||||
|
3.91 ms (1.59%) |
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 387155 397316 403042 403052 406800 408832 410950 416066 416151 417102 417773 418286 420386 422401 423490 426250 428920 429910 435973 437476 441677 443300 443619 445109 446328 451726 453505 453694 453802 457679 457869 462865 463118 464874 465293 465873 468025 468119 468274 474583 475076 477776 480201 482937 485414 487172 487654 489035 490758 491170 494482 494814 496454 506595 508534 509180 509494 513051 516883 521488 521650 523157 523760 523788 527203 529492 533566 535699 539293 549149 560970 561313 571474 574240 577896 583313 583536 585437 586965 597260 618129 618364 618544 619994 624273 630576 647357 649511 652126 652131 652513 652519 685889 686210 686749 700846 705791 714469 716076 717297 717906 720755 722585 727611 735593 735704 738679 740399 740407 740689 744290 747451 751512 755584 776988 777306 784608 794906 810702 822660 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dick little"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"член little"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"член little"
]
|
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.