Query Metrics
7
Database Queries
7
Different statements
172.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.43 ms (86.97%) |
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 109233 109313 233376 381424 382404 386083 388132 388560 389256 391423 391586 391959 391980 392015 401013 401089 413288 413754 423832 424483 425748 426873 427169 434466 435015 443002 443830 444208 444997 449701 451611 457470 457540 460898 461106 461451 461495 461957 461993 462161 462583 462975 466237 466676 469121 469836 470050 470076 470132 470393 470686 473244 473246 473252 473317 473889 475461 477730 479043 481195 481219 483388 485968 494285 494567 500842 502817 506559 509244 514598 522326 529074 541623 542280 543584 544305 551913 551915 551949 552763 554615 554625 556054 557536 558208 562454 565828 569137 572543 574237 576645 576680 578140 580956 592628 593102 597068 604190 612914 623502 624231 628698 636555 644303 663374 680657 692636 692812 715116 716244 737257 740659 740677 740723 745888 773324 795660 799362 813679 819706 ] |
||||||||||||||||||||||||||||||
|
13.10 ms (7.57%) |
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 593102 773324 799362 381424 388560 391959 401013 443002 389256 401089 413288 469836 233376 391980 423832 443830 457540 462583 469121 470132 470686 475461 479043 109313 388132 434466 435015 444208 461451 461957 462161 473252 473317 424483 426873 461993 481219 522326 506559 500842 485968 473889 558208 551915 556054 576645 457470 477730 529074 502817 541623 551913 740677 740659 795660 494285 597068 483388 494567 813679 592628 737257 740723 745888 109233 391586 382404 819706 557536 451611 461106 473244 509244 514598 473246 543584 544305 578140 542280 554625 569137 576680 580956 554615 562454 565828 574237 680657 663374 692636 716244 692812 715116 551949 552763 572543 628698 612914 604190 623502 624231 636555 644303 427169 470050 386083 392015 444997 460898 466237 391423 413754 461495 462975 466676 470076 470393 425748 449701 481195 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.43%) |
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 109233 109313 233376 381424 382404 386083 388132 388560 389256 391423 391586 391959 391980 392015 401013 401089 413288 413754 423832 424483 425748 426873 427169 434466 435015 443002 443830 444208 444997 449701 451611 457470 457540 460898 461106 461451 461495 461957 461993 462161 462583 462975 466237 466676 469121 469836 470050 470076 470132 470393 470686 473244 473246 473252 473317 473889 475461 477730 479043 481195 481219 483388 485968 494285 494567 500842 502817 506559 509244 514598 522326 529074 541623 542280 543584 544305 551913 551915 551949 552763 554615 554625 556054 557536 558208 562454 565828 569137 572543 574237 576645 576680 578140 580956 592628 593102 597068 604190 612914 623502 624231 628698 636555 644303 663374 680657 692636 692812 715116 716244 737257 740659 740677 740723 745888 773324 795660 799362 813679 819706 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"in the village"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"деревня"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.88%) |
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.