Query Metrics
7
Database Queries
7
Different statements
154.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.37 ms (82.21%) |
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 33917 357595 387742 390303 394737 400480 408502 411199 413690 418368 421829 421843 426348 429416 437793 439292 440894 445536 445828 447547 450818 452547 453016 457431 458459 459520 461586 466004 467807 468183 469487 470522 470961 472691 475467 478310 478362 483567 487347 490898 497005 499904 500100 504668 511616 516740 517069 519063 523835 527287 533783 533920 536420 536433 537263 549836 561852 578701 586897 589045 591003 591367 596738 599358 601915 609968 618847 622064 622645 633980 635916 641985 642282 642290 642346 643233 644289 668660 697025 700290 705320 705346 705878 711685 715812 724371 725135 725198 734324 736046 745136 748504 748981 757312 758201 758281 758509 761027 761029 761540 766764 770389 773841 773998 775473 777420 784247 786537 788610 788905 791926 796116 796566 796945 796957 799292 800306 804226 806146 ] |
||||||||||||||||||||||||||||||
|
17.52 ms (11.31%) |
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 641985 622064 643233 635916 786537 799292 777420 796957 800306 725198 758509 773998 796116 734324 748504 757312 758201 773841 770389 748981 761027 788905 445536 470961 390303 459520 461586 467807 394737 426348 429416 458459 411199 466004 536433 517069 537263 490898 523835 822133 533783 478310 609968 586897 516740 519063 33917 387742 400480 439292 408502 440894 418368 437793 457431 487347 452547 453016 483567 450818 470522 499904 533920 497005 536420 500100 504668 511616 527287 475467 561852 578701 668660 700290 705878 711685 715812 705320 697025 705346 549836 591003 591367 618847 633980 642282 589045 596738 622645 599358 601915 642290 642346 784247 796945 775473 788610 791926 804226 725135 736046 761029 761540 796566 766764 724371 745136 758281 644289 806146 413690 421829 421843 445828 468183 469487 472691 478362 357595 447547 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.79%) |
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 33917 357595 387742 390303 394737 400480 408502 411199 413690 418368 421829 421843 426348 429416 437793 439292 440894 445536 445828 447547 450818 452547 453016 457431 458459 459520 461586 466004 467807 468183 469487 470522 470961 472691 475467 478310 478362 483567 487347 490898 497005 499904 500100 504668 511616 516740 517069 519063 523835 527287 533783 533920 536420 536433 537263 549836 561852 578701 586897 589045 591003 591367 596738 599358 601915 609968 618847 622064 622645 633980 635916 641985 642282 642290 642346 643233 644289 668660 697025 700290 705320 705346 705878 711685 715812 724371 725135 725198 734324 736046 745136 748504 748981 757312 758201 758281 758509 761027 761029 761540 766764 770389 773841 773998 775473 777420 784247 786537 788610 788905 791926 796116 796566 796945 796957 799292 800306 804226 806146 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"housewife anal"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"housewife анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"housewife анал"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.98%) |
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.