SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 905311 LIMIT 1 [ RunTime:0.001429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 905311 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851220,870260,721241,301681,946426,302617,398522,533009,881048,155718,722248,915418,1001364,83782,727443,778839,698542,338004,1029733,26808,243798,980294,961709,109297,464211,45915,1026190,1029066,535301,714227,758204,514521,650593,378880,542887,109011,115407,537683,761283,419574,141192,65584,118277,585020,439460,803657,68027,557684,932505,969630,333037,738026,208004,166667,591638,770204,70901,597754,384858,818590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 905311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 905311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]