Query Metrics
7
Database Queries
7
Different statements
254.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
218.18 ms (85.82%) |
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 7178 13118 33917 34369 79355 88349 169962 186041 188064 188453 213573 326289 379559 382591 387192 387676 388421 388436 388792 391704 395724 400595 405534 408009 408056 409021 417746 424931 426512 428881 434425 440817 440895 441207 444060 444437 444519 446630 447102 448002 453735 453742 456517 457010 457585 459639 459778 464198 464814 464929 466196 466721 466883 468434 470304 470404 472639 473486 474465 476247 478005 478455 479369 479821 479851 481820 482074 482633 483114 485311 485646 486192 488727 489311 493575 493684 498089 499617 505394 508560 513114 514833 522614 531917 534621 549838 557557 557814 562967 564731 580712 584395 609825 638557 646290 646292 692049 693535 703900 714620 733371 736522 740826 758166 761134 770494 777734 788542 792631 792936 796184 798453 807352 807353 815890 816063 816538 821187 822421 825571 ] |
||||||||||||||||||||||||||||||
|
20.11 ms (7.91%) |
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 408056 409021 470304 405534 456517 479851 388792 481820 505394 531917 815890 816063 816538 821187 822421 825571 534621 646290 646292 692049 693535 736522 549838 213573 188064 395724 382591 388436 408009 440817 444437 448002 468434 488727 459778 466883 470404 474465 478005 479821 485646 493684 446630 464929 482633 483114 485311 508560 472639 564731 714620 557814 562967 580712 807352 807353 733371 770494 798453 740826 777734 792936 79355 379559 473486 7178 326289 434425 479369 391704 441207 13118 457585 478455 440895 453735 466196 499617 522614 513114 486192 489311 493575 514833 88349 169962 387192 447102 33917 388421 387676 417746 424931 761134 186041 34369 400595 444519 758166 188453 426512 444060 428881 457010 464198 466721 459639 476247 453742 498089 464814 482074 584395 557557 638557 788542 792631 796184 609825 703900 ] |
||||||||||||||||||||||||||||||
|
9.34 ms (3.68%) |
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 7178 13118 33917 34369 79355 88349 169962 186041 188064 188453 213573 326289 379559 382591 387192 387676 388421 388436 388792 391704 395724 400595 405534 408009 408056 409021 417746 424931 426512 428881 434425 440817 440895 441207 444060 444437 444519 446630 447102 448002 453735 453742 456517 457010 457585 459639 459778 464198 464814 464929 466196 466721 466883 468434 470304 470404 472639 473486 474465 476247 478005 478455 479369 479821 479851 481820 482074 482633 483114 485311 485646 486192 488727 489311 493575 493684 498089 499617 505394 508560 513114 514833 522614 531917 534621 549838 557557 557814 562967 564731 580712 584395 609825 638557 646290 646292 692049 693535 703900 714620 733371 736522 740826 758166 761134 770494 777734 788542 792631 792936 796184 798453 807352 807353 815890 816063 816538 821187 822421 825571 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big mother"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.56%) |
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.