Query Metrics
7
Database Queries
7
Different statements
142.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.60 ms (84.78%) |
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 208999 336986 342499 382657 384098 388069 388570 393124 393558 422957 433697 447988 448058 451786 457527 463915 465567 467540 467684 471141 471935 476042 476052 477498 479082 479138 481920 482377 488337 489603 491667 491891 497894 499042 500110 503843 506901 512385 512900 515521 515886 520630 521946 523024 523440 527625 529829 532965 534209 534396 541597 543288 543738 543874 545480 546010 548253 552070 556319 559192 561392 567349 569778 575451 575786 580664 582757 587216 593742 600964 605523 605676 606636 607556 613319 623409 629388 633077 667270 672953 681815 696906 700852 702149 705711 710256 710770 717367 721454 722510 722544 731384 738270 738482 742538 745007 748479 755237 764034 772077 781693 781694 782017 793438 804943 810715 813253 814182 814640 815913 817101 817105 817168 817180 817736 819421 824224 825219 825516 826180 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (9.11%) |
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 512385 523024 471141 575451 575786 587216 393124 477498 463915 532965 467540 467684 422957 527625 489603 545480 543288 721454 781693 569778 593742 491667 500110 448058 552070 556319 559192 567349 702149 745007 748479 629388 696906 548253 606636 813253 479138 471935 384098 722510 722544 600964 772077 700852 497894 499042 512900 755237 515886 814182 817101 824224 825516 710256 582757 781694 523440 503843 546010 433697 451786 479082 482377 817168 825219 580664 667270 633077 605523 731384 738270 382657 342499 817736 817105 529829 543738 681815 804943 742538 607556 623409 447988 515521 819421 826180 814640 705711 717367 605676 793438 810715 738482 764034 782017 476042 534396 521946 543874 817180 534209 815913 336986 388069 541597 672953 393558 388570 476052 488337 561392 481920 208999 465567 710770 506901 457527 520630 613319 491891 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.46%) |
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 208999 336986 342499 382657 384098 388069 388570 393124 393558 422957 433697 447988 448058 451786 457527 463915 465567 467540 467684 471141 471935 476042 476052 477498 479082 479138 481920 482377 488337 489603 491667 491891 497894 499042 500110 503843 506901 512385 512900 515521 515886 520630 521946 523024 523440 527625 529829 532965 534209 534396 541597 543288 543738 543874 545480 546010 548253 552070 556319 559192 561392 567349 569778 575451 575786 580664 582757 587216 593742 600964 605523 605676 606636 607556 613319 623409 629388 633077 667270 672953 681815 696906 700852 702149 705711 710256 710770 717367 721454 722510 722544 731384 738270 738482 742538 745007 748479 755237 764034 772077 781693 781694 782017 793438 804943 810715 813253 814182 814640 815913 817101 817105 817168 817180 817736 819421 824224 825219 825516 826180 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm big tits"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.96%) |
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.