Query Metrics
7
Database Queries
7
Different statements
149.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.14 ms (82.28%) |
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 66611 157194 188655 213579 382045 382303 383305 390769 390945 391913 392779 395998 404314 405504 406688 407407 407727 408194 409901 411345 411354 411773 413460 420457 424985 428112 432350 447829 450104 452230 452252 454249 454879 465524 465542 465953 466009 466238 466995 467838 468858 470942 474629 474674 474685 475669 475676 475686 477070 477524 477712 477723 479024 479073 482541 484598 484636 485939 486577 487338 488377 503961 511276 520913 521401 531318 535317 547463 554323 554490 557244 558409 579613 586617 589665 590345 590449 591430 604302 604494 605476 614191 619385 619513 619522 626994 660688 663391 663434 665213 665301 665306 665391 665423 665434 682811 696237 715372 718563 726859 727513 731815 742383 742706 745952 770187 771596 772340 777405 781485 796079 797272 799640 800508 805711 807376 813243 819237 825138 827312 ] |
||||||||||||||||||||||||||||||
|
16.26 ms (10.86%) |
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 557244 554323 579613 411345 466238 479024 479073 411354 474674 487338 484598 589665 474685 477712 382045 406688 467838 770187 383305 411773 807376 66611 477723 447829 477524 475676 485939 466995 466009 465524 619513 484636 382303 405504 407407 409901 827312 819237 477070 535317 660688 558409 626994 797272 799640 800508 813243 805711 731815 742706 745952 771596 604494 450104 452230 213579 395998 404314 407727 424985 452252 454879 531318 586617 726859 391913 408194 428112 475669 488377 554490 742383 468858 432350 520913 727513 390945 188655 825138 465542 547463 665434 696237 665301 665306 665391 614191 605476 781485 772340 392779 521401 413460 420457 482541 511276 465953 619522 796079 157194 474629 454249 470942 503961 486577 475686 619385 590345 390769 665213 682811 715372 663391 663434 665423 718563 590449 591430 604302 777405 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.05%) |
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 66611 157194 188655 213579 382045 382303 383305 390769 390945 391913 392779 395998 404314 405504 406688 407407 407727 408194 409901 411345 411354 411773 413460 420457 424985 428112 432350 447829 450104 452230 452252 454249 454879 465524 465542 465953 466009 466238 466995 467838 468858 470942 474629 474674 474685 475669 475676 475686 477070 477524 477712 477723 479024 479073 482541 484598 484636 485939 486577 487338 488377 503961 511276 520913 521401 531318 535317 547463 554323 554490 557244 558409 579613 586617 589665 590345 590449 591430 604302 604494 605476 614191 619385 619513 619522 626994 660688 663391 663434 665213 665301 665306 665391 665423 665434 682811 696237 715372 718563 726859 727513 731815 742383 742706 745952 770187 771596 772340 777405 781485 796079 797272 799640 800508 805711 807376 813243 819237 825138 827312 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big vagina mature"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие вагин mature"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие вагин mature"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.05%) |
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.