Query Metrics
7
Database Queries
7
Different statements
383.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.08 ms (53.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
150.57 ms (39.26%) |
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 382181 384282 385054 386892 387241 388004 390693 401122 404422 410732 411414 411715 411737 416146 422752 423455 425942 427188 445765 453105 454311 454701 457313 459885 460404 460938 461484 462104 462156 466944 469248 470982 471172 473918 474038 474822 475448 475450 477413 477576 477751 479086 479110 481376 486294 488075 490634 490641 492102 494750 495410 501527 502259 505300 507832 509114 509253 510391 511027 515883 516435 517064 521599 525749 531380 531381 535944 536849 538868 541626 556692 557814 559788 563927 564704 566362 566574 566981 572186 583293 595269 596191 597058 600847 608345 610209 612339 613287 622287 623609 630070 630649 640677 642813 648202 649527 656920 663268 663934 665416 672258 674528 682976 692209 692296 694194 697296 706029 709369 718558 722480 730111 738237 755253 783777 788311 788429 800010 814120 816158 ] |
||||||||||||||||||||||||||||||
|
19.85 ms (5.17%) |
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 454701 470982 516435 507832 697296 385054 386892 401122 404422 814120 466944 486294 535944 538868 495410 505300 517064 564704 563927 583293 566362 566981 663268 674528 692209 692296 648202 663934 672258 694194 649527 656920 722480 559788 566574 608345 640677 595269 622287 596191 600847 597058 623609 788429 800010 788311 730111 738237 755253 613287 630070 709369 783777 473918 479086 388004 461484 502259 510391 525749 509253 541626 445765 457313 474822 479110 556692 490641 454311 706029 411414 425942 492102 501527 531381 665416 718558 557814 642813 610209 612339 630649 387241 453105 460404 682976 490634 460938 515883 531380 411737 423455 384282 411715 416146 816158 469248 474038 475448 521599 462104 572186 382181 390693 427188 410732 422752 477576 477413 459885 462156 471172 475450 477751 536849 509114 494750 511027 481376 488075 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (0.92%) |
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 382181 384282 385054 386892 387241 388004 390693 401122 404422 410732 411414 411715 411737 416146 422752 423455 425942 427188 445765 453105 454311 454701 457313 459885 460404 460938 461484 462104 462156 466944 469248 470982 471172 473918 474038 474822 475448 475450 477413 477576 477751 479086 479110 481376 486294 488075 490634 490641 492102 494750 495410 501527 502259 505300 507832 509114 509253 510391 511027 515883 516435 517064 521599 525749 531380 531381 535944 536849 538868 541626 556692 557814 559788 563927 564704 566362 566574 566981 572186 583293 595269 596191 597058 600847 608345 610209 612339 613287 622287 623609 630070 630649 640677 642813 648202 649527 656920 663268 663934 665416 672258 674528 682976 692209 692296 694194 697296 706029 709369 718558 722480 730111 738237 755253 783777 788311 788429 800010 814120 816158 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy natural"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.40%) |
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.