Query Metrics
7
Database Queries
7
Different statements
161.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.74 ms (78.26%) |
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 69513 69950 96462 202901 228393 321410 338225 378272 383079 384545 385174 385302 385392 386804 388006 388732 389570 390306 393267 397988 399090 399387 404426 416093 417134 452872 464400 466691 467652 469986 472883 475982 476458 477482 498485 506301 511008 517691 518452 530394 530639 533241 534867 537007 537525 538241 540469 545594 545808 546253 551552 557362 568343 572172 573382 583175 584075 589199 590137 590233 591596 591635 591741 594209 598907 601756 606785 614739 629337 630915 640728 646127 646290 646639 647083 649166 650854 650916 651262 652521 652706 653684 653745 654970 655288 657959 658128 662039 662040 662559 666808 684361 691509 691729 694904 695242 696094 700834 707725 708451 710378 713605 716494 717150 718314 719946 719960 720064 726531 738057 814529 817184 817381 824369 824373 824780 827853 827874 827877 ] |
||||||||||||||||||||||||||||||
|
21.84 ms (13.48%) |
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 452872 472883 475982 477482 506301 518452 533241 469986 584075 666808 557362 573382 591596 591741 598907 594209 726531 738057 629337 321410 388732 399090 464400 467652 466691 228393 69513 385174 385302 389570 390306 416093 417134 498485 399387 386804 476458 388006 828185 640728 614739 630915 385392 383079 384545 202901 393267 338225 378272 69950 96462 397988 404426 817184 817381 824369 824373 814529 827877 827874 827853 824780 511008 530639 517691 530394 534867 540469 537007 537525 538241 545808 568343 551552 646127 650916 652706 653745 655288 657959 695242 700834 707725 710378 717150 718314 719960 646290 646639 647083 649166 654970 658128 662040 662559 691509 691729 719946 720064 650854 651262 652521 653684 662039 684361 694904 696094 708451 713605 716494 545594 546253 572172 583175 589199 590137 590233 591635 601756 606785 ] |
||||||||||||||||||||||||||||||
|
4.25 ms (2.63%) |
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 69513 69950 96462 202901 228393 321410 338225 378272 383079 384545 385174 385302 385392 386804 388006 388732 389570 390306 393267 397988 399090 399387 404426 416093 417134 452872 464400 466691 467652 469986 472883 475982 476458 477482 498485 506301 511008 517691 518452 530394 530639 533241 534867 537007 537525 538241 540469 545594 545808 546253 551552 557362 568343 572172 573382 583175 584075 589199 590137 590233 591596 591635 591741 594209 598907 601756 606785 614739 629337 630915 640728 646127 646290 646639 647083 649166 650854 650916 651262 652521 652706 653684 653745 654970 655288 657959 658128 662039 662040 662559 666808 684361 691509 691729 694904 695242 696094 700834 707725 708451 710378 713605 716494 717150 718314 719946 719960 720064 726531 738057 814529 817184 817381 824369 824373 824780 827853 827874 827877 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"межрасов рак"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"межрассовое раком"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"межрасов рак"
]
|
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.