Query Metrics
7
Database Queries
7
Different statements
154.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.16 ms (84.34%) |
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 385288 388316 392213 400867 436071 438312 439683 443795 451515 454260 454345 454351 455331 459445 460715 460757 460890 461400 461936 462193 466037 466127 466252 469113 470147 470826 471076 472810 472814 473645 477975 478394 478727 479073 479391 480638 480851 483451 483692 483978 485625 488703 490899 494933 495484 497042 497480 499291 499956 500432 501992 502562 503016 511524 512823 514015 515651 520919 521415 523165 525452 525741 538213 545673 546001 546377 547619 547738 547791 547794 547796 551560 551619 551876 552346 554222 554238 556490 556881 558158 559047 559066 560038 560422 560645 561357 561462 563038 564955 567409 572194 572203 575180 575460 575555 578538 582583 587894 595870 598032 598201 598554 600318 605011 619034 619059 619091 620058 626872 643986 659204 662376 668139 690745 751262 761141 765810 771392 778828 791858 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (9.40%) |
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 771392 751262 761141 765810 605011 778828 791858 392213 436071 438312 439683 480851 385288 451515 455331 459445 462193 466252 469113 478727 400867 478394 479391 454345 454351 461400 460715 460890 472814 514015 483451 488703 499291 483692 483978 500432 501992 520919 525741 538213 564955 546377 668139 546001 598032 598201 643986 595870 461936 466037 477975 480638 443795 454260 388316 460757 471076 473645 470826 479073 466127 515651 485625 503016 511524 523165 525452 502562 512823 490899 497480 499956 521415 472810 470147 494933 495484 497042 545673 547791 551619 560422 561462 572194 572203 575555 582583 547738 547796 556490 556881 558158 560645 563038 547794 551560 552346 554222 559066 560038 567409 575180 578538 662376 659204 690745 547619 551876 554238 559047 561357 575460 619091 619059 626872 587894 598554 600318 619034 620058 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.83%) |
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 385288 388316 392213 400867 436071 438312 439683 443795 451515 454260 454345 454351 455331 459445 460715 460757 460890 461400 461936 462193 466037 466127 466252 469113 470147 470826 471076 472810 472814 473645 477975 478394 478727 479073 479391 480638 480851 483451 483692 483978 485625 488703 490899 494933 495484 497042 497480 499291 499956 500432 501992 502562 503016 511524 512823 514015 515651 520919 521415 523165 525452 525741 538213 545673 546001 546377 547619 547738 547791 547794 547796 551560 551619 551876 552346 554222 554238 556490 556881 558158 559047 559066 560038 560422 560645 561357 561462 563038 564955 567409 572194 572203 575180 575460 575555 578538 582583 587894 595870 598032 598201 598554 600318 605011 619034 619059 619091 620058 626872 643986 659204 662376 668139 690745 751262 761141 765810 771392 778828 791858 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"платье русские"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"плат русск"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.88%) |
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.