Query Metrics
7
Database Queries
7
Different statements
377.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
351.12 ms (92.94%) |
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 233517 266633 392015 392843 397509 397656 398100 400571 411454 413418 413432 413641 415329 416000 416170 416681 416692 417334 417967 418893 419454 420295 420774 424195 432246 434596 439102 439393 439532 443255 448082 448257 448773 451337 452572 452794 452805 453209 455918 463751 465143 467114 468219 469120 470034 470453 471124 473743 482773 485555 486767 493398 493411 495737 498294 500308 501258 505138 505317 508891 511274 511455 512933 514235 516320 517425 518766 521677 532729 533461 541836 542146 545429 547485 552800 555075 556445 560925 573192 585294 587285 590281 601668 601766 604351 607799 609889 614975 619802 628107 637537 658777 660373 672950 693628 695893 707556 720145 723660 723930 725631 740250 749255 752602 752613 752623 770213 770260 780684 782839 784744 787511 787512 792715 796644 801311 809371 813195 825878 827847 ] |
||||||||||||||||||||||||||||||
|
16.18 ms (4.28%) |
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 752623 740250 749255 609889 784744 809371 413432 416000 486767 514235 470034 448257 501258 628107 439532 416692 511274 512933 468219 542146 587285 392015 418893 470453 693628 266633 397656 398100 813195 455918 463751 695893 707556 660373 672950 573192 601766 585294 607799 770213 723930 725631 770260 752602 424195 415329 448082 417334 434596 439102 465143 517425 485555 505317 516320 601668 637537 400571 547485 545429 590281 604351 533461 560925 416170 443255 471124 505138 473743 451337 511455 493398 518766 532729 452794 432246 392843 448773 541836 614975 493411 787512 420295 413641 416681 508891 619802 500308 482773 469120 498294 658777 233517 720145 555075 780684 782839 801311 787511 796644 752613 792715 417967 420774 825878 452572 467114 452805 495737 552800 556445 397509 521677 827847 419454 413418 439393 411454 723660 453209 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (0.90%) |
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 233517 266633 392015 392843 397509 397656 398100 400571 411454 413418 413432 413641 415329 416000 416170 416681 416692 417334 417967 418893 419454 420295 420774 424195 432246 434596 439102 439393 439532 443255 448082 448257 448773 451337 452572 452794 452805 453209 455918 463751 465143 467114 468219 469120 470034 470453 471124 473743 482773 485555 486767 493398 493411 495737 498294 500308 501258 505138 505317 508891 511274 511455 512933 514235 516320 517425 518766 521677 532729 533461 541836 542146 545429 547485 552800 555075 556445 560925 573192 585294 587285 590281 601668 601766 604351 607799 609889 614975 619802 628107 637537 658777 660373 672950 693628 695893 707556 720145 723660 723930 725631 740250 749255 752602 752613 752623 770213 770260 780684 782839 784744 787511 787512 792715 796644 801311 809371 813195 825878 827847 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur anal dildo"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск анал дилд"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.42%) |
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.