Query Metrics
7
Database Queries
7
Different statements
173.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.84 ms (85.80%) |
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 541402 543661 544267 544297 544302 546550 546719 548299 549307 554541 556796 557372 557895 560369 561575 562595 563433 564286 565227 566445 566551 567430 568265 568337 571206 573787 581347 581382 581385 581621 582670 593820 598028 606417 621608 645838 646042 646224 648211 648463 649138 649956 650593 650829 651163 651178 651182 652573 652856 652971 652983 659262 665751 668562 670052 670111 670388 670393 671747 671925 671927 672095 672105 672723 673170 674072 677740 678432 685279 685288 690834 691485 691998 692110 692231 692258 692349 692360 692473 693039 693041 693486 694023 694052 694073 694172 694197 694455 694495 694522 694528 694565 695180 695191 695196 695621 695631 695923 695941 696278 697258 697273 697328 697790 698497 698548 699695 699753 703040 703085 703533 705295 706620 708790 710317 712714 715097 716570 717934 720375 ] |
||||||||||||||||||||||||||||||
|
13.95 ms (8.04%) |
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 557372 560369 564286 568265 573787 581347 582670 541402 543661 544267 544297 544302 546550 549307 554541 557895 561575 562595 565227 566551 567430 568337 581382 581621 646042 646224 648211 648463 649138 649956 650593 650829 651178 659262 668562 670393 671925 672095 674072 685279 691485 692258 692349 692473 693039 694052 694455 694495 694522 694528 695196 695631 695923 696278 703040 703533 706620 710317 712714 716570 652983 670052 671927 672723 673170 678432 690834 692110 693486 694023 694172 694197 694565 695621 695941 697258 697273 697328 697790 698497 698548 699695 705295 717934 720375 645838 651163 651182 652573 652856 652971 665751 670111 670388 671747 672105 677740 685288 691998 692231 692360 693041 694073 695180 695191 699753 703085 708790 715097 546719 548299 556796 563433 566445 571206 581385 593820 598028 606417 621608 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.77%) |
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 541402 543661 544267 544297 544302 546550 546719 548299 549307 554541 556796 557372 557895 560369 561575 562595 563433 564286 565227 566445 566551 567430 568265 568337 571206 573787 581347 581382 581385 581621 582670 593820 598028 606417 621608 645838 646042 646224 648211 648463 649138 649956 650593 650829 651163 651178 651182 652573 652856 652971 652983 659262 665751 668562 670052 670111 670388 670393 671747 671925 671927 672095 672105 672723 673170 674072 677740 678432 685279 685288 690834 691485 691998 692110 692231 692258 692349 692360 692473 693039 693041 693486 694023 694052 694073 694172 694197 694455 694495 694522 694528 694565 695180 695191 695196 695621 695631 695923 695941 696278 697258 697273 697328 697790 698497 698548 699695 699753 703040 703085 703533 705295 706620 708790 710317 712714 715097 716570 717934 720375 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vintage 1994"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"vintage"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"vintage"
]
|
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.