Query Metrics
7
Database Queries
7
Different statements
574.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
418.63 ms (72.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован teen"
]
|
||||||||||||||||||||||||||||||
|
128.69 ms (22.39%) |
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 383356 395686 418724 420337 421220 421488 422576 422908 423503 423568 425326 429668 431975 443558 444111 444606 447790 448371 448376 451267 451559 454683 457232 459805 461725 462450 463756 472350 475933 476944 477340 482690 483436 486658 488809 490253 490701 491406 491480 491659 491940 492063 492315 492719 494999 496448 497392 497432 497873 497892 497901 503361 503426 506287 509875 509931 511753 511814 512215 512830 513160 514152 516685 516925 517782 518930 521353 522569 522851 523431 524592 524749 524794 525020 525748 525957 526168 527099 527625 530380 530385 530753 530776 531108 531211 532906 536413 536787 537901 537920 538881 542591 543865 544867 545649 546215 550051 550085 550092 552296 552608 559141 559428 563654 565174 565246 566991 572297 577332 581683 582785 592313 600382 625780 632655 632703 642359 646434 663976 720387 ] |
||||||||||||||||||||||||||||||
|
17.90 ms (3.11%) |
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 454683 420337 421488 429668 448371 448376 451559 472350 475933 503361 511753 514152 516685 517782 521353 524794 486658 491940 497892 503426 506287 523431 525957 488809 490701 491659 492063 494999 497432 512830 522569 524592 527099 527625 483436 492315 492719 496448 509931 511814 522851 525020 525748 566991 462450 444606 383356 395686 421220 425326 444111 418724 431975 443558 422576 423503 422908 423568 482690 447790 457232 463756 490253 491406 459805 461725 451267 476944 477340 497901 513160 530385 532906 526168 531108 536413 537920 497392 497873 518930 530753 531211 536787 537901 538881 509875 512215 516925 524749 530380 530776 491480 543865 545649 552608 559141 542591 546215 550085 550092 552296 565174 565246 582785 544867 563654 577332 581683 646434 663976 720387 550051 559428 572297 600382 632703 642359 592313 625780 632655 ] |
||||||||||||||||||||||||||||||
|
3.85 ms (0.67%) |
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 383356 395686 418724 420337 421220 421488 422576 422908 423503 423568 425326 429668 431975 443558 444111 444606 447790 448371 448376 451267 451559 454683 457232 459805 461725 462450 463756 472350 475933 476944 477340 482690 483436 486658 488809 490253 490701 491406 491480 491659 491940 492063 492315 492719 494999 496448 497392 497432 497873 497892 497901 503361 503426 506287 509875 509931 511753 511814 512215 512830 513160 514152 516685 516925 517782 518930 521353 522569 522851 523431 524592 524749 524794 525020 525748 525957 526168 527099 527625 530380 530385 530753 530776 531108 531211 532906 536413 536787 537901 537920 538881 542591 543865 544867 545649 546215 550051 550085 550092 552296 552608 559141 559428 563654 565174 565246 566991 572297 577332 581683 582785 592313 600382 625780 632655 632703 642359 646434 663976 720387 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slave teen"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"доминирован teen"
]
|
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.