Query Metrics
7
Database Queries
7
Different statements
169.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.13 ms (85.61%) |
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 193452 236902 249637 384455 384556 390956 391392 391574 396662 399089 401111 401383 404304 404306 409106 409371 411353 411616 411694 415570 416839 439721 440907 443158 443744 444041 449756 451491 451522 452189 452415 453145 456036 456507 460190 460730 460907 462325 463940 464535 466171 467275 467546 468483 470096 471140 472680 473246 474404 474444 475540 475859 476274 476406 477225 478381 478405 479079 479487 481324 483248 484358 484379 484394 484443 485357 485388 486751 486757 488749 488999 489293 490420 490705 491320 494192 499539 502012 502868 503047 503459 508771 510776 510824 513107 514919 516470 516500 517011 517494 517529 518837 520021 521531 522450 524609 525834 525882 526010 528814 530247 533568 555058 555099 559063 560485 563110 566787 572916 590347 598658 717935 726690 728605 737963 747069 766619 796349 799351 824456 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (8.75%) |
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 415570 471140 555058 416839 490705 396662 590347 479487 566787 411616 484394 528814 401383 747069 490420 555099 560485 516500 737963 481324 440907 484443 510824 449756 468483 472680 453145 514919 474404 476274 460730 517529 384455 524609 499539 533568 486751 502012 491320 391392 508771 530247 486757 193452 520021 824456 463940 485388 728605 478405 517494 474444 467275 473246 467546 452189 475859 494192 478381 404304 525834 390956 464535 460190 526010 799351 409371 522450 391574 451491 399089 484379 443744 456507 249637 502868 503047 411353 484358 766619 451522 488999 475540 510776 477225 563110 796349 521531 444041 503459 236902 401111 483248 384556 456036 717935 479079 404306 489293 470096 726690 517011 476406 443158 409106 488749 572916 598658 485357 518837 452415 525882 516470 462325 460907 411694 466171 439721 513107 559063 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.99%) |
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 193452 236902 249637 384455 384556 390956 391392 391574 396662 399089 401111 401383 404304 404306 409106 409371 411353 411616 411694 415570 416839 439721 440907 443158 443744 444041 449756 451491 451522 452189 452415 453145 456036 456507 460190 460730 460907 462325 463940 464535 466171 467275 467546 468483 470096 471140 472680 473246 474404 474444 475540 475859 476274 476406 477225 478381 478405 479079 479487 481324 483248 484358 484379 484394 484443 485357 485388 486751 486757 488749 488999 489293 490420 490705 491320 494192 499539 502012 502868 503047 503459 508771 510776 510824 513107 514919 516470 516500 517011 517494 517529 518837 520021 521531 522450 524609 525834 525882 526010 528814 530247 533568 555058 555099 559063 560485 563110 566787 572916 590347 598658 717935 726690 728605 737963 747069 766619 796349 799351 824456 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дал отсосать зрелке"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс зрелая женщин"
]
|
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.