Query Metrics
7
Database Queries
7
Different statements
185.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.64 ms (88.46%) |
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 154576 256988 315762 350614 373311 383554 388112 389209 412866 427035 432334 446479 448071 448081 458541 469400 470993 475636 477425 488633 491615 501962 508898 510921 522772 531379 531595 531773 533296 533774 537990 539603 544876 545149 545150 547542 550944 553092 553217 553228 558476 558541 561920 576497 581549 588233 596355 612911 627116 629794 631341 637375 637840 638440 648591 649738 651639 655557 666045 670460 677232 681231 698149 706015 706473 716393 734846 739300 741240 743239 747295 749599 752081 754568 754647 754658 755045 756372 758008 758085 758745 759093 759411 760448 773597 774099 777129 777149 782100 783286 784333 784547 785095 786336 786614 787768 788125 789795 791888 792272 792441 792458 792740 793092 796386 796389 796401 802904 804258 804709 804806 805588 806515 806913 811878 812242 819157 819232 822889 826496 ] |
||||||||||||||||||||||||||||||
|
11.11 ms (6.01%) |
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 792458 804806 806515 782100 784547 791888 796386 754568 785095 786336 793092 755045 773597 739300 749599 758745 774099 627116 789795 796401 812242 427035 533774 531595 545149 787768 666045 553228 588233 734846 432334 561920 802904 510921 576497 553092 792441 373311 388112 651639 805588 550944 547542 716393 783286 756372 256988 448081 533296 681231 581549 629794 796389 792272 822889 826496 475636 531773 539603 522772 706015 553217 637840 596355 638440 612911 631341 759093 758085 804258 811878 383554 531379 501962 491615 670460 677232 649738 655557 698149 558541 637375 804709 806913 758008 754658 759411 752081 754647 784333 412866 315762 350614 508898 469400 537990 706473 154576 819157 792740 786614 477425 446479 648591 760448 470993 747295 488633 777149 788125 777129 743239 741240 448071 545150 544876 558476 389209 819232 458541 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.58%) |
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 154576 256988 315762 350614 373311 383554 388112 389209 412866 427035 432334 446479 448071 448081 458541 469400 470993 475636 477425 488633 491615 501962 508898 510921 522772 531379 531595 531773 533296 533774 537990 539603 544876 545149 545150 547542 550944 553092 553217 553228 558476 558541 561920 576497 581549 588233 596355 612911 627116 629794 631341 637375 637840 638440 648591 649738 651639 655557 666045 670460 677232 681231 698149 706015 706473 716393 734846 739300 741240 743239 747295 749599 752081 754568 754647 754658 755045 756372 758008 758085 758745 759093 759411 760448 773597 774099 777129 777149 782100 783286 784333 784547 785095 786336 786614 787768 788125 789795 791888 792272 792441 792458 792740 793092 796386 796389 796401 802904 804258 804709 804806 805588 806515 806913 811878 812242 819157 819232 822889 826496 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo girl vagina"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло девушк вагин"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло девушк вагин"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.91%) |
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.