Query Metrics
7
Database Queries
7
Different statements
400.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.44 ms (52.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск milf скрыт"
]
|
||||||||||||||||||||||||||||||
|
158.75 ms (39.66%) |
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 418911 423767 424160 438011 438312 449109 449126 450866 453184 455600 456857 458690 460548 462299 463504 463839 464268 464545 464781 465481 466266 466336 466380 467160 467200 467209 467494 467758 470094 470563 470667 471574 471771 472409 472784 473321 474213 476414 477154 479359 479391 479394 479498 480814 481400 482915 483362 485429 485944 485975 487155 494975 495678 496151 496357 498853 504148 504304 506718 507266 509650 511872 518160 519366 519452 522032 522489 523604 524170 524251 524790 524963 528465 549655 552516 553563 555683 559036 559038 562867 578054 582451 582724 584662 594987 601248 601277 601281 607174 611788 611923 622826 651735 657782 663341 680675 685263 725441 725442 725477 727038 730947 731104 732829 733241 735840 736783 741076 742566 746165 746183 750728 754237 755141 758158 769448 779607 782065 788428 804422 ] |
||||||||||||||||||||||||||||||
|
23.04 ms (5.76%) |
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 746183 750728 438312 470563 450866 479391 528465 611788 462299 464781 463839 466266 467758 472409 474213 471771 522489 485975 504304 470094 418911 467209 519366 549655 555683 651735 663341 680675 685263 601277 594987 725477 733241 769448 725441 732829 735840 736783 746165 758158 741076 779607 804422 424160 438011 466336 487155 509650 523604 472784 456857 453184 467494 423767 455600 460548 463504 476414 479498 511872 496151 506718 507266 482915 483362 524790 485429 495678 496357 519452 524251 473321 504148 518160 449126 479359 494975 477154 481400 559036 559038 562867 578054 582724 584662 657782 552516 553563 582451 622826 601281 601248 611923 607174 788428 725442 731104 742566 754237 755141 727038 730947 782065 467160 467200 470667 479394 480814 471574 464545 449109 458690 464268 465481 466380 524963 485944 498853 522032 524170 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (0.63%) |
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 418911 423767 424160 438011 438312 449109 449126 450866 453184 455600 456857 458690 460548 462299 463504 463839 464268 464545 464781 465481 466266 466336 466380 467160 467200 467209 467494 467758 470094 470563 470667 471574 471771 472409 472784 473321 474213 476414 477154 479359 479391 479394 479498 480814 481400 482915 483362 485429 485944 485975 487155 494975 495678 496151 496357 498853 504148 504304 506718 507266 509650 511872 518160 519366 519452 522032 522489 523604 524170 524251 524790 524963 528465 549655 552516 553563 555683 559036 559038 562867 578054 582451 582724 584662 594987 601248 601277 601281 607174 611788 611923 622826 651735 657782 663341 680675 685263 725441 725442 725477 727038 730947 731104 732829 733241 735840 736783 741076 742566 746165 746183 750728 754237 755141 758158 769448 779607 782065 788428 804422 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian milf hidden"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск milf скрыт"
]
|
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.