Query Metrics
7
Database Queries
7
Different statements
194.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.90 ms (86.00%) |
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 159305 188507 370715 383390 387055 391546 391576 406568 418954 419565 426503 447164 450172 452445 452637 453628 454196 454253 454706 460186 462083 462100 462106 462610 462689 463172 465563 465592 466341 466962 467002 468033 469614 470026 471713 472413 472593 472618 472636 474133 476239 476240 476260 476262 476341 476350 479106 480755 485208 485704 485732 485773 486432 499914 502807 503828 517735 518843 518862 518871 518875 519153 524017 525502 525832 529340 534245 534581 541344 545926 546136 549130 549138 549222 549223 549250 551931 551932 552058 554499 554517 557189 557436 558281 559324 559346 559377 561567 563431 563478 565339 569419 580739 592945 598949 603342 603378 603384 607597 612171 616997 636478 678767 678794 697797 721382 722322 731080 735906 744229 745951 745955 746162 775970 776160 776339 794669 796469 802233 813004 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (8.85%) |
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 518843 534245 549138 541344 563478 580739 721382 722322 546136 554517 607597 616997 603342 776160 794669 796469 813004 731080 802233 746162 745951 744229 603378 391546 469614 468033 472636 525502 453628 549222 472413 383390 188507 419565 485208 480755 534581 524017 525832 471713 476240 549250 554499 557436 561567 545926 559346 565339 569419 612171 592945 598949 776339 735906 745955 697797 391576 447164 406568 418954 466341 426503 465563 479106 499914 558281 387055 485704 476260 519153 518875 552058 603384 476350 452637 454253 462083 454196 470026 472618 474133 485732 454706 465592 466962 476262 486432 503828 518871 529340 502807 517735 462100 551931 551932 559324 549130 557189 559377 563431 678794 678767 549223 636478 775970 462106 463172 462689 476341 159305 472593 467002 518862 370715 450172 452445 462610 485773 460186 476239 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.41%) |
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 159305 188507 370715 383390 387055 391546 391576 406568 418954 419565 426503 447164 450172 452445 452637 453628 454196 454253 454706 460186 462083 462100 462106 462610 462689 463172 465563 465592 466341 466962 467002 468033 469614 470026 471713 472413 472593 472618 472636 474133 476239 476240 476260 476262 476341 476350 479106 480755 485208 485704 485732 485773 486432 499914 502807 503828 517735 518843 518862 518871 518875 519153 524017 525502 525832 529340 534245 534581 541344 545926 546136 549130 549138 549222 549223 549250 551931 551932 552058 554499 554517 557189 557436 558281 559324 559346 559377 561567 563431 563478 565339 569419 580739 592945 598949 603342 603378 603384 607597 612171 616997 636478 678767 678794 697797 721382 722322 731080 735906 744229 745951 745955 746162 775970 776160 776339 794669 796469 802233 813004 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"glasses granny"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"очкастая granny"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"очкастая granny"
]
|
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.