Query Metrics
7
Database Queries
7
Different statements
373.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.54 ms (55.29%) |
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 6670 191316 341782 348262 383719 383985 384494 385175 385752 387470 392082 395592 401183 411709 419538 435052 440620 442146 442211 452594 454196 455834 459844 464404 465654 466150 466782 467621 469453 470172 474414 474964 479046 483484 485083 486454 487578 491352 492100 495256 500628 503476 504059 512494 513030 513214 515588 515679 517080 518564 518973 519438 522034 522827 522875 523280 525740 526222 526268 534962 535414 541907 544264 546851 550823 552000 554434 563214 569052 585446 585519 588375 588411 591702 592993 593400 600786 605093 606656 619235 619475 651685 663982 665884 666353 667196 671665 689833 690144 695241 702065 707308 708435 716111 717998 718733 719059 721895 724171 726602 735875 741077 743861 748144 759867 760801 771757 777792 789629 789708 791555 799710 800356 802117 805075 811105 815078 815283 815977 818430 ] |
||||||||||||||||||||||||||||||
|
143.03 ms (38.29%) |
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 6670 191316 341782 348262 383719 383985 384494 385175 385752 387470 392082 395592 401183 411709 419538 435052 440620 442146 442211 452594 454196 455834 459844 464404 465654 466150 466782 467621 469453 470172 474414 474964 479046 483484 485083 486454 487578 491352 492100 495256 500628 503476 504059 512494 513030 513214 515588 515679 517080 518564 518973 519438 522034 522827 522875 523280 525740 526222 526268 534962 535414 541907 544264 546851 550823 552000 554434 563214 569052 585446 585519 588375 588411 591702 592993 593400 600786 605093 606656 619235 619475 651685 663982 665884 666353 667196 671665 689833 690144 695241 702065 707308 708435 716111 717998 718733 719059 721895 724171 726602 735875 741077 743861 748144 759867 760801 771757 777792 789629 789708 791555 799710 800356 802117 805075 811105 815078 815283 815977 818430 ] |
||||||||||||||||||||||||||||||
|
17.05 ms (4.56%) |
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 467621 435052 500628 487578 485083 401183 592993 585519 6670 503476 619475 191316 442211 522034 667196 663982 563214 419538 383985 459844 474964 492100 486454 517080 525740 483484 491352 384494 513030 526268 550823 474414 535414 470172 522827 464404 554434 385752 392082 815283 818430 815078 815977 534962 518973 552000 569052 541907 544264 651685 671665 689833 708435 718733 719059 665884 690144 695241 702065 717998 546851 619235 591702 789629 789708 799710 805075 741077 791555 800356 811105 735875 759867 726602 743861 724171 748144 771757 707308 777792 341782 387470 522875 760801 479046 469453 411709 495256 588411 385175 442146 721895 605093 606656 802117 518564 716111 523280 593400 588375 455834 395592 440620 466782 504059 585446 452594 465654 600786 383719 348262 454196 466150 512494 515679 519438 526222 515588 513214 666353 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings office"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.44%) |
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.