Query Metrics
7
Database Queries
7
Different statements
401.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.11 ms (53.36%) |
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 24289 29403 66348 157493 172024 172685 193874 246509 308331 326158 327638 373311 382018 382444 383577 383583 384334 384889 386872 389893 392028 396891 397967 401532 402125 407746 409881 410015 421113 422172 424182 427486 429776 440894 441224 453232 455319 455994 456990 457572 459257 460348 462943 463180 464015 464459 466961 472852 475600 477453 481238 482467 482639 492199 494852 499189 504154 506273 507415 509348 510705 511205 512563 512612 512960 517077 519394 519659 539360 542979 545492 546629 550643 552802 557322 560366 561455 561464 561505 565865 566953 567431 569685 575195 577364 580866 584562 585395 601102 609604 613238 618948 621592 642407 642409 659397 675393 675618 684961 685400 685519 714554 716106 717546 717914 734180 738226 742220 742763 757113 761890 761949 780254 786080 796953 801175 803256 806754 810867 813710 ] |
||||||||||||||||||||||||||||||
|
165.75 ms (41.30%) |
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 24289 29403 66348 157493 172024 172685 193874 246509 308331 326158 327638 373311 382018 382444 383577 383583 384334 384889 386872 389893 392028 396891 397967 401532 402125 407746 409881 410015 421113 422172 424182 427486 429776 440894 441224 453232 455319 455994 456990 457572 459257 460348 462943 463180 464015 464459 466961 472852 475600 477453 481238 482467 482639 492199 494852 499189 504154 506273 507415 509348 510705 511205 512563 512612 512960 517077 519394 519659 539360 542979 545492 546629 550643 552802 557322 560366 561455 561464 561505 565865 566953 567431 569685 575195 577364 580866 584562 585395 601102 609604 613238 618948 621592 642407 642409 659397 675393 675618 684961 685400 685519 714554 716106 717546 717914 734180 738226 742220 742763 757113 761890 761949 780254 786080 796953 801175 803256 806754 810867 813710 ] |
||||||||||||||||||||||||||||||
|
14.72 ms (3.67%) |
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 373311 424182 66348 685519 675618 172685 389893 585395 510705 482639 453232 584562 613238 429776 512563 459257 326158 499189 472852 172024 685400 717546 742220 565865 621592 780254 560366 575195 504154 742763 757113 384334 734180 422172 327638 29403 561505 494852 796953 384889 577364 609604 401532 561464 761949 519394 382444 402125 517077 246509 308331 813710 716106 714554 810867 464459 561455 642409 392028 382018 482467 509348 557322 542979 409881 455994 512612 519659 506273 441224 475600 512960 457572 460348 462943 477453 786080 396891 466961 456990 539360 546629 552802 566953 427486 463180 511205 507415 569685 455319 659397 801175 803256 642407 545492 383577 410015 397967 193874 481238 684961 761890 738226 386872 675393 157493 464015 550643 618948 601102 24289 407746 567431 580866 492199 383583 421113 717914 806754 440894 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс в кухня"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в кухн"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс в кухн"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.37%) |
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.