Query Metrics
7
Database Queries
7
Different statements
194.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.49 ms (87.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 88760 172662 394417 401632 407895 412207 417519 420222 430553 431671 436042 445390 448483 449901 450219 455377 457113 458077 458652 458913 460790 461228 472641 473322 475378 481310 483256 488246 490208 492313 492606 493394 495384 504751 507010 511991 512665 515586 516061 519593 525873 525919 526595 532087 534107 546848 547604 548026 551650 552801 556851 558854 563839 568680 569431 571198 573492 574916 577935 584749 590482 603945 611416 611900 612792 620559 620792 621735 624222 627371 628720 631603 637650 641375 642832 644510 654974 668857 688855 696465 702860 704579 704599 705784 706117 719504 719746 725824 731376 738379 745751 745761 751341 752943 755454 756190 757719 759865 761340 762201 763746 768587 773565 774299 778076 778656 779124 780735 787137 790669 794767 797235 797261 802027 809352 812693 813700 815459 815973 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (8.32%) |
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 612792 526595 725824 731376 745761 815459 815973 644510 481310 573492 430553 448483 457113 483256 620792 512665 461228 568680 472641 492606 745751 473322 558854 458913 756190 458077 552801 627371 631603 449901 455377 460790 525919 755454 704579 504751 493394 450219 563839 458652 475378 417519 668857 642832 431671 569431 445390 773565 551650 624222 556851 574916 641375 488246 436042 525873 637650 759865 490208 611900 584749 394417 407895 611416 620559 621735 511991 420222 571198 590482 628720 719504 778656 774299 548026 495384 516061 738379 401632 696465 797235 790669 761340 778076 780735 507010 752943 768587 757719 719746 515586 412207 88760 534107 812693 751341 532087 547604 704599 794767 762201 702860 809352 519593 654974 603945 779124 763746 787137 546848 577935 688855 705784 802027 775358 172662 813700 492313 706117 797261 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.25%) |
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 88760 172662 394417 401632 407895 412207 417519 420222 430553 431671 436042 445390 448483 449901 450219 455377 457113 458077 458652 458913 460790 461228 472641 473322 475378 481310 483256 488246 490208 492313 492606 493394 495384 504751 507010 511991 512665 515586 516061 519593 525873 525919 526595 532087 534107 546848 547604 548026 551650 552801 556851 558854 563839 568680 569431 571198 573492 574916 577935 584749 590482 603945 611416 611900 612792 620559 620792 621735 624222 627371 628720 631603 637650 641375 642832 644510 654974 668857 688855 696465 702860 704579 704599 705784 706117 719504 719746 725824 731376 738379 745751 745761 751341 752943 755454 756190 757719 759865 761340 762201 763746 768587 773565 774299 778076 778656 779124 780735 787137 790669 794767 797235 797261 802027 809352 812693 813700 815459 815973 ] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен красивая"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.63%) |
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.