Query Metrics
7
Database Queries
7
Different statements
370.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.93 ms (57.73%) |
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 382129 387258 388087 394773 395733 398595 399351 416153 421039 427593 432128 432692 435735 437335 440650 442970 450377 451669 454199 454428 456778 461125 462461 470348 470647 471648 472445 472578 478425 482483 484415 484425 485223 485870 487022 487072 490567 491969 494577 496357 497117 498702 499587 501011 505219 506927 507005 508000 510418 511808 513545 515100 515182 515638 516817 519825 521656 523172 523796 523900 524327 525833 525984 526018 526030 528283 531903 542434 543420 544300 546372 548422 548559 548833 551627 554319 554424 558469 558849 558994 559203 560380 561937 563066 564172 565571 566033 569408 570980 571971 577897 581564 581637 583522 584049 588151 592873 593136 594414 603970 605105 605297 605459 609905 615819 615847 621316 622035 624430 625242 634327 651190 652945 660273 663854 665208 678486 814364 815594 816260 ] |
||||||||||||||||||||||||||||||
|
133.27 ms (35.96%) |
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 382129 387258 388087 394773 395733 398595 399351 416153 421039 427593 432128 432692 435735 437335 440650 442970 450377 451669 454199 454428 456778 461125 462461 470348 470647 471648 472445 472578 478425 482483 484415 484425 485223 485870 487022 487072 490567 491969 494577 496357 497117 498702 499587 501011 505219 506927 507005 508000 510418 511808 513545 515100 515182 515638 516817 519825 521656 523172 523796 523900 524327 525833 525984 526018 526030 528283 531903 542434 543420 544300 546372 548422 548559 548833 551627 554319 554424 558469 558849 558994 559203 560380 561937 563066 564172 565571 566033 569408 570980 571971 577897 581564 581637 583522 584049 588151 592873 593136 594414 603970 605105 605297 605459 609905 615819 615847 621316 622035 624430 625242 634327 651190 652945 660273 663854 665208 678486 814364 815594 816260 ] |
||||||||||||||||||||||||||||||
|
15.80 ms (4.26%) |
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 484425 485870 498702 516817 523900 485223 515100 515638 521656 525833 526018 484415 487022 491969 494577 496357 501011 525984 523172 624430 605105 487072 584049 394773 395733 382129 387258 388087 398595 399351 416153 427593 432692 435735 437335 440650 421039 432128 442970 814364 815594 816260 482483 450377 451669 454428 461125 470348 472445 490567 456778 454199 478425 513545 499587 511808 523796 526030 497117 505219 519825 524327 531903 506927 507005 508000 510418 515182 528283 462461 470647 471648 472578 546372 558849 563066 565571 581564 544300 548833 551627 559203 561937 569408 570980 577897 581637 583522 542434 543420 548422 548559 554319 558469 560380 566033 571971 665208 660273 678486 651190 652945 663854 554424 558994 564172 588151 592873 594414 603970 605297 615819 621316 622035 625242 634327 593136 605459 609905 615847 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toilet man"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"туалет мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.44%) |
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.