Query Metrics
7
Database Queries
7
Different statements
142.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.19 ms (84.49%) |
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 209723 210349 386065 399668 415796 417757 449691 455843 456850 469117 469503 476041 498790 503830 504533 506520 511515 514979 518590 519356 519888 531604 533711 534368 534723 535413 539962 542722 544622 545071 548233 548313 553235 557267 558099 558102 559668 570605 570891 573160 575404 577002 577395 580147 580959 586351 595765 601220 603338 606055 619655 621230 628319 628570 629210 631458 634458 636324 636468 637301 639861 640870 642979 644766 644850 644907 649830 649832 672384 673054 676418 679504 683568 694712 696124 696701 702232 709333 709517 714358 715449 718029 726049 736514 740614 747057 752189 755528 759124 765776 767784 768500 768606 768994 771990 772435 779871 788120 788240 791497 792584 798703 798947 801322 808642 811857 811865 812524 814729 817778 817964 819630 822634 824173 826980 827665 827860 828219 828363 828752 ] |
||||||||||||||||||||||||||||||
|
12.64 ms (8.89%) |
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 814729 506520 673054 679504 696124 636468 639861 595765 798703 768500 801322 557267 558099 822634 542722 640870 768606 771990 811857 415796 386065 469117 649832 498790 399668 798947 694712 811865 539962 817964 644907 826980 824173 819630 827665 504533 544622 548313 558102 702232 714358 545071 570891 636324 606055 628570 644766 808642 788240 752189 755528 812524 767784 759124 765776 747057 210349 449691 709333 476041 503830 570605 676418 511515 518590 455843 629210 768994 531604 559668 779871 580147 456850 715449 619655 469503 709517 726049 644850 533711 791497 736514 621230 696701 817778 603338 792584 519356 575404 649830 514979 417757 828752 519888 535413 534368 534723 553235 577002 718029 683568 586351 601220 772435 740614 672384 573160 580959 628319 631458 577395 548233 828219 827860 828363 634458 209723 637301 642979 788120 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.94%) |
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 209723 210349 386065 399668 415796 417757 449691 455843 456850 469117 469503 476041 498790 503830 504533 506520 511515 514979 518590 519356 519888 531604 533711 534368 534723 535413 539962 542722 544622 545071 548233 548313 553235 557267 558099 558102 559668 570605 570891 573160 575404 577002 577395 580147 580959 586351 595765 601220 603338 606055 619655 621230 628319 628570 629210 631458 634458 636324 636468 637301 639861 640870 642979 644766 644850 644907 649830 649832 672384 673054 676418 679504 683568 694712 696124 696701 702232 709333 709517 714358 715449 718029 726049 736514 740614 747057 752189 755528 759124 765776 767784 768500 768606 768994 771990 772435 779871 788120 788240 791497 792584 798703 798947 801322 808642 811857 811865 812524 814729 817778 817964 819630 822634 824173 826980 827665 827860 828219 828363 828752 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits public"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.97%) |
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.