SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 151108 LIMIT 1 [ RunTime:0.001077s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 151108 [ RunTime:0.004863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017202,350334,363124,545145,1039790,463068,230424,536972,660742,322766,868094,867344,143431,316519,586365,258544,433909,331134,321578,456933,99347,480404,418363,347765,454441,1010272,917201,769685,24577,589590,1010090,781778,908058,337121,265602,861755,725143,693377,443429,571118,131053,763045,92294,321668,218085,291558,556012,377100,151895,46172,843438,313305,151187,749338,337957,105504,576745,531940,953686,201326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.049336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 151108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 151108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003226s ]