Query Metrics
7
Database Queries
7
Different statements
196.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.57 ms (88.39%) |
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 185523 385009 385690 386467 387577 388161 391317 391944 392751 395932 398872 402628 408685 409016 410664 419737 446792 446880 447862 449335 453124 454910 460936 460952 466866 471058 472606 476150 487871 488952 490232 496471 507441 510925 516553 517439 517485 525727 526569 528540 529458 530429 533165 536209 539349 539352 539774 540719 541144 548414 550514 555191 558174 559408 561736 563429 563683 564104 571707 576771 578202 578510 581360 583464 585240 585806 589467 591045 595922 610166 612339 630105 632246 637245 647534 647839 650685 652163 666672 666697 667987 683202 685527 691291 694192 697299 697301 705053 706373 709871 709898 710408 713045 714322 714336 714357 714418 715724 716293 717127 719150 719228 721906 735912 736094 738469 739085 740586 746848 748594 781917 789559 800953 802621 804337 804435 810498 814297 824436 824859 ] |
||||||||||||||||||||||||||||||
|
13.14 ms (6.69%) |
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 476150 391317 559408 666697 717127 647534 705053 714418 691291 800953 739085 721906 748594 738469 824859 391944 585806 517485 402628 539349 540719 533165 563683 548414 595922 449335 666672 637245 185523 814297 541144 683202 650685 667987 736094 709871 583464 453124 529458 516553 563429 576771 632246 581360 525727 460952 510925 539352 578202 709898 719150 419737 387577 471058 550514 610166 507441 578510 652163 589467 802621 746848 716293 454910 697301 719228 810498 386467 496471 526569 517439 472606 488952 460936 466866 824436 398872 446880 447862 395932 697299 539774 713045 715724 487871 555191 564104 385690 490232 446792 528540 647839 710408 685527 694192 714336 714357 706373 714322 591045 612339 630105 781917 735912 740586 789559 804435 408685 409016 385009 804337 585240 536209 392751 561736 410664 388161 530429 558174 571707 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.45%) |
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 185523 385009 385690 386467 387577 388161 391317 391944 392751 395932 398872 402628 408685 409016 410664 419737 446792 446880 447862 449335 453124 454910 460936 460952 466866 471058 472606 476150 487871 488952 490232 496471 507441 510925 516553 517439 517485 525727 526569 528540 529458 530429 533165 536209 539349 539352 539774 540719 541144 548414 550514 555191 558174 559408 561736 563429 563683 564104 571707 576771 578202 578510 581360 583464 585240 585806 589467 591045 595922 610166 612339 630105 632246 637245 647534 647839 650685 652163 666672 666697 667987 683202 685527 691291 694192 697299 697301 705053 706373 709871 709898 710408 713045 714322 714336 714357 714418 715724 716293 717127 719150 719228 721906 735912 736094 738469 739085 740586 746848 748594 781917 789559 800953 802621 804337 804435 810498 814297 824436 824859 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy girls vagina"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая девушк вагин"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.76%) |
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.