Query Metrics
7
Database Queries
7
Different statements
150.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.79 ms (82.95%) |
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 31975 311897 383356 387039 395267 395446 396352 396577 397642 400270 400662 404622 405182 409948 414368 417801 418371 420216 422735 424791 424877 425353 427217 431105 443649 446856 446872 447102 452602 464650 468387 468467 468754 473461 473501 475303 481144 481151 491273 498626 500431 503406 506762 508179 508457 512057 516666 517932 522140 523546 524173 524846 527780 529202 530012 530272 530500 531127 531136 531210 531239 532667 532763 536248 537671 537676 538416 540408 542590 543888 544796 547523 555847 555873 558436 566758 571751 572189 585096 595337 597246 599994 600344 616328 616336 621426 628114 630526 631162 633124 633743 633767 634116 634189 634208 634818 637123 641977 643415 646004 646242 647361 650174 675002 675009 676092 678943 700674 715089 719427 720237 720249 720257 720301 731663 742428 775752 788570 800331 814634 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (10.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 468387 506762 516666 547523 555873 633767 600344 396577 500431 524846 508457 532667 536248 527780 481144 464650 529202 715089 417801 532763 475303 473501 595337 775752 719427 418371 566758 634189 621426 473461 422735 424877 446856 446872 530500 531210 540408 508179 512057 537676 530012 481151 720237 675002 597246 628114 643415 420216 425353 396352 571751 498626 387039 646004 650174 633743 414368 633124 431105 676092 409948 31975 397642 616328 544796 599994 491273 646242 616336 631162 675009 634116 404622 468467 558436 572189 503406 720257 720249 647361 443649 634818 637123 634208 530272 630526 517932 427217 522140 531127 538416 524173 678943 720301 555847 800331 742428 731663 788570 395267 311897 395446 405182 424791 400270 383356 400662 585096 447102 543888 641977 452602 700674 814634 523546 531136 542590 468754 531239 537671 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.68%) |
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 31975 311897 383356 387039 395267 395446 396352 396577 397642 400270 400662 404622 405182 409948 414368 417801 418371 420216 422735 424791 424877 425353 427217 431105 443649 446856 446872 447102 452602 464650 468387 468467 468754 473461 473501 475303 481144 481151 491273 498626 500431 503406 506762 508179 508457 512057 516666 517932 522140 523546 524173 524846 527780 529202 530012 530272 530500 531127 531136 531210 531239 532667 532763 536248 537671 537676 538416 540408 542590 543888 544796 547523 555847 555873 558436 566758 571751 572189 585096 595337 597246 599994 600344 616328 616336 621426 628114 630526 631162 633124 633743 633767 634116 634189 634208 634818 637123 641977 643415 646004 646242 647361 650174 675002 675009 676092 678943 700674 715089 719427 720237 720249 720257 720301 731663 742428 775752 788570 800331 814634 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal bbc big"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал bbc большие"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал bbc большие"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.