Query Metrics
7
Database Queries
7
Different statements
190.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.41 ms (86.28%) |
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 188009 232945 281095 382453 388232 388766 389861 389864 391355 395402 395861 395926 402128 410660 414016 415147 415637 417223 421883 424276 427536 429416 432601 432837 439569 441956 443166 443182 443191 444144 445714 446022 448955 449760 456842 457586 459407 459602 460582 464805 465834 466775 469167 471686 472867 481815 483654 487030 489841 491837 493195 499333 502994 506301 508744 512030 516002 517278 520377 521261 524874 529604 529674 529965 536441 538007 538789 544970 546308 546453 546912 547861 548040 549967 552285 554897 555658 556799 556801 560390 561486 563423 564298 565012 565623 569993 571494 572580 574249 581410 582479 582500 583015 597878 620245 625642 651327 668584 694195 714546 717517 740158 745474 770615 776532 778678 784211 788401 793844 798011 802041 805332 808607 813528 814535 814596 814610 815942 822121 824088 ] |
||||||||||||||||||||||||||||||
|
14.87 ms (7.80%) |
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 544970 556799 651327 694195 714546 668584 548040 549967 561486 574249 778678 813528 784211 740158 788401 745474 808607 281095 472867 529965 597878 448955 415147 512030 493195 538007 188009 395402 395926 389861 402128 432601 439569 414016 443182 445714 487030 489841 464805 506301 529674 536441 502994 460582 560390 581410 552285 554897 569993 582479 582500 546308 546912 565012 717517 563423 620245 793844 798011 776532 805332 770615 802041 625642 382453 443166 443191 459407 389864 421883 471686 481815 388232 391355 415637 424276 441956 456842 459602 466775 232945 395861 410660 429416 417223 444144 491837 516002 529604 521261 483654 508744 499333 524874 565623 571494 446022 469167 388766 427536 432837 465834 449760 517278 814535 814610 824088 814596 815942 822121 457586 520377 538789 556801 572580 555658 546453 547861 564298 583015 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (1.85%) |
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 188009 232945 281095 382453 388232 388766 389861 389864 391355 395402 395861 395926 402128 410660 414016 415147 415637 417223 421883 424276 427536 429416 432601 432837 439569 441956 443166 443182 443191 444144 445714 446022 448955 449760 456842 457586 459407 459602 460582 464805 465834 466775 469167 471686 472867 481815 483654 487030 489841 491837 493195 499333 502994 506301 508744 512030 516002 517278 520377 521261 524874 529604 529674 529965 536441 538007 538789 544970 546308 546453 546912 547861 548040 549967 552285 554897 555658 556799 556801 560390 561486 563423 564298 565012 565623 569993 571494 572580 574249 581410 582479 582500 583015 597878 620245 625642 651327 668584 694195 714546 717517 740158 745474 770615 776532 778678 784211 788401 793844 798011 802041 805332 808607 813528 814535 814596 814610 815942 822121 824088 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom рак"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom doggy"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom рак"
]
|
||||||||||||||||||||||||||||||
|
1.74 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.