Query Metrics
7
Database Queries
7
Different statements
144.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.98 ms (84.47%) |
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 30703 70636 154692 365978 382815 392572 398307 402563 403162 408435 408447 410855 410872 410874 418434 419991 423337 425654 429482 429545 434933 438208 442685 442754 447007 454969 458329 458784 459025 462554 466091 467668 470522 471500 474297 480047 481021 483359 484330 485420 485750 490452 491424 493458 494448 495436 498326 498621 500249 501005 501916 505659 505940 506339 506755 507763 510420 513133 514011 517924 522922 523746 524121 525586 526385 528800 531770 538784 544248 545725 548738 553616 553687 557951 564656 574051 579940 581518 586431 587918 593603 597884 608336 612387 617124 624377 624550 629461 634004 634223 636329 642221 666376 666429 680308 681777 690923 708888 709939 712664 713407 716268 730060 734217 735003 738182 739933 740703 746854 748082 753240 759854 768731 769555 780878 785585 785897 785997 802038 810375 ] |
||||||||||||||||||||||||||||||
|
12.93 ms (8.96%) |
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 418434 500249 408435 485420 617124 501916 544248 634223 517924 498326 402563 423337 442685 410874 410855 447007 523746 524121 553687 548738 612387 458784 462554 467668 471500 425654 442754 484330 495436 490452 494448 507763 522922 780878 408447 70636 410872 608336 398307 470522 505659 480047 666429 459025 474297 438208 506339 506755 485750 501005 514011 525586 528800 429545 597884 481021 769555 708888 712664 593603 634004 759854 636329 690923 498621 526385 466091 739933 30703 802038 510420 483359 365978 538784 574051 709939 624377 734217 753240 738182 746854 713407 429482 491424 581518 553616 557951 545725 564656 579940 587918 458329 454969 434933 493458 505940 513133 586431 624550 419991 681777 392572 716268 730060 740703 154692 382815 531770 680308 666376 629461 642221 785897 810375 785997 748082 735003 768731 785585 403162 ] |
||||||||||||||||||||||||||||||
|
2.40 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 30703 70636 154692 365978 382815 392572 398307 402563 403162 408435 408447 410855 410872 410874 418434 419991 423337 425654 429482 429545 434933 438208 442685 442754 447007 454969 458329 458784 459025 462554 466091 467668 470522 471500 474297 480047 481021 483359 484330 485420 485750 490452 491424 493458 494448 495436 498326 498621 500249 501005 501916 505659 505940 506339 506755 507763 510420 513133 514011 517924 522922 523746 524121 525586 526385 528800 531770 538784 544248 545725 548738 553616 553687 557951 564656 574051 579940 581518 586431 587918 593603 597884 608336 612387 617124 624377 624550 629461 634004 634223 636329 642221 666376 666429 680308 681777 690923 708888 709939 712664 713407 716268 730060 734217 735003 738182 739933 740703 746854 748082 753240 759854 768731 769555 780878 785585 785897 785997 802038 810375 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"подруга домашнее"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подружк домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.99%) |
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.