Query Metrics
7
Database Queries
7
Different statements
247.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
220.93 ms (89.27%) |
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 400684 421841 421860 421874 421898 421902 422168 422191 422204 423499 423917 426259 433359 439662 439763 439776 440771 447828 452254 452421 452640 455318 457442 457445 457461 457464 457541 461870 462350 464210 464659 465551 466026 468120 469463 472679 472701 473194 475769 475883 477961 483523 483632 484529 485064 488772 493158 493171 493178 493183 493254 499857 506865 508442 510803 511141 512100 513328 513385 513629 514243 514877 515363 519359 521140 523824 525092 526517 526525 529143 538001 538002 538007 538009 547481 547482 547494 549822 549848 555391 562938 564385 565691 569003 569126 569526 577402 586009 587854 590200 592675 601357 609825 625686 626588 626965 669012 669361 669386 670111 676287 690803 692711 730599 751589 752626 761598 761736 765860 766523 783402 786406 786523 787120 787131 787154 796184 800604 807326 816115 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (6.88%) |
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 421898 468120 423917 439763 439776 515363 538002 525092 519359 538007 670111 569003 586009 422191 485064 510803 564385 569526 669012 549848 587854 730599 421860 439662 421841 457442 457464 422204 462350 472679 457461 464210 526525 493158 506865 508442 513328 514243 523824 526517 493178 511141 626965 555391 625686 807326 787154 565691 529143 426259 452640 547481 577402 547494 669361 669386 676287 549822 626588 752626 751589 787131 422168 447828 457541 472701 475883 421874 433359 484529 521140 488772 493171 538001 538009 513385 466026 499857 816115 514877 692711 590200 800604 786406 796184 761598 761736 787120 765860 609825 783402 452421 475769 483523 690803 766523 400684 423499 452254 461870 464659 547482 562938 569126 601357 592675 786523 440771 421902 469463 457445 473194 477961 455318 465551 483632 493183 513629 493254 512100 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.27%) |
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 400684 421841 421860 421874 421898 421902 422168 422191 422204 423499 423917 426259 433359 439662 439763 439776 440771 447828 452254 452421 452640 455318 457442 457445 457461 457464 457541 461870 462350 464210 464659 465551 466026 468120 469463 472679 472701 473194 475769 475883 477961 483523 483632 484529 485064 488772 493158 493171 493178 493183 493254 499857 506865 508442 510803 511141 512100 513328 513385 513629 514243 514877 515363 519359 521140 523824 525092 526517 526525 529143 538001 538002 538007 538009 547481 547482 547494 549822 549848 555391 562938 564385 565691 569003 569126 569526 577402 586009 587854 590200 592675 601357 609825 625686 626588 626965 669012 669361 669386 670111 676287 690803 692711 730599 751589 752626 761598 761736 765860 766523 783402 786406 786523 787120 787131 787154 796184 800604 807326 816115 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade mom anal"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск mom анал"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск mom анал"
]
|
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.