Query Metrics
7
Database Queries
7
Different statements
182.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.81 ms (87.52%) |
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 126458 398604 400096 412539 423766 426113 427517 433976 437707 445012 446104 448662 452949 453604 460006 466220 470382 472381 473943 473990 475343 478239 479605 481579 483241 484400 485466 486221 487207 488791 490433 495556 496195 517236 523594 528378 533130 533273 534441 535938 537960 538438 539381 544470 544979 546639 548124 551588 551878 552103 552248 557373 558599 563405 566354 567072 567190 568227 568304 573496 578987 581934 591147 595491 596610 597210 598496 598580 603463 603573 609516 609590 609895 614617 614946 626045 626296 632719 635114 636180 644013 648690 652221 653661 653974 659476 666500 667190 668674 676753 677914 678621 679537 683286 684428 685372 686552 686574 687817 689826 690728 691964 695039 695042 695049 695547 696297 697481 699844 701264 701515 701964 702250 709329 709682 710880 711717 807434 809763 827970 ] |
||||||||||||||||||||||||||||||
|
12.91 ms (7.07%) |
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 487207 679537 598496 448662 423766 446104 563405 591147 400096 412539 466220 523594 533130 546639 567190 548124 566354 568304 699844 567072 598580 596610 473990 445012 479605 528378 496195 484400 486221 827970 533273 538438 534441 517236 539381 551878 544470 544979 568227 578987 653661 666500 668674 676753 684428 686552 686574 687817 695039 695042 701964 702250 659476 677914 678621 689826 690728 695049 695547 709329 648690 667190 691964 710880 711717 573496 581934 609895 636180 644013 614946 632719 595491 609590 614617 597210 609516 626296 603463 603573 626045 635114 697481 701264 701515 481579 433976 452949 490433 558599 552248 557373 807434 470382 460006 472381 473943 126458 398604 426113 427517 475343 478239 437707 453604 483241 495556 485466 488791 535938 537960 685372 552103 652221 696297 809763 551588 653974 683286 709682 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.64%) |
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 126458 398604 400096 412539 423766 426113 427517 433976 437707 445012 446104 448662 452949 453604 460006 466220 470382 472381 473943 473990 475343 478239 479605 481579 483241 484400 485466 486221 487207 488791 490433 495556 496195 517236 523594 528378 533130 533273 534441 535938 537960 538438 539381 544470 544979 546639 548124 551588 551878 552103 552248 557373 558599 563405 566354 567072 567190 568227 568304 573496 578987 581934 591147 595491 596610 597210 598496 598580 603463 603573 609516 609590 609895 614617 614946 626045 626296 632719 635114 636180 644013 648690 652221 653661 653974 659476 666500 667190 668674 676753 677914 678621 679537 683286 684428 685372 686552 686574 687817 689826 690728 691964 695039 695042 695049 695547 696297 697481 699844 701264 701515 701964 702250 709329 709682 710880 711717 807434 809763 827970 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny russian amateur"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые русск любительск"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.