SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 960302 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 960302 [ RunTime:0.002308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104369,877479,307024,679794,138021,766190,973914,891808,926712,401304,1034250,87627,201016,265358,890903,787785,923304,682873,320331,6734,357884,713228,538949,609329,437696,205144,940701,530311,386762,420868,651045,896513,329073,368712,244452,381850,953118,465577,436501,820083,843319,325055,333048,311978,449392,149833,165760,422580,1042514,388329,563789,586297,1042599,150553,668394,830459,957047,910017,1042664,483074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 960302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 960302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]