Query Metrics
7
Database Queries
7
Different statements
168.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.27 ms (86.64%) |
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 382057 384104 391585 394162 396369 398364 441958 455640 466224 468426 470397 473932 489946 492750 511004 521837 522196 524102 529296 531839 534091 536464 541868 544140 550925 553732 562587 564500 564830 567947 568938 571126 572235 575665 577883 592396 592587 600540 604399 607296 607814 632887 633015 633637 635558 636428 639040 645669 655294 656200 656487 656497 656548 656644 662203 666855 668305 683028 684383 685203 697460 700259 720157 725030 726194 728739 729337 730315 737561 740481 746305 749672 750145 752603 755637 755840 757747 757792 760401 760713 761723 761740 761754 761757 761759 763428 765729 765784 767236 767247 769064 769576 769776 770261 775716 776264 776327 776527 778670 780799 784217 784528 787606 790087 791160 792049 796077 799759 800301 800387 800901 801313 802620 803494 803603 803849 804935 806924 812983 814445 ] |
||||||||||||||||||||||||||||||
|
13.47 ms (7.98%) |
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 800901 801313 746305 757792 763428 800301 800387 769576 765784 728739 750145 761757 814445 553732 564500 541868 550925 564830 656548 668305 632887 737561 760401 790087 804935 767247 770261 726194 749672 697460 776327 780799 803494 760713 796077 803849 639040 466224 531839 544140 635558 592396 607296 725030 752603 757747 802620 791160 441958 568938 577883 592587 767236 729337 740481 730315 778670 396369 521837 524102 489946 645669 656497 685203 391585 455640 473932 575665 656487 656644 604399 492750 655294 511004 534091 529296 666855 656200 720157 700259 562587 607814 776264 784217 799759 792049 806924 761754 761759 787606 755840 761723 769064 769776 755637 761740 765729 775716 812983 803603 784528 384104 571126 572235 683028 684383 636428 600540 394162 567947 662203 776527 633015 633637 382057 398364 468426 470397 522196 536464 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.42%) |
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 382057 384104 391585 394162 396369 398364 441958 455640 466224 468426 470397 473932 489946 492750 511004 521837 522196 524102 529296 531839 534091 536464 541868 544140 550925 553732 562587 564500 564830 567947 568938 571126 572235 575665 577883 592396 592587 600540 604399 607296 607814 632887 633015 633637 635558 636428 639040 645669 655294 656200 656487 656497 656548 656644 662203 666855 668305 683028 684383 685203 697460 700259 720157 725030 726194 728739 729337 730315 737561 740481 746305 749672 750145 752603 755637 755840 757747 757792 760401 760713 761723 761740 761754 761757 761759 763428 765729 765784 767236 767247 769064 769576 769776 770261 775716 776264 776327 776527 778670 780799 784217 784528 787606 790087 791160 792049 796077 799759 800301 800387 800901 801313 802620 803494 803603 803849 804935 806924 812983 814445 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade anal riding"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск анал riding"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск анал riding"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.76%) |
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.