Query Metrics
7
Database Queries
7
Different statements
195.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.79 ms (88.38%) |
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 188031 385661 419246 421257 428860 429366 439532 441021 443256 444743 446251 450969 454633 457957 458678 459792 460072 461100 462923 463002 468482 471122 473331 473426 475404 479845 482190 483691 485666 486240 486776 489331 494491 504060 506783 509665 509833 511196 511278 511721 519481 520489 530497 531248 533556 536340 536378 536542 545454 550314 552263 554889 567063 569593 571359 580183 580194 587451 588617 591156 599894 600280 602291 612457 622025 633767 634811 635993 648223 652513 673035 674077 678701 680754 684660 686474 693310 696450 703644 704669 710943 713233 718785 721805 738126 740523 744266 744983 751316 751571 752921 753635 756840 757215 759344 766401 767208 767850 772552 778105 782554 785558 787075 790231 790418 791382 792700 792735 794013 795406 798161 799725 803624 804682 806830 808548 813558 814403 816235 818235 ] |
||||||||||||||||||||||||||||||
|
12.73 ms (6.51%) |
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 587451 602291 591156 622025 778105 790418 740523 744983 782554 794013 798161 751316 753635 767850 703644 704669 791382 459792 439532 531248 710943 457957 530497 511196 545454 693310 752921 766401 792700 468482 461100 816235 486776 536542 599894 511721 509665 429366 473426 482190 536378 718785 446251 471122 441021 519481 511278 444743 580183 785558 443256 696450 520489 814403 504060 678701 721805 803624 804682 738126 808548 772552 744266 751571 757215 792735 799725 473331 554889 506783 428860 634811 818235 648223 673035 635993 600280 633767 787075 790231 759344 756840 454633 483691 479845 674077 463002 767208 385661 550314 652513 795406 571359 533556 485666 684660 460072 419246 462923 458678 450969 569593 567063 588617 489331 580194 421257 509833 813558 686474 806830 486240 494491 475404 612457 536340 188031 552263 680754 713233 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.51%) |
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 188031 385661 419246 421257 428860 429366 439532 441021 443256 444743 446251 450969 454633 457957 458678 459792 460072 461100 462923 463002 468482 471122 473331 473426 475404 479845 482190 483691 485666 486240 486776 489331 494491 504060 506783 509665 509833 511196 511278 511721 519481 520489 530497 531248 533556 536340 536378 536542 545454 550314 552263 554889 567063 569593 571359 580183 580194 587451 588617 591156 599894 600280 602291 612457 622025 633767 634811 635993 648223 652513 673035 674077 678701 680754 684660 686474 693310 696450 703644 704669 710943 713233 718785 721805 738126 740523 744266 744983 751316 751571 752921 753635 756840 757215 759344 766401 767208 767850 772552 778105 782554 785558 787075 790231 790418 791382 792700 792735 794013 795406 798161 799725 803624 804682 806830 808548 813558 814403 816235 818235 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob long dildo"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс длинные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс длинные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
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.