Query Metrics
7
Database Queries
7
Different statements
165.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.72 ms (84.27%) |
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 192968 365989 388280 388346 388568 389639 390218 391519 391965 397908 413949 414432 416599 418244 419537 424007 424425 426959 426985 429001 434655 435364 436530 436830 439926 442625 443028 443269 443940 444346 445192 447509 447562 448853 450648 450657 451462 451502 451542 458475 459099 460512 460921 462017 466890 468307 471107 472400 473971 474485 475177 475873 475877 475913 476280 476936 477667 477695 480487 481747 483370 483435 484377 486086 487607 489405 490709 490849 491715 494688 495706 498734 501647 504172 505884 509434 511054 514041 515448 516378 518789 521933 521951 522046 524105 525441 533609 534678 551269 555065 555135 558126 558914 559954 564964 565460 566214 567081 567399 567881 568317 568349 570291 571691 572441 573789 573875 573901 575160 579467 581220 591747 597494 597813 598599 598703 600157 626850 659340 721395 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (9.10%) |
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 476280 475913 447509 447562 451542 483370 501647 487607 573875 573901 572441 591747 419537 451502 498734 533609 477695 413949 443269 450648 476936 495706 391965 388346 598703 434655 460921 466890 477667 473971 474485 468307 480487 414432 445192 458475 481747 518789 521951 483435 521933 524105 475873 365989 436530 390218 391519 450657 418244 424007 426959 472400 490709 575160 598599 388568 435364 436830 475877 462017 475177 388280 397908 443028 516378 514041 559954 192968 504172 444346 486086 525441 558126 565460 568349 571691 597813 439926 429001 459099 484377 568317 566214 448853 443940 426985 494688 534678 460512 558914 567081 581220 564964 567881 570291 579467 659340 551269 555065 555135 567399 573789 600157 597494 626850 721395 416599 451462 389639 424425 471107 442625 505884 515448 489405 509434 511054 522046 490849 491715 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.67%) |
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 192968 365989 388280 388346 388568 389639 390218 391519 391965 397908 413949 414432 416599 418244 419537 424007 424425 426959 426985 429001 434655 435364 436530 436830 439926 442625 443028 443269 443940 444346 445192 447509 447562 448853 450648 450657 451462 451502 451542 458475 459099 460512 460921 462017 466890 468307 471107 472400 473971 474485 475177 475873 475877 475913 476280 476936 477667 477695 480487 481747 483370 483435 484377 486086 487607 489405 490709 490849 491715 494688 495706 498734 501647 504172 505884 509434 511054 514041 515448 516378 518789 521933 521951 522046 524105 525441 533609 534678 551269 555065 555135 558126 558914 559954 564964 565460 566214 567081 567399 567881 568317 568349 570291 571691 572441 573789 573875 573901 575160 579467 581220 591747 597494 597813 598599 598703 600157 626850 659340 721395 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русская блондинка в в%…"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск беловолосая в в"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.15%) |
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.