Query Metrics
7
Database Queries
7
Different statements
381.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.01 ms (54.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
145.47 ms (38.09%) |
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 385318 389124 403654 420493 424190 424200 424232 425998 436591 438001 442841 442867 443499 445737 449557 451652 451780 452308 452370 454633 455846 455876 456665 462996 463367 463588 464702 465013 467569 468189 470251 472438 473867 479003 482551 486892 487393 487498 488011 488249 495406 496104 498038 502239 502778 505266 507276 507678 508222 508554 508967 509478 511446 511827 512540 515197 516852 517315 518242 519678 519878 520815 522249 522578 522740 522744 522905 523409 525879 527175 528235 535206 536903 538021 541857 547649 548538 552407 555090 555798 558614 560427 560791 564494 567721 570910 570980 571327 573273 585703 588510 595097 602647 604907 610931 612548 613708 613872 619221 619755 621647 624291 624875 626364 630500 639972 644268 671642 681399 704218 709257 723164 768554 810962 814553 ] |
||||||||||||||||||||||||||||||
|
19.27 ms (5.05%) |
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 462996 473867 424232 463367 472438 508222 525879 519678 487393 505266 509478 527175 385318 403654 814553 482551 467569 449557 518242 538021 511446 535206 487498 560427 570910 570980 723164 704218 709257 552407 560791 613872 585703 644268 619221 619755 624291 595097 610931 810962 768554 389124 436591 465013 454633 455876 463588 470251 443499 452308 452370 517315 522744 502778 508967 528235 507678 522249 522578 486892 519878 522905 523409 420493 451652 451780 456665 496104 555090 573273 547649 567721 564494 681399 621647 613708 639972 612548 588510 604907 630500 468189 442867 512540 488249 502239 515197 516852 438001 522740 479003 624875 424200 455846 511827 488011 495406 507276 520815 464702 498038 536903 541857 555798 558614 571327 671642 602647 424190 442841 508554 548538 626364 425998 445737 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (0.83%) |
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 385318 389124 403654 420493 424190 424200 424232 425998 436591 438001 442841 442867 443499 445737 449557 451652 451780 452308 452370 454633 455846 455876 456665 462996 463367 463588 464702 465013 467569 468189 470251 472438 473867 479003 482551 486892 487393 487498 488011 488249 495406 496104 498038 502239 502778 505266 507276 507678 508222 508554 508967 509478 511446 511827 512540 515197 516852 517315 518242 519678 519878 520815 522249 522578 522740 522744 522905 523409 525879 527175 528235 535206 536903 538021 541857 547649 548538 552407 555090 555798 558614 560427 560791 564494 567721 570910 570980 571327 573273 585703 588510 595097 602647 604907 610931 612548 613708 613872 619221 619755 621647 624291 624875 626364 630500 639972 644268 671642 681399 704218 709257 723164 768554 810962 814553 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.59%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"horny cum"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"horny cum"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"horny cum"
]
|
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.