Query Metrics
7
Database Queries
7
Different statements
177.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.93 ms (87.19%) |
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 386719 387186 389579 390350 390908 395514 401319 401985 408989 418494 425582 426159 426675 428494 431333 432927 433253 437856 441623 443093 446169 447146 447425 447435 447493 448876 456268 461461 464185 464650 466161 472179 473083 473208 473781 475237 476962 487206 490982 492553 494692 506310 516970 521532 527629 531908 532799 532945 536610 545730 555955 556911 560191 565953 574507 575162 578374 579182 580236 591349 591911 591955 595359 600167 600985 603168 603285 603584 609926 613055 622351 622986 630444 640811 644669 646776 653487 678552 679386 693859 701152 718492 719253 719285 720009 721949 724399 727632 727689 736614 737127 746067 746970 747092 747375 748389 751770 753445 753485 753836 753847 753870 754214 766871 767209 767596 769811 769880 770939 777513 779140 780979 780986 781055 787491 789753 790003 800762 801591 811439 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (8.16%) |
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 678552 679386 720009 591955 622986 591911 630444 777513 781055 779140 780986 789753 800762 811439 727632 747092 753445 753847 753870 754214 767596 770939 787491 766871 769811 769880 736614 751770 724399 727689 747375 753836 753485 718492 719285 780979 387186 390350 401319 386719 437856 447493 560191 613055 622351 603285 389579 693859 701152 801591 790003 746067 767209 746970 719253 390908 408989 395514 536610 646776 600985 603168 737127 748389 425582 428494 521532 506310 640811 721949 401985 426159 433253 441623 443093 432927 532799 532945 531908 556911 565953 578374 555955 575162 580236 653487 603584 591349 600167 595359 609926 456268 473083 475237 426675 446169 476962 418494 447146 447425 447435 448876 473208 464185 527629 490982 492553 487206 472179 545730 574507 579182 644669 466161 461461 464650 473781 431333 516970 494692 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.10%) |
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 386719 387186 389579 390350 390908 395514 401319 401985 408989 418494 425582 426159 426675 428494 431333 432927 433253 437856 441623 443093 446169 447146 447425 447435 447493 448876 456268 461461 464185 464650 466161 472179 473083 473208 473781 475237 476962 487206 490982 492553 494692 506310 516970 521532 527629 531908 532799 532945 536610 545730 555955 556911 560191 565953 574507 575162 578374 579182 580236 591349 591911 591955 595359 600167 600985 603168 603285 603584 609926 613055 622351 622986 630444 640811 644669 646776 653487 678552 679386 693859 701152 718492 719253 719285 720009 721949 724399 727632 727689 736614 737127 746067 746970 747092 747375 748389 751770 753445 753485 753836 753847 753870 754214 766871 767209 767596 769811 769880 770939 777513 779140 780979 780986 781055 787491 789753 790003 800762 801591 811439 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen сиськ лиза"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen tits licking"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen сиськ лиза"
]
|
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.