Query Metrics
7
Database Queries
7
Different statements
155.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.50 ms (80.08%) |
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 334950 389264 397369 400195 400869 401953 402247 407015 416841 418035 425636 426540 428837 437583 441626 442946 444588 447971 448745 449866 449879 454923 457649 460190 460693 462897 465355 467329 467338 469072 472162 479346 481798 482350 489185 489938 495088 500832 504739 504897 506113 510754 512377 513397 514337 515122 515952 516332 517049 517143 518960 519138 519322 519838 520265 522424 524456 527675 528538 530734 531120 531523 535684 535960 544495 547644 548848 550076 556865 565752 566708 569421 571033 571715 580744 581341 581737 582236 585392 587228 588041 591413 598993 599664 605484 610293 611562 615762 635920 665121 672328 672777 680824 695153 696557 704533 710594 724651 727465 742810 745397 757638 770642 784922 792910 799360 802104 803069 803293 809064 811037 813435 814830 815170 815278 815490 815885 815960 ] |
||||||||||||||||||||||||||||||
|
21.34 ms (13.72%) |
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 710594 672777 695153 581737 605484 784922 809064 813435 727465 742810 803069 724651 745397 770642 811037 400869 418035 479346 472162 519838 527675 334950 814830 815170 815960 448745 481798 513397 530734 522424 531523 517143 696557 547644 550076 585392 599664 611562 588041 635920 792910 802104 757638 704533 799360 401953 402247 447971 460190 400195 425636 462897 500832 504897 519322 495088 520265 426540 407015 815490 815885 815278 467329 467338 449879 460693 489185 489938 515952 519138 514337 544495 571715 580744 665121 565752 581341 610293 803293 389264 437583 449866 504739 524456 506113 441626 535684 535960 548848 672328 587228 591413 615762 465355 397369 457649 428837 454923 516332 531120 566708 598993 442946 469072 512377 416841 517049 571033 556865 482350 444588 510754 528538 569421 582236 515122 518960 680824 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.64%) |
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 334950 389264 397369 400195 400869 401953 402247 407015 416841 418035 425636 426540 428837 437583 441626 442946 444588 447971 448745 449866 449879 454923 457649 460190 460693 462897 465355 467329 467338 469072 472162 479346 481798 482350 489185 489938 495088 500832 504739 504897 506113 510754 512377 513397 514337 515122 515952 516332 517049 517143 518960 519138 519322 519838 520265 522424 524456 527675 528538 530734 531120 531523 535684 535960 544495 547644 548848 550076 556865 565752 566708 569421 571033 571715 580744 581341 581737 582236 585392 587228 588041 591413 598993 599664 605484 610293 611562 615762 635920 665121 672328 672777 680824 695153 696557 704533 710594 724651 727465 742810 745397 757638 770642 784922 792910 799360 802104 803069 803293 809064 811037 813435 814830 815170 815278 815490 815885 815960 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"catches"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"catches"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"catches"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.02%) |
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.