Query Metrics
7
Database Queries
7
Different statements
377.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.71 ms (54.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"maid mature"
]
|
||||||||||||||||||||||||||||||
|
147.18 ms (39.01%) |
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 4497 233710 381884 382045 383700 384489 392885 400998 402101 402247 404313 407685 409179 409330 417015 418958 421824 421826 428130 428147 444733 448921 453755 456584 459933 464013 469294 470201 471445 472906 473846 475629 482088 491823 514188 515904 518762 518941 520265 529573 532866 533052 533889 534240 536487 537134 541594 561486 561516 563160 564734 567434 568546 570954 570972 576004 579510 582581 587859 591064 591067 596334 596808 603249 610172 621716 626546 627654 633937 688003 705355 705455 706889 715414 720528 721471 724286 725170 725510 726473 726746 730352 731788 733338 734373 738330 740991 741472 744232 744653 744804 745844 746122 749052 758046 764144 771968 781672 781683 781685 782159 785879 788287 796276 796543 801781 805340 808226 808254 809701 817293 819235 820211 820381 825323 825431 826928 827032 827438 827596 ] |
||||||||||||||||||||||||||||||
|
16.91 ms (4.48%) |
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 734373 744232 781672 724286 725170 744804 745844 731788 740991 621716 705355 781685 796543 233710 407685 4497 825323 826928 827032 827438 827596 820381 825431 533889 532866 536487 533052 537134 720528 561486 561516 587859 805340 809701 808254 725510 741472 801781 749052 726746 758046 738330 796276 392885 402101 459933 469294 471445 448921 456584 464013 472906 453755 473846 518941 475629 576004 564734 568546 570954 688003 591067 596808 603249 596334 626546 633937 402247 400998 404313 421824 428130 384489 428147 418958 421826 444733 514188 520265 541594 627654 482088 730352 470201 491823 383700 382045 381884 409179 409330 417015 817293 820211 819235 515904 518762 529573 534240 582581 579510 563160 567434 570972 705455 706889 721471 715414 591064 610172 785879 788287 746122 771968 781683 782159 808226 726473 733338 744653 764144 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.80%) |
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 4497 233710 381884 382045 383700 384489 392885 400998 402101 402247 404313 407685 409179 409330 417015 418958 421824 421826 428130 428147 444733 448921 453755 456584 459933 464013 469294 470201 471445 472906 473846 475629 482088 491823 514188 515904 518762 518941 520265 529573 532866 533052 533889 534240 536487 537134 541594 561486 561516 563160 564734 567434 568546 570954 570972 576004 579510 582581 587859 591064 591067 596334 596808 603249 610172 621716 626546 627654 633937 688003 705355 705455 706889 715414 720528 721471 724286 725170 725510 726473 726746 730352 731788 733338 734373 738330 740991 741472 744232 744653 744804 745844 746122 749052 758046 764144 771968 781672 781683 781685 782159 785879 788287 796276 796543 801781 805340 808226 808254 809701 817293 819235 820211 820381 825323 825431 826928 827032 827438 827596 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"горничн mature"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"горничн mature"
]
|
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.