Query Metrics
7
Database Queries
7
Different statements
168.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.89 ms (86.03%) |
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 51972 76836 396070 398435 400004 406867 407995 408043 410079 413731 429471 437444 445205 445509 450128 450130 452862 455871 456158 456444 474164 478803 482873 484510 484867 500413 502164 508147 514766 528023 534926 548992 574160 577204 584452 595283 595665 600952 604215 604822 606285 608007 610275 611294 614583 616419 616652 621099 625299 630329 635202 635250 636929 642304 649207 650136 656621 666919 678491 682683 692710 693399 695123 700760 702006 706785 707127 707175 707856 709594 710094 710489 711345 713877 714079 715396 716155 716529 716648 719019 720140 724120 724307 724478 724495 727925 730159 731620 732640 733195 735420 738347 739648 740104 742009 742362 746477 751925 754253 756766 759184 759960 761199 761216 761936 762333 766690 767159 768001 772035 773678 781416 787820 789031 808802 811501 811919 812149 817423 823940 ] |
||||||||||||||||||||||||||||||
|
13.93 ms (8.27%) |
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 710489 715396 716155 716648 781416 787820 812149 76836 429471 474164 484867 678491 702006 709594 713877 649207 710094 650136 707856 604822 606285 616652 636929 600952 610275 614583 642304 808802 811919 733195 762333 740104 759184 735420 761936 746477 751925 754253 756766 767159 768001 731620 773678 450128 528023 508147 478803 695123 817423 456158 500413 682683 706785 720140 604215 730159 772035 714079 455871 407995 408043 482873 635202 811501 759960 396070 450130 534926 502164 666919 692710 611294 621099 595665 738347 452862 445205 823940 484510 548992 584452 625299 595283 608007 761199 413731 445509 456444 514766 577204 693399 716529 719019 656621 707127 707175 574160 635250 630329 789031 742009 727925 739648 724120 724307 724478 761216 724495 732640 742362 766690 616419 700760 711345 406867 437444 51972 398435 400004 410079 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.81%) |
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 51972 76836 396070 398435 400004 406867 407995 408043 410079 413731 429471 437444 445205 445509 450128 450130 452862 455871 456158 456444 474164 478803 482873 484510 484867 500413 502164 508147 514766 528023 534926 548992 574160 577204 584452 595283 595665 600952 604215 604822 606285 608007 610275 611294 614583 616419 616652 621099 625299 630329 635202 635250 636929 642304 649207 650136 656621 666919 678491 682683 692710 693399 695123 700760 702006 706785 707127 707175 707856 709594 710094 710489 711345 713877 714079 715396 716155 716529 716648 719019 720140 724120 724307 724478 724495 727925 730159 731620 732640 733195 735420 738347 739648 740104 742009 742362 746477 751925 754253 756766 759184 759960 761199 761216 761936 762333 766690 767159 768001 772035 773678 781416 787820 789031 808802 811501 811919 812149 817423 823940 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock creampie"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock creampie"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock creampie"
]
|
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.