Query Metrics
7
Database Queries
7
Different statements
147.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.31 ms (80.07%) |
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 405181 409948 417811 418363 422725 425164 428116 464445 469616 481910 498830 517722 517932 518493 519567 522883 523392 529243 530272 530489 530791 531089 531393 531419 532172 532720 532737 532839 533697 534823 536233 536586 537200 537685 537763 537771 538473 540579 541846 550194 556480 558074 558436 559162 564829 567343 572189 582376 583503 585363 590411 596082 599836 599863 599868 599914 599961 599965 600019 600249 600295 600296 600342 600352 600355 601040 601535 601625 604513 610060 612343 616336 617416 617428 620794 625412 625443 629963 631178 632641 632671 633124 634212 634782 636304 639706 639717 640755 642061 643376 644918 644961 645952 646025 646029 646771 646786 646849 648815 650175 650846 651079 656303 668528 668534 676092 676110 677674 678493 679733 708447 716882 720260 720288 801960 804464 806087 808579 809290 809520 ] |
||||||||||||||||||||||||||||||
|
18.97 ms (12.84%) |
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 806087 809290 422725 540579 531419 536233 646029 599836 601535 425164 532737 498830 517722 533697 558436 572189 650175 650846 676092 610060 601625 585363 600295 625443 405181 409948 529243 519567 522883 464445 531393 564829 530272 531089 541846 550194 678493 646771 646786 656303 604513 616336 590411 600355 636304 625412 633124 617428 620794 631178 639717 804464 417811 523392 517932 538473 532839 646849 632671 600249 632641 629963 644961 537763 537771 530489 536586 532172 532720 534823 537200 558074 583503 720260 651079 676110 679733 716882 720288 645952 648815 668528 642061 612343 600352 639706 640755 596082 599868 600342 634782 643376 801960 808579 617416 809520 518493 481910 469616 556480 582376 600296 599863 599961 599965 600019 418363 428116 644918 537685 530791 559162 567343 646025 668534 677674 708447 601040 599914 634212 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.87%) |
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 405181 409948 417811 418363 422725 425164 428116 464445 469616 481910 498830 517722 517932 518493 519567 522883 523392 529243 530272 530489 530791 531089 531393 531419 532172 532720 532737 532839 533697 534823 536233 536586 537200 537685 537763 537771 538473 540579 541846 550194 556480 558074 558436 559162 564829 567343 572189 582376 583503 585363 590411 596082 599836 599863 599868 599914 599961 599965 600019 600249 600295 600296 600342 600352 600355 601040 601535 601625 604513 610060 612343 616336 617416 617428 620794 625412 625443 629963 631178 632641 632671 633124 634212 634782 636304 639706 639717 640755 642061 643376 644918 644961 645952 646025 646029 646771 646786 646849 648815 650175 650846 651079 656303 668528 668534 676092 676110 677674 678493 679733 708447 716882 720260 720288 801960 804464 806087 808579 809290 809520 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom anal interracial"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom анал межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom анал межрасов"
]
|
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.