Query Metrics
7
Database Queries
7
Different statements
192.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.54 ms (89.48%) |
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 352189 401423 418397 419298 421942 421992 424261 426648 427113 427631 427634 428684 432470 432681 433614 440874 450164 452586 452699 453610 455228 455551 455620 455885 457352 461034 463238 464135 464552 466904 468387 471619 478247 479955 485787 486732 489222 494833 504343 505996 507708 512736 514451 515046 515707 516786 524926 525063 525883 527362 528733 533166 541749 545127 552848 557012 560329 567198 569138 585455 587448 587755 591107 591721 602913 605619 614931 617106 624391 628956 640210 646702 656158 664649 687141 700375 747972 757831 761305 765932 768188 774370 775345 777267 777355 782341 782430 788737 789780 794539 797105 801554 803885 804532 804823 809160 809433 811153 811363 811403 814271 817222 817990 818616 818642 818864 820064 821141 821230 821821 822741 823468 824298 824894 825494 825618 825643 827436 827644 ] |
||||||||||||||||||||||||||||||
|
11.69 ms (6.06%) |
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 552848 628956 811403 533166 700375 591721 809160 809433 804532 757831 817990 824894 827436 822741 818642 824298 827644 825643 545127 646702 664649 777267 803885 811153 775345 782341 788737 782430 794539 801554 747972 761305 769449 774370 614931 777355 789780 804823 461034 455620 463238 494833 504343 505996 466904 560329 591107 433614 455551 479955 419298 640210 464552 427113 421992 450164 352189 428684 489222 453610 605619 524926 811363 585455 541749 823468 825618 797105 457352 455228 569138 440874 528733 421942 427631 452586 468387 656158 455885 478247 527362 515046 687141 401423 818864 427634 418397 765932 557012 567198 514451 507708 432470 485787 432681 471619 587448 424261 525883 512736 587755 602913 624391 617106 426648 464135 486732 515707 525063 768188 452699 516786 821821 825494 817222 820064 814271 818616 821141 821230 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.43%) |
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 352189 401423 418397 419298 421942 421992 424261 426648 427113 427631 427634 428684 432470 432681 433614 440874 450164 452586 452699 453610 455228 455551 455620 455885 457352 461034 463238 464135 464552 466904 468387 471619 478247 479955 485787 486732 489222 494833 504343 505996 507708 512736 514451 515046 515707 516786 524926 525063 525883 527362 528733 533166 541749 545127 552848 557012 560329 567198 569138 585455 587448 587755 591107 591721 602913 605619 614931 617106 624391 628956 640210 646702 656158 664649 687141 700375 747972 757831 761305 765932 768188 774370 775345 777267 777355 782341 782430 788737 789780 794539 797105 801554 803885 804532 804823 809160 809433 811153 811363 811403 814271 817222 817990 818616 818642 818864 820064 821141 821230 821821 822741 823468 824298 824894 825494 825618 825643 827436 827644 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пов чулки"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.