Query Metrics
7
Database Queries
7
Different statements
160.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.76 ms (82.93%) |
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 154675 391386 395634 403588 416399 424119 426405 426710 427543 428184 435646 439610 446394 448148 448877 451108 453344 454521 459513 465354 475473 477586 480707 482506 483147 484222 486901 486964 487383 491209 491348 492606 494036 500904 500960 501487 508208 512059 513126 513517 514265 514809 515761 516014 516316 516327 517395 520127 520132 520290 520753 520759 522469 523401 523537 524018 524527 524613 526182 527484 528864 529345 530026 530763 531231 535084 542789 543508 543536 543844 545216 546720 556855 558441 562758 566007 566651 566993 570177 572026 574432 577400 578430 578631 581433 583723 584236 590230 591415 591416 592340 593269 593860 605552 606541 606778 608771 613177 620232 622778 622978 623306 623380 623834 634856 644005 649525 657504 684977 688116 698124 714479 718695 720288 720298 793603 ] |
||||||||||||||||||||||||||||||
|
17.97 ms (11.23%) |
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 606778 622978 403588 426710 520290 500960 593269 494036 483147 487383 453344 593860 623306 428184 475473 524527 459513 523537 556855 395634 530026 516316 517395 535084 543536 545216 606541 501487 484222 491209 515761 477586 577400 720288 718695 424119 439610 520127 527484 154675 435646 578430 529345 513126 531231 613177 454521 427543 698124 578631 623380 793603 391386 516327 523401 558441 649525 566993 590230 592340 446394 720298 465354 486901 482506 491348 605552 520753 526182 581433 524018 530763 543508 584236 591416 634856 480707 516014 714479 657504 684977 608771 528864 572026 543844 562758 448877 508208 566007 688116 500904 623834 514809 583723 416399 566651 574432 448148 492606 512059 620232 622778 486964 451108 542789 570177 546720 426405 514265 522469 644005 513517 520132 524613 591415 520759 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.66%) |
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 154675 391386 395634 403588 416399 424119 426405 426710 427543 428184 435646 439610 446394 448148 448877 451108 453344 454521 459513 465354 475473 477586 480707 482506 483147 484222 486901 486964 487383 491209 491348 492606 494036 500904 500960 501487 508208 512059 513126 513517 514265 514809 515761 516014 516316 516327 517395 520127 520132 520290 520753 520759 522469 523401 523537 524018 524527 524613 526182 527484 528864 529345 530026 530763 531231 535084 542789 543508 543536 543844 545216 546720 556855 558441 562758 566007 566651 566993 570177 572026 574432 577400 578430 578631 581433 583723 584236 590230 591415 591416 592340 593269 593860 605552 606541 606778 608771 613177 620232 622778 622978 623306 623380 623834 634856 644005 649525 657504 684977 688116 698124 714479 718695 720288 720298 793603 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal husband"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал husband"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал husband"
]
|
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.