Query Metrics
7
Database Queries
7
Different statements
163.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.22 ms (84.92%) |
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 8518 12573 96461 96623 324183 341691 389409 393677 396030 397232 399418 401580 408711 412189 413404 415954 421637 445416 454802 461723 467581 467606 468176 471476 491776 502489 513511 514034 516091 530295 530377 531174 532659 539232 544749 545389 564407 564554 583507 599969 603400 609875 609906 629243 630221 630524 632632 633179 633497 633602 634480 635835 635900 644894 645980 647898 647906 652850 654097 672388 672987 673942 677307 678532 680974 681515 682986 689525 690012 691984 695923 699531 699719 702342 703586 704235 708597 710794 713023 715750 715818 718327 719059 720219 720834 722648 723094 724170 727833 728327 729691 730329 730415 734483 736107 737516 745924 749669 749990 751309 766611 770292 772729 775766 782836 793899 795137 796652 796789 802732 805228 814423 815536 817240 817624 818938 819311 822304 823721 827969 ] |
||||||||||||||||||||||||||||||
|
13.65 ms (8.33%) |
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 734483 12573 389409 680974 413404 468176 691984 715750 722648 645980 689525 802732 728327 737516 749669 766611 770292 609875 629243 408711 471476 341691 817624 823721 822304 513511 530295 564554 654097 681515 695923 652850 544749 633179 635835 633602 805228 796652 796789 736107 727833 745924 749990 634480 699719 702342 723094 324183 96623 396030 393677 715818 603400 730415 502489 564407 583507 647898 677307 609906 467581 491776 445416 530377 545389 720834 412189 454802 531174 539232 678532 704235 710794 647906 599969 630524 635900 630221 633497 461723 415954 516091 96461 401580 818938 703586 718327 782836 795137 793899 772729 8518 632632 397232 399418 421637 814423 467606 672388 775766 729691 730329 751309 724170 827969 713023 644894 815536 819311 817240 514034 532659 673942 690012 708597 719059 720219 699531 672987 682986 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.69%) |
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 8518 12573 96461 96623 324183 341691 389409 393677 396030 397232 399418 401580 408711 412189 413404 415954 421637 445416 454802 461723 467581 467606 468176 471476 491776 502489 513511 514034 516091 530295 530377 531174 532659 539232 544749 545389 564407 564554 583507 599969 603400 609875 609906 629243 630221 630524 632632 633179 633497 633602 634480 635835 635900 644894 645980 647898 647906 652850 654097 672388 672987 673942 677307 678532 680974 681515 682986 689525 690012 691984 695923 699531 699719 702342 703586 704235 708597 710794 713023 715750 715818 718327 719059 720219 720834 722648 723094 724170 727833 728327 729691 730329 730415 734483 736107 737516 745924 749669 749990 751309 766611 770292 772729 775766 782836 793899 795137 796652 796789 802732 805228 814423 815536 817240 817624 818938 819311 822304 823721 827969 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double анал teens"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double anal teens"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double анал teens"
]
|
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.