Query Metrics
7
Database Queries
7
Different statements
238.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.65 ms (89.07%) |
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 8518 23696 45306 233446 396055 426352 433582 434326 435498 437738 442236 442947 450886 451255 451592 452230 454190 456906 457528 461411 462224 462833 463655 464556 467761 468704 470995 473322 475352 476315 476513 483822 486787 489842 494545 505549 505551 507133 509593 518309 528129 529901 535341 536463 539572 542767 542951 544941 549797 550006 557097 558324 563065 566780 569420 569982 572287 576917 577735 581503 583542 611356 657398 668766 668970 682329 693948 697079 703945 714868 715810 719111 729717 730595 737338 741556 742706 742927 744570 746070 747269 747384 751761 755426 756152 758629 759582 760697 762169 762203 763798 764919 765278 765573 765726 766357 766867 767181 768462 768852 769742 770849 771289 771834 772410 773771 775415 777381 785369 786051 787343 791405 791460 792551 797389 797440 797843 802369 805524 809604 ] |
||||||||||||||||||||||||||||||
|
15.89 ms (6.66%) |
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 759582 766357 786051 787343 797843 805524 730595 746070 758629 762203 769742 770849 741556 742706 747269 751761 762169 765278 765573 768462 772410 729717 737338 742927 744570 755426 756152 760697 766867 767181 771834 747384 763798 764919 765726 768852 771289 773771 611356 697079 703945 719111 775415 777381 785369 791405 791460 792551 797389 797440 802369 809604 8518 462833 23696 45306 233446 457528 461411 452230 451255 451592 505551 518309 396055 442236 426352 433582 434326 435498 437738 442947 470995 473322 483822 489842 454190 462224 463655 464556 467761 450886 456906 505549 507133 539572 509593 528129 535341 536463 494545 529901 468704 475352 476315 476513 486787 549797 558324 581503 583542 542767 550006 569982 542951 544941 563065 566780 569420 657398 668766 682329 715810 668970 714868 693948 557097 572287 576917 577735 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.07%) |
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 8518 23696 45306 233446 396055 426352 433582 434326 435498 437738 442236 442947 450886 451255 451592 452230 454190 456906 457528 461411 462224 462833 463655 464556 467761 468704 470995 473322 475352 476315 476513 483822 486787 489842 494545 505549 505551 507133 509593 518309 528129 529901 535341 536463 539572 542767 542951 544941 549797 550006 557097 558324 563065 566780 569420 569982 572287 576917 577735 581503 583542 611356 657398 668766 668970 682329 693948 697079 703945 714868 715810 719111 729717 730595 737338 741556 742706 742927 744570 746070 747269 747384 751761 755426 756152 758629 759582 760697 762169 762203 763798 764919 765278 765573 765726 766357 766867 767181 768462 768852 769742 770849 771289 771834 772410 773771 775415 777381 785369 786051 787343 791405 791460 792551 797389 797440 797843 802369 805524 809604 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вагин red"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vagina red"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вагин red"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.68%) |
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.