SHOW FULL COLUMNS FROM `xn_keyword` [ RunTime:0.028893s ]
SELECT * FROM `xn_keyword` WHERE `type` = 'main' AND `type_resources` = 2 ORDER BY `sort` DESC [ RunTime:0.003193s ]
SELECT * FROM `xn_keyword` WHERE `type` = 'main' AND `type_resources` = 3 ORDER BY `sort` DESC [ RunTime:0.002993s ]
SHOW FULL COLUMNS FROM `xn_category` [ RunTime:0.033806s ]
SELECT * FROM `xn_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008609s ]
SELECT * FROM `xn_category` WHERE `type` = 1 AND `is_plan` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004222s ]
SELECT * FROM `xn_category` WHERE `type` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.005366s ]
SELECT * FROM `xn_category` WHERE `type` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.004217s ]
SHOW FULL COLUMNS FROM `xn_online` [ RunTime:0.017268s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'index' AND `type` = 1 ORDER BY `sort` DESC [ RunTime:0.003031s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'index' AND `type` = 2 ORDER BY `sort` DESC [ RunTime:0.002801s ]
SELECT * FROM `xn_online` WHERE `category_name` = 'index' AND `type` = 3 LIMIT 1 [ RunTime:0.002713s ]
SHOW FULL COLUMNS FROM `xn_main_category` [ RunTime:0.029538s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002894s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 46 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002801s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002886s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002765s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002818s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002835s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 77 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002780s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002761s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002825s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 50 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002816s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 51 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002831s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 52 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.003213s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 61 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.003174s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 62 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002816s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 53 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002789s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 63 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002797s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002869s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 57 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002858s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 60 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002728s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 58 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002765s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 72 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002784s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002752s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 54 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002727s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 55 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002738s ]
SELECT * FROM `xn_main_category` WHERE `pid` = 56 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002787s ]
SHOW FULL COLUMNS FROM `xn_footer` [ RunTime:0.016283s ]
SELECT * FROM `xn_footer` ORDER BY `sort` DESC [ RunTime:0.002815s ]
SELECT * FROM `xn_footer` WHERE `type` = 1 ORDER BY `sort` DESC [ RunTime:0.002770s ]
SELECT * FROM `xn_footer` WHERE `type` = 2 ORDER BY `sort` DESC [ RunTime:0.002818s ]
SELECT * FROM `xn_category` WHERE `pid` = 205 [ RunTime:0.002797s ]
SELECT * FROM `xn_category` WHERE `pid` = 379 [ RunTime:0.002771s ]
SELECT * FROM `xn_category` WHERE `pid` = 381 [ RunTime:0.002872s ]
SELECT * FROM `xn_category` WHERE `pid` = 446 [ RunTime:0.002819s ]
SELECT * FROM `xn_category` WHERE `pid` = 447 [ RunTime:0.002920s ]
SELECT * FROM `xn_category` WHERE `pid` = 382 [ RunTime:0.002827s ]
SELECT * FROM `xn_category` WHERE `pid` = 403 [ RunTime:0.002788s ]
SELECT * FROM `xn_category` WHERE `pid` = 404 [ RunTime:0.004568s ]
SELECT * FROM `xn_category` WHERE `pid` = 405 [ RunTime:0.002939s ]
SELECT * FROM `xn_category` WHERE `pid` = 406 [ RunTime:0.002837s ]
SELECT * FROM `xn_category` WHERE `pid` = 442 [ RunTime:0.002813s ]
SELECT * FROM `xn_category` WHERE `pid` = 443 [ RunTime:0.002781s ]
SELECT * FROM `xn_category` WHERE `pid` = 444 [ RunTime:0.002799s ]
SELECT * FROM `xn_category` WHERE `pid` = 445 [ RunTime:0.002909s ]
SELECT * FROM `xn_category` WHERE `pid` = 451 [ RunTime:0.002791s ]
SELECT * FROM `xn_category` WHERE `pid` = 383 [ RunTime:0.002762s ]
SELECT * FROM `xn_category` WHERE `pid` = 407 [ RunTime:0.002842s ]
SELECT * FROM `xn_category` WHERE `pid` = 408 [ RunTime:0.002998s ]
SELECT * FROM `xn_category` WHERE `pid` = 409 [ RunTime:0.002846s ]
SELECT * FROM `xn_category` WHERE `pid` = 410 [ RunTime:0.002850s ]
SELECT * FROM `xn_category` WHERE `pid` = 411 [ RunTime:0.002811s ]
SELECT * FROM `xn_category` WHERE `pid` = 412 [ RunTime:0.002934s ]
SELECT * FROM `xn_category` WHERE `pid` = 413 [ RunTime:0.002834s ]
SELECT * FROM `xn_category` WHERE `pid` = 448 [ RunTime:0.002819s ]
SELECT * FROM `xn_category` WHERE `pid` = 449 [ RunTime:0.002774s ]
SELECT * FROM `xn_category` WHERE `pid` = 452 [ RunTime:0.002789s ]
SELECT * FROM `xn_category` WHERE `pid` = 461 [ RunTime:0.002770s ]
SELECT * FROM `xn_category` WHERE `pid` = 462 [ RunTime:0.002799s ]
SELECT * FROM `xn_category` WHERE `pid` = 463 [ RunTime:0.002735s ]
SELECT * FROM `xn_category` WHERE `pid` = 384 [ RunTime:0.002791s ]
SELECT * FROM `xn_category` WHERE `pid` = 414 [ RunTime:0.002837s ]
SELECT * FROM `xn_category` WHERE `pid` = 415 [ RunTime:0.002922s ]
SELECT * FROM `xn_category` WHERE `pid` = 416 [ RunTime:0.002884s ]
SELECT * FROM `xn_category` WHERE `pid` = 417 [ RunTime:0.002819s ]
SELECT * FROM `xn_category` WHERE `pid` = 418 [ RunTime:0.002802s ]
SELECT * FROM `xn_category` WHERE `pid` = 419 [ RunTime:0.002836s ]
SELECT * FROM `xn_category` WHERE `pid` = 464 [ RunTime:0.002721s ]
SELECT * FROM `xn_category` WHERE `pid` = 385 [ RunTime:0.002730s ]
SELECT * FROM `xn_category` WHERE `pid` = 420 [ RunTime:0.002792s ]
SELECT * FROM `xn_category` WHERE `pid` = 421 [ RunTime:0.002818s ]
SELECT * FROM `xn_category` WHERE `pid` = 422 [ RunTime:0.002797s ]
SELECT * FROM `xn_category` WHERE `pid` = 386 [ RunTime:0.002764s ]
SELECT * FROM `xn_category` WHERE `pid` = 423 [ RunTime:0.002864s ]
SELECT * FROM `xn_category` WHERE `pid` = 424 [ RunTime:0.002791s ]
SELECT * FROM `xn_category` WHERE `pid` = 1813 [ RunTime:0.002752s ]
SELECT * FROM `xn_category` WHERE `pid` = 387 [ RunTime:0.002761s ]
SELECT * FROM `xn_category` WHERE `pid` = 425 [ RunTime:0.002794s ]
SELECT * FROM `xn_category` WHERE `pid` = 426 [ RunTime:0.002753s ]
SELECT * FROM `xn_category` WHERE `pid` = 427 [ RunTime:0.002740s ]
SELECT * FROM `xn_category` WHERE `pid` = 388 [ RunTime:0.002829s ]
SELECT * FROM `xn_category` WHERE `pid` = 428 [ RunTime:0.002861s ]
SELECT * FROM `xn_category` WHERE `pid` = 429 [ RunTime:0.002756s ]
SELECT * FROM `xn_category` WHERE `pid` = 430 [ RunTime:0.002738s ]
SELECT * FROM `xn_category` WHERE `pid` = 1775 [ RunTime:0.002754s ]
SELECT * FROM `xn_category` WHERE `pid` = 389 [ RunTime:0.002713s ]
SELECT * FROM `xn_category` WHERE `pid` = 431 [ RunTime:0.002737s ]
SELECT * FROM `xn_category` WHERE `pid` = 390 [ RunTime:0.002873s ]
SELECT * FROM `xn_category` WHERE `pid` = 432 [ RunTime:0.002932s ]
SELECT * FROM `xn_category` WHERE `pid` = 1726 [ RunTime:0.002727s ]
SELECT * FROM `xn_category` WHERE `pid` = 391 [ RunTime:0.002720s ]
SELECT * FROM `xn_category` WHERE `pid` = 433 [ RunTime:0.002759s ]
SELECT * FROM `xn_category` WHERE `pid` = 392 [ RunTime:0.002702s ]
SELECT * FROM `xn_category` WHERE `pid` = 434 [ RunTime:0.002814s ]
SELECT * FROM `xn_category` WHERE `pid` = 393 [ RunTime:0.002852s ]
SELECT * FROM `xn_category` WHERE `pid` = 435 [ RunTime:0.002830s ]
SELECT * FROM `xn_category` WHERE `pid` = 397 [ RunTime:0.002721s ]
SELECT * FROM `xn_category` WHERE `pid` = 436 [ RunTime:0.002908s ]
SELECT * FROM `xn_category` WHERE `pid` = 399 [ RunTime:0.002725s ]
SELECT * FROM `xn_category` WHERE `pid` = 454 [ RunTime:0.002691s ]
SELECT * FROM `xn_category` WHERE `pid` = 400 [ RunTime:0.002842s ]
SELECT * FROM `xn_category` WHERE `pid` = 455 [ RunTime:0.002707s ]
SELECT * FROM `xn_category` WHERE `pid` = 456 [ RunTime:0.002686s ]
SELECT * FROM `xn_category` WHERE `pid` = 457 [ RunTime:0.002706s ]
SELECT * FROM `xn_category` WHERE `pid` = 458 [ RunTime:0.002712s ]
SELECT * FROM `xn_category` WHERE `pid` = 459 [ RunTime:0.002678s ]
SELECT * FROM `xn_category` WHERE `pid` = 470 [ RunTime:0.002757s ]
SELECT * FROM `xn_category` WHERE `pid` = 1077 [ RunTime:0.002738s ]
SELECT * FROM `xn_category` WHERE `pid` = 1785 [ RunTime:0.002745s ]
SELECT * FROM `xn_category` WHERE `pid` = 402 [ RunTime:0.002752s ]
SELECT * FROM `xn_category` WHERE `pid` = 465 [ RunTime:0.002803s ]
SELECT * FROM `xn_category` WHERE `pid` = 1727 [ RunTime:0.002802s ]
SELECT * FROM `xn_category` WHERE `pid` = 1728 [ RunTime:0.002708s ]
SELECT * FROM `xn_category` WHERE `pid` = 1729 [ RunTime:0.002800s ]
SELECT * FROM `xn_category` WHERE `pid` = 1730 [ RunTime:0.002689s ]
SELECT * FROM `xn_category` WHERE `pid` = 1731 [ RunTime:0.002698s ]
SELECT * FROM `xn_category` WHERE `pid` = 1732 [ RunTime:0.002748s ]
SELECT * FROM `xn_category` WHERE `pid` = 1733 [ RunTime:0.002673s ]
SELECT * FROM `xn_category` WHERE `pid` = 1734 [ RunTime:0.002723s ]
SELECT * FROM `xn_category` WHERE `pid` = 1735 [ RunTime:0.002917s ]
SELECT * FROM `xn_category` WHERE `pid` = 1736 [ RunTime:0.002656s ]
SELECT * FROM `xn_category` WHERE `pid` = 1814 [ RunTime:0.002862s ]
SELECT * FROM `xn_category` WHERE `pid` = 380 [ RunTime:0.002682s ]
SELECT * FROM `xn_category` WHERE `pid` = 394 [ RunTime:0.002687s ]
SELECT * FROM `xn_category` WHERE `pid` = 437 [ RunTime:0.002699s ]
SELECT * FROM `xn_category` WHERE `pid` = 466 [ RunTime:0.002629s ]
SELECT * FROM `xn_category` WHERE `pid` = 395 [ RunTime:0.002773s ]
SELECT * FROM `xn_category` WHERE `pid` = 438 [ RunTime:0.002656s ]
SELECT * FROM `xn_category` WHERE `pid` = 467 [ RunTime:0.002615s ]
SELECT * FROM `xn_category` WHERE `pid` = 468 [ RunTime:0.002749s ]
SELECT * FROM `xn_category` WHERE `pid` = 469 [ RunTime:0.002716s ]
SELECT * FROM `xn_category` WHERE `pid` = 396 [ RunTime:0.002673s ]
SELECT * FROM `xn_category` WHERE `pid` = 439 [ RunTime:0.002737s ]
SELECT * FROM `xn_category` WHERE `pid` = 440 [ RunTime:0.002772s ]
SELECT * FROM `xn_category` WHERE `pid` = 398 [ RunTime:0.002703s ]
SELECT * FROM `xn_category` WHERE `pid` = 441 [ RunTime:0.002701s ]
SELECT * FROM `xn_category` WHERE `pid` = 401 [ RunTime:0.002661s ]
SELECT * FROM `xn_category` WHERE `pid` = 460 [ RunTime:0.002690s ]
SELECT * FROM `xn_category` WHERE `pid` = 1075 [ RunTime:0.002655s ]
SELECT * FROM `xn_category` WHERE `pid` = 1071 [ RunTime:0.002686s ]
SELECT * FROM `xn_category` WHERE `pid` = 1072 [ RunTime:0.002718s ]
SELECT * FROM `xn_category` WHERE `pid` = 213 [ RunTime:0.002692s ]
SELECT * FROM `xn_category` WHERE `pid` = 215 [ RunTime:0.002685s ]
SELECT * FROM `xn_category` WHERE `pid` = 216 [ RunTime:0.002690s ]
SELECT * FROM `xn_category` WHERE `pid` = 217 [ RunTime:0.002708s ]
SELECT `title` FROM `xn_category` WHERE `id` = 205 LIMIT 1 [ RunTime:0.002781s ]
SHOW FULL COLUMNS FROM `xn_books` [ RunTime:0.015007s ]
SELECT COUNT(*) AS think_count FROM `xn_books` WHERE `type` = 1 AND `category_id` IN (205,379,381,446,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,944,1043,1044,1050,1055,1056,1057,1058,1064,447,519,520,521,522,523,524,525,526,527,528,529,530,1059,382,403,486,487,488,489,490,491,492,493,494,997,1060,404,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,405,547,548,549,674,675,676,677,678,679,680,681,682,683,684,685,875,883,1021,1022,1023,1024,1025,1026,1051,1052,1053,1065,1773,1774,406,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,640,825,442,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,443,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,1041,444,789,790,791,792,793,794,445,876,877,878,879,880,881,882,451,998,999,1000,1001,1002,383,407,697,698,699,700,702,703,704,705,706,707,708,709,710,711,712,725,1011,408,931,934,935,936,937,938,939,940,941,942,943,968,969,1786,1815,409,644,645,646,647,648,649,650,651,652,653,654,915,410,686,687,688,689,690,691,692,693,694,695,701,411,531,532,533,534,412,572,573,574,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,835,971,413,575,576,577,578,579,580,581,448,536,544,545,546,550,551,552,553,554,555,641,642,643,916,1020,1038,449,917,452,1013,1014,1015,1740,1741,461,1035,1772,462,1031,1032,1033,1034,1787,463,1037,384,414,535,537,538,539,540,541,542,543,637,638,874,1062,1063,415,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,416,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,417,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,418,826,827,834,853,854,855,856,857,858,859,860,861,862,419,863,864,865,866,867,868,464,1042,385,420,715,716,717,718,719,720,721,722,723,724,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,1019,1784,421,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,830,831,422,774,775,776,777,778,779,780,781,782,783,784,386,423,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,639,696,713,714,424,726,727,728,729,730,731,732,733,734,1813,387,425,945,946,947,948,949,950,951,952,953,954,955,956,426,957,958,959,960,1016,427,961,962,963,964,965,966,967,388,428,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,1054,429,884,885,886,887,888,889,890,891,892,893,430,970,1010,1775,389,431,785,786,787,788,928,929,930,972,390,432,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,829,1061,1793,1726,391,433,1003,1004,1005,1006,1007,1008,1009,392,434,828,869,870,871,872,873,1012,1036,1039,1778,393,435,832,833,918,919,920,921,922,923,924,925,926,927,397,436,973,974,975,976,977,978,399,454,1018,400,455,456,457,458,459,470,1077,1785,402,465,1040,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1814,380,394,437,466,1046,395,438,467,1045,468,1047,469,1048,396,439,440,1030,398,441,401,460,1075,1071,1072,213,215,216,217) LIMIT 1 [ RunTime:0.030385s ]
SELECT COUNT(*) AS think_count FROM `xn_books` WHERE `type` = 1 AND `category_id` IN (205,379,381,446,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,944,1043,1044,1050,1055,1056,1057,1058,1064,447,519,520,521,522,523,524,525,526,527,528,529,530,1059,382,403,486,487,488,489,490,491,492,493,494,997,1060,404,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,405,547,548,549,674,675,676,677,678,679,680,681,682,683,684,685,875,883,1021,1022,1023,1024,1025,1026,1051,1052,1053,1065,1773,1774,406,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,640,825,442,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,443,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,1041,444,789,790,791,792,793,794,445,876,877,878,879,880,881,882,451,998,999,1000,1001,1002,383,407,697,698,699,700,702,703,704,705,706,707,708,709,710,711,712,725,1011,408,931,934,935,936,937,938,939,940,941,942,943,968,969,1786,1815,409,644,645,646,647,648,649,650,651,652,653,654,915,410,686,687,688,689,690,691,692,693,694,695,701,411,531,532,533,534,412,572,573,574,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,835,971,413,575,576,577,578,579,580,581,448,536,544,545,546,550,551,552,553,554,555,641,642,643,916,1020,1038,449,917,452,1013,1014,1015,1740,1741,461,1035,1772,462,1031,1032,1033,1034,1787,463,1037,384,414,535,537,538,539,540,541,542,543,637,638,874,1062,1063,415,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,416,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,417,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,418,826,827,834,853,854,855,856,857,858,859,860,861,862,419,863,864,865,866,867,868,464,1042,385,420,715,716,717,718,719,720,721,722,723,724,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,1019,1784,421,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,830,831,422,774,775,776,777,778,779,780,781,782,783,784,386,423,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,639,696,713,714,424,726,727,728,729,730,731,732,733,734,1813,387,425,945,946,947,948,949,950,951,952,953,954,955,956,426,957,958,959,960,1016,427,961,962,963,964,965,966,967,388,428,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,1054,429,884,885,886,887,888,889,890,891,892,893,430,970,1010,1775,389,431,785,786,787,788,928,929,930,972,390,432,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,829,1061,1793,1726,391,433,1003,1004,1005,1006,1007,1008,1009,392,434,828,869,870,871,872,873,1012,1036,1039,1778,393,435,832,833,918,919,920,921,922,923,924,925,926,927,397,436,973,974,975,976,977,978,399,454,1018,400,455,456,457,458,459,470,1077,1785,402,465,1040,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1814,380,394,437,466,1046,395,438,467,1045,468,1047,469,1048,396,439,440,1030,398,441,401,460,1075,1071,1072,213,215,216,217) LIMIT 1 [ RunTime:0.030422s ]
SELECT * FROM `xn_books` WHERE `type` = 1 AND `category_id` IN (205,379,381,446,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,944,1043,1044,1050,1055,1056,1057,1058,1064,447,519,520,521,522,523,524,525,526,527,528,529,530,1059,382,403,486,487,488,489,490,491,492,493,494,997,1060,404,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,405,547,548,549,674,675,676,677,678,679,680,681,682,683,684,685,875,883,1021,1022,1023,1024,1025,1026,1051,1052,1053,1065,1773,1774,406,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,640,825,442,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,443,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,1041,444,789,790,791,792,793,794,445,876,877,878,879,880,881,882,451,998,999,1000,1001,1002,383,407,697,698,699,700,702,703,704,705,706,707,708,709,710,711,712,725,1011,408,931,934,935,936,937,938,939,940,941,942,943,968,969,1786,1815,409,644,645,646,647,648,649,650,651,652,653,654,915,410,686,687,688,689,690,691,692,693,694,695,701,411,531,532,533,534,412,572,573,574,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,835,971,413,575,576,577,578,579,580,581,448,536,544,545,546,550,551,552,553,554,555,641,642,643,916,1020,1038,449,917,452,1013,1014,1015,1740,1741,461,1035,1772,462,1031,1032,1033,1034,1787,463,1037,384,414,535,537,538,539,540,541,542,543,637,638,874,1062,1063,415,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,416,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,417,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,418,826,827,834,853,854,855,856,857,858,859,860,861,862,419,863,864,865,866,867,868,464,1042,385,420,715,716,717,718,719,720,721,722,723,724,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,1019,1784,421,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,830,831,422,774,775,776,777,778,779,780,781,782,783,784,386,423,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,639,696,713,714,424,726,727,728,729,730,731,732,733,734,1813,387,425,945,946,947,948,949,950,951,952,953,954,955,956,426,957,958,959,960,1016,427,961,962,963,964,965,966,967,388,428,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,1054,429,884,885,886,887,888,889,890,891,892,893,430,970,1010,1775,389,431,785,786,787,788,928,929,930,972,390,432,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,829,1061,1793,1726,391,433,1003,1004,1005,1006,1007,1008,1009,392,434,828,869,870,871,872,873,1012,1036,1039,1778,393,435,832,833,918,919,920,921,922,923,924,925,926,927,397,436,973,974,975,976,977,978,399,454,1018,400,455,456,457,458,459,470,1077,1785,402,465,1040,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1814,380,394,437,466,1046,395,438,467,1045,468,1047,469,1048,396,439,440,1030,398,441,401,460,1075,1071,1072,213,215,216,217) ORDER BY `sort` DESC,`create_time` DESC LIMIT 1500,15 [ RunTime:0.041961s ]
0
样
