SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44070 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44070 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623471,338354,472954,1037211,458176,253599,819494,934086,841228,939302,97943,119226,649437,435438,896480,646846,128962,4925,469744,145311,350914,861859,240099,521294,966676,776115,189263,837955,320416,165577,52211,417750,430283,730938,74223,748940,937756,253378,751882,43598,405865,1044883,301439,842858,321106,989568,479078,723480,228208,323074,882512,677618,234564,579057,602138,660585,60529,557674,383490,761598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]