Query Metrics
7
Database Queries
7
Different statements
193.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.47 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.74 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature housewife"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.64 ms |
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 409330 417015 817293 820211 819235 464927 515904 518762 529573 534240 582581 566662 563160 567434 570972 666128 705455 721471 715414 591064 610172 785879 788287 807385 746122 771968 781683 782159 808226 732580 726473 733338 731305 744653 764144 710895 715528 717663 721280 782155 782246 451470 388261 477227 155306 25650 819190 823565 823739 818393 820373 827141 827421 819966 825418 527773 555308 542472 584397 660025 714112 716736 719384 671379 721751 561522 596797 593415 643329 799748 803008 804430 811122 796015 804423 725201 727047 781674 785196 791561 796306 805706 725481 730930 766684 770201 761473 697211 776725 788982 790984 407780 412983 814933 476224 473829 475842 476262 484399 512608 522589 523164 536444 496873 557244 563173 569943 559071 549842 549846 609999 733319 726587 470967 12900 466109 467279 474482 482323 443761 ] |
||||||||||||||||||||||||||||||
| 4 | 2.55 ms |
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 12900 25650 155306 388261 407780 409330 412983 417015 443761 451470 464927 466109 467279 470967 473829 474482 475842 476224 476262 477227 482323 484399 496873 512608 515904 518762 522589 523164 527773 529573 534240 536444 542472 549842 549846 555308 557244 559071 561522 563160 563173 566662 567434 569943 570972 582581 584397 591064 593415 596797 609999 610172 643329 660025 666128 671379 697211 705455 710895 714112 715414 715528 716736 717663 719384 721280 721471 721751 725201 725481 726473 726587 727047 730930 731305 732580 733319 733338 744653 746122 761473 764144 766684 770201 771968 776725 781674 781683 782155 782159 782246 785196 785879 788287 788982 790984 791561 796015 796306 799748 803008 804423 804430 805706 807385 808226 811122 814933 817293 818393 819190 819235 819966 820211 820373 823565 823739 825418 827141 827421 ] |
||||||||||||||||||||||||||||||
| 5 | 168.62 ms |
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 12900 25650 155306 388261 407780 409330 412983 417015 443761 451470 464927 466109 467279 470967 473829 474482 475842 476224 476262 477227 482323 484399 496873 512608 515904 518762 522589 523164 527773 529573 534240 536444 542472 549842 549846 555308 557244 559071 561522 563160 563173 566662 567434 569943 570972 582581 584397 591064 593415 596797 609999 610172 643329 660025 666128 671379 697211 705455 710895 714112 715414 715528 716736 717663 719384 721280 721471 721751 725201 725481 726473 726587 727047 730930 731305 732580 733319 733338 744653 746122 761473 764144 766684 770201 771968 776725 781674 781683 782155 782159 782246 785196 785879 788287 788982 790984 791561 796015 796306 799748 803008 804423 804430 805706 807385 808226 811122 814933 817293 818393 819190 819235 819966 820211 820373 823565 823739 825418 827141 827421 ] |
||||||||||||||||||||||||||||||
| 6 | 1.88 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature housewife"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.40 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature housewife"
]
|
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.