SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029321 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029321 [ RunTime:0.002236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485695,418363,563028,391319,868296,548981,366466,661451,819909,637447,131104,774948,1008607,13609,118693,43817,660105,171092,255741,481138,807033,857648,745511,495518,339510,465474,944813,960128,500289,4702,241798,21359,971934,732018,33527,865238,654224,678163,669942,923791,230703,668474,431880,101171,614202,301139,648053,965432,298470,664708,1037099,674711,695479,128121,478878,920801,223983,17975,785726,122894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000959s ]