Query Metrics
7
Database Queries
7
Different statements
175.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.77 ms (82.72%) |
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 89409 131512 188014 395395 402617 405974 415356 418279 419585 427196 427488 433550 436718 437778 438091 441293 444306 449218 450437 459066 460850 469205 469411 469905 475340 480087 482836 486830 491131 493341 495241 495388 495496 495736 496158 498632 498856 501286 501427 504038 504730 506875 510097 511509 512122 513210 513631 516205 516569 517979 518802 519300 522304 523725 525427 526816 528540 532057 534084 537051 538281 541961 543530 546427 547277 547937 548185 549577 550950 551607 554058 555254 557995 558251 558987 559515 560693 560988 562521 564670 565040 566359 566364 567599 568625 570974 571780 572704 575936 576208 577180 579101 579878 581579 582735 583662 584358 584437 586948 596610 604250 606282 612498 621603 621958 623277 625987 632920 647403 666401 672896 675495 681354 684531 690748 690935 742633 749791 793303 ] |
||||||||||||||||||||||||||||||
|
19.38 ms (11.07%) |
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 480087 511509 482836 519300 437778 526816 532057 582735 566364 510097 584437 556243 538281 541961 647403 690935 546427 559515 579101 549577 672896 550950 433550 513631 522304 623277 469905 495736 572704 576208 579878 469205 395395 438091 517979 89409 427196 419585 469411 486830 513210 793303 459066 418279 441293 496158 675495 402617 405974 415356 749791 427488 449218 444306 537051 436718 501286 516205 584358 604250 450437 528540 516569 547937 586948 596610 475340 131512 558987 566359 583662 495241 460850 577180 495388 491131 606282 188014 506875 493341 581579 551607 501427 621958 742633 564670 525427 548185 518802 632920 495496 523725 534084 504730 512122 554058 555254 558251 543530 547277 557995 562521 570974 560693 571780 666401 684531 690748 681354 560988 565040 567599 568625 575936 621603 625987 612498 504038 498632 498856 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.71%) |
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 89409 131512 188014 395395 402617 405974 415356 418279 419585 427196 427488 433550 436718 437778 438091 441293 444306 449218 450437 459066 460850 469205 469411 469905 475340 480087 482836 486830 491131 493341 495241 495388 495496 495736 496158 498632 498856 501286 501427 504038 504730 506875 510097 511509 512122 513210 513631 516205 516569 517979 518802 519300 522304 523725 525427 526816 528540 532057 534084 537051 538281 541961 543530 546427 547277 547937 548185 549577 550950 551607 554058 555254 557995 558251 558987 559515 560693 560988 562521 564670 565040 566359 566364 567599 568625 570974 571780 572704 575936 576208 577180 579101 579878 581579 582735 583662 584358 584437 586948 596610 604250 606282 612498 621603 621958 623277 625987 632920 647403 666401 672896 675495 681354 684531 690748 690935 742633 749791 793303 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"домашнее на ноги и"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск на ног"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
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.