Query Metrics
7
Database Queries
7
Different statements
388.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
363.51 ms (93.61%) |
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 21220 69969 251476 305626 366321 382378 386103 394233 403045 403050 425939 456885 515118 515198 538868 550448 550663 552013 560408 566981 567145 578470 588625 600105 603145 605610 607103 607203 608042 612106 613471 618873 620856 621686 622216 622540 631601 637061 649561 663359 663910 663932 663955 663975 664302 664825 665134 665498 667510 667850 668453 670476 676445 676469 676528 677011 681322 682511 691994 696964 696970 696972 696977 696981 700660 709639 710970 712830 719817 720429 722652 722664 722919 724904 727650 731693 732167 734907 735587 735602 735814 741248 741652 743096 743126 743127 744315 744326 744359 745003 745818 748145 748386 754128 754206 759405 759560 759564 759565 759572 759575 759642 767960 767961 773620 774155 788095 788471 788749 789283 800700 806031 812097 812115 812129 812150 816232 821375 821798 826097 ] |
||||||||||||||||||||||||||||||
|
15.47 ms (3.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 550448 305626 744359 816232 826097 515118 515198 550663 691994 637061 812097 759564 812150 767961 741248 748145 774155 722664 622540 741652 456885 649561 800700 366321 69969 821375 663932 676528 676445 677011 712830 719817 600105 605610 788471 788749 724904 759575 735587 767960 735814 745003 700660 21220 386103 667850 670476 696981 696964 789283 754128 567145 251476 425939 538868 578470 664302 663910 676469 696977 663359 696970 603145 613471 621686 812115 735602 745818 773620 727650 732167 744326 608042 612106 722919 403050 394233 382378 403045 682511 722652 667510 668453 681322 620856 744315 788095 731693 754206 743126 759560 759642 759572 709639 743127 560408 734907 821798 552013 566981 665134 665498 696972 720429 663955 663975 664825 710970 588625 607203 622216 631601 607103 618873 806031 812129 743096 748386 759565 759405 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (0.66%) |
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 21220 69969 251476 305626 366321 382378 386103 394233 403045 403050 425939 456885 515118 515198 538868 550448 550663 552013 560408 566981 567145 578470 588625 600105 603145 605610 607103 607203 608042 612106 613471 618873 620856 621686 622216 622540 631601 637061 649561 663359 663910 663932 663955 663975 664302 664825 665134 665498 667510 667850 668453 670476 676445 676469 676528 677011 681322 682511 691994 696964 696970 696972 696977 696981 700660 709639 710970 712830 719817 720429 722652 722664 722919 724904 727650 731693 732167 734907 735587 735602 735814 741248 741652 743096 743126 743127 744315 744326 744359 745003 745818 748145 748386 754128 754206 759405 759560 759564 759565 759572 759575 759642 767960 767961 773620 774155 788095 788471 788749 789283 800700 806031 812097 812115 812129 812150 816232 821375 821798 826097 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old girl"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old девушк"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old девушк"
]
|
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.