Query Metrics
7
Database Queries
7
Different statements
193.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.63 ms (82.85%) |
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 21323 25461 100665 107651 134947 169272 191048 312831 381849 383281 383482 385009 386804 390306 411939 415635 418439 425060 427220 433458 433587 438432 439456 441838 442101 446107 448466 451513 452757 453244 454388 454476 455991 458320 458358 458362 458625 458737 458896 459199 460680 460685 463978 464985 466892 468953 471186 488980 488982 488993 490499 503988 506863 507090 509290 515356 519342 520227 522331 525307 529437 532634 536585 547632 554770 562644 575234 582440 630760 640350 663427 663898 663912 663926 664322 664801 667536 667756 668875 669771 716862 725633 726078 728442 735893 747197 758170 770125 772681 775140 776442 777010 781783 781823 781824 781853 781862 781885 781892 781912 781922 782396 782411 794622 794796 803476 805265 807757 807763 808752 810021 812081 812943 813808 814037 814289 824965 828035 828142 828598 ] |
||||||||||||||||||||||||||||||
|
22.67 ms (11.69%) |
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 781862 803476 810021 781823 781824 812081 726078 781922 381849 107651 312831 507090 169272 191048 418439 458358 452757 459199 525307 515356 460680 468953 663427 663926 488980 519342 805265 554770 464985 451513 506863 509290 824965 383281 385009 383482 134947 21323 25461 390306 433587 441838 442101 427220 438432 411939 814289 813808 814037 446107 453244 454476 455991 458362 460685 463978 448466 488982 454388 458320 458625 458737 466892 520227 503988 532634 536585 488993 582440 663898 664801 669771 663912 664322 667756 716862 667536 668875 547632 575234 640350 630760 781783 775140 781885 781912 782396 794622 807763 808752 725633 772681 781892 794796 807757 758170 770125 728442 735893 776442 777010 781853 782411 812943 100665 439456 471186 386804 433458 458896 415635 425060 522331 529437 490499 562644 828035 828142 828598 747197 ] |
||||||||||||||||||||||||||||||
|
3.68 ms (1.90%) |
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 21323 25461 100665 107651 134947 169272 191048 312831 381849 383281 383482 385009 386804 390306 411939 415635 418439 425060 427220 433458 433587 438432 439456 441838 442101 446107 448466 451513 452757 453244 454388 454476 455991 458320 458358 458362 458625 458737 458896 459199 460680 460685 463978 464985 466892 468953 471186 488980 488982 488993 490499 503988 506863 507090 509290 515356 519342 520227 522331 525307 529437 532634 536585 547632 554770 562644 575234 582440 630760 640350 663427 663898 663912 663926 664322 664801 667536 667756 668875 669771 716862 725633 726078 728442 735893 747197 758170 770125 772681 775140 776442 777010 781783 781823 781824 781853 781862 781885 781892 781912 781922 782396 782411 794622 794796 803476 805265 807757 807763 808752 810021 812081 812943 813808 814037 814289 824965 828035 828142 828598 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная татуированные"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"толстушки с тату"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"полная татуированные"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
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.