Query Metrics
7
Database Queries
7
Different statements
186.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.96 ms (84.15%) |
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 387287 397331 413595 430072 434624 439218 440680 442691 443652 443990 446624 446771 447073 449435 449562 449886 450670 453935 454658 457770 460295 473915 476054 477362 478833 484433 484866 495480 504418 505623 507601 514806 515690 515724 517941 525119 527200 527454 530010 531242 531657 533747 536058 536914 538510 541676 542606 544523 545190 545223 545415 548614 552463 553750 554288 555135 555882 556115 556407 556899 556901 559355 559568 559914 560106 561416 562377 565262 568260 570090 572867 574704 575154 575941 578778 579026 586157 586914 587260 587397 589057 589378 591874 592319 592380 594267 597113 597242 599108 601558 604259 606269 606686 606947 622391 627814 633497 635902 647844 660405 660412 666016 666886 669035 671045 672992 676769 685013 695868 696210 702168 722543 747612 750546 751880 761510 780642 790951 807011 821605 ] |
||||||||||||||||||||||||||||||
|
18.40 ms (9.87%) |
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 553750 556899 542606 568260 578778 672992 722543 676769 685013 696210 545415 556407 556901 559914 575941 606269 599108 606686 594267 601558 589057 604259 790951 750546 761510 751880 747612 606947 635902 446771 495480 538510 554288 622391 587397 387287 450670 478833 536914 531657 536058 548614 552463 560106 545190 574704 575154 544523 545223 556115 559355 559568 561416 572867 579026 660405 666886 695868 647844 660412 666016 669035 671045 555135 555882 562377 570090 586914 587260 589378 592380 597242 586157 597113 591874 592319 780642 807011 476054 447073 460295 453935 439218 541676 517941 533747 702168 565262 627814 633497 484866 397331 443990 440680 430072 434624 443652 413595 442691 821605 446624 454658 473915 477362 449435 449562 457770 484433 449886 505623 530010 531242 515724 525119 527454 504418 507601 514806 515690 527200 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.76%) |
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 387287 397331 413595 430072 434624 439218 440680 442691 443652 443990 446624 446771 447073 449435 449562 449886 450670 453935 454658 457770 460295 473915 476054 477362 478833 484433 484866 495480 504418 505623 507601 514806 515690 515724 517941 525119 527200 527454 530010 531242 531657 533747 536058 536914 538510 541676 542606 544523 545190 545223 545415 548614 552463 553750 554288 555135 555882 556115 556407 556899 556901 559355 559568 559914 560106 561416 562377 565262 568260 570090 572867 574704 575154 575941 578778 579026 586157 586914 587260 587397 589057 589378 591874 592319 592380 594267 597113 597242 599108 601558 604259 606269 606686 606947 622391 627814 633497 635902 647844 660405 660412 666016 666886 669035 671045 672992 676769 685013 695868 696210 702168 722543 747612 750546 751880 761510 780642 790951 807011 821605 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny big ass"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.95%) |
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.