SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525663 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525663 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815379,892514,566690,731115,54928,52635,140248,434645,766932,871015,530086,932856,742759,843486,635352,456749,56017,726302,291835,299268,113128,513600,933952,644936,452138,296166,1025805,583810,348422,907285,402748,906291,89436,105936,597853,422133,481335,156381,883461,859626,870333,311767,85158,361414,274581,243347,186087,1022028,232357,21537,18825,914376,510628,949339,403053,745062,257662,686421,372683,835396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002528s ]